|
|
OHIO BOARD OF REGENTS |
Edit and Load Specifications
Degree/Certificate
Earned (DC) File
Revised September 9,
2005
|
Error Code |
Edit Message
Text (Text that appears in primary edit results) |
Business Logic (The rules that triggered the error.) |
Programming
Logic |
|
035 |
There are non-blank characters
beyond the allotted record length for this file |
Same as programming logic. |
If there are non-blank characters beyond 32 characters |
|
001 |
The Campus Code is not in the
Institution/Campus Codes table |
|
If Campus Code does not exist in the Campus Code Column of the Institution/Campus code verification table or the Campus code is CYCC |
|
040 |
The Campus code in the input record
does not correspond to the login Institution code |
|
If the Campus Code is in the Institution/Campus code verification table and does not relate to the Institution Code in the current login |
|
069 |
This student does not have a
Student Entrance record |
|
If there is not a 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 or Term |
|
C22 |
This student does not have a Student
Enrollment record |
|
If there is not a Student Enrollment 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 or Term |
|
228 |
Year is not numeric in each
character position |
|
If Year is not numeric in each character position |
|
225 |
Term is WI or SP but Year is not
current year |
|
If the Term is WI or SP and Year is numeric and is not equal to current year (from Header Record) |
|
226 |
Term is AU but Year is not one
less than current year |
|
If the Term is AU and Year is numeric and is not one year less than current year (from Header Record) |
|
229 |
Term is SM but Year is more than
two years prior to the current year |
|
If the Term is SM and the Year is numeric and is not the current year (from Header Record) or not one year less than the current year |
|
A12 |
Term is SM but Year is not one
less than current year |
|
If the Term is SM and Year is numeric and Error 229 was not tripped and Year is not one year less than current year (from Header Record) |
|
082 |
Term is not in Term verification
table |
|
If Term is not in Term verification table for this Year and Term |
|
084 |
Level of Degree or Certificate
Completed is not in the Level of Degree or Certificate Completed verification
table |
|
If Level of Degree or Certificate Completed is not in Level of Degree or Certificate Completed Codes verification table for this submission year |
|
C17 |
Degree level indicates second
major but a first major for this SSN and level is not found |
|
If Delete Switch is N AND Level of Degree or Certificate Completed is A1, A2, A3, A4, A5, A6, A7, A8 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: 01 = A1, 02 = A2, 03 = A3, 04 = A4, 05 = A5, 06 = A6 ,07 = A7 ,08 = A8 ,09 = A9 |
|
616 |
Academic Program Code is not in
the Academic Program code column of the Academic Program table for this
institution |
|
If the Academic Program Code is not in the Academic Program code column of the Academic Program table for this institution |
|
083 |
Combination of Field of Study
and Campus is invalid |
|
If the subject code is not "TRAMOD" AND The combination of Field of Study (Subject Code) and Campus is not in the Course Level/Subject Code/Campus verification table for this year and term (Do not write Error 083 if Degree Level = "01" or "A1" and the subject code is in the Alternative Subject Table for the year of this submission.) |
|
227 |
Credit Hours to Degree is not
numeric |
|
If Credit Hours to Degree is not numeric in each character position |
|
A50 |
Level of Degree or Certificate
is 01 or 02 but Credit Hours to Degree is less than or equal to 20 |
|
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 |
|
A51 |
Level of Degree or Certificate
is 03, 04, or 07 but Credit Hours to Degree is less than or equal to 30 |
|
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 less than or equal to 30 |
|
A52 |
Level of Degree or Certificate
is 05, 09, or 10 but Credit Hours to Degree is less than or equal to 60 |
|
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 less than or equal to 60 |
|
A53 |
Level of Degree or Certificate
is 06 but Credit Hours to Degree is less than or equal to 18 |
|
If the Delete Switch is N and the Level of Degree or Certificate is 06 and Credit Hours to Degree is numeric and less than or equal to 18 |
|
A54 |
Level of Degree or Certificate
is 08 but Credit Hours to Degree is less than or equal to 24 |
|
If the Delete Switch is N, Level of Degree or Certificate is 08 and Credit Hours to Degree is numeric and less than or equal to 24 |
|
A55 |
Credit Hours to Degree is
greater than or equal to 300 |
|
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 greater than or equal to 300 |
|
A56 |
Credit Hours to Degree is
greater than or equal to 200 |
|
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 greater than or equal to 200 |
|
013 |
The Delete Switch is not Y or N |
|
If Degree/Certificate Delete Switch is Not Y or N |
|
A17 |
Degree/Certificate Completed
table entry already exists for this record |
|
If Degree/Certificate Delete Switch is N and there is already a Degree/Certificate Completed 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 |
|
A16 |
Duplicate Degree/Certificate
Completed record already exists in this file submission |
|
If there is another matching record in this submission for this Student ID, Campus, Field of Study, Credit Hours to Degree, Level of Degree or Certificate Completed, and Delete Switch |
|
087 |
Degree/Certificate Completed
entry does not exist for this record |
|
If Degree/Certificate Delete Switch is Y and there is not already an entry in the Degree/Certificate Completed table for this OBRID, Campus, Year, Term, Level of Degree or Certificate Completed, Field of Study, Credit Hours to Degree |
|
A57 |
Two or more degrees will have
been awarded to this student during this year and term |
|
If Degree/Certificate Delete Switch is N and there is already a Degree/Certificate Completed table entry for this OBRID, and Fiscal Year and Term OR If Degree/Certificate 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 |
|
A58 |
Three or more degrees will have
been awarded to this student during this fiscal year |
|
If Degree/Certificate 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 Degree/Certificate 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 |
|
247 |
The Degree Level for this
student identifier is inappropriate for the Admission Area of the student
reported in the SE |
|
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 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. If the academic program and campus code matches the table Academic Program Degree Cert Exception table, 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 |
|
B19 |
Student ID matches an ID that
was formerly used to identify another student |
|
If this Student Identifier matches a Previous Identifier with Data Area code set to “S” for this institution in the Identifier Change table |
|
437 |
Field of Study is for Short Term
Certificates Only: This Degree Level is Invalid for Short Term Certificates |
|
If Error 083 was not triggered and if campus is valid per edit D AND Degree level <> “01” and <> "A1" and the Field of Study matches a value in the DC Subject Code column in the Alternative Subject table for a Year equal to the submission year |
|
C33 |
Level of Degree or Certificate is
WI but Credit Hours to Degree is greater than 45 |
|
If the Delete Switch is N and the Level of Degree Certificate is WI and Credit Hours to Degree is numeric and greater than 45 |
Last updated September 9, 2005