USAS User’s Manual –
Chapter 12 – Understanding Financial Tables (continued)
FUNDING-EDIT ALGORITHMS – (October, 1995)
| Error Codes | Short Description of Error Condition | Profile | Control Indicator | Edit Calculation (+/- Balance Types) |
|---|---|---|---|---|
| F13 | Cumulative Appn Adj Budget < 0 | 20 | Appn Control Type-Cash | +01+02-03+04-05+06-11+12+13+20-21 |
| F14 | Prior Month Appn Adj Budget < 0 | |||
| F16 | Prior Year Appn Adj Budget < 0 | * Excess Revenue Collected | Sum must be > or = zero | |
| F17 | Cumulative Allotment > Appn Budget | 20 | Appn Allotment Control Type | +01+02-03+04-05+06-11+12+13+20-21-23 |
| F18 | Prior Month Allotment > Appn Budget | |||
| F20 | Prior Year Allotment > Appn Budget | * Excess Revenue Collected | Sum must be > or = zero | |
| F21 | Cumulative Exp/Accr/Enc > Appn Budget | 20 | Appn Control Type-Enc | +01+02-03+04-05+06-07-08-11+12+13-15-16-17-18+20-21 |
| F22 | Prior Month Exp/Accr/Enc > Appn Budget | |||
| F24 | Prior Year Exp/Accr/Enc > Appn Budget | * Excess Revenue Collected | Sum must be > or = zero | |
| FJ1 | Cumulative Available Revenue < 0 | 20 | Appn Control Type-Cash | +01+02-03+04-05+06-08-11+12+20-21 |
| FJ2 | Prior Month Available Revenue < 0 | |||
| FJ4 | Prior Year Available Revenue < 0 | *Excess Revenue Collected | Sum must be > or = zero | |
| FJ5 | Cumulative Appn Encumb Cash 0 | 20 | Appn Control Type-Enc | +01+02-03+04-05+06-08-11+12-15-16-17-18+20-21 |
| FJ6 | Prior Month Appn Encumb Cash 0 | Sum must be > or = zero | ||
| FJ8 | Prior Year Appn Encumb Cash 0 | * Excess Revenue Collected | ||
| FK1 | Cumulative Exp > Cash Appn Budget | 20 | Appn Control Type-Cash | +01+02-03+04-05+06-07-08-11+12+13-15-16+20-21 |
| FK2 | Prior Month Exp > Cash Appn Budget | Sum must be > or = zero | ||
| FK4 | Prior Year Exp > Cash Appn Budget | * Excess Revenue Collected | ||
| FK5 | Cumulative Exp > Appn Cash Available | 20 | Appn Control Type-Cash | +01+02-03+04-05+06-08-11+12-15-16+20-21 |
| FK6 | Prior Month Exp > Appn Cash Available | Sum must be > or = zero | ||
| FK8 | Prior Year Exp > Appn Cash Available | |||
| FL1 | Cumulative Exp/Accr > Appn Accr Budget | 20 | Appn Control Type-Accrued | +01+02-03+04-05+06-07-08-11+12+13-15-16-17+20-21 |
| FL2 | Prior Month Exp/Accr > Appn Accr Budget | |||
| FL4 | Prior Year Exp/Accr > Appn Accr Budget | * Excess Revenue Collected | Sum must be > or = zero | |
| FL5 | Cumulative Exp/Accr > Appn Accr Cash | 20 | Appn Control Type-Accrued | +01+02-03+04-05+06-08-11+12-15-16-17+20-21 |
| FL6 | Prior Month Exp/Accr > Appn Accr Cash | Sum must be > or = zero | ||
| FL8 | Prior Year Exp/Accr > Appn Accr Cash | |||
| FM1 | Cumulative Exp/Accr/Enc > Allotment | 20 | Appn Allotment Control Type | -15-16-17-18+23 |
| FM2 | Prior Month Exp/Accr/Enc > Allotment | |||
| FM4 | Prior Year Exp/Accr/Enc > Allotment | Sum must be > or = zero | ||
| FM5 | Cumulative Excess Revenue Collected > 0 | 20 | Excess Revenue Collected Indicator | -11+12-13+20-21 |
| FM6 | Prior Month Excess Revenue Collected > 0 | |||
| FM8 | Prior Year Excess Revenue Collected > 0 | Sum must be > or = zero | ||
| * If the excess revenue collected indicator is set to ‘N,’ balance types 11, 12, 20, and 21 are not included in the calculation. | ||||
| Error Codes | Short Description of Error Condition | Profile | Control Indicator | Edit Calculation (+/- Balance Types) |
|---|---|---|---|---|
| F25 | Cumulative Agency Budget < 0 | 20 | Agency Budget Control Type | +9+10 |
| F26 | Prior Month Agency Budget < 0 | |||
| F28 | Prior Year Agency Budget < 0 | Sum must be > or = zero | ||
| F29 | Cumulative Exp/Accr/Enc > Agency Budget | 20 | Agency Budget Control Type | +09+10-15-16-17-18 |
| F30 | Prior Month Exp/Accr/Enc > Agency Budget | |||
| F32 | Prior Year Exp/Accr/Enc > Agency Budget | *Encumbrance Indicator | Sum must be > or = zero | |
| F81 | Cumulative Exp/Accr/Enc/Pre > Agency Budget | 20 | Agency Budget Control Type | +09+10-15-16-17-18-19 |
| F82 | Prior Month Exp/Accr/Enc/Pre > Agency Budget | |||
| F84 | Prior Year Exp/Accr/Enc/Pre > Agency Budget | *Pre-Encumbrance Indicator | Sum must be > or = zero | |
| FN1 | Cumulative Allotment > Agency Budget | 20 | Agency Budget Allotment Control Type | +09+10-24 |
| FN2 | Prior Month Allotment > Agency Budget | |||
| FN4 | Prior Year Allotment > Agency Budget | Sum must be > or = zero | ||
| FN5 | Cumulative Exp/Accr/Enc/Enc > Allotment | 20 | Agency Budget Control Type | -15-16-17-18+24 |
| FN6 | Prior Month Exp/Accr/Enc/Enc > Allotment | |||
| FN8 | Prior Year Exp/Accr/Enc/Enc > Allotment | *Encumbrance Indicator | Sum must be > or = zero | |
| KP5 | Cumulative Cash Balance < 0 | D22 | Cash Control Type | +12-15-16+20-21 |
| KP6 | Prior Month Cash Balance < 0 | 29 | **Grant Cash Control Type | |
| KP8 | Prior Year Cash Balance < 0 | Sum must be > or = zero | ||
| F33 | Cumulative Cash+Interfund Borrowing 0 | D22 | Cash Control Type | +12-15-16+20-21+32 |
| F34 | Prior Month Cash+Interfund Borrowing 0 | 29 | **Grant Cash Control Type | |
| F36 | Prior Year Cash+Interfund Borrowing 0 | Sum must be > or = zero | ||
| F37 | Cumulative Grant Billable Budget < 0 | 29 | Grant Budget Control Type | +25 |
| F38 | Prior Month Grant Billable Budget < 0 | |||
| F40 | Prior Year Grant Billable Budget < 0 | Sum must be > or = zero | ||
| F41 | Cumulative Exp/Accr/Enc > Grant Exp Budget | 29 | Grant Budget Control Type | -15-16-17-18+26 |
| F42 | Prior Month Exp/Accr/Enc > Grant Exp Budget | |||
| F44 | Prior Year Exp/Accr/Enc > Grant Exp Budget | Sum must be > or = zero | ||
| K89 | Cumulative Exp/Accr/Enc/Pre > Grant Exp Budget | 29 | Grant Budget Control Type | -15-16-17-18-19+26 |
| K90 | Prior Month Exp/Accr/Enc/Pre > Grant Exp Budget | |||
| K92 | Prior Year Exp/Accr/Enc/Pre > Grant Exp Budget | Sum must be > or = zero | ||
| F58 | Cumulative Grant Expendable Budget < 0 | 29 | Grant Budget Control Type | +26 |
| F59 | Prior Month Grant Expendable Budget < 0 | |||
| F60 | Prior Year Grant Expendable Budget < 0 | Sum must be > or = zero | ||
| F50 | Cumulative Project Billable Budget < 0 | 27 | Project Budget Control Type | +25 |
| F51 | Prior Month Project Billable Budget < 0 | |||
| F53 | Prior Year Project Billable Budget < 0 | Sum must be > or = zero | ||
| F54 | Cumulative Exp/Accr/Enc > Project Exp Budget | 27 | Project Budget Control Type | -15-16-17-18+26 |
| F55 | Prior Month Exp/Accr/Enc > Project Exp Budget | |||
| F57 | Prior Year Exp/Accr/Enc > Project Exp Budget | Sum must be > or = zero | ||
| K93 | Cumulative Exp/Accr/Enc/Pre > Proj Exp Budget | 27 | Project Budget Control Type | -15-16-17-18-19+26 |
| K94 | Prior Month Exp/Accr/Enc/Pre > Proj Exp Budget | |||
| K96 | Prior Year Exp/Accr/Enc/Pre > Proj Exp Budget | Sum must be > or = zero | ||
| F62 | Cumulative Project Expendable Budget < 0 | 27 | Project Budget Control Type | +26 |
| F63 | Prior Month Project Expendable Budget < 0 | |||
| F65 | Prior Year Project Expendable Budget < 0 | Sum must be > or = zero | ||
| * If the encumbrance and/or pre-encumbrance indicator is set to ‘Y,’ balance types 18 and/or 19 are included in
the calculation.
** The Grant cash control indicator does NOT function correctly. This indicator must be set to zero (ignore) |
||||