| Data Element |
Definition |
| ACCOUNTING_UNIT
Indexed - yes
Format - char(15)
May be null? no |
No longer used following the migration from FacilityCenter to TRIRIGA in April 2014.
Accounting unit associated with this room. The association
of an accounting unit with a room
indicates that the entire room, or portions of the room, is occupied
by the Health System.
|
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. |
DATE_LAST_SURVEYED
Indexed - no
Format - char(16)
May be null? no
|
Date of last physical
survey of the room. |
DATE_MODIFIED
Indexed - no
Format - date
May be null? yes
|
The date associated with the most recent update to the ROOMS or ROOM
UTILIZATION records through the Space@Penn Web Updater. Any update to the
basic room information (as contained in this, the ROOMS table) or changes
to the program activity data stored in the ROOMS UTILIZATION table will
be reflected in this field. |
EMERGENCY_CONTACT
Indexed - no
Format - char(40)
May be null? yes
|
No longer used following the migration from FacilityCenter to TRIRIGA in April 2014.
Name and emergency phone number for the contact for the room. This data
is not tied to any other system and is stored as a string value. |
EXTRACT_DATE
Indexed - no
Format - date
May be null? yes |
Date of the last extract of the record 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. |
FLOOR_LOCATION
Indexed - no
Format - char(8)
May be null? yes |
The area or section in which the room is located on the floor. |
NET_AREA
Indexed - no
Format - number(12,4)
May be null? yes
|
Net area is calculated from the CAD drawings of the building's floors. |
OCCUPIED_INDICATOR
Indexed - no
Format - char(1)
May be null? yes
|
No longer used following the migration from FacilityCenter to TRIRIGA in April 2014.
Used by Facilities Services to indicate that a room is occupied or assigned
to an organization and by the School of Medicine to indicate that a room
is assigned to a Principle Investigator (for research space) or there is
an occupant (non-research space.) |
ORIG_UP_ROOM_CODE
Indexed - no
Format - char(16)
May be null? yes
|
The original University room code. For Health System buildings, the ROOM_CODE
field now contains the Health System code; ORIG_UP_ROOM_CODE stores the
original room code for historical purposes in those cases. |
RESPONSIBLE_CTR
Indexed - yes
Format - char(2)
May be null? yes
|
A 2-digit number used to identify the school or center having primary
(budgetary) responsibility for the room. The code set is from the University
General Ledger. May or may not be the
same as Occupying Organizations. |
RESPONSIBLE_ORG
Indexed - yes
Format - char(4)
May be null? yes
|
A 4-character code used to identify the organization having primary (budgetary)
responsibility for the room. The code set is from the University
General Ledger. May or may not be the same as
Occupying Organizations. |
ROOM_CLASS_CODE
Indexed - yes
Format - char(3)
May be null? yes
|
Also known as HEGIS Architectural Use code; relating to the room's main
purpose. |
ROOM_CLASS_TYPE
Indexed - yes
Format - char(3)
May be null? yes
|
Also known as HEGIS Architectural Room Type; a finer categorization of
the room's main purpose. |
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. |
ROOM_DESCRIPTION
Indexed - yes
Format - char(32)
May be null? yes
|
Free-form text description of a room, describing the type of room or
giving a name for the room. This data element may be null, and is used
in the School of Medicine to further differentiate the room's class and
type. |
ROOM_LOCATION
Indexed - yes
Format - char(72)
May be null? no
|
A concatenation of Property, Building, Area, Floor and Room codes to
uniquely identify a room. The location code is built by TRIRIGA. |
STORAGE_INDICATOR
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether (Y/N) the room is used for storage. |
SUBLOCATION_TYPE
Indexed - no
Format - char(18)
May be null? yes
|
A descriptor of space used internally by Facilities and Real Estate Services. |
USER_LAST_NAME_MODIFIED
Indexed - no
Format - char(25)
May be null? yes
|
The last name (and first initial) of the person who performed the last
update to the room data, either in the ROOMS or ROOM UTILIZATION tables.
Corresponds to the USER_NAME_MODIFIED. |
USER_NAME_MODIFIED
Indexed - no
Format - char(12)
May be null? yes
|
Erroneously named, this is actually the Penn ID of the person who performed
the last update to the room data, either in the ROOMS or ROOM UTILIZATION
tables. |
