Penn Computing

University of Pennsylvania
Penn Computing << go backback
BUILDINGS_HISTORY Table - Data Element Index   Tables and Data Elements   Space@Penn Home   Data Warehouse Home

BUILDINGS_HISTORY Table

Explanation
Monthly snapshot of all data elements related to buildings 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 report on historical changes to buildings.

Primary Key Indexed Data Elements Related Tables
BUILDING_CODE
FISCAL_YEAR 
FISCAL_MONTH_SEQ 
 
BUILDING_CODE
FISCAL_YEAR 
FISCAL_MONTH_SEQ 
FLOORS_HISTORY
PROPERITES
ROOMS_HISTORY

Cautions

  • Contains one record per building 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.
  • Contains historical building data; the BUILDINGS table is available to view current buildings data.

Source

The BUILDINGS table in the Data Warehouse.

BUILDINGS_HISTORY 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