OHIO BOARD OF REGENTS 

 

 

Edit and Load Specifications

Master's and Professional Student Tuition Awards (TA) file
Revised
December 26, 2002

 

 

Edit Rules for each Master's and Professional Student Tuition Awards (TA) record

 

A.

Read the record

B.

If Campus code is not in the Campus Code Column of the Institution/Campus Codes table or the Campus code is SSCC or CYCC              

 

Write Error 001 on edit report file

C.

If the Campus Code is in the Institution/Campus code verification table and does not relate to the Institution Code in the current login

 

Write Error 040 on edit report file

D.

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 year and term

 

Write Error 069 on edit report file

E.

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 a graduate Admission Area Code (Admissions Area Code of “GRD” or “PRO” or “NDG”) for any Year or Term

 

Write Error 824 on edit message report

F.

If this Student Identifier matches a Previous Identifier with Data Area code set to “S” for this institution in the Identifier Change table

 

Write Warning B19 on edit report file

G.

If the Delete Switch is “N” and there is a row in the Tuition Award table that matches the Student Identifier, Campus, Year of Award, and Term of Award in the submission and the submission does not contain a record with a matching Student Identifier, Campus, Year of Award, Term of Award, and a Delete Switch field value of “Y”

 

Write Warning B93 on edit report file

H.

If the Delete switch field value is Y and there is not a row in the Tuition Award table for this campus, year, student identifier, year of award and term of award

 

Write Error 821 on edit report file.

I.

If there are 2 or more records in submission file with the same campus, student identifier, year of award, term of award, explanation and delete switch field value of “Y” stop processing the record

 

Write Error 822 on edit report file.

J.

If there are 2 or more records in submission file with the same campus, student identifier, year of award, term of award and delete switch field value of “N”

 

Write Warning B94 on edit report file

K.

Run edits 011, 013, and 035

 

 

Report of Errors and Warnings

 

Edit Code

Edit Text

Display Field

001

The Campus Code is not in the Institution/Campus Codes table

 

011

Blank records are not allowed

Blank Records

013

The Delete Switch is not Y or N

Delete Switch

040

The Campus code in the input record does not correspond to the login Institution code

Campus Code/Institution Code from Login

069

This Student Identifier does not have a Student Entrance record

Student Identifier

820

The delete switch is N but there is already a row in the database for this student identifier, campus, year of award, and term of

Student Identifier/Campus

821

The delete switch is Y but there is no row in the database for this student, campus,  year of award, term of award

Student Identifier/Campus

822

There are 2 or more records with the same Student Identifier, Campus, Year of Award, Term of Award and Delete Switch

Student Identifier/Campus/Delete Switch

824

This Student Identifier does not have a graduate Student Entrance record

Student Identifier

B19

Student ID matches an ID that was formerly used to identify another student

Student Identifier

B93

The delete switch is N but there is already a row in the database for this student identifier, campus, year and term of award

Student ID/campus/year/term/delete switch

B94

There are 2 or more records in the submission file that match this student identifier, year of award, and term of award

Student Identifier

Return to Enrollment Files

http://regents.ohio.gov/hei/enrollment/taedit.html
Last updated December 26, 2002