OHIO BOARD OF REGENTS

Edit and Load Specifications

Cross Registration (XR) File

Revised September 15, 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)

002

Course Identifier is blank or not left justified

Same as programming logic.

If the Course Identifier is blank in the first character position

013

The Delete Switch is not Y or N

Same as programming logic.

If Delete Switch is not Y or N

056

There is no record of this student in the Student Enrollment table for this year and term

Same as programming logic.

If the Student Identifier does exist in the Student Entrance table for this institution and there is not an entry for this OBRID (from Institution/SSN table), for this Institution, Year, and Term in the Student Enrollment table

068

Credit Hours is not numeric

Same as programming logic.

If Credit Hours is not numeric

069

This student 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

073

Audit Switch is not Y or N

Same as programming logic.

If Audit Switch is not Y or N

095

Sending or Host Institution is not in IPEDS Institution or IPEDS Institution Exception verification tables

Same as programming logic.

If Host Institution does not match IPEDS code from IPEDS Institution or IPEDS Institution Exception verification tables

139

Record already exists for this Student ID, Course ID, Credit Hours, Host Institution, Year and Term in XR table

Same as programming logic.

If Delete Switch is N and there is already a matching row in the Cross Registration table for this Institution, OBRID (from Institution/SSN table), Course Identifier, Host Institution, Year, and Term

AND

there is not another record in this submission that matches this Student Identifier, Course Identifier, and Host Institution with Delete Switch set to Y

140

Record already exists for this Student ID, Course ID, Credit Hours, Host Institution, Year and Term in this submission

Same as programming logic.

If Delete Switch is N and there is already a matching row in this Cross Registration submission for this Student Identifier, Course Identifier, Host Institution, Year and Term with Delete Switch set to N

if Delete Switch is Y and there is already a matching row in the Cross Registration submission for this Student Identifier, Course Identifier, Credit Hours, Host Institution, Audit Switch, Year and Term with Delete Switch set to Y

142

Delete Switch is Y and there is not a matching record in the XR table

Same as programming logic.

If Delete Switch is Y and there is not a matching row in the Cross Registration table for this Institution, OBRID (from Institution/SSN table), Course Identifier, Credit Hours, Host Institution, Audit Switch, Year and Term

223

Cross Registration record has non-blank characters beyond 32 characters

Same as programming logic.

If there are any non-blank characters beyond 32 characters

234

Host Institution and Reporting Institution are same

Same as programming logic.

If Host Institution (IPEDS) Code matches the code of the Institution in the Header Record (compare from the Institution/Campus table)

A46

Host Institution is an Ohio public institution but the Course Identifier does not match a Course Identifier at that institution

Same as programming logic.

If Host Institution is an Ohio public college or university (Institution/Campus table) and Course Identifier is not XXXXXXXXXXXX and does not match a Course Identifier in the most recent version (not necessarily this year and term) of the Course Inventory table for the Host Institution

A47

Credit Hours are greater than 24 and Host Institution is FXCHNG or FOREGN

Same as programming logic.

If Host Institution is FXCHNG or FOREGN and Credit Hours is numeric and greater than 24

A48

Credit Hours are greater than 6

Same as programming logic.

If Host Institution is not FXCHNG and FOREGN and Credit Hours is greater than 6

A49

Enrollments from FOREGN or Ohio non-public institutions will not be subsidized

Same as programming logic.

If Host Institution is a valid IPEDS code from IPEDS Institution verification table

AND

is not in the Institution/Campus table

is in the Institution/Campus table but Type of Campus code is IN

if Host Institution is FOREGN

B19

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

Same as programming logic.

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

B28

*** WARNING B28: The sum of credit hours for this HOST INSTITUTION has changed more than 20% from the same term last year.

Same as programming logic.

If there is any sum varying 20% or more, sum totaling greater than or equal to 50, with the same sum generated from final data for the same TERM in the immediately preceding YEAR

Return to Enrollment Files

http://www.regents.state.oh.us/hei/enrollment/xredit.html
Last updated September 15, 2005