Edit and Load Specifications

A.

Read the record

B.

If there are non-blank characters beyond 32 characters

            Write Error 035 on edit report file

C.

If Campus Code does not exist in the Campus Code Column of the Institution/Campus code verification table                       

            Write Error 001 on edit report file

D.

If the Campus Code is in the Institution/Campus code verification table and does not relate to the Institution Code in the current login

            Write Error 040 on edit report file

E.

If there is not a Private College and University Student Entrance table entry for OBRID assigned to this Student Identifier (from Institution/SSN table) and Institution (from Header Record) for any Admission Area Code and any Year -

            Write Error 069 on edit report file

F.

If Year is not numeric in each character position

            Write Error 228 on edit report file

G.

If Term is not in Term verification table for this Year and Term

            Write Error 082 on edit report file

H.

If Level of Degree or Certificate Completed is not in Level of Degree or Certificate Completed Codes verification table for this submission year

            Write Error 084 on edit report file

I.

If Delete Switch is N and Level of Degree or Certificate Completed is A3, A5, A7 or A9 and there is not a record in this submission or a row in the DC table (for this year) that matches this Student ID and level accordingly:

03 = A3

05 = A5

07 = A7

09 = A9

            Write Error 353 on edit report file

J.

If the combination of Field of Study (Subject Code) is not TRAMOD and Campus is not in the Course Level/Subject Code/Campus verification table for this year and term, or if campus is valid per edit D and degree level= "01" and combination of campus and Field of Study are not in the Course Level/Subject Code/Campus verification table for this year and term and the Field of Study does not match a value in the DC Subject Code  column in the Alternate Subject table for Year equal to the Submission Year or if campus is valid per edit D and the Campus Type for this campus in the Institution Campus History table is "IN" or "PY" or "SN" and Field of Study is not in the Subject verification table for this year and the SM term of this year.

            Write Error 083 on edit report file

K.

If Credit Hours to Degree is not numeric in each character position

            Write Error 227 on edit report file

L

If the Delete Switch is N  and the Level of Degree or Certificate is 01 and 02 and Credit Hours to Degree is numeric and less than or equal to 20

            Write Warning A50 on edit report file

M.

If the Delete Switch is N and the Level of Degree or Certificate is 03, 04, and 07 and Credit Hours to Degree is numeric and not equal to all zeroes and less than or equal to 30

            Write Warning A51 on edit report file

N.

If the Delete Switch is N and the Level of Degree or Certificate is 05, 09, and 10 and Credit Hours to Degree is numeric and not equal to all zeroes and less than or equal to 60

            Write Warning A52 on edit report file

O.

If the Delete Switch is N and the Level of Degree or Certificate is 06 and Credit Hours to Degree is numeric and not equal to all zeroes and less than or equal to 18

            Write Warning A53 on edit report file

P.

If the Delete Switch is N, Level of Degree or Certificate is 08 and Credit Hours to Degree is numeric and not equal to all zeroes and less than or equal to 24

            Write Warning A54 on edit report file

Q.

If the Delete Switch in the input record is N and the Term Type Code from Academic Calendar table for this Institution is Q (on quarter calendar) and Credit Hours to Degree is numeric and not equal to all zeroes and greater than or equal to 300

            Write Warning A55 on edit report file

R.

If the Delete Switch in the input record is N, Term Type Code from Academic Calendar table for this Institution is S (on semester calendar) and Credit Hours to Degree is numeric and not equal to all zeroes and greater than or equal to 200

            Write Warning A56 on edit report file

S.

If Independent, Proprietary, and Non-Ohio Colleges and Universities Degree/Certificate Earned (PD) Delete Switch is Not Y or N

            Write Error 013 on edit report file

T.

If Independent, Proprietary, and Non-Ohio Colleges and Universities Degree/Certificate Earned (PD) Delete Switch is N and there is already a Private College Degree/Certifiate Earned table entry for this OBRID (from Institution/SSN table), Campus, Fiscal Year, Field of Study, Credit Hours to Degree, and Level of Degree or Certificate Completed

AND

There is not another matching record with Delete Switch set to Y

            Write Warning A17 on edit report file

U.

V.

            Write Error 087 on edit report file

W.

If Independent, Proprietary, and Non-Ohio Colleges and Universities Degree/Certificate Earned (PD) Delete Switch is N and there is already a Independent, Proprietary, and Non-Ohio Colleges and Universities Degree/Certificate Earned (PD) table entry for this OBRID, and Fiscal Year and Term

Or

If Independent, Proprietary, and Non-Ohio Colleges and Universities Degree/Certificate Earned (PD) Delete Switch is N and there is another matching entry in this submission for this Student Identifier and same Term

AND

As a result of loading this submission there would be two or more rows on the table

            Write Warning A57 on edit report file

X.

If Independent, Proprietary, and Non-Ohio Colleges and Universities Degree/Certificate Earned (PD) Delete Switch is N and, if loaded, there would be three or more rows or records for this Student Identifier at this Institution in the Independent, Proprietary, and Non-Ohio Colleges and Universities Degree/Certificate Earned (PD) table or in this submission for this Fiscal Year

AND

As a result of loading this submission there would be three or more rows on the table

Y.

If the "Level of Degree or Certificate Completed" in the submission record is valid and the combination of "Level of Degree or Certificate Completed" and the Admission Area for this student identifier in the Private College and University Student Entrance is not in the Admission Area/Degree Certificate Level table for the year in the header record

(If more than one Admission Area exists for this student at this institution, check the combination of each Admission Area (SE) and Degree Level (DC) against the Admission Area/Degree Certificate Level table. If one of those combinations match the table, then do not write Error 247.)

Note: Combination of GRD/10 in the Admission Area/Degree Certificate Level verification table is valid only if the Field of Study is 512001 or 512099

            Write Error 247 on edit report file

Z.

If this Student Identifier matches a Previous Identifier with Data Area code set to "S" for this institution in the Identifier Change table

            Write Warning B19 on edit report file

AA.

Add one record to count

Edit Code

Edit Text

Display Value