DW_EWDV_X_EWDI_DVC_D1_DVC_EVT_D

Details

Module: Device Analytics

Type: Dimension

Key Columns

DVC_EVT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DVC_EVT_ID VARCHAR2 14 True Device Event
SOURCE_RECORD_ID VARCHAR2 14 Source Record Id
BO_STATUS_CD VARCHAR2 12 Status
DEVICE_ID VARCHAR2 38 Device ID
DVC_EVT_DTTM TIMESTAMP 0 6 Device Event Date/Time
DVC_EVT_END_DTTM TIMESTAMP 0 6 Device Event End Date/Time
EXT_EVT_NAME_FLG VARCHAR2 254 External Event Name
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6