The Mining Data Mart - Data Mining Techniques in CRM: Inside Customer Segmentation - page 146

Table 4.7 A typical list of product groups and subgroups in retail banking.

Product group Product subgroup

Deposits/savings • Saving accounts

• Current accounts
• Notice accounts
• Collaterals
• Other accounts

Time deposits

• Time deposits

Investments

• Stock funds
• Bond funds
• Money market funds
• Balanced funds
• Bonds
•Stocks
•Otherinvestments

Insurances • Life assurance

• Pension insurance
• Health insurance
• General insurance

Business products

• Business loans
• Business accounts
• Business services

Mortgages and home equity loans • Mortgage

• Home equity loans
•Otherhomeloans

Consumer loans

• Personal lines
• Personal loans
• Auto loans
• Student loans
• Debt consolidation
• Other consumer loans

Cards • Charge cards

• Debit cards
• Credit cards
• Prepaid cards
• Other cards

Table 4.8 A lookup table for transaction channels.

Field name Field type Field description

Transaction_Channel Int The transaction channel code

Transaction_Channel_Desc Char The transaction channel description

Transaction_Channel is the primary key (PK) of this table.