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..

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