|
|
OHIO BOARD OF REGENTS |
Edit and Load
Specifications
High
School of Graduation (HG) File
Revised
September 22, 2005
|
Error Code |
Edit Message
Text (Text
that appears in primary edit results) |
Business Logic (The rules that triggered the error.) |
Programming
Logic |
|
011 |
Blank records are not allowed |
Same as programming logic. |
If record is blank stop editing record |
|
013 |
The Delete Switch is not Y or N |
Same as programming logic. |
If the Delete Switch field value is not Y or N |
|
035 |
There are non-blank characters beyond the allotted record
length for this file |
Same as programming logic. |
If record has non-blank characters beyond the specified length in the data
submission document |
|
069 |
This Student Identifier 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 |
|
080 |
The Admission Area for this student is not UND |
Same as programming logic. |
If there is not an Admission Area Code in the Student Entrance table for
this student and institution =UND |
|
141 |
Year of graduation is not "UNKN", or not numeric
or does not begin with either 19 or 20 |
Same as programming logic. |
If Year of Graduation (is not UNKN and is not numeric in all four
character positions) OR (if year of graduation is numeric in all four
character positions and the first 2 characters are not 19 or not 20) |
|
155 |
Year and Term of First Enrollment in the SE are not within
the previous fiscal year |
Same as programming logic. |
If the Year and Term of first enrollment for the OBRID associated with
the identifier in the submission record is not within the fiscal year (SM or
AU of the previous year; WI or SP of the current Year) in Student Entrance or
Revised First Enrollment tables |
|
189 |
Row already exists in database for this Student Identifier |
Same as programming logic. |
If the Delete Switch field value is N and a row exists in the High
School of Graduation table matching the OBRID associated with the Student
Identifier in the record, Institution, and the submission does not contain a
record with a matching Student Identifier and Delete Switch field value of
Y |
|
248 |
Delete Switch is Y but there is not a row in database for
this Student Identifier |
Same as programming logic. |
If the Delete Switch field value is Y and row does not exist in the
High School of Graduation table matching the OBRID associated with the
Student Identifier in the record, Institution from the header record, and
year |
|
249 |
There are duplicate records in the submission for this
Student Identifier and Delete Switch |
Same as programming logic. |
If there are 2 or more records with matching identifiers and Delete
Switch field values |
|
899 |
Year of High School Graduation is greater than year of this
submission. |
Same as programming logic. |
If the Year of Graduation is > submission year (from header record) |
|
B79 |
The First Time Ever Enrolled in College Switch submitted
in the SE record for this student is N |
Same as programming logic. |
If First Time in College Switch in the Student Entrance table for the
OBRID associated with the Student Identifier in the submission record is N |
|
B80 |
This high school accounts for 5% or more of the total
first-time first-year population at this institution |
Same as programming logic. |
|
|
B95 |
ACT High School Code is not UNKN and is not in the ACT
High School Codes table. |
Same as programming logic. |
If the ACT High School Code field value does not match an ACT code in
the ACT High School Total table and is not XXXXXX |
|
B96 |
An HG record was expected for this student, but has not
been submitted |
Same as programming logic. |
|
|
B97 |
This student was at least 20 years old when she or he
graduated from high school |
Same as programming logic. |
|
|
11 |
Blank records are not allowed |
Same as programming logic. |
If record is blank stop editing record |
|
13 |
The Delete Switch is not Y or N |
Same as programming logic. |
If the Delete Switch field value is not Y or N |
|
35 |
There are non-blank characters beyond the allotted record
length for this file |
Same as programming logic. |
If record has non-blank characters beyond the specified length in the
data submission document |
|
69 |
This Student Identifier 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 |
|
80 |
The Admission Area for this student is not UND |
Same as programming logic. |
If there is not an Admission Area Code in the Student Entrance table
for this student and institution =UND |
|
141 |
Year of graduation is not "UNKN", or not numeric
or does not begin with either 19 or 20 |
Same as programming logic. |
If Year of Graduation (is not UNKN and is not numeric in all four
character positions) OR (if year of graduation is numeric in all four
character positions and the first 2 characters are not 19 or not 20) |
|
155 |
Year and Term of First Enrollment in the SE are not within
the previous fiscal year |
Same as programming logic. |
If the Year and Term of first enrollment for the OBRID associated with
the identifier in the submission record is not within the fiscal year (SM or
AU of the previous year; WI or SP of the current Year) in Student Entrance or
Revised First Enrollment tables |
|
189 |
Row already exists in database for this Student Identifier |
Same as programming logic. |
If the Delete Switch field value is N and a row exists in the High
School of Graduation table matching the OBRID associated with the Student
Identifier in the record, Institution, and the submission does not contain a
record with a matching Student Identifier and Delete Switch field value of
Y |
|
248 |
Delete Switch is Y but there is not a row in database for
this Student Identifier |
Same as programming logic. |
If the Delete Switch field value is Y and row does not exist in the High
School of Graduation table matching the OBRID associated with the Student
Identifier in the record, Institution from the header record, and year |
|
249 |
There are duplicate records in the submission for this
Student Identifier and Delete Switch |
Same as programming logic. |
If there are 2 or more records with matching identifiers and Delete
Switch field values |
|
899 |
Year of High School Graduation is greater than year of this
submission. |
Same as programming logic. |
If the Year of Graduation is > submission year (from header record) |
|
B79 |
The First Time Ever Enrolled in College Switch submitted
in the SE record for this student is N |
Same as programming logic. |
If First Time in College Switch in the Student Entrance table for the
OBRID associated with the Student Identifier in the submission record is N |
|
B80 |
This high school accounts for 5% or more of the total
first-time first-year population at this institution |
Same as programming logic. |
|
|
B95 |
ACT High School Code is not UNKN and is not in the ACT
High School Codes table. |
Same as programming logic. |
If the ACT High School Code field value does not match an ACT code in
the ACT High School Total table and is not XXXXXX |
|
B96 |
An HG record was expected for this student, but has not
been submitted |
Same as programming logic. |
|
|
B97 |
This student was at least 20 years old when she or he
graduated from high school |
Same as programming logic. |
|
Last updated September 22, 2005