| Data Element |
Definition |
AREA_USED
Indexed - no
Format - number(12,4)
May be null? yes
|
Area (in square feet) that is devoted to the selected function or program
activity. |
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. |
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. |
FUNCTION_CODE
Indexed - yes
Format - char(5)
May be null? no
|
Also known as the HEGIS Function Code; relating to the room's function. |
OCCUPYING_ORG
Indexed - yes
Format - char(4)
May be null? no
|
The organization with budget responsiblity for the room. May or may not
be the same as the Responsible Organization. |
PERCENT_USED
Indexed - no
Format - number(12,4)
May be null? yes
|
The percentage of the room reserved for the selected function and program. |
PRINCIPAL_INVESTIGATOR
Indexed - yes
Format - char(8)
May be null? no
|
Penn ID number of the Principal Investigator assigned to the space. |
PROGRAM_CODE
Indexed - yes
Format - char(2)
May be null? no
|
Also known as HEGIS Program Activity code; relating to the room's function. |
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. |
