SUMMARY_BALANCES Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home

SUMMARY_BALANCES Table

Explanation
Contains budget, encumbrance, and actual balances for summary-level Accounting Flexfields by accounting period. Balances are available for the month, the fiscal year-to-date, and the project year-to-date. For budgets, balances are also available for the total fiscal year.

Common Uses
Reporting on balances for selected summary-level Accounting Flexfields. For example, "Show me the spendable balance for my center as of the end of the latest accounting period."

FISCAL_YEAR

FISCAL_MONTH_SEQ

COA_ACCOUNT

ACCOUNTING_PERIOD

ACCOUNT_TYPE

CALENDAR_YEAR

COA_ACCOUNT

COA_CNAC

COA_CREF

COA_FUND

COA_OBJECT

COA_ORG

COA_PROGRAM

COA_RESPONSIBLE_ORG

FISCAL_MONTH_SEQ

FISCAL_YEAR

MONTH

BUDGET_PERIODS

CENTER_REF_CODES

CNAC_CODES

FUND_CODES

GL_FULL_OLD_TO_NEW

GL_PART_OLD_TO_NEW

GL_SUBCD_OLD_TO_NEW

OBJECT_CODES

ORG_CODES

ORG_OLD_TO_NEW

PARENT_CNAC_CODES

PARENT_FUND_CODES

PARENT_OBJECT_CODES

PARENT_CODES

PARENT_PROGRAM_CODES

PROGRAM_CODES

Cautions

• This table contains balances only for summary-level accounts. For balances for detail-level accounts (such as for object code 5412, WATER&SEWER), see the BALANCES table.
• Most often, you will want data for just one accounting period. Beware summarizing beginning balance, ending balance, fiscal year-to-date, project-to-date, fiscal year total, or project total amounts for multiple accounting periods.
• It is often easiest to use ACCOUNTING_PERIOD when setting the record selection conditions for queries. If, instead, Month or FISCAL_MONTH_SEQ are used in the record selection conditions for a query, FISCAL_YEAR ought to be used as well.
• When reporting on Organizations, be sure to select the data element that meets your needs. COA_ORG is the ORGANIZATION segment of the COA_ACCOUNT (the 26-position Accounting Flexfield). COA_RESPONSIBLE_ORG is the code for the ORGANIZATION responsible for managing the fund.
• The F_AND_A_RATE and the ICR_SCHOOL_PORTION are stored in the Balances table, but are not stored in the Summary Balances table. A given F&A rate applies only to balances for certain funds and certain object codes. The Summary Balances are not summarized using those fund/object combinations, so using the F&A rate in calculations involving a summary balance would generate incorrect figures.
• For the rate actually used to calculate the indirect cost recovery amounts each week, see the F_AND_A_RATE in the Balances table. For the rate awarded by the sponsor, see the INDIRECT_COST_RATE in the Award table (whose value may differ from that of the F_AND_A_RATE in cases where the awarded rate actually floats based on the federally negotiated rate). For the rate quoted in the project proposal, see the INDIRECT_COST_RATE in the Proposal table.

SUMMARY_BALANCES Table - Data Element Index   Tables and Data Elements   General Ledger Home   Data Warehouse Home