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."
Primary Key |
Indexed Data Elements |
Related Tables |
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.
Questions about this page? Email us at da-staff@isc.upenn.edu
|