Spreadsheet: bbc5ec95-7842-4e45-b84b-cd4e1404328c
Sheet: Page1_1

 |  |  | Colorado Department of Education |  |  | Page: 1
 |  |  | Business Rules
School Year: | 2013-14 | Dataset: | Student Profile | File Type: | Advanced Course Completion
Data Element Name | Error/Warning Code | Error Type | Message | Status | Tier | Last Updated User | Last Updated Date
ADVANCE_PLACEMENT_COURSE_1 | SP238 | Error | AP Course 2 must = 00 or be blank where AP Course 1 = 00 or is blank. | Active | 1
ADVANCE_PLACEMENT_COURSE_1 | SP239 | Error | Advanced Placement Course 1 must contain a valid AP Course code. | Active | 1
ADVANCE_PLACEMENT_COURSE_10 | SP248 | Error | Advanced Placement Course 10 must contain a valid AP Course code. | Active | 1
ADVANCE_PLACEMENT_COURSE_2 | SP240 | Error | Advanced Placement Course 2 must contain a valid AP Course code. | Active | 1
ADVANCE_PLACEMENT_COURSE_3 | SP241 | Error | Advanced Placement Course 3 must contain a valid AP Course code. | Active | 1
ADVANCE_PLACEMENT_COURSE_4 | SP242 | Error | Advanced Placement Course 4 must contain a valid AP Course code. | Active | 1
ADVANCE_PLACEMENT_COURSE_5 | SP243 | Error | Advanced Placement Course 5 must contain a valid AP Course code. | Active | 1
ADVANCE_PLACEMENT_COURSE_6 | SP244 | Error | Advanced Placement Course 6 must contain a valid AP Course code. | Active | 1
ADVANCE_PLACEMENT_COURSE_7 | SP245 | Error | Advanced Placement Course 7 must contain a valid AP Course code. | Active | 1
ADVANCE_PLACEMENT_COURSE_8 | SP246 | Error | Advanced Placement Course 8 must contain a valid AP Course code. | Active | 1
ADVANCE_PLACEMENT_COURSE_9 | SP247 | Error | Advanced Placement Course 9 must contain a valid AP Course code. | Active | 1
BIRTH_DATE_STUDENT | SP372 | Error | [NAME] is mandatory | Active | 1
DISTRICT_CODE | SP1 | Error | District number must be valid | Active | 1
DISTRICT_CODE | SP69 | Error | If post secondary is 1 then district must be a valid district from the list of districts providing this program | Active | 1
FIRST_NAME_STUDENT | SP234 | Error | FIRST NAME may contain only characters A-Z, blank, apostrophe, hyphen, comma and period. | Active | 1
FIRST_NAME_STUDENT | SP358 | Error | First name is mandatory | Active | 1
GENDER_STUDENT | SP362 | Error | Gender must be a valid code | Active | 1
LAST_NAME_STUDENT | SP235 | Error | LAST NAME may contain only characters A-Z, blank, apostrophe, hyphen, comma and period. | Active | 1
LAST_NAME_STUDENT | SP360 | Error | Last Name is mandatory | Active | 1
POST_SECONDARY_INSTITUTION_1 | SP250 | Error | 1st Semester A Institution Code must be a valid code. | Active | 1
POST_SECONDARY_INSTITUTION_2 | SP252 | Error | 1st Semester B Institution Code must be a valid code. | Active | 1
POST_SECONDARY_INSTITUTION_3 | SP254 | Error | 2nd Semester A Institution Code must be a valid code. | Active | 1
POST_SECONDARY_INSTITUTION_4 | SP256 | Error | 2nd Semester B Institution Code must be a valid code. | Active | 1
POST_SECONDARY_PROGRAM_1 | SP249 | Error | 1st Semester A Postsecondary Participation must be a valid code. | Active | 1
POST_SECONDARY_PROGRAM_1 | SP285 | Error | 1st Semester A Institution Code must = 0000 where 1st Semester A Other Postsecondary Participation = 0 | Active | 1
POST_SECONDARY_PROGRAM_1 | SP286 | Error | 1st Semester A Institution Code cannot be 0000 if 1st Semester A Other Postsecondary Participation is 1, 2, or 8 | Active | 1
POST_SECONDARY_PROGRAM_2 | SP251 | Error | 1st Semester B Postsecondary Participation must be a valid code. | Active | 1
POST_SECONDARY_PROGRAM_2 | SP287 | Error | 1st Semester B Institution Code must = 0000 where 1st Semester B Other Postsecondary Participation = 0 | Active | 1
POST_SECONDARY_PROGRAM_2 | SP288 | Error | 1st Semester B Institution Code cannot be 0000 if 1st Semester B Other Postsecondary Participation is 1, 2, or 8 | Active | 1
POST_SECONDARY_PROGRAM_3 | SP253 | Error | 2nd Semester A Postsecondary Participation must be a valid code. | Active | 1
POST_SECONDARY_PROGRAM_3 | SP289 | Error | 2nd Semester A Institution Code must = 0000 where 2nd Semester A Other Postsecondary Participation = 0 | Active | 1
POST_SECONDARY_PROGRAM_3 | SP290 | Error | 2nd Semester A Institution Code cannot be 0000 if 2nd Semester A Other Postsecondary Participation is 1, 2, or 8 | Active | 1
POST_SECONDARY_PROGRAM_4 | SP255 | Error | 2nd Semester B Postsecondary Participation must be a valid code. | Active | 1
POST_SECONDARY_PROGRAM_4 | SP291 | Error | 2nd Semester B Institution Code must = 0000 where 2nd Semester B Other Postsecondary Participation = 0 | Active | 1
POST_SECONDARY_PROGRAM_4 | SP292 | Error | 2nd Semester B Institution Code cannot be 0000 if 2nd Semester B Other Postsecondary Participation is 1, 2, or 8 | Active | 1
SASID | 99999 | Error | The SASID is invalid or name, birth date, or gender doesnt match whats in the RITS system for the entered SASID | Active | 1
SASID | SP366 | Error | SASID is mandatory | Active | 1
SASID | SP367 | Error | SASID must be numeric | Active | 1
SASID | SP368 | Error | SASID must be 10 digits long | Active | 1
SASID | SP381 | Error | There is not a matching student record in the Student School Association file.  Please upload a corresponding record to the 'Student School Association' file | Active | 1
SASID | SP386 | Error | District, School Code, SASID, school year combination must be unique in the ACC file.  Raise error if there are duplicate records. | Active | 1
SCHOOL_CODE | SP380 | Error | School Code does not contain a valid code | Active | 1
SCHOOL_CODE | SP68 | Error | If post secondary is 7 then school code must be 2217, 8132, 0212, 1795 or 2837 | Active | 1