Penn Computing

University of Pennsylvania
Penn Computing << go backback
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.

Primary Key Indexed Data Elements Related Tables
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

Facilities and Real Estate Services' TRIRIGA application.

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

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania