CDI_MCFD_BRAND_LEVEL_CUST_CONSENT
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 | HOUSEHOLD_ID | DOUBLE PRECISION | 8 |
| 5 | CUSTOMER_TENURE_MTHS | DOUBLE PRECISION | 8 |
| 6 | CUSTOMER_TENURE_YRS | DOUBLE PRECISION | 8 |
| 7 | DATE_OF_BIRTH | TIMESTAMP | 8 |
| 8 | AGE_MTHS | DOUBLE PRECISION | 8 |
| 9 | AGE_YRS | DOUBLE PRECISION | 8 |
| 10 | GENDER_IND | CHARACTER VARYING(3) | 3 |
| 11 | FA_IND | CHARACTER VARYING(3) | 3 |
| 12 | IFA_IND | CHARACTER VARYING(3) | 3 |
| 13 | CA_IND | CHARACTER VARYING(3) | 3 |
| 14 | HOME_LOAN_BROKER_IND | CHARACTER VARYING(3) | 3 |
| 15 | BB_BRKR_IND | CHARACTER VARYING(3) | 3 |
| 16 | TITLE | CHARACTER VARYING(30) | 30 |
| 17 | FIRST_NAME | CHARACTER VARYING(100) | 100 |
| 18 | MIDDLE_NAME | CHARACTER VARYING(100) | 100 |
| 19 | LAST_NAME | CHARACTER VARYING(50) | 50 |
| 20 | NAME_SUFFIX | CHARACTER VARYING(30) | 30 |
| 21 | PREFERRED_NAME | CHARACTER VARYING(50) | 50 |
| 22 | NAM | CHARACTER VARYING(200) | 200 |
| 23 | ORGANISATION_NAME | CHARACTER VARYING(150) | 150 |
| 24 | EMAIL_ADDRESS_TYPE_1 | CHARACTER VARYING(50) | 50 |
| 25 | EMAIL_ADDRESS_TYPE_2 | CHARACTER VARYING(50) | 50 |
| 26 | EMAIL_ADDRESS_1 | CHARACTER VARYING(100) | 100 |
| 27 | EMAIL_ADDRESS_2 | CHARACTER VARYING(100) | 100 |
| 28 | WORK_PHONE_NUMBER | CHARACTER VARYING(20) | 20 |
| 29 | HOME_PHONE_NUMBER | CHARACTER VARYING(20) | 20 |
| 30 | MOBILE_PHONE_NUMBER | CHARACTER VARYING(20) | 20 |
| 31 | EXTERNAL_PHONE_NUMBER | CHARACTER VARYING(20) | 20 |
| 32 | OTHER_PHONE_NUMBER | CHARACTER VARYING(20) | 20 |
| 33 | ADDRESS_TYPE | CHARACTER VARYING(20) | 20 |
| 34 | ADDRESS_LINE_1 | CHARACTER VARYING(50) | 50 |
| 35 | ADDRESS_LINE_2 | CHARACTER VARYING(50) | 50 |
| 36 | ADDRESS_LINE_3 | CHARACTER VARYING(50) | 50 |
| 37 | SUBURB | CHARACTER VARYING(50) | 50 |
| 38 | PCODE | CHARACTER VARYING(10) | 10 |
| 39 | STATE | CHARACTER VARYING(50) | 50 |
| 40 | COUNTRY | CHARACTER VARYING(100) | 100 |
| 41 | DPID | CHARACTER VARYING(20) | 20 |
| 42 | CENSUS_COLCTIVE_DISTRICT_CODE | CHARACTER VARYING(10) | 10 |
| 43 | CONSENT_GLOBAL_IND | CHARACTER VARYING(3) | 3 |
| 44 | SENIOR_DISC_IND | CHARACTER VARYING(3) | 3 |
| 45 | MULTI_POL_DISC_IND | CHARACTER VARYING(3) | 3 |
| 46 | OVR_55_DISC_IND | CHARACTER VARYING(3) | 3 |
| 47 | COMBINED_DISC_IND | CHARACTER VARYING(3) | 3 |
| 48 | STAFF_DISC_IND | CHARACTER VARYING(3) | 3 |
| 49 | ALM_DISC_IND | CHARACTER VARYING(3) | 3 |
| 50 | RETIREE_DISC_IND | CHARACTER VARYING(3) | 3 |
| 51 | POL_DISC_IND | CHARACTER VARYING(3) | 3 |
| 52 | SECURE_DISC_IND | CHARACTER VARYING(3) | 3 |
| 53 | STAFF_FAMILY_DISC_IND | CHARACTER VARYING(3) | 3 |
| 54 | FAMILY_NO_CLM_DISC_IND | CHARACTER VARYING(3) | 3 |
| 55 | GI_BROKER_IND | CHARACTER VARYING(3) | 3 |
| 56 | OWNERSHIP_GROUP | DOUBLE PRECISION | 8 |
| 57 | LIFECYCLE_STAT_CODE | CHARACTER VARYING(50) | 50 |
| 58 | RTRN_MAIL_FLG | CHARACTER VARYING(3) | 3 |
| 59 | DIRECT_MAIL_CONSNT_IND | CHARACTER VARYING(3) | 3 |
| 60 | OTM_CONSNT_IND | CHARACTER VARYING(3) | 3 |
| 61 | EMAIL_CONSNT_IND | CHARACTER VARYING(3) | 3 |
| 62 | SMS_CONSNT_IND | CHARACTER VARYING(3) | 3 |
| 63 | SRVY_CONSNT_IND | CHARACTER VARYING(3) | 3 |
| 64 | GLOBAL_CONSNT_DATE | TIMESTAMP | 8 |
| 65 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 66 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 67 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 68 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |