CDI_MCFD_BRAND_LEVEL_CUST

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUST_NUM CHARACTER VARYING(20) 20
2 BRND_CODE CHARACTER VARYING(50) 50
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 FA_IND CHARACTER VARYING(1) 1
11 IFA_IND CHARACTER VARYING(1) 1
12 CA_IND CHARACTER VARYING(1) 1
13 HOME_LOAN_BROKER_IND CHARACTER VARYING(1) 1
14 BB_BROKER_IND CHARACTER VARYING(1) 1
15 TITLE CHARACTER VARYING(30) 30
16 FIRST_NAME CHARACTER VARYING(50) 50
17 MIDDLE_NAME CHARACTER VARYING(60) 60
18 LAST_NAME CHARACTER VARYING(50) 50
19 NAME_SUFFIX CHARACTER VARYING(30) 30
20 PREFERRED_NAME CHARACTER VARYING(50) 50
21 NAME CHARACTER VARYING(200) 200
22 ORGANISATION_NAME CHARACTER VARYING(150) 150
23 EMAIL_ADDRESS_1 CHARACTER VARYING(100) 100
24 EMAIL_ADDRESS_2 CHARACTER VARYING(100) 100
25 EMAIL_ADDRESS_TYPE_1 CHARACTER VARYING(50) 50
26 EMAIL_ADDRESS_TYPE_2 CHARACTER VARYING(50) 50
27 WORK_PHONE_NUMBER CHARACTER VARYING(20) 20
28 HOME_PHONE_NUMBER CHARACTER VARYING(20) 20
29 MOBILE_PHONE_NUMBER CHARACTER VARYING(20) 20
30 EXTERNAL_PHONE_NUMBER CHARACTER VARYING(20) 20
31 OTHER_PHONE_NUMBER CHARACTER VARYING(20) 20
32 ADDRESS_TYPE CHARACTER VARYING(50) 50
33 ADDRESS_LINE_1 CHARACTER VARYING(50) 50
34 ADDRESS_LINE_2 CHARACTER VARYING(50) 50
35 ADDRESS_LINE_3 CHARACTER VARYING(50) 50
36 SUBURB CHARACTER VARYING(50) 50
37 PCODE CHARACTER VARYING(10) 10
38 STATE CHARACTER VARYING(50) 50
39 COUNTRY CHARACTER VARYING(100) 100
40 DPID CHARACTER VARYING(15) 15
41 CENSUS_COLCTIVE_DISTRICT_CODE CHARACTER VARYING(10) 10
42 CONSENT_GLOBAL_IND CHARACTER VARYING(3) 3
43 SENIOR_DISC_IND CHARACTER VARYING(2) 2
44 MULTI_POL_DISC_IND CHARACTER VARYING(2) 2
45 OVR_55_DISC_IND CHARACTER VARYING(2) 2
46 COMBINED_DISC_IND CHARACTER VARYING(2) 2
47 STAFF_DISC_IND CHARACTER VARYING(2) 2
48 ALM_DISC_IND CHARACTER VARYING(2) 2
49 RETIREE_DISC_IND CHARACTER VARYING(2) 2
50 POL_DISC_IND CHARACTER VARYING(2) 2
51 SECURE_DISC_IND CHARACTER VARYING(2) 2
52 STAFF_FAMILY_DISC_IND CHARACTER VARYING(2) 2
53 FAMILY_NO_CLM_DISC_IND CHARACTER VARYING(2) 2
54 GI_BROKER_IND CHARACTER VARYING(3) 3
55 OWNERSHIP_GROUP DOUBLE PRECISION 8
56 LIFECYCLE_STAT_CODE CHARACTER VARYING(50) 50
57 RTRN_MAIL_FLG CHARACTER VARYING(3) 3
58 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
59 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
60 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
61 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8