| Data Element |
Definition |
AREA_OCCUPIED_BY_ORG
Indexed - no
Format - number(12,4)
May be null? yes |
Total area (in square feet) occupied by the charge org in the room. |
BUILDING_CODE
Indexed - yes
Format - char(16)
May be null? no |
Unique identifier for a building. Four digits, zero filled, for older
buildings; five digits for newer buildings constructed since the implementation
of FacilityCenter. |
CHARGE_ORG
Indexed - yes
Format - char(4)
May be null? no
|
The charge organization. |
EXTRACT_DATE
Indexed - no
Format - date
May be null? yes
|
Date of the last extract from TRIRIGA to the Data Warehouse. |
FLOOR_CODE
Indexed - yes
Format - char(8)
May be null? no
|
Identifies the floor within the building that contains the room. |
PERCENT_OCCUPIED_BY_ORG
Indexed - no
Format - number(12,4)
May be null? yes
|
Total percentage of the room occupied by the charge org. |
ROOM_CODE
Indexed - yes
Format - char(16)
May be null? no
|
Uniquely identifies the room within a building. This may contain letters,
numbers, and symbols. |
