To Do Entry
Module: Common
Type: Fact
TD_ENTRY_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| TD_ENTRY_ID | VARCHAR2 | 14 | True | To Do | |||
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| ACCT_ID | VARCHAR2 | 38 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| ASSIGNED_DT | NUMBER | 38 | 0 | Assigned Date | |||
| ASSIGNED_DTTM | TIMESTAMP | 0 | 6 | Assigned Date/Time | |||
| ASSIGNED_TM | NUMBER | 38 | 0 | Assigned Time | |||
| ASSIGNED_TO_USER_ID | VARCHAR2 | 38 | Assigned to User | DW_EWB_X_EWDI_BASE_SC_USER_D | USER_ID | ||
| COMPLETE_DT | NUMBER | 38 | 0 | Completion Date | |||
| COMPLETE_DTTM | TIMESTAMP | 0 | 6 | Completion Date/Time | |||
| COMPLETE_TM | NUMBER | 38 | 0 | Completion Time | |||
| COMPLETE_TM_MINS | NUMBER | 38 | 2 | Completion Duration (in minutes) | |||
| COMPLETE_USER_ID | VARCHAR2 | 38 | Completed By | DW_EWB_X_EWDI_BASE_SC_USER_D | USER_ID | ||
| CONTACT_ID | VARCHAR2 | 38 | Contact ID | ||||
| D1_DEVICE_ID | VARCHAR2 | 38 | Device | DW_EWB_X_EWDI_BASE_D1_DVC_D | D1_DEVICE_ID | ||
| D1_SP_ID | VARCHAR2 | 38 | MDM Service Point | DW_EWB_X_EWDI_BASE_D1_SP_D | D1_SP_ID | ||
| ENTRY_STATUS_FLG | VARCHAR2 | 2 | Status | ||||
| MEASR_COMP_ID | VARCHAR2 | 38 | Measuring Component | DW_EWB_X_EWDI_BASE_D1_MEASR_COMP_D | MEASR_COMP_ID | ||
| MESSAGE_CAT_NBR | NUMBER | 5 | 0 | Message Category | DW_EWB_X_EWDI_BASE_CI_MSG_D | MESSAGE_CAT_NBR | |
| 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 | ||
| SA_ID | VARCHAR2 | 38 | Service Agreement | DW_EWB_X_EWDI_BASE_CI_SA_D | SA_ID | ||
| TD_CRE_DT | NUMBER | 38 | 0 | Creation Date | |||
| TD_CRE_DTTM | TIMESTAMP | 0 | 6 | Creation Date/Time | |||
| TD_CRE_TM | NUMBER | 38 | 0 | Creation Time | |||
| TD_ENTRY_MESSAGE_NBR | NUMBER | 5 | 0 | Message | DW_EWB_X_EWDI_BASE_CI_MSG_D | MESSAGE_TXT | |
| TD_PRIORITY_FLG | VARCHAR2 | 4 | Priority | ||||
| TD_TYPE_CD | VARCHAR2 | 8 | To Do Type | DW_EWB_X_EWDI_BASE_CI_TD_TYPE_D | TD_TYPE_CD | ||
| US_ID | VARCHAR2 | 38 | Usage Subscription | DW_EWB_X_EWDI_BASE_D1_US_D | US_ID | ||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |