Customer Contact
Module: Customer Analytics
Type: Fact
CC_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CC_ID | VARCHAR2 | 10 | True | Customer Contact | |||
| SOURCE_RECORD_ID | VARCHAR2 | 10 | Source Record Id | ||||
| ACCT_ID | VARCHAR2 | 38 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| BATCH_CD | VARCHAR2 | 38 | Batch Control | DW_EWB_X_EWDI_BASE_CI_BATCH_CTRL_D | BATCH_CD | ||
| BATCH_NBR | NUMBER | 10 | 0 | Batch Number | |||
| C1_CONTACT_ID | VARCHAR2 | 38 | Person Contact | DW_EWC_X_EWDI_CUST_C1_PER_CONTDET_D | C1_CONTACT_ID | ||
| CC_CL_CD | VARCHAR2 | 4 | Contact Class | DW_EWC_X_EWDI_CUST_CI_CC_TYPE_D | CC_CL_CD | ||
| CC_DT | NUMBER | 38 | 0 | Contact Date | |||
| CC_ENTITY_FLG | VARCHAR2 | 4 | Customer Contact Entity | ||||
| CC_STATUS_FLG | VARCHAR2 | 38 | Contact Status | ||||
| CC_TM | NUMBER | 38 | 0 | Contact Time | |||
| CC_TYPE_CD | VARCHAR2 | 12 | Contact Type | DW_EWC_X_EWDI_CUST_CI_CC_TYPE_D | CC_TYPE_CD | ||
| CONTACT_METH_FLG | VARCHAR2 | 38 | Preferred Contact Method | ||||
| DESCRLONG | VARCHAR2 | 4000 | Detailed Description | ||||
| LETTER_PRINT_DT | NUMBER | 38 | 0 | Letter Print Date | |||
| LETTER_PRINT_TM | NUMBER | 38 | 0 | Letter Print Time | |||
| LTR_TMPL_CD | VARCHAR2 | 38 | Letter Template | DW_EWC_X_EWDI_CUST_CI_LETTER_TMPL_D | LTR_TMPL_CD | ||
| PER_ID | VARCHAR2 | 38 | Person | DW_EWB_X_EWDI_BASE_CI_PER_D | PER_ID | ||
| PREM_ID | VARCHAR2 | 38 | Premise | DW_EWB_X_EWDI_BASE_CI_PREM_D | PREM_ID | ||
| PRINT_LETTER_SW | VARCHAR2 | 1 | Print Letter | ||||
| USER_ID | VARCHAR2 | 38 | User | DW_EWB_X_EWDI_BASE_SC_USER_D | USER_ID | ||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |