| |
OHIO BOARD OF REGENTS |
![]()
Edit and Load Specifications
Academic Program (AP) File
Revised August 23, 2004
Edit Rules for Academic Programs (AP) Records
Read the record
A. |
If the Campus Code does not exist in the Campus Code Column of the Institution/Campus code verification table |
|
|
Write Error 001 on edit report file |
B. |
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 |
C. |
If the Campus Code, Program Code and Delete Switch field values are repeated in the file submission |
|
|
Write Error 429 on edit report file |
D. |
If the Subject Code is not in the Subject Code Exceptions table (for this file submission only) or Subject Code verification tables for the term and the year reported in the Header Record |
|
|
Write Error 003 on edit report file |
E. |
If the Level of Degree or Certificate Completed is not in the Level of Degree or Certificate Completed Codes verification table for this submission year (XX is an acceptable value only for the Academic Program file submission-please hard code the acceptable value of XX for this submission) |
|
|
Write Error 084 on edit report file |
F. |
If the Level of Degree begins with A |
|
|
Write Error 432 on edit report file |
G. |
If the Degree Name Code and Year Number is not in the Degree Name table for the current submission year |
|
|
Write Error 356 on edit report file |
H. |
If the Minimum Expected Time to Degree is not numeric or not blank (it is permissible for the field to be left blank under some conditions), THEN Write Error 361
If the Minimum Expected Time to Degree is numeric or blank, then proceed with the following condition: If the Degree Cert Level is not greater than 05 (if the Degree Cert Level is greater than 05, the field may be left blank)ANDthe Minimum Expected Time to Degree is not numeric |
|
|
Write Error 361 on edit report file |
I. |
If the Degree Cert Level is not equal to XX and is less than or equal to 05, and the Minimum Expected Time to Completion is not greater than 0 |
|
|
Write Error 797 on edit report file |
J. |
If the Minimum Number of Credit Hours for program completion is not numeric or not blank (it is permissible for the field to be left blank under some conditions), THEN Write Error 242
If the Minimum Number of Credit Hours for program completion is numeric or blank, then proceed with the following condition: If the Degree Cert Level is not greater than 05 (if the Degree Cert Level is greater than 05, the field may be left blank)ANDThe Minimum Number of Credit Hours for program completion is not numeric |
|
|
Write Error 242 on edit report file |
K. |
If the Degree Cert Level is not equal to XX and is less than or equal to 05, and the Minimum Credit Hours to Degree is not greater than 0 |
|
|
Write Error 438 on edit report file |
L |
If the Degree Cert Level is equal to XX and if the Minimum Expected Time to Completion and the Minimum Number of Credit Hours for Program Completion are not both zero |
|
|
Write Error 798 on edit report file |
M. |
If the program Status is not I or A |
|
|
Write Error 373 on edit report file |
N. |
If the Year of Inactivity is not numeric in all four spaces or is not UNKN |
|
|
Write Error 419 |
O. |
If the Term of Inactivity cannot be found in the Term Code verification table or the Term of Inactivity is not NA |
|
|
Write Error 082 |
P. |
If the Delete Switch is Y and there is not a row in the Academic Program table that matches the Campus Code, Program Code, Year Number, and Term Code |
|
|
Write Error 033 on edit report file |
Q. |
If the Delete Switch is N and there is a matching Program Code, Year Number, and Term Code in the Academic Program table for this campus and at least one of the remaining fields does not equal its corresponding column value in the Academic Program table |
|
|
Then Update per Load Instructions and Write Warning U07 on edit report file |
R. |
If the Delete Switch is N and the newly submitted record matches all fields for another record already in the Academic Program table |
|
|
Write Warning C13 on edit report file and ignore record |
S. |
If there are non-blank characters beyond the allotted record length of 84 characters for this file |
|
|
Write Error 035 on edit report file |
T. |
If the Delete Switch is not Y or N |
|
|
Write Error 013 on edit report file |
U. |
If the Degree Cert Level Code is not XX and its corresponding Admission Area Code found in the Admission Area/Degree Cert Level verification table does not coincide with the acceptable Admission Area values in the Institution/Admission Area table for the Spring term of the year found in the header record (having already joined the Institution/Admission Area table and the Institution/Campus table) |
|
|
Write Error 376 on the edit report file |
V. |
If the Delete Switch is Y |
|
|
Write Warning C14 on the edit report file |
W. |
If the following unexpected low values are submitted in the Minimum Credit Hours to Degree field:
|
|
|
Write Warning C15 on the edit report file |
X. |
If the following high values are submitted in the Minimum Years to Completion field:
|
|
|
Write Warning C16 on the edit report file |
Y. |
If the Delete Switch is Y and the Campus Code and the Program Code from this submission exists within the Degree/Certificate table for a Graduation Year and Term equal to or after this submission year and term |
|
|
Write Error 826 to the edit report file |
Report of Errors and Warnings
|
Edit Code |
Edit Text |
Display Field |
|
001 |
The Campus Code is not in the Institution/Campus Codes table |
Campus Code |
|
003 |
Subject Code is not in Subject Code verification table |
Subject Code |
|
013 |
The Delete Switch is not Y or N |
Delete Switch |
|
033 |
Delete Switch is Y but there is no record to delete |
Program Code |
|
035 |
There are non-blank characters beyond the allotted record length for this file |
Characters beyond 84 characters |
|
040 |
The Campus code in the input record does not correspond to the login Institution code |
Campus Code/Institution Code from Login |
|
082 |
Term is invalid |
Term |
|
084 |
Level of Degree or Certificate Completed is not in the Level of Degree or Certificate Completed verification table |
Level of Degree Code |
|
242 |
Number of Credit Hours for Program Completion contains nonnumeric data |
Expected Number of Credit Hours for Program Completion |
|
356 |
Degree Name Code is not a valid entry |
Degree Name/Submission year |
|
361 |
Minimum Expected Time to Degree is not numeric |
Time to degree/Degree Cert Level |
|
373 |
Program Status is not I or A |
Status entry |
|
376 |
Degree Cert Level Code and Admission Area Code do not correspond |
Degree Cert Level Code |
|
419 |
Year is not numeric or UNKN |
Year |
|
429 |
Campus, Program, Del Repeated |
Campus Code, Program Code, Delete Switch |
|
432 |
Second degree not valid entry |
Degree Level Code |
|
438 |
Minimum Credit Hrs to Degree is not greater than zero |
Program Code, Degree Level, Min Cred Hrs |
|
797 |
Minimum Expected Time to Completion is not greater than zero |
Program Code, Degree Level, Min Time to Completion |
|
798 |
Degree Cert Level is XX and Min Time to Completion and Min Cred Hrs are not zero |
Pgrm Code, Degree/Cert Lvl, Min Time to Comp, Min Cred Hrs |
|
826 |
Cannot delete. Program Code exists in DC. |
Program Code, Campus Code |
|
U07 |
Delete Switch is N and there is already a matching Program Code in the system. Record will be updated. |
Program code |
|
C13 |
Delete Switch is N and the newly submitted record matches all fields for another record already in the system. Record ignored. |
Program code |
|
C14 |
WARNING: Deletion is not used to inactivate a course at an institution. It is used only to correct errors. |
Program Code |
|
C15 |
Unexpected low values for Credit Hours to Degree |
Minimum Credit Hours to Degree |
|
C16 |
Unexpected high values for Minimum Years to Completion |
Minimum Years to Completion |
![]()
Return to Academic Programs Files
http://regents.ohio.gov/hei/datasubdoc/academicprogs/apedit.html
Last updated
August 23, 2004