OHIO BOARD OF REGENTS

Edit Rules for each Investment by Type (IT) 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 Fund field value does not equal a fund code column value in the fund asset table matching institution and year (from
    the header record) to inst code and yr number columns,
    write Error 500 on edit error message report.

 G.If Investment Type field value does not equal an invest type code column value in invest type table matching year
    (from header record) to yr number column,
    write Error 781 on edit error message report.

 H.If Market value field is not numeric,
    write Error 782 on edit error message report.

  I.If Delete Switch is "N" and row exists in invest by type table matching institution (from the header record), year
    (from the header record), Fund and Investment Type fields to inst code, yr number, fund code and invest type code
    columns and submission does not contain a record with the same Fund and Investment Type and Delete Switch of "Y",
    write Error 784 on edit error message report.

  J.If Delete Switch is "Y" and a row does not exist in invest by type table matching institution (from the header record),
    year (from the header record), Fund and Investment Type fields to inst code, yr number, fund code and invest type code
    columns,
    write Error 785 on edit error message report.

 K.If there are two or more records within the submission file with the same Fund, Investment Type, and Delete Switch
    field values,
    write Error 772 on edit error message report.
 

   Post Record Level Edits:

  L.If row exists in fund asset table matching institution (from the header record) and year (from the header record) to
    inst code and yr number columns and having an invest asset column value > 0 (zero) and a fund code column that does
    not match the Fund field of any record in the submission having a Delete Switch field value of 'N' ,
    write Error 615 on edit error message report.

 M.For each valid Fund field value (valid = all records containing the fund value passed edits listed in A - G above), if
    sum of Market Value field is not equal to the invest asset column in the row in the fund asset table matching institution
    (from the header record), year (from the header record), and Fund field to inst code, yr number, and fund code columns,
    write Error 783 on edit error message report.
 
 

Return to Financial Files

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