Certification of Balances - File Layout and Data Mapping
The following table lists the Certification of Balances' column names and descriptions.
Column Name | Description |
---|---|
FUND CLASS | The classification of the Fund/SCC. Valid values:
The value is retrieved from the Fund Class field on the OH Certification of Balances page. |
FUND TYPE | The type of the Fund/SCC. Valid values:
The value is retrieved from the Fund Type field on the OH Certification of Balances page. |
FUND | The Fund being reported. The value is retrieved from the Fund/SCC field on the OH Certification of Balances page. |
SCC | The special cost center (SCC) being reported. The value is retrieved from the Fund/SCC field on the OH Certification of Balances page. |
TITLE | Description of the Fund/SCC. The value is retrieved from the Title field on the OH Certification of Balances page. |
CASH BALANCE | The beginning balance from the transaction details. The value is retrieved from the transact.trans_amt field. |
ENCUMBRANCES | The sum of the amount of purchase orders from the transaction details pertaining to transaction code 17. |
ADVANCES NOT REPAID | A positive amount for the Fund that made the advance and a negative amount for the Fund that will be making the reimbursement. The value is retrieved from the Advance Not Repaid field on the OH Certification of Balances page. |
CARRY OVER BALANCE | The amount is calculated in the following way: Detailed cash balance - Detailed encumbrance + Advance |
BUDGETED EXPENDITURES | The amount from all sources the governmental unit expects to receive during the forthcoming year which is available for expenditures. The value is retrieved from the Budgeted Expenditures field on the OH Certification of Balances page. |
AVAILABLE BALANCE | The amount is calculated in the following way: Carry over balance + Available expense |