DW_EWWA_X_EWDI_WACS_W1_BI_NODE_HIERARCHY_D

Details

Module: Work Asset Analytics

Type: Dimension

Key Columns

LOC_ORG_NODE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LOC_ORG_NODE_ID VARCHAR2 12 True Location/Organization
SOURCE_RECORD_ID VARCHAR2 12 Source Record Id
DESCR100 VARCHAR2 100 Description
DESCR100_LVL1 VARCHAR2 100 Location Level 1 Description
DESCR100_LVL10 VARCHAR2 100 Location Level 10 Description
DESCR100_LVL11 VARCHAR2 100 Location Level 11 Description
DESCR100_LVL12 VARCHAR2 100 Location Level 12 Description
DESCR100_LVL13 VARCHAR2 100 Location Level 13 Description
DESCR100_LVL14 VARCHAR2 100 Location Level 14 Description
DESCR100_LVL15 VARCHAR2 100 Location Level 15 Description
DESCR100_LVL2 VARCHAR2 100 Location Level 2 Description
DESCR100_LVL3 VARCHAR2 100 Location Level 3 Description
DESCR100_LVL4 VARCHAR2 100 Location Level 4 Description
DESCR100_LVL5 VARCHAR2 100 Location Level 5 Description
DESCR100_LVL6 VARCHAR2 100 Location Level 6 Description
DESCR100_LVL7 VARCHAR2 100 Location Level 7 Description
DESCR100_LVL8 VARCHAR2 100 Location Level 8 Description
DESCR100_LVL9 VARCHAR2 100 Location Level 9 Description
NODE_BUS_OBJ_DESCR100 VARCHAR2 38 Location Business Object Description
NODE_BUS_OBJ_DESCR100_LVL1 VARCHAR2 38 Location Level 1 Business Object Description
NODE_BUS_OBJ_DESCR100_LVL10 VARCHAR2 38 Location Level 10 Business Object Description
NODE_BUS_OBJ_DESCR100_LVL11 VARCHAR2 38 Location Level 11 Business Object Description
NODE_BUS_OBJ_DESCR100_LVL12 VARCHAR2 38 Location Level 12 Business Object Description
NODE_BUS_OBJ_DESCR100_LVL13 VARCHAR2 38 Location Level 13 Business Object Description
NODE_BUS_OBJ_DESCR100_LVL14 VARCHAR2 38 Location Level 14 Business Object Description
NODE_BUS_OBJ_DESCR100_LVL15 VARCHAR2 38 Location Level 15 Business Object Description
NODE_BUS_OBJ_DESCR100_LVL2 VARCHAR2 38 Location Level 2 Business Object Description
NODE_BUS_OBJ_DESCR100_LVL3 VARCHAR2 38 Location Level 3 Business Object Description
NODE_BUS_OBJ_DESCR100_LVL4 VARCHAR2 38 Location Level 4 Business Object Description
NODE_BUS_OBJ_DESCR100_LVL5 VARCHAR2 38 Location Level 5 Business Object Description
NODE_BUS_OBJ_DESCR100_LVL6 VARCHAR2 38 Location Level 6 Business Object Description
NODE_BUS_OBJ_DESCR100_LVL7 VARCHAR2 38 Location Level 7 Business Object Description
NODE_BUS_OBJ_DESCR100_LVL8 VARCHAR2 38 Location Level 8 Business Object Description
NODE_BUS_OBJ_DESCR100_LVL9 VARCHAR2 38 Location Level 9 Business Object Description
NODE_ID_LVL1 VARCHAR2 38 Location Level 1
NODE_ID_LVL10 VARCHAR2 38 Location Level 10
NODE_ID_LVL11 VARCHAR2 38 Location Level 11
NODE_ID_LVL12 VARCHAR2 38 Location Level 12
NODE_ID_LVL13 VARCHAR2 38 Location Level 13
NODE_ID_LVL14 VARCHAR2 38 Location Level 14
NODE_ID_LVL15 VARCHAR2 38 Location Level 15
NODE_ID_LVL2 VARCHAR2 38 Location Level 2
NODE_ID_LVL3 VARCHAR2 38 Location Level 3
NODE_ID_LVL4 VARCHAR2 38 Location Level 4
NODE_ID_LVL5 VARCHAR2 38 Location Level 5
NODE_ID_LVL6 VARCHAR2 38 Location Level 6
NODE_ID_LVL7 VARCHAR2 38 Location Level 7
NODE_ID_LVL8 VARCHAR2 38 Location Level 8
NODE_ID_LVL9 VARCHAR2 38 Location Level 9
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6