New OBR logo
OHIO BOARD OF REGENTS 
horizontal red line

Edit and Load Specifications

Changes in Funds Balances (CB) File
Revised January 28, 2004

Summary of Changes: Removed error 509 per feedback from pilot.

Preprocessing (Edit Rules) for each Changes in Funds Balances (CB) File and Record

A. Execute all common edits from the General Section of the Edit and Load Specifications
B. If Fund field is not in Fund table matching institution and year (from the header record) to institution code and yr number columns and Fund field is not found in fundexcept table matching  Institution, year, and submission ("CB") (from the header record) to institution code, yr number, and submission columns.
Write Error 500 on edit error message report.
C.  If Fund field in submission is valid (edit 500) and Fund is repeated within the file
Write Error 501 on edit error message report.
D. If first character in any fields listed below is not zero (0) or negative sign (-), or if any of the remaining characters are non numeric, write the error message corresponding to the field according to the table below.
 

                                                                                                               

  Field Name  
Error Number
Beginning Fund Balance Error 502
Prior period Adjustment Error 526
Restated Fund Balance Error 527
Total Expenditures Error 504
Net Mandatory Transfers Error 505
Net Non-Mandatory Transfers Error 506
Ending Fund Balance Error 507

E. For each valid fund field (edit 500) in submission, if Beginning Fund Balance field from submission does not equal fund_bal_end column value in the fund balance chg table matching Fund, Institution (from header record), and Year - 1 (from header record) to fund code, institution ocode, and yr number columns

Write Error 525 on edit error message file.
F. For each valid fund field (edit 500) in submission, if Ending Fund Balance field value does not equal
   Restated Fund Balance field
  Plus(+)     Total Revenues field
  Less(-)     Total Expenditures field
  Less(-)     Mandatory Transfers field
  Plus(+)     Net Non-Mandatory field

        Write Error 508 on edit error message report.

G. For each valid fund field (edit 500), if Ending Fund Balance field is negative (first character position is "-")

 Write Warning A70 on edit error message report.
H. For each valid fund field (edit 500), if fund field from submission exists on fund balance chg table matching Institution and Year (from header record) to  institution code and yr number columns
 Write Error 543 on edit error message report.

 Errors of Omission:


I. If there are any fund columns in fund table or fund except table matching only institution and year fields (from header record) to institution code and yr number columns, and these fund columns are not reported in Fund field of CB submission

Write Error 674 on edit error message report.


horizontal red line

Return to Financial Files

http://regents.ohio.gov/hei/financial/cbedit.html
Last updated January 3, 2000