Penn Computing

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

MONTHLY_FINANCIAL_SUMMARY Table

Explanation
Contains budget and actual balances by building, program, Facilities subledger, order type, month and year, as well as monthly and year-to-date balances.

Common Uses
Budget/actual variance reporting by building or building program..

Primary Key Indexed Data Elements Related Tables
BLDG_CODE
CATEGORY_TYPE
FISCAL_MONTH_SEQ
FISCAL_YEAR
OFFSETSUB_CODE
ORDER_TYPE
SUBLEDGER
SUBLEDGER_DESC
BLDG_CODE
CATEGORY_TYPE
FISCAL_MONTH_SEQ
FISCAL_YEAR
OFFSETSUB_CODE
ORDER_TYPE
SUBLEDGER
SUBLEDGER_DESC
    
BUILDINGS (DWADMIN)
BUILDING_CENTER (DWFS)
GL_PERIODS (DWADMIN)
ORG_CODES (DWADMIN)

Cautions

  • Contains data from fiscal year 2008 onward.
  • Users may access rows in MONTHLY_FINANCIAL_SUMMARY for center codes to which they have been granted access.
  • The MONTHLY_FINANCIAL_SUMMARY table is stored in the DWFS schema in the Data Warehouse.
MONTHLY_FINANCIAL_SUMMARY 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