OHIO BOARD OF REGENTS 

 

 

Edit and Load Specifications

 

Course Enrollment (CN) File

Revised September 14, 2005

 

Error Code

Edit Message Text

(Text that appears in primary edit results)

Business Logic

(The rules that triggered the error.)

Programming Logic
(Detailed and technical explanation of the conditions that triggered the error)

1

The Campus Code is not in the Institution/Campus Codes table

Same as programming logic. 

If Campus Code does not exist in the Campus Code Column of the Institution/Campus code verification table or the Campus code is SSCC or CYCC                       

2

Course Identifier is blank or not left justified

Same as programming logic. 

If the Course Identifier is blank in the first character position

4

Subject code from Course Inventory indicates this course is medical.  This enrollment should not be reported in the CN.

Same as programming logic. 

If Course Identifier is in the Course Inventory table for this Institution, Year and Term, and the Subject code and Course Level is in the Medical Funding Unit verification table for this year and term

12

Professional level law school enrollments are on semester calendar only: Report in spring

Same as programming logic. 

If Course Identifier is in the Course Inventory table for this institution, year and term, and the Subject code is 220101 and the Course Level is P and the Term is WI

13

The Delete Switch is not Y or N

Same as programming logic. 

If the Delete Switch is not Y or N

40

The Campus code in the input record does not correspond to the login Institution code

Same as programming logic. 

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

56

There is no record of this student in the Student Enrollment table for this campus, year and term

Same as programming logic. 

If the Student Identifier does exist in the Student Entrance table for this institution and there is not a entry for this OBRID (from Institution/SSN table), Campus, Year, and Term in the Student Enrollment table

69

This student does not have a Student Entrance record

Same as programming logic. 

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

71

Course Identifier does not match a course in the Course Inventory table

Same as programming logic. 

If the Course Identifier is not blank in the first character position and is not in the Course Inventory table for this institution and this Year and Term

78

Course Enrollment Delete Switch is Y, but there is no Course Enrollment row to delete

Same as programming logic. 

If the Course Enrollment Delete Switch is Y and Course Enrollment record does not match a row that already exists on the Course Enrollment table

OR

the number of matching rows in the CN table plus the number of insertions in the CN submission is less than the number of deletions in the CN submission

79

Credit Hours is not numeric

Same as programming logic. 

If Credit Hours is not numeric in each character position

181

This combination of Subject Code, Course Level and Campus is invalid.  See Subject Code/Course Level/Campus verification table.

Same as programming logic. 

If Course Identifier is in the Course Inventory table for this Institution, Year and Term, and the combination of Subject Code and Course Level (from Course Inventory) and Campus (from this submission) is not in the Subject/Level/Campus verification table

182

Section Identifier is blank or not left justified.

Same as programming logic. 

If the Section Identifier is blank in the first character position

183

Attempt for Academic Credit Code not in Attempt for Academic Credit verification table

Same as programming logic. 

If Attempt for Academic Credit Code is not in Attempt for Academic Credit verification table

184

Award of Academic Credit Code is not Y or N

Same as programming logic. 

If Award of Academic Credit Code is not Y or N

185

Attempt for Academic Credit is A or C and Award of Academic Credit is not N

Same as programming logic. 

If Attempt for Academic Credit Code is A or C and Award of Academic Credit Code is not N

186

Cannot delete record because there is a Flexibly Scheduled Course Section associated with this course section

Same as programming logic. 

If all enrollments for this combination of Course Identifier, Section Identifier, Campus, Year and Term in the Course Enrollment table are to be deleted and the Section is Flexibly Scheduled (from Course Section table)

AND

there is not another record in the submission file matching this Course Identifier, Section Identifier, and Campus with the Delete Switch equal to N

187

Cannot delete record because there is an Off-campus Course Section associated with this course section

Same as programming logic. 

If all enrollments for this combination of Course Identifier, Section Identifier, Campus, Year and Term in the Course Enrollment table are to be deleted and the Section is Off-campus (from Course Section table)

AND

there is not another record in the submission file matching this Course Identifier, Section Identifier, and Campus with the Delete Switch equal to N

188

Cannot delete record because there is a Resident Credit Center Course Section associated with this course section

Same as programming logic. 

If all enrollments for this combination of Course Identifier, Section Identifier, Campus, Year and Term in the Course Enrollment table are to be deleted and the Section is Resident Credit Center (from Course Section table)

AND

there is not another record in the submission file matching this Course Identifier, Section Identifier, and Campus with the Delete Switch equal to N

191

Cannot delete record: There is an entry for Funding Unit from the Sections Taught file (Faculty) associated w/ this course section

Same as programming logic. 

If all enrollments for this combination of Course Identifier, Section Identifier, Campus, Year and Term in the Course Enrollment table are to be deleted and the Section has an entry for Funding Unit (from Course Section table)

AND

there is not another record in the submission file matching this Course Identifier, Section Identifier, and Campus with the Delete Switch equal to N

232

This record is a duplicate of a previous record and is not needed.  Previous record will delete all rows in the database.

Same as programming logic. 

 

253

Duplicate records comprise more than 5% of total records

Same as programming logic. 

If the count of all duplicate records (records that match Student ID, Institution, Campus, Course ID, Section ID, Year and Term) is more than five percent of all records (in this submission and loaded onto the database) for this institution, campus, year and term

A35

Combination of Subject Code, Course Level, and Campus is valid, but there will be subsidy implications due to this student's rank

Same as programming logic. 

If Course Identifier is in the Course Inventory table for this Institution, Year and Term, and the combination of Subject Code, Course Level, and Campus is valid

AND

if the Subsidy Level Code is equal to E for this combination of Course Level (from Course Inventory table) and Student Rank (from Student Enrollment table)

A36

Credit Hours are greater than 15

Same as programming logic. 

If Course Identifier and Credit Hours are valid and Credit Hours are more than 15

A37

There is more than one row on the Course Enrollment table for this Course and Section ID

Same as programming logic. 

If the Course Enrollment Delete Switch is Y and there is more than one row that matches the Student Identifier (OBRID), Course Identifier, Section Identifier, Credit Hours, Attempt for Academic Credit and Award of Academic Credit in the Course Enrollment table

A38

Two or more rows exist for this Student, Course ID, Section ID and Campus in the Course Enrollment submission and table

Same as programming logic. 

If this file were to be loaded onto the database and as a result two or more rows for this OBRID, Year, Term, Campus, Course Identifier and Section Identifier would exist in the Course Enrollment table

A39

Student is in Student Enrollment table but not in the Course Enrollment file and not a med student: Student might be in XR file

Same as programming logic. 

If there is an OBRID (from Institution/SSN table) in the Student Enrollment table for this Campus, Year, and Term that is not in this Course Enrollment file submission or Course Enrollment table for this year and term and the student’s Major Field of Study (from SN) is not in the Medical Funding Unit verification table for this year and term and the student’s Rank (from SN) is not professional (PR)

A84

Credit Hours are not in the range specified on the Course Inventory table for this course

Same as programming logic. 

If the Course Identifier is valid and Credit Hours is not in the range for this course in the Course Inventory table

 

 

horizontal red line

 

Return to Enrollment Files

 

Last updated September 14, 2005