| Data Element |
Definition |
| ACCOUNTING_UNIT
Indexed - yes
Format - char(15)
May be null? no |
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
|
Field labeled 'phone' in FacilityCenter, but contains 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
|
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 FacilityCenter 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 (the
field is referred to as "area" in FacilityCenter). |
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
|
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. While FacilityCenter holds a maximum of 16 characters
for room code, data flowing to other systems may be truncated. |
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 FacilityCenter.
For Health System buildings, the building code segment of the ROOM_LOCATION
string represents the Health System building code while the BUILDING_CODE
stores the code for the building from the FIMS system. |
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
|
Not used. |
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. |
