OHIO BOARD OF REGENTS

Edit and Load Specifications

Off-campus Course Sections (OC) File

Revised October 5, 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)
001	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
002	Course Identifier is blank or not left justified	Same as programming logic.	If the Course Identifier is blank in the first character position
013	The Delete Switch is not Y or N	Same as programming logic.	If Delete Switch is not Y or N
040	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
071	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
092	There is not a matching Off-campus Course Section to be deleted in the Course Section table for this year and term	Same as programming logic.	If Off-campus Course Section Delete Switch is Y and there is not a Course Section table entry for this Campus, Year, Term, Course Identifier, Section Identifier, and Location Code
144	Section Identifier must match a Section Identifier for this Course in the Course Enrollment table	Same as programming logic.	If the Section Identifier is not blank in the first character position and does not match a combination of Course Identifier and Section Identifier in the Course Section table for this year and term
182	Section Identifier is blank or not left justified.	Same as programming logic.	If the Section Identifier is blank in the first character position
193	Off-campus Course Sections cannot be Professional course level	Same as programming logic.	If Course Level (from Course Inventory table) is P
194	Off-campus Course Sections cannot be Resident Credit Center Course Sections	Same as programming logic.	If Course Identifier and Section Identifier is Y in Resident Credit Center column of Course Section table for this campus, year and term
195	Location Code is not a valid ZIP Code or not FOREIGNCN	Same as programming logic.	If (first five digits of) Location Code is not in ZIP Code/State Abbreviations verification table for this year and term and Location Code not FOREIGNCN
196	There is already a record matching for this Campus, Course ID, Section ID, Location and Delete Switch	Same as programming logic.	If there is already a record matching this Campus, Course Identifier, Section Identifier, Location Code and Delete Switch in this submission file
197	There is already an Off-campus Course Section for this location code in the Course Section table for this year and term	Same as programming logic.	If Off-campus Course Section Delete Switch is N and there is a Course Section table entry for this Campus, Year, Term, Course Identifier, Section Identifier, and any Location Code AND there is not another record in this submission that matches this Course Identifier and Section Identifier with Delete Switch set to Y
A40	Unexpected combination of Course Level and Campus Type for Off-campus Course Section	Same as programming logic.	If, for this combination of Course Level (from Course Inventory) and Campus, the Off-campus Subsidy Level is not equal to the Course Level in the Off-campus/Campus/Course Level verification table
A41	Location Code indicates the ZIP Code is not in Ohio	Same as programming logic.	If Location Code does not map to Ohio in ZIP Code/State Abbreviations verification table for this year and term
B32	*** WARNING B32: The percentage of the off-campus course sections is greater than or equal to 10% of the total course sections for one or more campuses.	Same as programming logic.

Return to Enrollment Files

Last updated October 5, 2005