Install Event
Module: Device Analytics
Type: Fact
BI_INSTALL_EVT_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| BI_INSTALL_EVT_ID | VARCHAR2 | 12 | True | Install Event ID | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| BO_STATUS_CD | VARCHAR2 | 12 | Status | ||||
| CRE_DT | NUMBER | 38 | 0 | Creation Date | |||
| CRE_TM | NUMBER | 38 | 0 | Creation Time | |||
| D1_INSTALL_DT | DATE | 0 | Install Date | ||||
| D1_INSTALL_TM | NUMBER | 38 | 0 | ||||
| D1_REMOVAL_DT | NUMBER | 38 | 0 | Removal Date | |||
| D1_REMOVAL_TM | NUMBER | 38 | 0 | Removal Time | |||
| D1_SP_ID | VARCHAR2 | 38 | MDM Service Point | DW_EWB_X_EWDI_BASE_D1_SP_D | D1_SP_ID | ||
| DEVICE_CONFIG_ID | VARCHAR2 | 38 | Device Configuration | DW_EWDV_X_EWDI_DVC_D1_DVC_CFG_D | DEVICE_CONFIG_ID | ||
| INSTALLATION_CONST | NUMBER | 12 | 6 | Installation Constant | |||
| 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 |