OHIO BOARD OF REGENTS

Edit Rules for each College Expenditure (CF) Record

A. If Campus Code field from submission not found in campus code column of inst campus table,
     write Error 001 on edit error message report.

B. If there are blank lines in the submission,
     write Error 011 on edit error message report.

C. If Delete Switch field value is not equal to "Y" or "N",
     write Error 013 on edit error message report.

D. If there are non-blank characters beyond the allotted record length,
     write Error 035 on edit error message report.

E. If Campus Code field from submission not found in campus code column of inst campus table matching institution field (from header record) to inst code column,
     write Error 040 on edit error message report.

F. If value of College field not found in college id column of fund unit table matching Campus field and year (from header record) to campus code and yr num columns and term code column value equal to "SP",
          write Error 629 on edit error message report.

G. If Unrestricted College Expenditures field is not numeric,
 write Error 631 on edit error message report.

H. If Restricted College Expenditures field is not numeric,
       write Error 632 on edit error message report.

I. If Delete Switch is "Y" and a row does not exist in college expens table matching year (from the header record), Campus and College fields to yr num, campus code, and college id columns,
        write Error 633 on edit error message report.

J. If Delete Switch is "N" and a row exists in college expens table matching year (from the header record), Campus and College fields to yr num, campus code, and college id columns, and submission does not contain record with same Campus and College field values with Delete Switch "Y",
         write Error 634 on edit error message report.

K. If there are two or more records within submission containing same Campus, College, and Delete Switch field values,
           write Error 656 on edit error message report.
 

 Post Record Level

L. For all records with Delete Switch field value of "N", if a row does not exist in the fund unit expens table matching year (from the header record) and Campus fields to yr num and campus code columns and having fund unit id column matching a fund unit id selected from the fund unit table where year (from header record), Campus and College field values match yr num, campus code and college id column values (in the fund unit table),
           write Error 630 on edit error message report.
 
 

Summary Edit:
 

<Insert Errors of Omission> If no errors were detected leave space blank.
 

The data presented below are summaries of the data provided in your Campus Expenditure (CP) submission file. The table below summarizes the total Instruction and General (I&G) expenditures made by your institution per campus in both dollars and in terms of a percentage of total I&G expenditures for the institution. Recall that I&G expenditures are a subset of Education and General expenditures and are comprised of the following expenditure categories: Instruction and Department Research, Academic Support, Institutional Support, Student Services, and Plant Operation and Maintenance. The expenditures detailed in the CX will be used in the Resource Analysis computations that will determine statewide average costs of instruction that will be used in subsidy determination. Please look over the data below to verify the accuracy of the information provided.

Errors of Omission

Table 01

Campus	Dollar Amount	Percentage of Total I&G Expenditures
A.	B.	D.

A. Print campus field value from record in submission file.
B. Print Total I&G Expenditures for the Campus field value in the record
C. From current expens table sum the following columns for fund code column values UE and RE and budget actualcode value of A and yr num columnn value equal to Year field value value in header record of submission file and inst code column value equal to Institution field value in header record (current instr dept resrch expens, current acad support expens, current student serv expens, current inst support expens, current pom expens)
D. Calculate the following: B/C [Express as a percentage]
E. Repeat Steps A through D for each campus listed in submission file

Table Build

For all records with Delete Switch field value of "Y" and the entire submission has zero errors, delete corresponding row from college_expens table using table below for matching:

                                                     Field Names                          Table  Columns

For all records with Delete Switch field value of "N" and the entire submission has zero errors, add a new row to the college_expens table as follows:

                                                   From Field Value                    to Column name

Return to Financial Files

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