Penn Computing

University of Pennsylvania
Penn Computing << go backback
BUILDING_CENTER Table - Data Element Index   Tables and Data Elements   FRES Work Requests Home   Data Warehouse Home

BUILDING_CENTER Table

Explanation
Provides a mapping between Facilties building codes, their corresponding program codes, and the University centers responsible for the buildings.

Common Uses
Determining the school or center responsible for a building.

Primary Key Indexed Data Elements Related Tables
BLDG_CODE
BLDG_CODE
BUILDINGS (DWADMIN)
MONTHLY_FINANCIAL_SUMMARY (DWFS)

ORG_CODES (DWADMIN)
PROGRAM_CODES (DWADMIN)

Cautions

  • Provides building/center mapping used for monthly financial reporting by building. Note that buildings are often shared among more than one school or center.
  • The BUILDING_CENTER table is stored in the DWFS schema in the Data Warehouse.
BUILDING_CENTER Table - Data Element Index   Tables and Data Elements   FRES Work Requests 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