CDI_MCFD_CUSTOMER

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_NUM CHARACTER VARYING(20) 20
2 HOUSEHOLD_ID DOUBLE PRECISION 8
3 ENTITY_TYPE CHARACTER VARYING(20) 20
4 CUSTOMER_TENURE_MTHS DOUBLE PRECISION 8
5 CUSTOMER_TENURE_YRS DOUBLE PRECISION 8
6 DATE_OF_BIRTH TIMESTAMP 8
7 AGE_MTHS DOUBLE PRECISION 8
8 AGE_YRS DOUBLE PRECISION 8
9 GENDER_IND CHARACTER VARYING(3) 3
10 DECEASED_IND CHARACTER VARYING(3) 3
11 BANKRUPT_IND CHARACTER VARYING(3) 3
12 EMPLOYEE_IND CHARACTER VARYING(3) 3
13 FA_IND CHARACTER VARYING(1) 1
14 IFA_IND CHARACTER VARYING(1) 1
15 CA_IND CHARACTER VARYING(1) 1
16 HOME_LOAN_BROKER_IND CHARACTER VARYING(1) 1
17 BB_BROKER_IND CHARACTER VARYING(1) 1
18 TITLE CHARACTER VARYING(30) 30
19 FIRST_NAME CHARACTER VARYING(50) 50
20 MIDDLE_NAME CHARACTER VARYING(60) 60
21 LAST_NAME CHARACTER VARYING(50) 50
22 NAME_SUFFIX CHARACTER VARYING(30) 30
23 PREFERRED_NAME CHARACTER VARYING(50) 50
24 NAME CHARACTER VARYING(200) 200
25 ORGANISATION_NAME CHARACTER VARYING(150) 150
26 DRIVERS_LICENCE_NUMBER CHARACTER VARYING(20) 20
27 ABN CHARACTER VARYING(20) 20
28 ADDRESS_TYPE CHARACTER VARYING(50) 50
29 PCODE CHARACTER VARYING(10) 10
30 STATE CHARACTER VARYING(50) 50
31 COUNTRY CHARACTER VARYING(100) 100
32 DPID CHARACTER VARYING(15) 15
33 CENSUS_COLCTIVE_DISTRICT_CODE CHARACTER VARYING(10) 10
34 MOSAIC_AFFLUENCE_CODE INTEGER 4
35 MOSAIC_ESTIMATED_INCOME DOUBLE PRECISION 8
36 MOSAIC_FACTORS_SCORES_2008_1 INTEGER 4
37 MOSAIC_FACTORS_SCORES_2008_2 INTEGER 4
38 MOSAIC_FACTORS_SCORES_2008_3 INTEGER 4
39 MOSAIC_FACTORS_SCORES_2008_4 INTEGER 4
40 MOSAIC_FACTORS_SCORES_2008_5 INTEGER 4
41 MOSAIC_FACTORS_SCORES_2008_6 INTEGER 4
42 MOSAIC_FACTORS_PC_2008_1 INTEGER 4
43 MOSAIC_FACTORS_PC_2008_2 INTEGER 4
44 MOSAIC_FACTORS_PC_2008_3 INTEGER 4
45 MOSAIC_FACTORS_PC_2008_4 INTEGER 4
46 MOSAIC_FACTORS_PC_2008_5 INTEGER 4
47 MOSAIC_FACTORS_PC_2008_6 INTEGER 4
48 MOSAIC_RELATIONS_TYPE_CODE CHARACTER VARYING(4) 4
49 MICRO_SGMNT_TYP_CODE CHARACTER VARYING(4) 4
50 GEODEMO_SEGMENT_CODE CHARACTER VARYING(10) 10
51 GEODEMOGRAPHIC_SEGMT_TITLE CHARACTER VARYING(100) 100
52 GEODEMOGRAPHIC_SEGMT_SUBTITLE CHARACTER VARYING(75) 75
53 ONL_ACCESS_STAT_CODE CHARACTER VARYING(20) 20
54 ONL_ACCESS_STAT_DESC CHARACTER VARYING(50) 50
55 INT_BANK_REG_DATE TIMESTAMP 8
56 INT_BANK_TENURE_MTHS DOUBLE PRECISION 8
57 INT_BANK_TENURE_YRS DOUBLE PRECISION 8
58 LAST_INT_BANK_DATE TIMESTAMP 8
59 LAST_INT_BANK_MTHS DOUBLE PRECISION 8
60 LAST_INT_BANK_YRS DOUBLE PRECISION 8
61 INT_BANK_LOGONS_LAST_MTH DOUBLE PRECISION 8
62 INT_BANK_LOGONS_LAST_3_MTHS DOUBLE PRECISION 8
63 INT_BANK_LOGONS_LAST_12_MTHS DOUBLE PRECISION 8
64 SENIOR_DISC_IND CHARACTER VARYING(2) 2
65 MULTI_POL_DISC_IND CHARACTER VARYING(2) 2
66 OVR_55_DISC_IND CHARACTER VARYING(2) 2
67 COMBINED_DISC_IND CHARACTER VARYING(2) 2
68 STAFF_DISC_IND CHARACTER VARYING(2) 2
69 ALM_DISC_IND CHARACTER VARYING(2) 2
70 RETIREE_DISC_IND CHARACTER VARYING(2) 2
71 POL_DISC_IND CHARACTER VARYING(2) 2
72 SECURE_DISC_IND CHARACTER VARYING(2) 2
73 STAFF_FAMILY_DISC_IND CHARACTER VARYING(2) 2
74 FAMILY_NO_CLM_DISC_IND CHARACTER VARYING(2) 2
75 CHILD_PRESENT_IND CHARACTER VARYING(2) 2
76 GI_BROKER_IND CHARACTER VARYING(3) 3
77 OWNERSHIP_GROUP DOUBLE PRECISION 8
78 LIFECYCLE_STAT_CODE CHARACTER VARYING(50) 50
79 RTRN_MAIL_FLG CHARACTER VARYING(3) 3
80 COMPLETE_CUST_SCORE_VAL DOUBLE PRECISION 8
81 EFTPOS_DEPOSITS_ELSEWHERE_IND CHARACTER VARYING(1) 1
82 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
83 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
84 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
85 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8