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.

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