OHIO BOARD OF REGENTS

Edit and Load Specifications

Edit and Load Specifications
Research Incentive (RE) record
Revised December 3, 2001 Primary Edits

A. Read the record
B. If there are non-blank characters beyond the allotted record length for this file
            Write Error 035 on the edit message file
C. If the record is blank, do not run edit checks for this file on this record, and
            Write Error 011 on the edit message file
D. If Internal Account Number is blank in the first character position
            Write Error 942 on the edit message file
E. If the Sponsor Type is not in the Research Incentive Sponsor Type table
            Write Error 921 on edit message file
F. If the Sponsor Type is S AND if the first 6 characters of the Sponsor Name Code are not OTHER- AND if the Sponsor Name Code is not in the Sponsor Code column of the Research Incentive Sponsor Type Table with a S Federal State Code
            Write Error 922 on the edit message file
G. If the Sponsor Type is F AND if the first 6 characters of the Sponsor Name Code are not OTHER- AND if the Sponsor      Name Code is not in the Sponsor Code column of the Research Incentive Sponsor Type Table with a F Federal State Code
           Write Error 923 on the edit message file
H. If Pass Through Sponsor Type is not N AND is not in the Research Incentive Sponsor Type table
           Write Error 928 on edit message file
I. If the Pass Through Sponsor Type is S AND if the first 6 characters of the Pass Through Sponsor Name Code are not OTHER- AND if the Pass Through Sponsor Name Code is not in the Sponsor Code column of the Research Incentive Sponsor Type Table with a S Federal State Code
          Write Error 924 on edit message file
J. If the Pass Through Sponsor Type is F AND if the first 6 characters of the Pass Through Sponsor Name Code are not OTHER- AND if the Pass Through Sponsor Name Code is not in the Sponsor Code column of the Research Incentive Sponsor Type Table with a F Federal State Code
          Write Error 925 on edit message file
K.   If the Sponsor Type is NOT S AND the Sponsor Name Code is in the Sponsor Code column of the Research Sponsor Type Table with a S Federal State Code
         Write Error 926 on the edit message file
L. If the Sponsor type is NOT F AND the Sponsor Name Code is in the Sponsor Code column of the Research Incentive Sponsor Type Table F Federal State Code
        Write Error 927 on the edit message file
M. If the Pass Through Sponsor Type is NOT S AND the Pass Through Sponsor Name Code is in the Sponsor Code column of the Research Incentive Sponsor Type Table with a S Federal State Code
         Write Error 929 on edit message file
N. If the Pass Through Sponsor Type is NOT F AND the Pass Through Sponsor Name Code is in the Sponsor Code column of the Research Incentive Sponsor Type Table F Federal State Code
        Write Error 930 on edit message file
O. If Pass Through Sponsor Type is N and Pass Through Sponsor Name Code is not N
        Write Error 943 on edit message file
P. If Project Title is blank in the first character position
        Write Error 944 on edit message file
R.    If Partial Claim is not Y or N
        Write Error 933 on edit message
S. If Withdraw Switch is not Y and not N
        Write Error 945 on edit message file
T. If the Withdraw Switch is Y and there is no record in the re table for this institution with the same Internal Account Number, Sponsor Type, Sponsor Name, Pass Through Sponsor Type, Pass Through Name, Project Title, Amount Expended, Partial Claim and Year
        Write Error 934 on edit message file
U. If Sponsor Type is S and Pass Through Type is NOT F, P, V, or B
        Write Error 935 on edit message file
V. If Sponsor Type is U and Pass Through Type is not F, P, B, or V
        Write Error 946 on edit message file
W. If Sponsor Type is S and Pass Through Sponsor name code is OTHER- in the first 6 character positions
        Write Warning B98 on edit message
X. If Withdraw Switch is N there are two or more records in the Submission file with the same Internal Account Number, Sponsor Type, Sponsor Name, Pass Through Sponsor Type, Pass Through Name, Project Title, Amount Expended, Partial Claim (or there is one record in the submission file with the same the same Internal Account Number, Sponsor Type, Sponsor Name, Pass Through Sponsor Type, Pass Through Name, Project Title, Amount Expended, Partial Claim and Year as is in on the database)
        Write Warning B99 on edit message file
Y. If the first 6 characters of Sponsor Name Code is OTHER- and the 7th character is a "-" or blank
        Write Error 948 on edit message file
Z. If the first 6 characters of Pass Through Sponsor Name Code is OTHER- and the 7th character is a "-" or blank
        Write Error 949 on edit message file
AA. If Two or more records in the Submission file with a Withdraw Switch of Y with the same Internal Account Number, Sponsor Type, Sponsor Name, Pass Through Sponsor Type, Pass Through Name, Project Title, Amount Expended, Partial Claim and there are fewer records in the database with the matching Internal Account Number, Sponsor Type, Sponsor Name, Pass Through Sponsor Type, Pass Through Name, Project Title, Amount Expended, Partial Claim and Year for this institution
        Write Error 950 on edit message file

BB. If the first 5 characters of the Sponsor Name Code is OTHER and the 6th character is not a"-",
Write Error 952 on edit message file

CC. If the first character of the Amount Expended field is not zero (0) or negative (-) or if remaining characters in field are not numeric
Write Error 932.

Edit Code Edit Type Edit Text Display Field

011 E Blank Records are not allowed Blank Records

035 E There are non-blank characters beyond the allotted record length for this file 20 characters beyond allotted length of record

040 E Campus field does not correspond to login institution code Campus

920 E More than one record in the data submissions file with the same year and internal account number Internal Account Number

921 E Sponsor Type is not NA OR is not in the Sponsor Type Table Sponsor Type

