Module: Work Asset Analytics
Type: Dimension
LOC_ORG_NODE_ID
| 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 |