OHIO BOARD OF REGENTS

Edit and Load Specifications

TRIO Tracking (TR) File

Revised October 12, 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)

013

The Delete Switch is not Y or N

Same as programming logic.

If Delete Switch is not “Y” or “N”

017

This Student Identifier has more than one record

Same as programming logic.

If there is more than one matching combination of Student Identifier and Delete Switch in this submission

018

Invalid Social Security Number

Same as programming logic.

This edit verifies whether the SSN meets the rules for issuing SSN’s by the Social Security Administration. The rules can be found at http://www.ssa.gov/employer/stateweb.htm and http://www.ssa.gov/employer/ssnweb.htm.

If the Institution Assigned Student Identifier Switch is “N” and the Delete Switch is “N” and 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

if the Institution Assigned Student Identifier Switch is “N” and the Delete Switch is “N” and the Student Identifier does not match a Student Identifier (OBRID) for this institution in the Student Entrance table and the Student Identifier is numeric in each character position and the first three digits are 775 or above.

021

The Social Security Number is not numeric

Same as programming logic.

If Institution Assigned Student Identifier Switch is “N” and Student Identifier is not numeric in each character position

022

The Institution Assigned Identifier Switch is not Y or N

Same as programming logic.

If Institution Assigned Student Identifier Switch is not “Y” or “N”

070

Student Identifier is blank or not left justified

Same as programming logic.

If Institution Assigned Switch is “Y” and Student Identifier is blank in first character position

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 (The only programs that may use "UNKN" are those programs that have TRIO Program Codes of "VUBN" or "EOPC" in the TRIO Institution table)

if the Year of Graduation is not numeric in all four character positions

If the Year of Graduation is numeric in all four character positions and the first 2 characters are not "19" or not "20"

256

The High School Code is not a recognized IRN

Same as programming logic.

If the High School Code is not in the IRN Code column of the ODE High School table for this year (from Header Record)

828

The First Generation Switch is not Y or N

Same as programming logic.

If First Generation Switch is not "Y" or "N"

829

The Low Income Switch is not Y or N

Same as programming logic.

If the Low Income switch is not "Y" or "N"

995

The TRIO Code is not in the TRIO Institution verification table

Same as programming logic.

If the TRIO Code is not in the TRIO verification table for this year (from Header Record)

996

This TRIO Code is not an allowable TRIO code for this user to enter.

Same as programming logic.

If the TRIO Code is not a TRIO code associated with the user identifier (from TRIO/User ID table)

998

Cannot Delete: This combination of Student Identifier, TRIO Code does not exist

Same as programming logic.

If the Delete Switch is “Y” and this combination of Student Identifier and TRIO Code from the submission does not exist in the TRIO Student table

C25

There is already a record in the TRIO Student table for this student, the input record will be ignored

Same as programming logic.

If the combination of TRIO Code and Student Identifier already exists in the TRIO Student table

Return to Enrollment Files

Last updated October 12, 2005