💹 PEOPLEORGBALANCE Balance Type Codes
The PEOPLEORGBALANCE table contains pre-computed balance information sliced and diced in many ways. Triggers on other tables (CHARGECREDIT?) update PEOPLEORGBALANCE in real time.
Negative numbers indicate a credit balance owed to the student.
Occasionally, the balance table in PowerCampus is simply wrong, and you may need to force a recalculation for a specific student. This is always safe to run.EXEC spRecalcPeopleOrgBalance @People_Org_Code_Id
Charges/credits with any of the following flags are excluded from PEOPLEORGBALANCE:PREBILL_FLAG = 'Y'VOID_FLAG = 'Y'VOID_FLAG = 'Y'ANTICIPATED_FLAG = 'Y'
Charges/credits with BEGINNING_BAL_FLAG = 'Y' are included only in Fiscal Year (FISCYR) balance type.
The BALANCE_TYPE column is especially important; see below. 👀
|
Balance Type Code |
Name |
Notes |
|---|---|---|
|
ACAYR |
Academic Year |
Not sure exactly how prior or beginning balances are handled. |
|
ALLSESS |
Year/Term (All Sessions Only) |
Only session-level items for sessions within the selected Y/T. |
|
ALLTERM |
Year/Term (Term/All Sessions) |
All term and session level items. Excludes beginning balances. |
|
ALLTERMCUM |
Year/Term (Term/All Sessions + Cumulative) |
All term and session level items plus cumulative. Excludes beginning balances. Included all anticipated aid up to the Y/T/S. |
|
CALYR |
Calendar Year |
Not sure exactly how prior or beginning balances are handled. |
|
CURR |
Current |
All charges and credits. In other words, don't filter by dates/periods. There will be multiple rows of type CURR; you can still filter by |
|
FISCYR |
Fiscal Year |
Includes anticipated aid for the selected fiscal year only if the selected year is the current fiscal year. 🤷♂️ |
|
TERM |
Term Only |
Only term-level items for the selected Y/T. |
|
TERMCUM |
Year/Term (Term Only + Cumulative)? |
Excludes beginning balances and session-level items. Includes previous cumulative. |
|
YTS |
Year/Term/Session |
Items from a single session only. |
No Comments