WORK REQUEST FUNC LOC HIER Table
View exposing functional location hierarchy data associated with facilities work requests and maintenance reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FUNCTIONAL_LOCATION_KEY |
Surrogate key identifying the functional location. |
VARCHAR2 |
30 |
HIERARCHY_TYPE |
Hierarchy type associated with the record. |
VARCHAR2 |
4 |
LEVEL_1_CODE |
Code identifying level 1. |
VARCHAR2 |
40 |
LEVEL_1_NAME |
Level 1 name associated with the record. |
VARCHAR2 |
40 |
LEVEL_2_CODE |
Code identifying level 2. |
VARCHAR2 |
40 |
LEVEL_2_NAME |
Level 2 name associated with the record. |
VARCHAR2 |
40 |
LEVEL_3_CODE |
Code identifying level 3. |
VARCHAR2 |
40 |
LEVEL_3_NAME |
Level 3 name associated with the record. |
VARCHAR2 |
40 |
LEVEL_4_CODE |
Code identifying level 4. |
VARCHAR2 |
40 |
LEVEL_4_NAME |
Level 4 name associated with the record. |
VARCHAR2 |
40 |
LEVEL_5_CODE |
Code identifying level 5. |
VARCHAR2 |
40 |
LEVEL_5_NAME |
Level 5 name associated with the record. |
VARCHAR2 |
40 |
LEVEL_6_CODE |
Code identifying level 6. |
VARCHAR2 |
40 |
LEVEL_6_NAME |
Level 6 name associated with the record. |
VARCHAR2 |
40 |
LEVEL_7_CODE |
Code identifying level 7. |
VARCHAR2 |
40 |
LEVEL_7_NAME |
Level 7 name associated with the record. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WORK_REQUEST_KEY |
Surrogate key identifying the work request. |
VARCHAR2 |
12 |