| 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. |
CALENDAR_MONTH
Indexed - yes
Format - char(2)
May be null? yes |
The calendar month for the ACCOUNTING_PERIOD.For cases in which the snapshot is for the 13th fiscal month, the CALENDAR_MONTH will be set to 13. |
CALENDAR_YEAR
Indexed - yes
Format - char(4)
May be null? yes |
The calendar year for the ACCOUNTING_PERIOD. The calendar year begins
January 1 and ends December 31. Example: 1996 (the CALENDAR_YEAR for ACCOUNTING_PERIOD
JUL-96). |
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, prior to the extract for SpaceHistory and made 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. |
FISCAL_MONTH_SEQ
Indexed - yes
Format - char(2)
May be null? yes |
The month (or accounting period) of the fiscal year. This field is used
for sorting. Examples: 01 (July); 11 (May). See also FISCAL_YEAR |
FISCAL_YEAR
Indexed - yes
Format - char(4)
May be null? yes |
The financial year within which the Accounting_Period falls. Penn's fiscal
year begins July 1 of one calendar year and ends June 30 of the next calendar
year. Example: 2000 (fiscal year that began July 1, 1999, and ended June
30, 2000) |
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 was formerly 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
|
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. |
