Monthly snapshot of all data elements related to a room within
a building associated with the University.
To detail or summarize historical use of space at the room
||Indexed Data Elements
- Contains one record per building/floor/room and month for each snapshot period. For cases in which the snapshot is for the 13th fiscal month, the CALENDAR_MONTH will be set to 13.
- 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 historical rooms data; the ROOMS table
is available to view current rooms data.
The ROOMS table in the Data Warehouse.
Questions about this page? Email us at firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania