OHIO BOARD OF REGENTS
|
|
OHIO BOARD OF REGENTS |
|
Edit Rules for each Distance Learning Course Offerings (DO) record
| A |
Run edits 011 and 035 |
| B | If the Course Identifier is blank in the first character position |
|
Write Error 002 on edit report file |
|
| C |
If Term is not in the Term verification table |
|
Write Error 082 on edit report file |
|
| D |
If Year is not numeric or does not begin with “20” |
|
Write Error 348 on edit report file |
|
| E |
If First Subject Code is not in the subject code verification table |
|
Write Error 268 on edit report file |
|
| F |
If Second Subject Code is not null or not in the subject code verification table |
|
Write Error 269 on edit report file |
|
| G |
If Third Subject Code is not null or not in the subject code verification table |
|
Write Error 270 on edit report file |
|
| H |
If Undergraduate Course Type is not “Y” or “N” |
|
Write Error 271 on edit report file |
|
| I |
If Graduate Course Type is not “Y” or “N” |
|
Write Error 272 on edit report file |
|
| J |
If Certificate Course Type is not “Y” or “N” |
|
Write Error 273 on edit report file |
|
| K |
If Continuing Education Course Type is not “Y” or “N” |
|
Write Error 274 on edit report file |
|
| L |
If Noncredit Course Type is not “Y” or “N” |
|
Write Error 275 on edit report file |
|
| M |
If Other Course Type is not “Y” or “N” |
|
Write Error 443 on edit report file |
|
| N |
If Low Credit Value is not numeric in each character position |
|
Write Error 006 on edit report file |
|
| O |
If High Credit Value is not numeric in each character position |
|
Write Error 007 on edit report file |
|
| P |
If Low Credit Value is greater than 15 |
|
Write Warning A09 on edit report file |
|
| Q |
If High Credit Value is greater than 15 |
|
Write Warning A10 on edit report file |
|
| R |
If Low Credit Value is greater than High Credit Value |
|
Write Error 008 on edit report file |
|
| S |
If Course Title is null |
|
Write Error 276 on edit report file |
|
| T |
If Prerequisites is null |
|
Write Error 278 on edit report file |
|
| U |
If Transition URL starts with http:// |
|
Write Error 279 on edit report file |
|
| V |
If Calendar Type is not “Q,” “S” or “O” |
|
Write Error 489 on edit report file |
|
| W |
If Deactivate Switch is not “Y” or “N” |
|
Write Error 490 on edit report file |
|
| X |
If Delete Switch is not “Y” or “N” |
|
Write Error 013 on edit report file |
|
| Y |
If Course Delete Switch is “Y” and there is not a corresponding row in the Distance Learning Course Offering (DO) table for the Year, Term, Institution and Course Identifier on the submission file |
|
Write Error 351 on edit report file |
|
| Z |
If Course Delete Switch is “Y” and there are records associated with this Course Identifier in the Distance Learning Course Section (DS) table for this institution, year and term |
|
Write Error 352 on edit report file |
|
| AA |
If the Campus Type code in the Institution/Campus table for this institution is “UM,” “UB,” “CC,” “SC” or “TC” and the Course Identifier has not appeared in a previous Course Inventory submission from this institution |
|
Write Warning C11 on edit report file |
|
| AB |
If First Subject Code does not match the subject code reported with this Course ID in any previous Course Inventory (CI) file submission |
|
Write Warning C19 on edit report file |
|
| AC |
If there are 2 or more records in the submission with the same Course ID, Year, Term and Delete Switch |
|
Write Error 867 on edit report file |
|
| AD |
If there is not an entry in the academic calendar table for this institution, year and term |
|
Write Error 825 on edit report file |
|
| AD |
Check if the record is fixed width or tilde delimited. If fixed width, count the number of characters in the field. If less than 1588, |
|
Write Error 871 on edit report file |
Report of Errors and Warnings
|
Edit Code |
Edit Text |
Display Value |
|
002 |
Course Identifier is blank or not left justified |
Course Identifier |
|
006 |
Low Credit Value is not numeric |
Low Credit Value |
|
007 |
High Credit Value is not numeric |
High Credit Value |
|
008 |
Low Credit Value is greater than High Credit Value |
Low Credit Value/High Credit Value |
|
013 |
The Delete Switch is not Y or N |
Delete Switch |
|
082 |
Term is not in Term verification table |
Term |
|
268 |
First Subject Code is not in the subject code verification table |
Course ID/Term/Year/First Subject Code |
|
269 |
Second Subject Code is not null or not in the subject code verification table |
Course Id/Term/Year/Second Subject Code |
|
270 |
Third Subject Code is not null or not in the subject code verification table |
Course Id/Term/Year/Third Subject Code |
|
271 |
Undergraduate Course Type not Y or N |
Course Id/Term/Year/Undergraduate Course Type |
|
272 |
Graduate Course Type not Y or N |
Course Id/Term/Year/Graduate Course Type |
|
273 |
Certificate Course Type not Y or N |
Course Id/Term/Year/Certificate Course Type |
|
274 |
Continuing Education Course Type not Y or N |
Course Id/Term/Year/Continuing Ed Course Type |
|
275 |
Noncredit Course Type is not Y or N |
Course Id/Term/Year/Noncredit Course Type |
|
276 |
Course Title is Null |
Course Id/Term/Year/Course title |
|
278 |
Prerequisites is Null |
Course Id/Term/Year/Prerequisites |
|
279 |
Transition URL starts with http:\\ |
Course Id/Term/Year/Transition URL |
|
348 |
Year is not numeric or does not begin with “20” |
Course Id/Year |
|
351 |
The delete switch is Y but there is no matching record for this course identifier, year, and term in the database |
Course Identifier/Year/Term |
|
352 |
Cannot delete course because there are associated course sections |
Course Identifier/Year/Term |
|
443 |
Other Course Type is not “Y” or “N” |
Other Course Type |
|
489 |
Invalid Calendar Type |
Calendar type |
|
490 |
Deactivate Switch is not “Y” or “N” |
Deactivate Switch |
| 825 | The year and term of this record is not available on this system. | Year, Term, Institution |
|
867 |
2 or more records in the submission with the same Course ID, Year, Term, and Delete Switch |
Course Identifier/Year/Term/Call #/Delete Switch |
| 871 | The record is fixed-width and does not contain the correct number of columns. | Record identifier |
|
A09 |
Low Credit Value is greater than 15 |
Low Credit Value |
|
A10 |
High Credit Value is greater than 15 |
High Credit Value |
|
C11 |
This Course Identifier has not been used in any previous term |
Course Identifier
|
|
C19 |
First Subject Code does not match the subject code reported with this Course ID in any previous Course Inventory (CI) file submission |
Course ID/Subject Code |
http://regents.ohio.gov/hei/oln/doedit.html
Last updated March 26, 2004