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

BUILDINGS Table

Explanation
Core table containing all data elements related to a building associated with the University. A building is defined as an entity that can exist on its own. Wings can be considered buildings if they are structurally capable of standing alone.

Common Uses
To select building level information, such as building name or address.

BUILDING_CODE

BUILDING_CODE

    

FLOORS
PROPERITES
ROOMS

Cautions

• Not selecting a specific building or property will return all buildings, both on campus and off.
• Contains current building data; the BUILDINGS_HISTORY table is available to view historical snapshots of buildings data.

Source

SPBLDINF and SPBLDINF_ATTRIB from FacilityCenter

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