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

FLOORS_HISTORY Table

Explanation
Monthly snapshot of all data elements related to a floor in a particular building.

Common Uses
To report on the configuration of floors over time.

BUILDING_CODE
FISCAL_YEAR 
FISCAL_MONTH_SEQ
FLOOR_CODE 
 

BUILDING_CODE
CALENDAR_MONTH 
CALENDAR_YEAR 
FISCAL_MONTH_SEQ 
FISCAL_YEAR
FLOOR_CODE  

BUILDINGS_HISTORY
ROOMS_HISTORY

Cautions

• Contains one record per building, floor 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 floors data; the FLOORS table is available to view current floors data.

Source

The FLOORS table in the Data Warehouse.

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