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

Table 4.30 Basic customer information table.

Field name Field type Field description

Customer_ID Int Customer ID or loyalty card ID

VAT_Num Char VAT number

Gender_Code Int Gender - code number

Marital_Status_Code Int Marital status - code number

Children_Num Int Number of children

Child_Birth_Date Datetime The date of birth of first child

Educational_Status_Code Int Educational status - code number

Occupation_Code Int Occupation - code number

Annual_Income_Code Int Annual income band - code number

Birth_Date Datetime Date of birth

Death_Date Datetime Date of death, otherwise a control date

Registration_Date Datetime First registration date

Closure_Date Datetime Date of customer relationship closure

First_Name Char First name

Last_Name Char Last name

Middle_Name Char Middle name

Home_Street Char Home street name

Home_Num Char Home street number

Home_City Char Home city

Home_State Char Home state

Home_ZIP Char Home ZIP code

Home_Country Char Home country

Fixed_Phone Nchar Home phone number

Mobile_Phone Nchar Work phone number

Home_Email Char Home e-mail

Work_Email Char Work e-mail

Last_Update Datetime Last date of customer record update

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