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

Table 4.15 ( continued )

Field_Name Field description

Registration_Date First registration date

Home_ZIP Home postal code

Customer segment and group information:

Banking_Code The basic banking code that categorizes customers as retail,

corporate, private banking, etc., customers

VIP_Flag A flag that indicates if a customer is considered as a VIP by the

bank

Person_Flag A flag that indicates if a customer is a person or a legal entity

Dormant_Flag A flag that indicates, in accordance with the bank's relevant

definition, a dormant customer, for instance a customer with
no transactions for the last 12 months

Active_Flag A flag that separates active from inactive customers, according

to the bank's definition. For instance, a customer with null or
very low total balances could be considered as inactive

Payroll_Flag A flag that indicates if a customer has a payroll account in the

bank

Segment_Code A code that allocates customers to specific segments such as

affluent (customers with the highest assets, namely savings
and investment balances), mass (customers with lower assets),
staff (belonging to the organization's staff), and so on.

Product ownership:

Saving_Accounts_Count Number of saving accounts

Current_Accounts_Count Number of current accounts

Time_Deposits_Count Number of time deposit accounts

Stock_Funds_Count Number of stock funds

Bond_Funds_Count Number of bond funds

Money_Market_Funds_Count Number of money market funds

Balanced_Funds_Count Number of balanced funds

Bonds_Count Number of bonds

Stocks_Count Number of stocks

Life_Assurance_Count Number of life insurance contracts

Pension_Insurance_Count Number of pension insurance contracts

Health_Insurance_Count Number of health insurance contracts

General_Insurances_Count Number of general insurance contracts

Business_Loans_Count Number of business loans

Business_Accounts_Count Number of business accounts

Business_Services_Count Number of business services

Mortgage_Count Number of mortgage loans