FCT_CUST_RESPONSYS_GCIS_CUSTOMER_PROFILE
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | GCIS_ID | NUMERIC(22,0) | 19 |
| 2 | CUST_NUM | CHARACTER VARYING(20) | 20 |
| 3 | BRAND | CHARACTER VARYING(10) | 10 |
| 4 | OCID | CHARACTER VARYING(70) | 70 |
| 5 | ENTITY_TYPE | CHARACTER VARYING(20) | 20 |
| 6 | TITLE | CHARACTER VARYING(20) | 20 |
| 7 | FIRST_NAME | CHARACTER VARYING(100) | 100 |
| 8 | LAST_NAME | CHARACTER VARYING(50) | 50 |
| 9 | EMAIL_ADDRESS | CHARACTER VARYING(100) | 100 |
| 10 | EMAIL_PERMISSION_STATUS | CHARACTER VARYING(5) | 5 |
| 11 | MOBILE_NUMBER | CHARACTER VARYING(22) | 22 |
| 12 | MOBILE_PERMISSION_STATUS | CHARACTER VARYING(5) | 5 |
| 13 | MOBILE_COUNTRY | CHARACTER VARYING(2) | 2 |
| 14 | POSTAL_CODE | CHARACTER VARYING(20) | 20 |
| 15 | CITY | CHARACTER VARYING(50) | 50 |
| 16 | STATE | CHARACTER VARYING(50) | 50 |
| 17 | DOB | TIMESTAMP | 8 |
| 18 | AGE | BIGINT | 8 |
| 19 | GENDER | CHARACTER VARYING(4) | 4 |
| 20 | BRAND_EXCLUSION_FLAG | CHARACTER VARYING(1) | 1 |
| 21 | OVER_MATCH_FLAG | CHARACTER VARYING(1) | 1 |
| 22 | EMBARGO_FLAG | CHARACTER VARYING(1) | 1 |
| 23 | CURRENT_INSURANCE_CLAIMS_FLAG | CHARACTER VARYING(1) | 1 |
| 24 | BANK_EXCLUSION_FLAG | CHARACTER VARYING(1) | 1 |
| 25 | INSURANCE_EXCLUSION_FLAG | CHARACTER VARYING(1) | 1 |
| 26 | ACTIVE_COMPLAINT_FLAG | CHARACTER VARYING(1) | 1 |
| 27 | EMAIL_CONSENT_ERROR_FLAG | CHARACTER VARYING(1) | 1 |
| 28 | SMS_CONSENT_ERROR_FLAG | CHARACTER VARYING(1) | 1 |
| 29 | BRAND_PRODUCT_TYPE | CHARACTER VARYING(339) | 339 |
| 30 | GROUP_PRODUCT_TYPE | CHARACTER VARYING(339) | 339 |
| 31 | BANK_IND | CHARACTER VARYING(1) | 1 |
| 32 | HOME_INSURANCE_IND | CHARACTER VARYING(1) | 1 |
| 33 | MOTOR_INSURANCE_IND | CHARACTER VARYING(1) | 1 |
| 34 | CTP_INSURANCE_IND | CHARACTER VARYING(1) | 1 |
| 35 | CTP_EXCLUSION | CHARACTER VARYING(1) | 1 |
| 36 | HEALTH_IND | CHARACTER VARYING(1) | 1 |
| 37 | LIFE_IND | CHARACTER VARYING(1) | 1 |
| 38 | LOYALTY_IND | CHARACTER VARYING(1) | 1 |
| 39 | END_IND | CHARACTER VARYING(1) | 1 |
| 40 | MPD_IND | CHARACTER VARYING(1) | 1 |
| 41 | IB_IND | CHARACTER VARYING(1) | 1 |
| 42 | IB_DATE | TIMESTAMP | 8 |
| 43 | ELIGIBLE_MPD_COUNT | BIGINT | 8 |
| 44 | BUSINESS_INSURANCE_IND | CHARACTER VARYING(1) | 1 |