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

Table 4.4 The product ownership and utilization table.

Field name Field type Field description

Year_Month Int The number that indicates the year and month of

data

Customer_ID Int The customer identification number

Account_ID Int The product account identification number

Primary_Flag Bit Primary owner of the account - flag

Product_Code Int The account product code (see next ''L_Produc-

t_Code'' lookup table)

Interest_Rate Real The rate of interest (when applicable)

Interest_Type Int The type of interest (floating, fixed - when appli-

cable)

Credit_Limit Real The credit limit (when applicable - credit cards)

Fee Real The fee amount (when applicable - credit cards)

Approved_Amount Real The approved amount (when applicable -

personal loans)

Used_Amount Real The actually used amount (when

applicable - personal loans disbursal)

Installment_Amount Real The monthly installment amount (when applicable)

Min_Payment_Amount Real The minimum payment amount (when

applicable - credit cards)

Outstanding_Balance Real The outstanding balance (end of month balance)

Average_Balance Real The (daily) average balance

Max_Balance Real The maximum balance within a month

Min_Balance Real The minimum balance within a month

Revenue Real The projected monthly revenue

Cost Real The projected monthly cost

Arrears_Months Int Months in arrears (when applicable - credit cards,

personal loans, etc.)

Year_Month, Customer_ID, and Account_ID are the primary keys (PKs) of this table.

LOOKUP INFORMATION

A lookup table contains entries (records) which store key-value pairs. Each key
is mapped to a corresponding value(s). The value provides additional information,
such as key description or categorization information.