Activities
Module: Device Analytics
Type: Fact
D1_ACTIVITY_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| D1_ACTIVITY_ID | VARCHAR2 | 14 | True | Activity | DW_EWDV_X_EWDI_DVC_D1_ACTIVITY_D | D1_ACTIVITY_ID | |
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| ACCT_ID | VARCHAR2 | 38 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| ACTIVITY_TYPE_CAT_FLG | VARCHAR2 | 4 | Activity Type Category | ||||
| ACTIVITY_TYPE_CD | VARCHAR2 | 30 | Activity Type | DW_EWDV_X_EWDI_DVC_D1_ACTIVITY_TYPE_D | ACTIVITY_TYPE_CD | ||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| BO_STATUS_COND_FLG | VARCHAR2 | 38 | Status Condition | ||||
| BO_STATUS_REASON_CD | VARCHAR2 | 38 | Status Reason | DW_EWB_X_EWDI_BASE_F1_BUS_OBJ_STATUS_RSN_D | BO_STATUS_REASON_CD | ||
| CRE_DT | DATE | 0 | Creation Date | ||||
| CRE_DTTM | TIMESTAMP | 0 | 6 | Creation Date/Time | |||
| CRE_TM | NUMBER | 38 | 0 | Creation Time | |||
| D1_DEVICE_ID | VARCHAR2 | 38 | Device | DW_EWB_X_EWDI_BASE_D1_DVC_D | D1_DEVICE_ID | ||
| D1_SPR_CD | VARCHAR2 | 38 | Service Provider | DW_EWDV_X_EWDI_DVC_D1_SPR_D | D1_SPR_CD | ||
| D1_SP_ID | VARCHAR2 | 38 | MDM Service Point | DW_EWB_X_EWDI_BASE_D1_SP_D | D1_SP_ID | ||
| D1_SP_TYPE_CD | VARCHAR2 | 38 | Service Point Type | DW_EWB_X_EWDI_BASE_D1_SP_TYPE_D | D1_SP_TYPE_CD | ||
| EFF_DT | NUMBER | 38 | 0 | Effective Date | |||
| EFF_DTTM | TIMESTAMP | 0 | 6 | Effective Date/Time | |||
| EFF_TM | NUMBER | 38 | 0 | Effective Time | |||
| END_DT | NUMBER | 38 | 0 | End Date | |||
| END_DTTM | TIMESTAMP | 0 | 6 | End Date/Time | |||
| END_TM | NUMBER | 38 | 0 | End Time | |||
| FACILITY_ID | VARCHAR2 | 38 | Facility | ||||
| PER_ID | VARCHAR2 | 38 | Person | DW_EWB_X_EWDI_BASE_CI_PER_D | PER_ID | ||
| PREM_ID | VARCHAR2 | 120 | 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 | ||
| START_DT | NUMBER | 38 | 0 | Start Date | |||
| START_DTTM | TIMESTAMP | 0 | 6 | Start Date/Time | |||
| START_TM | NUMBER | 38 | 0 | Start Time | |||
| STATUS_UPD_DT | NUMBER | 38 | 0 | Status Date | |||
| STATUS_UPD_DTTM | TIMESTAMP | 0 | 6 | Status Date/Time | |||
| STATUS_UPD_TM | NUMBER | 38 | 0 | Status Time | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |