Penn Computing

University of Pennsylvania
Penn Computing << go backback
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.

Primary Key Indexed Data Elements Related Tables
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

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