Spreadsheet: 0da5ff7d-0a1d-4448-948e-70ca1d97abff
Sheet: Page1_1

 |  |  | Colorado Department of Education |  |  | Page: 1
 |  |  | Business Rules
School Year: | 2013-14 | Dataset: | SBD ACCESS | File Type: | ACCESS SBD File
Data Element Name | Error/Warning Code | Error Type | Message | Status | Tier | Last Updated User | Last Updated Date
ABSENT_LISTENING_ACCESS | CS049 | Error | Absent Listening must be a valid code. | Active | 1
ABSENT_READING_ACCESS | CS051 | Error | Absent Reading must be a valid code. | Active | 1
ABSENT_SPEAKING_ACCESS | CS050 | Error | Absent Speaking must be a valid code. | Active | 1
ABSENT_WRITING_ACCESS | CS052 | Error | Absent Writing must be a valid code. | Active | 1
ASSESSMENT_TYPE_ACCESS | [NAME] | Error | Assessment Type must be unchanged from the vendor file for this Sequence Number. | Active | 1
BILINGUAL | CS018 | Error | Bilingual must be a valid code. | Active | 1
BILINGUAL | [NAME] | Error | Pupils cannot be enrolled in both Bilingual and ESL. | Active | 1
BILINGUAL | CS075 | Warning | Bilingual students coded as 2 (monitored [NAME]), 3, (monitored Y2) and 4 (exited Y3+) should not have been administered this assessment. | Active | 1
BIRTH_DATE_STUDENT | CS004 | Error | Birth Date must be a valid date. | Active | 1
CLUSTER_ACCESS | CS047 | Error | Cluster must be unchanged from the vendor file for this Sequence Number. | Active | 1
COLORADO_CONTINUOUSLY | CS022 | Error | Colorado Continuously must be a valid code. | Active | 1
COLORADO_CONTINUOUSLY | CS023 | Error | It is unlikely that more than 20% of your records for any grade in KG-3 should be marked as Colorado Continuously. This would indicate that more than 20% of students in that grade were retained. | Active | 1
CONTINUOUS_IN_DISTRICT | CS029 | Error | Continuous in School must be a valid code. | Active | 1
CONTINUOUS_IN_SCHOOL | CS030 | Error | Continuous in District must be a valid code. | Active | 1
CONTINUOUS_IN_SCHOOL | [NAME] | Error | For all grades except grade 11, if pupil has been enrolled in the school as of or before 3/12/12, then pupil has been enrolled in district as of or before 3/12/12.For grade 11, if pupil has been enrolled in the school as of or before 4/24/12, then pupil has been enrolled in district as of or before 4/24/12. | Active | 1
DECLINED_LISTENING_ACCESS | CS057 | Error | Declined Listening must be a valid code. | Active | 1 | [EMAIL] | 2014-03-06 13:35:29
DECLINED_READING_ACCESS | CS059 | Error | Declined Reading must be a valid code. | Active | 1 | [EMAIL] | 2014-03-06 13:38:54
DECLINED_SPEAKING_ACCESS | CS058 | Error | Declined Speaking must be a valid code. | Active | 1
DECLINED_WRITING_ACCESS | CS060 | Error | Declined Writing must be a valid code. | Active | 1
DISTRICT_CODE | CS002 | Error | District Code must be unchanged from the vendor file for this Sequence Number. | Active | 1
DISTRICT_NAME_ACCESS | [NAME] | Error | District Name must be unchanged from the vendor file for this Sequence Number | Active | 1
ESL_STATUS | CS020 | Error | ESL must be a valid code. | Active | 1
ESL_STATUS | CS076 | Warning | ESL students coded as 2 (monitored [NAME]), 3, (monitored Y2) and 4 (exited Y3+) should not have been administered this assessment. | Active | 1
ETHNICITY_ACCESS | CS007 | Error | Race must be a valid code. | Active | 1
EXEMPT_LISTENING_ACCESS | CS061 | Error | Exempted Listening must be a valid code. | Active | 1
EXEMPT_LISTENING_ACCESS | CS062 | Error | If Exempted Special Ed/504 – Listening = Y OR  Exempted Special Ed/504 – Speaking = Y  OR Exempted Special Ed/504 – Reading= Y OR  Exempted Special Ed/504 – Writing = Y    AND IEP = 0 | Active | 1
EXEMPT_READING_ACCESS | CS064 | Error | Exempted Reading must be a valid code. | Active | 1
EXEMPT_SPEAKING_ACCESS | CS063 | Error | Exempted Speaking must be a valid code. | Active | 1
EXEMPT_WRITING_ACCESS | CS065 | Error | Exempted Writing must be a valid code. | Active | 1
EXPELLED_EDUCATION | CS038 | Error | Expelled Education must be a valid code. | Active | 1
FIVE_ZERO_FOUR_ACCESS | CS033 | Error | Plan 504 must be a valid code. | Active | 1 | [EMAIL] | 2014-03-06 13:15:00
FREE_REDUCED_LUNCH | CS039 | Error | Free and Reduced Lunch Eligibility must be a valid code. | Active | 1
GENDER_ACCESS | CS005 | Error | Gender must be a valid code. | Active | 1 | [EMAIL] | 2014-03-06 13:30:35.999000
GIFTED_AND_TALENTED | CS036 | Error | Gifted and Talented must be a valid code. | Active | 1
GRADE_ACCESS | CS006 | Error | Grade must be unchanged from the vendor file for this Sequence Number. | Active | 1
GRADE_ACCESS | CS072 | Warning | Grade must match the official grade range for the school.  If you get this warning, call the Assessment SBD contact immediately. | Active | 1
GRADE_ACCESS | CS074 | Warning | It is unlikely the pupil has both an IEP and a 504 Plan. | Active | 1
HOMELESS_ACCESS | CS037 | Error | Homeless must be a valid code. | Active | 1
HOMELESS_ACCESS | CS041 | Error | Homeless Pupils are eligible for free lunch and should be marked as such. | Active | 1
IEP_ACCESS | CS073 | Warning | If a pupil is reported as not having an IEP, then they should not be reported as having disabilities. | Active | 1 | [EMAIL] | 2014-02-27 10:14:25
IEP_ACCESS | CS077 | Error | IEP must be a valid code. | Active | 1 | [EMAIL] | 2014-02-27 10:13:29
IMMIGRANT | CS035 | Error | Immigrant must be a valid code. | Active | 1
INVALID_LISTENING_ACCESS | CS053 | Error | [NAME] must be a valid code. | Active | 1
INVALID_READING_ACCESS | CS055 | Error | [NAME] must be a valid code. | Active | 1
INVALID_SPEAKING_ACCESS | CS054 | Error | [NAME] must be a valid code. | Active | 1
INVALID_WRITING_ACCESS | CS056 | Error | [NAME] must be a valid code. | Active | 1
LABEL_USED_ACCESS | CS066 | Error | Pre-Coded Label Used must be unchanged from the vendor file for this Sequence Number. | Active | 1
LANGUAGE_BACKGROUND | CS021 | Error | Pupils with Home Language other than English (eng) must be reported as Yes (1),  or Parent Choice (5) in either Bilingual or ESL Field | Active | 1
LANGUAGE_BACKGROUND | CS043 | Error | [NAME] must be a valid code. | Active | 1
LANGUAGE_BACKGROUND | CS044 | Error | Pupils taking the Access for ELLs must be reported as Non-English speaking. | Active | 1
LANGUAGE_PROFICIENCY | CS014 | Error | [NAME] must be a valid code. | Active | 1
LANGUAGE_PROFICIENCY | CS015 | Error | Non-English speaking students reported as NEP or LEP must be reported as being in a bilingual or ESL program, or they must have a code 5 in bilingual or ESL for not served in an ELL program due to parent choice. | Active | 1
LANGUAGE_PROFICIENCY | CS016 | Warning | Pupils reported as NEP or LEP cannot be reported as monitored or exited from an ESL Program. | Active | 1
LANGUAGE_PROFICIENCY | CS017 | Warning | Pupils reported as NEP or LEP cannot be reported as monitored or exited from a Bilingual Program. | Active | 1
MIGRANT_ACCESS | CS034 | Error | Migrant must be a valid code. | Active | 1
MIGRANT_ACCESS | CS040 | Error | Migrant Pupils are eligible for free lunch and should be marked as such. | Active | 1
OCTOBER_NEW_TO_SCHOOL | [NAME] | Error | Pupil cannot be new to the school as of Oct 1 AND Continuous in School | Active | 1
PRIMARY_DISABILITY | CS042 | Error | Primary Disability must be a valid code. | Active | 1
RACE_ASIAN_ACCESS | CS010 | Error | Race must be a valid code. | Active | 1
RACE_BLACK_ACCESS | CS011 | Error | Race must be a valid code. | Active | 1
RACE_HAWAIIAN_ACCESS | CS012 | Error | Race must be a valid code. | Active | 1
RACE_INDIAN_ACCESS | CS008 | Error | All 5 race fields cannot = 0 | Active | 1
RACE_INDIAN_ACCESS | CS009 | Error | Race must be a valid code. | Active | 1
RACE_WHITE_ACCESS | CS013 | Error | Race must be a valid code. | 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
SCHOOL_CODE | CS003 | Error | School Code must be unchanged from the vendor file for this Sequence Number. | Active | 1
SCHOOL_NAME_ACCESS | CS069 | Error | School Name must be unchanged from the vendor file for this Sequence Number | Active | 1
SEQUENCE_ACCESS | CS001 | Error | Only one record may be submitted per Sequence Number. | Active | 1
TIER_ACCESS | CS048 | Error | Tier must be unchanged from the vendor file for this Sequence Number. | Active | 1
VENDOR_NUMBER_ACCESS | CS070 | Error | Vendor Number must be unchanged from the vendor file for this Sequence Number. | Active | 1