SPACE UNIT Table
Physical Plant data -- org units
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
DLC_KEY |
a unigue key to enable joining information stored with other forms of Department Key |
VARCHAR2 |
15 |
FCLT_ORGANIZATION_KEY |
XXX |
VARCHAR2 |
16 |
SPACE_UNIT |
The title of the organizational unit that owns the room, according to the Department of Facilities. |
VARCHAR2 |
16 |
SPACE_UNIT_CODE |
The 6-digit HR unit code of the organizational unit that owns the room, according to the Department of Facilities. |
VARCHAR2 |
6 |
SPACE_UNIT_KEY |
Key field used to join to the SPACE_UNIT table. This field should only be used for joining data, NOT for reporting. |
NUMBER |
22 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |