OHIO BOARD OF REGENTS

Preprocessing (Edit Rules) for Changes in Hospital Funds (HP) File

Global Edits
-Execute the following edits for all records in submission

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 Record Type field is not found in record type code column in record type table matching submission ("HP") and year fields (from header record) to submission and yr num columns,
     write Error 541 on edit error message report.
G. If Restricted/Unrestricted field value not found in revenue type code column in restricted unrestricted table matching year (from the header record) to yr num column,
     write Error 681 on edit error message report.
H. If there are two or more records in the submission file with the same Record Type field value, Restricted/Unrestricted field value and Delete Switch field value,
     write Error 761 on edit message file.

Edits for Record Type value of "R"
Execute the following edits for all records where the "Record Type" field is equal to "R"

I. If first character in any of the following fields is not zero (0) or negative sign (-) or if remaining characters in field are not numeric write the corresponding error from the table below on the edit message file.
 

J. For all records in submission having Restricted/Unrestricted field value of "U" and  Delete Switch field value of "N", if the following field values are numeric
 

and sum of above field values for all these records does not equal current total revenues column in current revenue table matching "A" to  budget actual code column and "UH" to fund code column and year (from header record) to yr num column and institution (from header record) to inst code column,
     write Error 755 on edit message file.

K. For all all records in submission having Restricted/Unrestricted field value of "R" and  Delete Switch field value of "N", if the following field values are numeric
 

and sum of above field values for all these records does not equal current total revenues column in current revenue table matching "A" to  budget actual code column and "RH" to fund code column and year (from header record) to yr num column and institution (from header record) to inst code column,
     write Error 756 on edit message file.

L. If Delete Switch is "Y" and a row is not found in hospital revenue table matching year (from the header record), Institution (from the header record), and Restricted/Unrestricted fields to yr num, inst code, and revenue type code columns,
           write Error 757 on edit message file.

M. If Delete Switch is "N" and a row is found on hospital revenue table matching  Institution (from header record), year (from header record) and Restricted/Unrestricted fields to yr num, inst code, and revenue type code columns and submission does not contain a record with the same Restricted/Unrestricted field value and Delete Switch of "Y",
           write Error 758 on edit message file.

N. If Delete Switch is "Y" and a row is found on hospital revenue table matching  Institution (from header record), year (from header record) and Restricted/Unrestricted fields to yr num, inst code, and revenue type code columns and submission does not contain a record with the same Restricted/Unrestricted field value and Delete Switch of "N",
           write Error 759 on edit message file.

 Record Type E edits
Execute the following edits for all records where the "Record Type" field is equal to "E"

O. If first character in any of the following fields is not zero (0) or negative sign (-) or if remaining characters in field are not numeric write the corresponding error from the table below on the edit message file.
 
 

P. For all records having Restricted/Unrestricted field values of "U" and Delete Switch field values of "N", if the following field values are numeric
Administrative and General
Household and Property
Dietary Service
General Nursing Care for Patients
Laboratory Services
Other Patient Services
Outpatient Clinic
Pharmacy
Training and Research
Indirect Costs from Main Campus
Other Expenditures
and sum of above field values for all these records does not equal current total expense column in current expense table matching "A" to  budget actual code column and "UH" to fund code column and year (from header record) to yr num column and institution (from header record) to inst code column,
     write Error 657 on edit message file.

Q. For all records having Restricted/Unrestricted field values of "R" and Delete Switch field values of "N", if the following field values are numeric
Administrative and General
Household and Property
Dietary Service
General Nursing Care for Patients
Laboratory Services
Other Patient Services
Outpatient Clinic
Pharmacy
Training and Research
Indirect Costs from Main Campus
Other Expenditures
and sum of above field values for all these records does not equal cur tot expens column in cur expens table matching "A" to  budget actual code column and "RH" to fund code column and year (from header record) to yr num column and institution (from header record) to inst code column,
     write Error 675 on edit message file.

R. If Delete Switch is "Y" and a row is not found in hosp expense table matching  year (from the header record), institution (from the header record) and Restricted/Unrestricted fields to yr num, inst code, and revenue type code columns,
           write Error 764 on edit message file.
S. If Delete Switch is "N" and a row is found in hosp expens table matching  year (from the header record), institution (from the header record) and Restricted/Unrestricted fields to yr num, inst code, and revenue type code columns and submission does not contain a record with the same Restricted/Unrestricted field value and Delete Switch of "Y",
           write Error 765 on edit message file.
T. If Delete Switch is "Y" and record exists in hosp expens table matching  year (from the header record), institution (from the header record) and Restricted/Unrestricted fields to yr num, inst code, and revenue type code columns and submission does not contain a record with the same Restricted/Unrestricted field value and Delete Switch of "N",
           write Error 766 on edit message file.
 
 

Record Type T Edits
Execute the edits below for all records with Record Type field value of "T"

U. If first character in any of the following fields is not zero (0) or negative sign (-) or if remaining characters in field are not numeric write the corresponding error from the table below on the edit message file.
 

V. For all records having Restricted/Unrestricted field values of "U" and Delete Switch field value of "N" if the following field values are numeric
 Mandatory Transfer for Principal and Interest
 Other Mandatory Transfers
 Net Nonmandatory Transfer for Endowment Principal
 Net Nonmandatory Transfer for Debt Service
 Net Nonmandatory Transfer for Capital Improvements
 Net Nonmandatory Interfund Transfers
 Excess of Restricted Receipts over Transfers to Revenue
and sum of above field values for all these records does not equal cur tot xfer column in current fund xfer table matching "A" to  budget actual code column and "UH" to fund code column and year (from header record) to yr num column and institution (from header record) to inst code column,
     write Warning B73 on edit message report.

W. For all records having Restricted/Unrestricted field values of  "R" and Delete Switch field value of "N" if the following field values are numeric
 Mandatory Transfer for Principal and Interest
 Other Mandatory Transfers
 Net Nonmandatory Transfer for Endowment Principal
 Net Nonmandatory Transfer for Debt Service
 Net Nonmandatory Transfer for Capital Improvements
 Net Nonmandatory Interfund Transfers
 Excess of Restricted Receipts over Transfers to Revenue
and sum of above field values for all these records does not equal current total xfer column in current fund xfer table matching "A" to  budget actual code column and "RH" to fund code column and year (from header record) to yr num column and institution (from header record) to inst code column,
      write Warning B74 on edit message report.

X. If Delete Switch is "N" and row is found in hosp fund xfer table matching year (from the header record), institution (from the header record) and Restricted/Unrestricted fields to  yr num, inst code, and revenue type code columns and submission does not contain a record with the same Restricted/Unrestricted field value with a Delete Switch field value of "Y",
           write Error 769 on edit message report.
Y. If Delete Switch is "Y" and row is not found  in hosp fund xfer table matching year (from the header record), institution (from the header record) and Restricted/Unrestricted fields to  yr num, inst code, and revenue type code columns,
           write Error 770 on edit message report.

Z. If Delete Switch is "Y" and a row is found in hosp fund xfer table matching year (from the header record), institution (from the header record) and Restricted/Unrestricted fields to  yr num, inst code, and revenue type code columns, and submission does not contain a record with the same Restricted/Unrestricted field value and Delete Switch of "N",
           write Error 773 on edit message file.
 

Return to Financial Files

http://regents.ohio.gov/hei/financial/hpedit.html
Last updated January 5, 2000