Edit and Load Specifications: Degree/Certificate Earned (DC) File Revised September 9, 2005

Edit and Load Specifications

Degree/Certificate Earned (DC) File Revised September 9, 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)
035 There are non-blank characters beyond the allotted record length for this file Same as programming logic. If there are non-blank characters beyond 32 characters
001 The Campus Code is not in the Institution/Campus Codes table   If Campus Code does not exist in the Campus Code Column of the Institution/Campus code verification table or the Campus code is CYCC
040 The Campus code in the input record does not correspond to the login Institution code   If the Campus Code is in the Institution/Campus code verification table and does not relate to the Institution Code in the current login
069 This student does not have a Student Entrance record   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
C22 This student does not have a Student Enrollment record   If there is not a Student Enrollment 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
228 Year is not numeric in each character position   If Year is not numeric in each character position
225 Term is WI or SP but Year is not current year   If the Term is WI or SP and Year is numeric and is not equal to current year (from Header Record)
226 Term is AU but Year is not one less than current year   If the Term is AU and Year is numeric and is not one year less than current year (from Header Record)
229 Term is SM but Year is more than two years prior to the current year   If the Term is SM and the Year is numeric and is not the current year (from Header Record) or not one year less than the current year
A12 Term is SM but Year is not one less than current year   If the Term is SM and Year is numeric and Error 229 was not tripped and Year is not one year less than current year (from Header Record)
082 Term is not in Term verification table   If Term is not in Term verification table for this Year and Term
084 Level of Degree or Certificate Completed is not in the Level of Degree or Certificate Completed verification table   If Level of Degree or Certificate Completed is not in Level of Degree or Certificate Completed Codes verification table for this submission year
C17 Degree level indicates second major but a first major for this SSN and level is not found  

If Delete Switch is N

AND

Level of Degree or Certificate Completed is A1, A2, A3, A4, A5, A6, A7, A8 or A9

AND

there is not a record in this submission or a row in the DC table (for this year) that matches this Student ID and level accordingly:

01 = A1, 02 = A2, 03 = A3, 04 = A4, 05 = A5, 06 = A6 ,07 = A7 ,08 = A8 ,09 = A9

616 Academic Program Code is not in the Academic Program code column of the Academic Program table for this institution   If the Academic Program Code is not in the Academic Program code column of the Academic Program table for this institution
083 Combination of Field of Study and Campus is invalid  

If the subject code is not "TRAMOD"

AND

The combination of Field of Study (Subject Code) and Campus is not in the Course Level/Subject Code/Campus verification table for this year and term

(Do not write Error 083 if Degree Level = "01" or "A1" and the subject code is in the Alternative Subject Table for the year of this submission.)

227 Credit Hours to Degree is not numeric   If Credit Hours to Degree is not numeric in each character position
A50 Level of Degree or Certificate is 01 or 02 but Credit Hours to Degree is less than or equal to 20   If the Delete Switch is N  and the Level of Degree or Certificate is 01 and 02 and Credit Hours to Degree is numeric and less than or equal to 20
A51 Level of Degree or Certificate is 03, 04, or 07 but Credit Hours to Degree is less than or equal to 30   If the Delete Switch is N and the Level of Degree or Certificate is 03, 04, and 07 and Credit Hours to Degree is numeric and less than or equal to 30
A52 Level of Degree or Certificate is 05, 09, or 10 but Credit Hours to Degree is less than or equal to 60   If the Delete Switch is N and the Level of Degree or Certificate is 05, 09, and 10 and Credit Hours to Degree is numeric and less than or equal to 60
A53 Level of Degree or Certificate is 06 but Credit Hours to Degree is less than or equal to 18   If the Delete Switch is N and the Level of Degree or Certificate is 06 and Credit Hours to Degree is numeric and less than or equal to 18
A54 Level of Degree or Certificate is 08 but Credit Hours to Degree is less than or equal to 24   If the Delete Switch is N, Level of Degree or Certificate is 08 and Credit Hours to Degree is numeric and less than or equal to 24
A55 Credit Hours to Degree is greater than or equal to 300   If the Delete Switch in the input record is N and the Term Type Code from Academic Calendar table for this Institution is Q (on quarter calendar) and Credit Hours to Degree is numeric and greater than or equal to 300
A56 Credit Hours to Degree is greater than or equal to 200   If the Delete Switch in the input record is N, Term Type Code from Academic Calendar table for this Institution is S (on semester calendar) and Credit Hours to Degree is numeric and greater than or equal to 200
013 The Delete Switch is not Y or N   If Degree/Certificate Delete Switch is Not Y or N
A17 Degree/Certificate Completed table entry already exists for this record  

If Degree/Certificate Delete Switch is N and there is already a Degree/Certificate Completed table entry for this OBRID (from Institution/SSN table), Campus, Fiscal Year, Field of Study, Credit Hours to Degree, and Level of Degree or Certificate Completed

AND

There is not another matching record with Delete Switch set to Y

A16 Duplicate Degree/Certificate Completed record already exists in this file submission   If there is another matching record in this submission for this Student ID, Campus, Field of Study, Credit Hours to Degree, Level of Degree or Certificate Completed, and Delete Switch
087 Degree/Certificate Completed entry does not exist for this record   If Degree/Certificate Delete Switch is Y and there is not already an entry in the Degree/Certificate Completed table for this OBRID, Campus, Year, Term, Level of Degree or Certificate Completed, Field of Study, Credit Hours to Degree
A57 Two or more degrees will have been awarded to this student during this year and term  

If Degree/Certificate Delete Switch is N and there is already a Degree/Certificate Completed table entry for this OBRID, and Fiscal Year and Term

OR

If Degree/Certificate Delete Switch is N and there is another matching entry in this submission for this Student Identifier and same Term

AND

As a result of loading this submission there would be two or more rows on the table

A58 Three or more degrees will have been awarded to this student during this fiscal year  

If Degree/Certificate Delete Switch is N and, if loaded, there would be three or more rows or records for this Student Identifier at this Institution in the Degree/Certificate table or in this submission for this Fiscal Year

AND

As a result of loading this submission there would be three or more rows on the table

247 The Degree Level for this student identifier is inappropriate for the Admission Area of the student reported in the SE  

If the "Level of Degree or Certificate Completed" in the submission record is valid and the combination of "Level of Degree or Certificate Completed" and the Admission Area for this student identifier in the Student Entrance is not in the Admission Area/Degree Certificate Level table for the year in the header record

If more than one Admission Area exists for this student at this institution, check the combination of each Admission Area (SE) and Degree Level (DC) against the Admission Area/Degree Certificate Level table. If one of those combinations match the table, then do not write Error 247.

If the academic program and campus code matches the table Academic Program Degree Cert Exception table, do not write Error 247.

Note: Combination of GRD/10 in the Admission Area/Degree Certificate Level verification table is valid only if the Field of Study is 512001 or 512099

B19 Student ID matches an ID that was formerly used to identify another student   If this Student Identifier matches a Previous Identifier with Data Area code set to “S” for this institution in the Identifier Change table
437 Field of Study is for Short Term Certificates Only: This Degree Level is Invalid for Short Term Certificates  

If Error 083 was not triggered and if campus is valid per edit D

AND

Degree level <> “01” and <> "A1" and the Field of Study matches a value in the DC Subject Code column in the Alternative Subject table for a Year equal to the submission year

C33 Level of Degree or Certificate is WI but Credit Hours to Degree is greater than 45   If the Delete Switch is N and the Level of Degree Certificate is WI and Credit Hours to Degree is numeric and greater than 45