Device Events
Module: Device Analytics
Type: Fact
DVC_EVT_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| DVC_EVT_ID | VARCHAR2 | 14 | True | Device Event | DW_EWDV_X_EWDI_DVC_D1_DVC_EVT_D | DVC_EVT_ID | |
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| ACCT_ID | VARCHAR2 | 38 | Account | DW_EWB_X_EWDI_BASE_CI_ACCT_D | ACCT_ID | ||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| 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 | NUMBER | 38 | 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 | ||
| DVC_EVT_DT | DATE | 0 | Device Event Date | ||||
| DVC_EVT_TM | NUMBER | 38 | 0 | Device Event Time | |||
| DVC_EVT_TYPE_CD | VARCHAR2 | 38 | Device Event Type | DW_EWDV_X_EWDI_DVC_D1_DVC_EVT_TYPE_D | DVC_EVT_TYPE_CD | ||
| EXT_EVT_NAME_FLG | VARCHAR2 | 254 | External Event Name | ||||
| MEASR_COMP_ID | VARCHAR2 | 2 | Measuring Component | DW_EWB_X_EWDI_BASE_D1_MEASR_COMP_D | MEASR_COMP_ID | ||
| 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 | ||
| STATUS_UPD_DT | NUMBER | 38 | 0 | Status Date | |||
| STATUS_UPD_TM | NUMBER | 38 | 0 | Status Time | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |