|
|
OHIO BOARD OF REGENTS |
Edit and Load
Specifications
Course Inventory (CI) 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 |
|
002 |
Course Identifier is blank or not left justified |
Same as programming logic. |
If the Course Identifier is blank in the first character position |
|
003 |
Subject Code is not in Subject Code verification table |
Same as programming logic. |
If Subject Code is not in the Subject Code Exceptions (for this file
submission only) or Subject Code verification tables for this year and term |
|
005 |
Course Level Code is not in the Course Level verification
table |
Same as programming logic. |
If Course Level is not in the Course Level verification table for this
year and term |
|
006 |
Low Credit Value is not numeric |
Same as programming logic. |
If Low Credit Value is not numeric in each character position |
|
007 |
High Credit Value is not numeric |
Same as programming logic. |
If High Credit Value is not numeric in each character position |
|
008 |
Low Credit Value is greater than High Credit Value |
Same as programming logic. |
If Low Credit Value is greater than High Credit Value |
|
013 |
The Delete Switch is not Y or N |
Same as programming logic. |
If Delete Switch is not Y or N |
|
014 |
Course Identifier being deleted is not in the Course Inventory
table |
Same as programming logic. |
If Course Delete Switch is Y and there is not a corresponding row in
the Course Inventory table for the Year, Term, Institution and Course
Identifier on the submission file |
|
015 |
There is already a record in this Course Inventory File
submission for this course |
Same as programming logic. |
If there is already a Course Inventory record for this Course
Identifier on this submission file |
|
016 |
Eligible for Subsidy switch is not Y or N |
Same as programming logic. |
If the Eligible for Subsidy switch is not Y or N |
|
019 |
Combination of Subject Code, Course Level and Institution
are invalid |
Same as programming logic. |
If the combination of Subject Code and Course Level does not exist for
any campus of this institution (from Header Record) in the Subject
Code/Course Level/Campus verification table for this year and term |
|
020 |
Course Title is blank or is not left justified |
Same as programming logic. |
If the Course Title is blank in the first character position |
|
035 |
There are non-blank characters beyond the allotted record length for
this file |
Same as programming logic. |
If the record is not 52 characters long |
|
081 |
Cannot delete record because there are Flexibly Scheduled Course
Sections associated w/ this Course ID in the Course Section table |
Same as programming logic. |
If Course Delete Switch is Y and there are Flexibly Scheduled Course Sections
associated with this Course Identifier in the Course Section table for this
institution, year and term |
|
091 |
Cannot delete record because there are Off-campus Course
Sections associated with this Course ID in the Course Section table |
Same as programming logic. |
If Course Delete Switch is Y and there are Off-campus Course Sections
associated with this Course Identifier in the Course Section table for this
institution, year and term |
|
100 |
Cannot delete record because there are Resident Credit
Course Sections associated with this Course ID in the Course Section table |
Same as programming logic. |
If Course Delete Switch is Y and there are Resident Credit Center
Course Sections associated with this Course Identifier in the Course Section table
for this institution, year and term |
|
113 |
Cannot delete record because there are Course Enrollments
associated with this Course Identifier for this year and term |
Same as programming logic. |
If Course Delete Switch is Y and there are Course Enrollments
associated with this Course Identifier in the Course Enrollment table for
this institution, year and term |
|
240 |
Course/Subject Code/Level combination not allowed per
prior agreement |
Same as programming logic. |
If Delete Switch is N and there is a row in the Course Exceptions
table for this Institution, Course Id, Subject Code and Course Level |
|
A09 |
Low Credit Value is greater than 15 |
Same as programming logic. |
If Low Credit Value is greater than 15 |
|
A10 |
High Credit Value is greater than 15 |
Same as programming logic. |
If High Credit Value is greater than 15 |
|
A60 |
Changing Subject Code from prior term |
Same as programming logic. |
If Delete Switch is N and there is not a row in the Course Exceptions
table for this Institution, Course Id, Subject Code and Course Level and
there was a row in the Course Inventory table for this Course Identifier and
Institution in the previous term and the Subject Code has changed – if this
Course ID is not found in the previous term, search for the Course ID in the
term before that. If the Course ID is not found in that term, search the term
before that. |
|
A61 |
Changing Course Level from prior term |
Same as programming logic. |
If Delete Switch is N and there is not a row in the Course Exceptions
table for this Institution, Course Id, Subject Code and Course Level and
there was a row in the Course Inventory table for this Course Identifier and
Institution in the previous term and the Course Level has changed – if this
Course ID is not found in the previous term, search for the Course ID in the
term before that. If the Course ID is not found in that term, search the term
before that. |
|
A62 |
Changing Subsidy Eligibility Status from prior term |
Same as programming logic. |
If Delete Switch is N and there is not a row in the Course Exceptions
table for this Institution, Course Id, Subject Code and Course Level and
there was a row in the Course Inventory table for this Course Identifier and
Institution in the previous term and the Subsidy Eligibility Status has
changed – if this Course ID is not found in the previous term, search for the
Course ID in the term before that. If the Course ID is not found in that
term, search the term before that. |
|
A94 |
This record will change the Course Level from an earlier
submission. |
Same as programming logic. |
If the Delete Switch is N and the Course Identifier on the submission matches
a Course Identifier in the Course Inventory table for this institution, year
and term and the Course Level of the submission does not match the Course
Level in the table |
|
A95 |
This record will change the Subject Code from an earlier
submission |
Same as programming logic. |
If the Delete Switch is N and the Course Identifier on the submission
matches a Course Identifier in the Course Inventory table for this
institution, year and term and the Subject Code of the submission does not
match the Subject Code in the table |
|
A96 |
This record will change the Subsidy Eligibility Switch
from an earlier submission |
Same as programming logic. |
If the Delete Switch is N and the Course Identifier on the submission matches
a Course Identifier in the Course Inventory table for this institution, year
and term and the Subsidy Eligibility Switch of the submission does not match
the Subsidy Eligibility Switch in the table |
|
B01 |
*** WARNING B01: Total ineligible course record count is
greater than or equal to 5% of the total course record count. |
Same as programming logic. |
|
|
C20 |
This Course ID appeared in the Distance Learning Course Offerings (DO)
file for this year and term. |
Same as programming logic. |
If there are Course Identifiers that are in the Distance Learning
Course Offerings (DO) table for this institution, year and term, that do not
appear in this file submission |
View Edit and Load Specifications
http://www.regents.state.oh.us/hei/datasubdoc/enrollment/production/cifile.html
Last updated September 14, 2004