|
|
OHIO BOARD OF REGENTS |
|
|
OHIO BOARD OF REGENTS |
| Error Code | Edit Message Text (Text that appears in the primary edit results) | Business Logic (The rules that triggered the error.) | Programming Logic (Detailed and technical explanation of the conditions that triggered the error) |
| 1AY | Subject Area is not in the OTM Subject Area Table | The Subject Area does not exist. | If the Subject Area is not in the OTM Subject Area table for the Year and Term Code specified in the header record |
| 1AO | First HEI Course Identifier blank or not left justified | There must be at least one course identifier per record line. | If the HEI Course Identifier (1) is blank or not left justified |
| 1AP | HEI Course Identifier not blank or not left justified | Course identifiers must be formatted by HEI standards. | If the HEI Course Identifier (2-5) is not blank or not left justified |
| 1AQ | First Transcript Department blank or not left justified | There must be at least one transcript department abbreviation per record line. | If the Transcript Department Abbreviation (1) is blank or not left justified |
| 1AR | Transcript Department Abbrevation not blank and not left justified | The transcript department identifiers must be formatted per HEI standards. | If the transcript_dept_abbrev(2-5) is not blank and is not left justified |
| 1AS | First Transcript Course Number is blank or not left justified | There must be at least one transcript course number per record line. | If the Transcript Course Number (1) is blank or not left justified |
| 1AT | Transcript Course Number is not blank and not left justified | The transcript course numbers must be formatted per HEI standards. | If the Transcript Course Number (2-5) is not blank and not left justified |
| 1BG | HEI or Transcript Identifer repeated in record | A course must not appear in the same record line twice. | Within a record line, if the HEI Course Identifier is repeated in any of the fields reserved for the HEI Course Identifier (1-5) or Within a record line, if the concatenated Transcript Department Abbreviation and Transcript Course Number is repeated for any of the concatenated combinations of Transcript Department Abbreviation and Transcript Course Number (1-5) |
| 1BC | Interdisciplinary switch is not Y or N | There are only two acceptable values; Yes or No. | If the Interdisciplinary Switch is not "Y" or "N" (1-5) |
| 13 | The Delete Switch is not Y or N | There are only two acceptable values; Yes or No. | If the Delete Switch is not "Y" or "N" |
| 1BD | Duplicate record exists in submission or in OTM Inventory for this year and term | There must be no exact duplicate record lines in the database. | If the Delete Switch is “N” (And the Subject Area Code is in the OTM Subject Area table for the Year and Term from the header record), AND If for the same Year, Term, OTM Subject Area Code, Institution and Campus (OTM Campus Year Term), the block of HEI Course Identifiers in any sequence may already be found in the OTM Course Inventory table for a record line matching on all HEI Course Identifiers already in the OTM Course Inventory table or in this file, Or may already be found in any sequence within a larger sequence of HEI Course Identifiers already in the OTM Course Inventory table or in this file, Or may be found in any sequence within a smaller sequence of HEI Course Identifiers already in the OTM Course Inventory table or in this file. |
| 1BE | There is no matching record to be deleted in the OTM Course Inventory table | A record must exist in the HEI database for it to be deleted. | If the delete switch is "Y" and the Subject Area Code in the record line matches the Subject Area Code in the OTM Subject Area table, and the record does not match an identical record on all data elements in a View of the same Subject Area Code, Year (compare to the header record), Term Code (compare to the header record), Campus Code and Institution Code created from the OTM Campus Year Term and OTM Course Inventory table |
| 1BF | The course has been reported as Non-Interdisciplinary within this file submission or a previous file submission | A non-interdisciplinary course must not be submitted for more than one subject area code. | If the Delete Switch is “N” and if the combination of the Institution code, Campus Code, Year from header record, Term Code from header record and HEI Course Identifier is received for the same combination of values that already exist in the OTM Course Inventory/OTM Campus Year Term tables or within this file submission for another Subject Area and the Interdisciplinary Switch is "N" for any of the record lines |
| 011 | Blank records are not allowed | Blanks records must not be permitted. | Blank records are not allowed |
| 035 | Non-blank characters | There must be no non-blank characters beyond the last expected character in the record line. | There are non-blank characters beyond the allotted record length for this file (beyond column 208) |
| 1BH | Partial entry of course identifiers | For a course identifier to submitted in its entirety, it must include the HEI course identifier, transcript department abbreviation and transcript course number. | If any of the blocks of identifiers (blocks 2-5 containing the units of HEI Course Identifier, Transcript Department Abbreviation, and Transcript Course Number), are not all filled or all blank for each block unit |
| 1BL | Credit Hours for OTM not approved until winter of 2007 and after. Please pad credit hour fields. | HEI will not begin collecting credit hours until the Winter of 2007 collection. | If the submission year and term taken from the header record is prior to winter of 2007 And all of the Total Credit Hour and Subject Area Credit Hour fields are not padded with spaces |
| 1BM | No Subject Area Credit Hours | Any course listed in the record line must have subject area credit hours if submitted for Winter of 2007 and thereafter. | If the year and term taken from the header record is for Winter of 2007 or thereafter And If there is an HEI Course Identifier in any of the 1-5 blocks and there is not also a corresponding numeric entry in the Subject Area Credit Hours for Course Number field(s) |
| 1BN | No matching HEI Course Identifier for input Subject Area Credit Hours | Subject area credit hours should not be entered if there is a corresponding course. | If the year and term taken from the header record is for Winter of 2007 or thereafter And If there is numeric Subject Area Credit Hour entry in any of the 1-5 blocks reserved for that field, but there is not a corresponding HEI Course Identifier for the corresponding block 1-5 |
| C42 | Warning: Total Credit Hours exceeded within file or OTM Course Inventory table | Under normal circumstances, it would not be expected that the sum of all subject area credit hours for an interdisciplinary course would exceed the total credit hours. | If the year and term taken from the header record is for Winter of 2007 or thereafter And If the Delete Switch is N And If the Total Credit Hours for an HEI Course Identifier is exceeded by summing the Subject Area Credit Hours from this file and the OTM Course Inventory table for the same combination of Subject Area Code, Campus, HEI Course Identifier, Year, Term |
| C43 | Warning: Sum of Subject Area Credit Hours less than Total Credit Hours | Under normal circumstances, it would not be expected that the sum of the subject area credit hours for a course would be less than the total credit hours. This circumstance might arise if not all of the mappings for a course had been submitted at a certain point in time. | If the year and term taken from the header record is for Winter of 2007 or thereafter And If the Delete Switch is N And If the Total Credit Hours for an HEI Course Identifier is greater than the sum of the Subject Area Credit Hours from this file and the OTM Course Inventory table for the same combination of Subject Area Code, Campus, HEI Course Identifier, Year, Term |
| C38 | Warning: Total Credit Hours mismatch in file or OTM Course Inventory table | Under normal circumstances, the total credit hours for a course should not change from what has been reported previously in a given term. | If the year and term taken from the header record is for Winter of 2007 or thereafter And If for this record line the Total Credit Hours for an HEI Course Identifier is less than or greater than the Total Credit Hours reported for this HEI Course Identifier in the OTM Course Inventory table or in another record line in this file submission. |
| C39 | Warning: HEI Course Identifier not in Course Inventory | Under normal circumstances, the HEI course identifier would have already been reported in the Course Inventory (CI) file submission. Since the TM is a prospective submission, however, a circumstance might arise where the identifier will not have been reported yet in the CI. | If for any of the HEI Course Identifiers (1-5) there is not a matching HEI Course Identifier in the Course Inventory table for this Institution within the year prior to the Year in the header record. |
Return to Transfer Assurance Guide Files
http://regents.ohio.gov/hei/datasubdoc/enrollment/tmedit.html
Last updated August 1, 2006
