DW_EWWA_X_EWDI_WACS_W1_ACTIVITY_TYPE_D

Details

Module: Work Asset Analytics

Type: Dimension

Key Columns

ACT_TYPE_CD

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACT_TYPE_CD VARCHAR2 30 True Asset Activity Type
SOURCE_RECORD_ID VARCHAR2 30 Source Record Id
CATEGORY_FLG VARCHAR2 4 Category
CONSTR_RELATED_FLG VARCHAR2 38 Construction Related
NT_XID_CD VARCHAR2 38 External System
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6