DIM_CUST_ACTIVITY_MASTER_LEADS
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ACTIVITY_ID | CHARACTER VARYING(20) | 20 |
| 2 | CUST_NUM | CHARACTER VARYING(20) | 20 |
| 3 | CMPY_CUST_NUM | CHARACTER VARYING(30) | 30 |
| 4 | LOB | CHARACTER VARYING(10) | 10 |
| 5 | BRND_CODE | CHARACTER VARYING(10) | 10 |
| 6 | PRODUCT_TYPE | CHARACTER VARYING(20) | 20 |
| 7 | PRODUCT_TYPE_DESC | CHARACTER VARYING(100) | 100 |
| 8 | FOLLOWUP_SYSTEM | CHARACTER VARYING(10) | 10 |
| 9 | PRODUCT_SUB_TYPE | CHARACTER VARYING(100) | 100 |
| 10 | CAMPAIGN_CODE | CHARACTER VARYING(50) | 50 |
| 11 | CAMPAIGN_NAME | CHARACTER VARYING(250) | 250 |
| 12 | TREATMENT_CODE | CHARACTER VARYING(50) | 50 |
| 13 | DIALLER_UNIQUE_CODE | CHARACTER VARYING(50) | 50 |
| 14 | POLICY_NUM | CHARACTER VARYING(20) | 20 |
| 15 | ACTIVITY_TYPE_CODE | CHARACTER VARYING(20) | 20 |
| 16 | ACTIVITY_STATUS_CODE | CHARACTER VARYING(10) | 10 |
| 17 | ACTIVITY_STATUS_DESC | CHARACTER VARYING(50) | 50 |
| 18 | ACTIVITY_RESOLUTION_CODE | CHARACTER VARYING(10) | 10 |
| 19 | ACTIVITY_RESOLUTION_NAME | CHARACTER VARYING(50) | 50 |
| 20 | ACTIVITY_EXPIRY_DATE | TIMESTAMP | 8 |
| 21 | FOLLOWUP_TYPE | CHARACTER VARYING(20) | 20 |
| 22 | RENEWAL_DUE_DATE | TIMESTAMP | 8 |
| 23 | TRANSFER_DATE | TIMESTAMP | 8 |
| 24 | CALL_BACK_DATE | TIMESTAMP | 8 |
| 25 | PREFERRED_CONTACT_TYPE | CHARACTER VARYING(20) | 20 |
| 26 | OTHER_CONTACT_DETAIL | CHARACTER VARYING(50) | 50 |
| 27 | PREFERRED_CONTACT_DETAIL | CHARACTER VARYING(50) | 50 |
| 28 | OCCUPATION_CODE | CHARACTER VARYING(100) | 100 |
| 29 | ACTIVITY_SOURCE_CODE | CHARACTER VARYING(50) | 50 |
| 30 | ACTIVITY_SOURCE_NAME | CHARACTER VARYING(50) | 50 |
| 31 | ACTIVITY_CREATED_USER_ID | CHARACTER VARYING(10) | 10 |
| 32 | ACTIVITY_CREATED_DATE | TIMESTAMP | 8 |
| 33 | ACTIVITY_UPDATED_USER_ID | CHARACTER VARYING(10) | 10 |
| 34 | ACTIVITY_UPDATED_DATE | TIMESTAMP | 8 |
| 35 | CREATED_BY_AGENT_BU_NAME | CHARACTER VARYING(100) | 100 |
| 36 | CREATED_BY_AGENT_GROUP_NAME | CHARACTER VARYING(100) | 100 |
| 37 | DIALLER_COMP_CODE | CHARACTER VARYING(20) | 20 |
| 38 | SUMMARY | CHARACTER VARYING(100) | 100 |
| 39 | SRC_CUST_NAM | CHARACTER VARYING(100) | 100 |
| 40 | SRC_SYS_ID | CHARACTER VARYING(10) | 10 |
| 41 | SNPSHT_DATE | TIMESTAMP | 8 |
| 42 | ORIGINATION_BRAND | CHARACTER VARYING(50) | 50 |
| 43 | EXTERNAL_ID_1 | CHARACTER VARYING(50) | 50 |
| 44 | EXTERNAL_ID_2 | CHARACTER VARYING(50) | 50 |
| 45 | EXTERNAL_SOURCE | CHARACTER VARYING(10) | 10 |
| 46 | EXTERNAL_DATA | CHARACTER VARYING(4000) | 4000 |
| 47 | PHONE_CONSENT | CHARACTER VARYING(1) | 1 |
| 48 | RECEIVED_DATE | TIMESTAMP | 8 |