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)

AND

the 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)

AND

The 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:
  • If the Level of Degree is 01 and the Minimum Credit Hours to Completion is less than 15 credits hours
  •  If the Level of Degree is 03 and the Minimum Credit Hours to Completion is less than 60 credit hours

  • If the Level of Degree is 05 and the Minimum Credit Hours to Completion is less than or equal to 120

  •  If the Level of Degree is 02, 06, 07, 08, 11, TM and the Minimum Credit Hours to Completion is less than or equal to 25 credit hours
  • If  the Level of Degree is 04, 09, or 10 and the Minimum Credit Hours to Completion is less than or equal to 80 credit hours

 
            Write Warning C15 on the edit report file
X.
If the following high values are submitted in the Minimum Years to Completion field:
  • If the Years to Completion for the Degree Level Code of 03 are greater than 2 years

  • If the Years to Completion for the Degree Level Code of 05 are greater than 4 years

  • If the Years to Completion for the Degree Level Codes of 01, 06, XX are greater than 1 year

  • If the Years to Completion for the Degree Level Codes of 02, 09, TM are greater than 2 years

  • If the Years to Completion for the Degree Level Codes of 07, 08 are greater than 3 years

  • If the Years to Completion for the Degree Level Code of 04, 10 are greater than 6 years

 
            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

 

horizontal red line

 

Return to Academic Programs Files

 

http://regents.ohio.gov/hei/datasubdoc/academicprogs/apedit.html
Last updated August 23, 2004