ROOMS Table - Data Element Index   Tables and Data Elements   Space@Penn Home   Data Warehouse Home

ROOMS Table

Explanation
Core table containing data elements related to a room within a building associated with the University.

Common Uses
To detail or summarize space at the room level.

BUILDING_CODE
FLOOR_CODE

ROOM_CODE

ACCOUNTING_UNIT
BUILDING_CODE
FLOOR_CODE
RESPONSIBLE_CTR 
RESPONSIBLE_ORG
ROOM_CLASS_CODE
ROOM_CLASS_TYPE
ROOM_CODE
ROOM_DESCRIPTION
ROOM_LOCATION

BUILDINGS
FLOORS
ORGANIZATIONS
PRINCIPAL_INVESTIGATORS
ROOM_CLASS
ROOM_CLASS_TYPE
ROOM_UTILIZATION

Cautions.

• For Health System buildings, the ROOM_CODE column contains the current Health System room code; the University room code is stored in ORIG_UP_ROOM_CODE, where it can be used for reporting on rooms historically.
• Contains current rooms data; the ROOMS_HISTORY table is available to view historical snapshots of rooms data.

Source

SPBLDROM and SPBLDROM_ATTRIB from FacilityCenter

ROOMS Table - Data Element Index   Tables and Data Elements   Space@Penn Home   Data Warehouse Home