Edit and Load Specifications

A.

Read the record

B.

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

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 the Course Identifier is blank in the first character position

Write Error 002 on edit report file

E.

If the Course Identifier is not blank in the first character position and is not in the Course Inventory table for this institution and this Year and Term

Write Error 071 on edit report file

F.

If the Section Identifier is blank in the first character position

Write Error 182 on edit report file

G.

If the Section Identifier is not blank in the first character position and does not match a combination of Course Identifier and Section Identifier in the Course Section table for this year and term and campus

Write Error 144 on edit report file

H.

If Campus Type (from Institution History table) is not UB

Write Error 202 on edit report file

I.

If Course Level (from Course Inventory) is not B, M, or D

Write Error 203 on edit report file

J.

If Course Section Location field of Course Section table is filled for this Course Identifier and Section Identifier, campus, year and term

Write Error 204 on edit report file

K.

If Course Level (from Course Inventory) is B and the sum of Credit Hours (from Course Enrollment) for Student Ranks FR, SO, and NU (from Student Enrollment) is greater than or equal to 60% of the sum of the total credit hours (from Course Enrollment) for this Course Identifier, campus, year and term

Write Warning A59 on edit report file

L.

If the Delete Switch is not Y or N

Write Error 013 on edit report file

M.

If Resident Credit Center Course Section Delete Switch is Y and there is not a Course Section table entry for this Campus, Year, Term, Course Identifier, Section Identifier, and Resident Credit Center Switch set to Y

Write Error 207 on edit report file

N.

If there is already a record matching this Campus, Course Identifier, Section Identifier, and Delete Switch in this submission file

Write Error 206 on edit report file

O.

If Resident Credit Center Course Section Delete Switch is N and there is a Course Section table entry for this Campus, Year, Term, Course Identifier, Section Identifier, and Resident Credit Center Course Section Switch is set to Y

Write Error 208 on edit report file

P.

General Edits 011, 035, 018

Add 1 to record count

Edit Code

Edit Text

Display Field

001

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

Campus Code

002

Course Identifier is blank or not left justified

Course Identifier

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

071

Course Identifier does not match a course in the Course Inventory table

Course Identifier

144

Section Identifier must match a Section Identifier for this Course in the Course Enrollment table

Course Identifier/Section Identifier

182

Section Identifier is blank or not left justified.

Course Identifier/Section Identifier

202

This campus is not a regional campus of a university and cannot be a Resident Credit Center Course Section

Campus

203

Course Level is not B (Baccalaureate), M (Masters), or D (Doctoral)

Course Level

204

Resident Credit Center Course Section cannot be Off-campus

Course ID/Section ID/Location Code (Course Section table)

206

There is already a matching record for this Campus, Course Identifier, Section Identifier, and Delete Switch in this submission

Campus/Course ID/Section ID/Delete Switch

207

There is not a matching Resident Credit Center Course Section to be deleted in the Course Section table for this year and term

Course ID/Section ID/Delete Switch

208

There is already a Resident Credit Center Course Section for this location code in the Course Section table for this year and term

Course ID/Section ID

A59

Course Level is B, but Freshmen and Sophomores are more than 60% of total enrollments in this course section

<<% of Credit Hours from Freshmen and Sophomores>>

B34

*** WARNING B34: The number of course sections for this COURSE LEVEL and CAMPUS has changed more than 20% from the same term last year