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

CHARGE_ORG_HISTORY Table

Explanation
Monthly snapshot of area and percent occupied by charge organization by room.

Common Uses
To report on historical area and percent usage by charge org within room, floor and building.

BUILDING_CODE
CHARGE_ORG
FISCAL_YEAR 
FISCAL_MONTH_SEQ 
FLOOR_CODE 
ROOM_CODE 

BUILDING_CODE
CHARGE_ORG
FISCAL_YEAR 
FISCAL_MONTH_SEQ 
FLOOR_CODE 
ROOM_CODE 

BUILDINGS_HISTORY
FLOORS_HISTORY
ORGANIZATION
ROOMS_HISTORY

Cautions

• Contains one record per building, floor, room and charge ORG 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 data; the CHARGE_ORG table is available to view current charge org data.

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