Case Log
Module: Customer Analytics
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CASE_ID | VARCHAR2 | 10 | Case ID | ||||
| SEQ_NUM | NUMBER | 3 | 0 | Sequence | |||
| SOURCE_RECORD_ID | VARCHAR2 | 49 | Source Record Id | ||||
| ACCT_ID | VARCHAR2 | 38 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| ACCT_SK | VARCHAR2 | 39 | Account | ||||
| CASE_LOG_TYPE_FLG | VARCHAR2 | 4 | Log Type | ||||
| CASE_STATUS_CD | VARCHAR2 | 12 | Status | DW_EWC_X_EWDI_CUST_CI_CASE_STATUS_D | CASE_STATUS_CD | ||
| CASE_TYPE_CD | VARCHAR2 | 12 | Case Type | DW_EWC_X_EWDI_CUST_CI_CASE_TYPE_D | CASE_TYPE_CD | ||
| LEAD_LOG_DT | NUMBER | 38 | 0 | ||||
| LEAD_LOG_DTTM | TIMESTAMP | 0 | 6 | ||||
| LEAD_LOG_TM | NUMBER | 38 | 0 | ||||
| LOG_DT | NUMBER | 38 | 0 | Log Date | |||
| LOG_DTTM | TIMESTAMP | 0 | 6 | Log Date/Time | |||
| LOG_TM | NUMBER | 38 | 0 | Log Time | |||
| PER_ID | VARCHAR2 | 38 | Person | DW_EWB_X_EWDI_BASE_CI_PER_D | PER_ID | ||
| PER_SK | VARCHAR2 | 39 | Person | ||||
| PREM_ID | VARCHAR2 | 38 | Premise | DW_EWB_X_EWDI_BASE_CI_PREM_D | PREM_ID | ||
| PREM_SK | VARCHAR2 | 39 | Premise | ||||
| PREV_CASE_STATUS_CD | VARCHAR2 | 38 | Previous Case Status | ||||
| PREV_LOG_DT | NUMBER | 38 | 0 | Previous Log Date | |||
| PREV_LOG_DTTM | TIMESTAMP | 0 | 6 | Previous Log Date/Time | |||
| PREV_LOG_TM | NUMBER | 38 | 0 | Previous Log Time | |||
| PREV_STATE_DUR | NUMBER | 38 | 2 | Duration in Previous State (in minutes) | |||
| STATUS_COND_FLG | VARCHAR2 | 4 | Status Condition | ||||
| 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 |