922 E First 5 letters of State Sponsor Type are not OTHER or Sponsor Name is not in State Sponsor Table Sponsor Name

923 E First 5 letters of Federal Sponsor Type are not OTHER or Sponsor Name is not in the Federal Sponsor Table Sponsor name

924 E First 5 letters of State Sponsor Type are not OTHER or Sponsor Name is not in State Sponsor Table Pass Through name

925 E First 5 letters of Federal Sponsor Type are not OTHER or Sponsor Name is not in the Federal Sponsor Table Pass Through name

926 E Sponsor Type is P, B, U, or O and Sponsor Name is in the State Sponsor Table Sponsor Name

927 E Sponsor Type is P, B, U, or O and Sponsor name is in the Federal Sponsor Table Sponsor Name

928 E Pass Through Type is not NA OR is not in the Sponsor Table Pass Through Type

929 E Pass Through Sponsor Type is P, B, U, or O and Sponsor Name is in the State Sponsor Table Pass Through Name

930 E Sponsor Type is P, B, U, or O and Sponsor name is in the Federal Sponsor Table Pass Through Name

931 E Project Title does not contain a word from the Keyword Listing Table Project Title

932 E First character in Amount Expended field is not 0 or - and remaining characters are not numeric Amount Expended

933 E Partial Claim is not Y or N Partial Claim

934 E No Record to Withdraw Withdrawal switch

935 E Sponsor type is S and Pass through type is not F, P, or B Pass through type

942 E Internal Account Number is blank in first character position Internal Account Number

943 E Pass Through Name has entry, but Pass through Code is N Pass Through Code, Pass Through Name

944 E Project Title is blank in first character position Project Title

945 E Withdrawal Switch is not N or Y Withdrawal Switch

947 E A record is being withdraw that has already been approve. Only the Regents administrator can withdraw an approved claim. Contact Regents. Withdraw Switch

948 E In Sponsor Code Name, OTHER must be followed by a single dash and a name. A space or double dash is appearing after single dash. Sponsor Name Code

949 E Pass Through Sponsor Code: OTHER must be followed by a single dash and a name; a second dash or space is following the single dash Pass Through Sponsor Name Code

950 E You have requested a withdrawal of a record more times than it appears on the database. All columns

952 E If the first 5 characters of the Sponsor Name Code is OTHER and the 6th character is not a"-" Sponsor Name.

B98 E Sponsor name is S and pass through name is other Pass through name

B99 E A duplicate entry has been submitted All fields All Fields

Return to Financial Files

http://regents.ohio.gov/hei/financial/reedit.html
Last updated December 4, 2001

Edit Code	Edit Type	Edit Text	Display Field
011	E	Blank Records are not allowed	Blank Records
035	E	There are non-blank characters beyond the allotted record length for this file	20 characters beyond allotted length of record
040	E	Campus field does not correspond to login institution code	Campus
920	E	More than one record in the data submissions file with the same year and internal account number	Internal Account Number
921	E	Sponsor Type is not NA OR is not in the Sponsor Type Table	Sponsor Type
922	E	First 5 letters of State Sponsor Type are not OTHER or Sponsor Name is not in State Sponsor Table	Sponsor Name
923	E	First 5 letters of Federal Sponsor Type are not OTHER or Sponsor Name is not in the Federal Sponsor Table	Sponsor name
924	E	First 5 letters of State Sponsor Type are not OTHER or Sponsor Name is not in State Sponsor Table	Pass Through name
925	E	First 5 letters of Federal Sponsor Type are not OTHER or Sponsor Name is not in the Federal Sponsor Table	Pass Through name
926	E	Sponsor Type is P, B, U, or O and Sponsor Name is in the State Sponsor Table	Sponsor Name
927	E	Sponsor Type is P, B, U, or O and Sponsor name is in the Federal Sponsor Table	Sponsor Name
928	E	Pass Through Type is not NA OR is not in the Sponsor Table	Pass Through Type
929	E	Pass Through Sponsor Type is P, B, U, or O and Sponsor Name is in the State Sponsor Table	Pass Through Name
930	E	Sponsor Type is P, B, U, or O and Sponsor name is in the Federal Sponsor Table	Pass Through Name
931	E	Project Title does not contain a word from the Keyword Listing Table	Project Title
932	E	First character in Amount Expended field is not 0 or - and remaining characters are not numeric	Amount Expended
933	E	Partial Claim is not Y or N	Partial Claim
934	E	No Record to Withdraw	Withdrawal switch
935	E	Sponsor type is S and Pass through type is not F, P, or B	Pass through type
942	E	Internal Account Number is blank in first character position	Internal Account Number
943	E	Pass Through Name has entry, but Pass through Code is N	Pass Through Code, Pass Through Name
944	E	Project Title is blank in first character position	Project Title
945	E	Withdrawal Switch is not N or Y	Withdrawal Switch
947	E	A record is being withdraw that has already been approve. Only the Regents administrator can withdraw an approved claim. Contact Regents.	Withdraw Switch
948	E	In Sponsor Code Name, OTHER must be followed by a single dash and a name. A space or double dash is appearing after single dash.	Sponsor Name Code
949	E	Pass Through Sponsor Code: OTHER must be followed by a single dash and a name; a second dash or space is following the single dash	Pass Through Sponsor Name Code
950	E	You have requested a withdrawal of a record more times than it appears on the database.	All columns
952	E	If the first 5 characters of the Sponsor Name Code is OTHER and the 6th character is not a"-"	Sponsor Name.
B98	E	Sponsor name is S and pass through name is other	Pass through name
B99	E	A duplicate entry has been submitted All fields	All Fields