OHIO BOARD OF REGENTS

Edit and Load Specifications

Cohort Tracking (CT) 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 (Detailed and technical explanation of the conditions that triggered the error)
001	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	Same as programming logic.	The Campus Code is not in the Institution/Campus Codes table
013	If Delete Switch is not Y or N	Same as programming logic.	The Delete Switch is not Y or N
017	This Student Identifier has more than one record	Same as programming logic.	Record with this student identifier and delete switch is already in the file
018	If Institution Assigned Student Identifier Switch is N AND if the Student Identifier is numeric in each character position and the first three digits, or the fourth and fifth, or the sixth through ninth digits of the Student Identifier are zeros, OR if the Student Identifier is numeric in each character position and the first three digits are 769 or above.	Same as programming logic.	Student Identifier is not a Social Security Number
021	If Institution Assigned Student Identifier Switch is N and Student Identifier is not numeric in each character position	Same as programming logic.	SSN is not numeric
022	If Institution Assigned Student Identifier Switch is not Y or N	Same as programming logic.	Institution Assigned ID Switch is not Y or N
024	If Sex Code is not M or F	Same as programming logic.	Sex Code is not a valid code
026	If Racial/Ethnic Code is not in Racial/Ethnic verification table for the calendar year of the date of this submission for the Spring term	Same as programming logic.	The Racial/Ethnic code is not in the Racial/Ethnic Codes table
033	If the Delete Switch is set to “Y” and there is not a matching Student Identifier for this institution in the Cohort Tracking table	Same as programming logic.	Delete Switch is Y but there is no record to delete
035	If record is not 24 characters long	Same as programming logic.	There are non-blank characters beyond the allotted record length for this file
040	If the Campus Code is in the Institution/Campus code verification table and does not relate to the Institution Code in the current login	Same as programming logic.	The Campus code in the input record does not correspond to the login Institution code
049	If Cohort Year is not numeric in each character position	Same as programming logic.	Cohort Year not numeric
050	If IPEDS Reported Cohort Type is not "1" or "2" or "4"	Same as programming logic.	IPEDS Reported Cohort Type is not “1,” “2” or “4”
051	If Enrollment Status is not "P" or "F"	Same as programming logic.	Enrollment Status not P or F
052	If Athlete Status is not in Athlete Status verification table for the calendar year of the date of this submission	Same as programming logic.	Athlete Status is not in Athlete Status verification table
066	If there are two records with the same Student ID on this file submission	Same as programming logic.	Student enrollment record already exists for this student in this file submission
070	If Student Identifier is blank in first character position	Same as programming logic.	Student Identifier is blank or not left justified
072	If IPEDS Status is not in the IPEDS Status verification table for the calendar year of the date of this submission	Same as programming logic.	IPEDS Status is not in the IPEDS Status verification table
U05	If the Delete Switch is set to "N" and there is a matching Student Identifier for this Institution in the Cohort Tracking table	Same as programming logic.	UPDATE: This student identifier has been submitted in a previous version. This record will replace the old.

Return to Enrollment Files

Last updated September 14, 2005