Spreadsheet: 4fa03369-0efb-480a-a114-6f0c3684db60
Sheet: Page1_1

 |  |  | Colorado Department of Education |  |  | Page: 1
 |  |  | Business Rules Last Updated: 11/19/13
School Year: | 2013-14 | Dataset: | Student Profile | File Type: | Student
Data Element Name | Error/Warning Code | Error Type | Message | Status | Tier | Last Updated User | Last Updated Date
ADDRESS_CITY_STUDENT | SP342 | Error | City must contain valid characters (a-z, A-Z, -, .) | Active | 1
ADDRESS_STATE_STUDENT | SP343 | Error | Student State must be a valid state code. | Active | 1 | [EMAIL] | 2013-08-24 11:12:53.999000
ADDRESS_STUDENT | SP341 | Error | Student Address valid characters are (a-z, A-Z, 0-9, ' ', '-', '.', ''', '/') | Active | 1
ADDRESS_ZIP_STUDENT | SP344 | Error | Student Zip Code valid characters are (0-9) | Active | 1
ATTENDS_GED_PROGRAM | SP49 | Error | Attends GED Program does not contain a valid code. | Active | 1
BILINGUAL | SP152 | Error | English Speaking students can only have a Bilingual code of 0. | Active | 1
BILINGUAL | [NAME] | Error | Non-English speaking student cannot be enrolled in both a Bilingual and an ESL program. | Active | 1 | [EMAIL] | 2013-09-09 13:39:54
BILINGUAL | SP158 | Error | If a student is coded as NEP or LEP then Bilingual or ESL must be 1 or 5. | Active | 1 | [EMAIL] | 2013-10-14 09:33:39
BILINGUAL | SP161 | Error | If language proficiency is PHLOTE or FELL then student cannot be in ELL (ESL or bilingual) program | Active | 1 | [EMAIL] | 2013-09-09 10:41:55.999000
BILINGUAL | SP163 | Error | If [NAME] is either 1 or 2 then the ESL or Bilingual code must be either 1 or 5. | Active | 1 | [EMAIL] | 2013-09-09 11:04:20.999000
BILINGUAL | SP167 | Error | Student was identified as ELL prior year and this year they are coded as Not applicable | Active | 1 | [EMAIL] | 2013-09-30 17:07:29.999000
BILINGUAL | SP176 | Warning | The following students have been exited from a Bilingual program. | Active | 1
BILINGUAL | SP179 | Warning | Students usually do not switch from a Bilingual program to a ESL program from one year to the next. | Active | 1
BILINGUAL | SP195 | Error | Student does not follow logical sequence for ELL. Last year they were marked as Exited Bilingual Program and this year they are marked as Not Applicable. | Active | 1
BILINGUAL | SP298 | Warning | WARNING - If Bilingual = 1 and prior year ESL = 0 and prior year Bilingual = 0, or prior year ESL = 4 and prior year Bilingual = 0, or prior year ESL = 0 and prior year Bilingual = 4. | Active | 1
BILINGUAL | SP299 | Warning | WARNING - If Bilingual = 2 and prior year ESL = 0,2,3,4 and prior year Bilingual = 0,2,3,4. | Active | 1
BILINGUAL | SP300 | Warning | WARNING - If Bilingual = 3 and prior year ESL = 0,1,3,4 and prior year Bilingual = 0,1,3,4. | Active | 1
BILINGUAL | SP301 | Warning | WARNING - If Bilingual = 4 and prior year ESL = 0,1,2,4 and prior year Bilingual = 0,1,2. | Active | 1
BILINGUAL | SP43 | Error | Bilingual does not contain a valid code. | Active | 1
BIRTH_DATE_STUDENT | SP10 | Error | Birth Date must be a valid date in MMDDYYYY format | Active | 1
BIRTH_DATE_STUDENT | SP9 | Error | [NAME] is mandatory unless student is homeschooled. | Active | 1
COALT_ASSESSMENT_PARTICIPANT | SP100 | Error | If CSAP_A = '1' then Primary Disability must be reported. | Active | 1
COALT_ASSESSMENT_PARTICIPANT | SP39 | Error | CSAPA does not contain a valid code. | Active | 1
DISTRICT_CODE | SP1 | Error | District Number is invalid | Active | 1
EMAIL_STUDENT | SP347 | Error | Student Email must be an email address with one "@" and at least one period. | Active | 1
ESL_STATUS | SP153 | Error | English speaking students must not be coded as being served in an ESL program. | Active | 1
ESL_STATUS | [NAME] | Error | Non-English speaking student cannot be enrolled in both a Bilingual and an ESL program. | Active | 1 | [EMAIL] | 2013-09-09 13:45:41
ESL_STATUS | [NAME] | Error | If ESL  NOT '0', then Language Proficiency must NOT be 0. | Active | 1
ESL_STATUS | SP159 | Error | If a student is coded as NEP or LEP then Bilingual or ESL must be 1 or 5. | Active | 1 | [EMAIL] | 2013-10-14 09:33:24.999000
ESL_STATUS | SP164 | Error | If [NAME] is either 1 or 2 then the ESL or Bilingual code must be either 1 or 5. | Active | 1 | [EMAIL] | 2013-09-09 11:49:57.999000
ESL_STATUS | SP166 | Error | Student was identified as ELL prior year and this year they are coded as Not applicable | Active | 1
ESL_STATUS | SP177 | Warning | The following students have been exited from an ESL program. | Active | 1
ESL_STATUS | SP178 | Warning | Students usually do not switch from a ESL program to a Bilingual program from one year to the next. | Active | 1
ESL_STATUS | SP180 | Warning | Student does not follow logical sequence for ELL. Last year they were marked as being in an ELL program and this year they are marked as Not Applicable. | Active | 1
ESL_STATUS | [NAME] | Warning | Student does not follow logical sequence for ELL. Last year they were marked as being in an ELL program and this year they are marked as Not Applicable. | Active | 1
ESL_STATUS | SP182 | Error | Student does not follow logical sequence for ELL. Last year they were marked as ELL Program and this year they are marked as Redesignated ESL Program (Monitored Year 2). | Active | 1
ESL_STATUS | SP183 | Error | Student does not follow logical sequence for ELL. Last year they were marked as ELL Program and this year they are marked as Redesignated ESL Program (Monitored Year 2). | Active | 1
ESL_STATUS | SP184 | Error | Student does not follow logical sequence for ELL. Last year they were marked as ELL Program and this year they are marked as Exited ELL Program. | Active | 1
ESL_STATUS | SP185 | Error | Student does not follow logical sequence for ELL. Last year they were marked as ELL Program and this year they are marked as Exited ELL Program. | Active | 1
ESL_STATUS | SP186 | Error | Student does not follow logical sequence for ELL. Last year they were marked as Redesignated ELL Program (Monitored Year 1) and this year they are marked as Not Applicable. | Active | 1
ESL_STATUS | SP187 | Error | Student does not follow logical sequence for ELL. Last year they were marked as Redesignated ELL Program (Monitored Year 1) and this year they are marked as Not Applicable. | Active | 1
ESL_STATUS | SP188 | Error | Student does not follow logical sequence for ELL. Last year they were marked as Redesignated ELL Program (Monitored Year 1) and this year they are marked as Exited ELL Program. | Active | 1
ESL_STATUS | SP189 | Error | Student does not follow logical sequence for ELL. Last year they were marked as Redesignated ELL Program (Monitored Year 1) and this year they are marked as Exited ELL Program. | Active | 1
ESL_STATUS | SP190 | Error | Student does not follow logical sequence for ELL. Last year they were marked as Redesignated ELL Program (Monitored Year 2) and this year they are marked as Not Applicable. | Active | 1
ESL_STATUS | SP191 | Error | Student does not follow logical sequence for ELL. Last year they were marked as Redesignated ELL Program (Monitored Year 2) and this year they are marked as Not Applicable. | Active | 1
ESL_STATUS | SP192 | Error | Student does not follow logical sequence for ELL. Last year they were marked as Redesignated ELL Program (Monitored Year 2) and this year they are marked as Redesignated ESL Program (Monitored Year 1) | Active | 1
ESL_STATUS | SP193 | Error | Student does not follow logical sequence for ELL. Last year they were marked as Redesignated ELL Program (Monitored Year 2) and this year they are marked as Redesignated ESL Program (Monitored Year 1) | Active | 1
ESL_STATUS | [NAME] | Error | Student does not follow logical sequence for ELL. Last year they were marked as Exited ELL Program and this year they are marked as Not Applicable. | Active | 1
ESL_STATUS | SP196 | Error | Student does not follow logical sequence for ELL. Last year they were marked as Exited ELL Program and this year they are marked as Redesignated ELL Program (Monitored Year 1). | Active | 1
ESL_STATUS | SP197 | Error | Student does not follow logical sequence for ELL. Last year they were marked as Exited ELL Program and this year they are marked as Redesignated ELL Program (Monitored Year 1). | Active | 1
ESL_STATUS | SP198 | Error | Student does not follow logical sequence for ELL. Last year they were marked as Exited ELL Program and this year they are marked as Redesignated ELL Program (Monitored Year 2). | Active | 1
ESL_STATUS | SP199 | Error | Student does not follow logical sequence for ELL. Last year they were marked as Exited ELL Program and this year they are marked as Redesignated ELL Program (Monitored Year 2). | Active | 1
ESL_STATUS | SP294 | Warning | WARNING - If ESL = 1 and prior year ESL = 0 and prior year Bilingual = 0, or prior year ESL = 4 and prior year Bilingual = 0, or prior year ESL = 0 and prior year Bilingual = 4. | Active | 1
ESL_STATUS | SP295 | Warning | WARNING - If ESL = 2 and prior year ESL = 0,2,3,4 and prior year Bilingual = 0,2,3,4. | Active | 1
ESL_STATUS | [NAME] | Warning | WARNING - If ESL = 3 and prior year ESL = 0,1,3,4 and prior year Bilingual = 0,1,3,4. | Active | 1
ESL_STATUS | SP297 | Warning | WARNING - If ESL = 4 and prior year ESL = 0,1,2 and prior year Bilingual = 0,1,2,4. | Active | 1
ESL_STATUS | SP44 | Error | ESL does not contain a valid code. | Active | 1
ETHNICITY_STUDENT | SP13 | Error | Ethnicity: Hispanic or Latino is invalid.  It must = 1 (yes - Hispanic) or 0 (no - not Hispanic). No other coding options are valid for this field. | Active | 1
FIRST_NAME_STUDENT | SP234 | Error | FIRST NAME may contain only characters A-Z, 0-9, blank, apostrophe, hyphen, comma and period. | Active | 1
FIRST_NAME_STUDENT | SP357 | Error | STUDENT FIRST NAME is a required field. | Active | 1
FREE_REDUCED_LUNCH | SP30 | Error | Free/Reduced Lunch Eligible does not contain a valid code. | Active | 1
FREE_REDUCED_LUNCH | SP90 | Error | If Migrant = 1 then FREE REDUCED LUNCH must be 01. Verifications of a students migrant status substantiates eligibility for free meal benefits under National School Lunch and School Breakfast Programs | Active | 1
GENDER_STUDENT | SP22 | Error | Gender does not contain a valid code. | Active | 1
HOMELESS | SP102 | Error | If HOMELESS is 3 or 4 then FREE REDUCED LUNCH must be 01. | Active | 1
HOMELESS | SP36 | Error | Homeless does not contain a valid code. | Active | 1
IMMIGRANT | SP35 | Error | Immigrant does not contain a valid code. | Active | 1
LANGUAGE_BACKGROUND | SP160 | Error | Pupils reported as being monitored or exited from a Bilingual Program must be reported as FEP.  Pupils who were never an English Language Learner must NOT be reported as exited. | Active | 1
LANGUAGE_BACKGROUND | SP20 | Error | [NAME] does not contain a valid code. | Active | 1
LANGUAGE_PROFICIENCY | SP151 | Error | English speaking students must have a Language Proficiency code of 0. | Active | 1 | [EMAIL] | 2013-10-25 05:27:15
LANGUAGE_PROFICIENCY | SP154 | Error | If language background is not English, then Language Proficiency must be provided and not zero-filled. | Active | 1
LANGUAGE_PROFICIENCY | SP171 | Error | Pupils reported as being in an ELL (Bilingal or ESL) program or as parent refusal of program services should not be reported as FEP. Code NEP or LEP. | Inactive | 1 | [EMAIL] | 2013-09-01 08:47:25.999000
LANGUAGE_PROFICIENCY | SP352 | Warning | [NAME] cannot be coded as English if student is coded as PHLOTE or FELL. | Active | 1
LANGUAGE_PROFICIENCY | SP353 | Warning | If language proficiency is PHLOTE or FELL, then the student cannot be in an ESL program | Active | 1 | [EMAIL] | 2013-09-10 16:09:56.999000
LANGUAGE_PROFICIENCY | SP354 | Warning | If language proficiency is PHLOTE or FELL then student cannot be in ELL (ESL or bilingual) program | Active | 1
LANGUAGE_PROFICIENCY | SP355 | Error | If language proficiency is set to NEP, LEP, or FEP then must be in ELL program (ESL or Bilingual) | Active | 1
LANGUAGE_PROFICIENCY | SP383 | Warning | If language proficiency = 4(PHLOTE) then prior year language proficiency must be = 0 or 4 | Active | 1
LANGUAGE_PROFICIENCY | SP384 | Error | If Lang Prof = 5 (FELL) and student is in grade 006-120, then prior year Language Proficiency must = 1, 2 or 3 from a different district or Language Proficiency must be 5 from any district. | Active | 1
LANGUAGE_PROFICIENCY | SP385 | Warning | Prior year Lang Prof = 1, 2, or 3 in a different district; please consider coding this student with Lang Prof = 5 (FELL) | Active | 1 | [EMAIL] | 2013-09-11 09:09:35
LANGUAGE_PROFICIENCY | SP400 | Error | If language proficiency = [NAME] (3), then ESL or Bilingual must be Monitored or Exited (2,3, or 4) | Active | 1 | [EMAIL] | 2013-11-04 12:49:18
LANGUAGE_PROFICIENCY | SP42 | Error | [NAME] does not contain a valid code. | Active | 1
LANGUAGE_PROFICIENCY | SP88 | Error | Based on the results of the ACCESS for ELLs exam this student must be coded with a language proficiency of 1, 2, or 3. | Active | 1
[NAME] | SP2 | Error | [NAME] is mandatory | Active | 1
[NAME] | SP3 | Error | [NAME] must be 10 digits unless reported by a facility. | Active | 1
[NAME] | SP4 | Error | [NAME] must be numeric | Active | 1
LAST_NAME_STUDENT | SP235 | Error | LAST NAME may contain only characters A-Z, 0-9, blank, apostrophe, hyphen, comma and period. | Active | 1
LAST_NAME_STUDENT | SP359 | Error | STUDENT LAST NAME is required. | Active | 1
MIDDLE_NAME_STUDENT | [NAME] | Error | MIDDLE NAME may contain only characters A-Z, 0-9, apostrophe, hyphen, comma and period. | Active | 1
MIGRANT | SP34 | Error | Migrant does not contain a valid code. | Active | 1
PRIMARY_DISABILITY | SP46 | Error | Primary Disability does not contain a valid code. | Active | 1
PRIMARY_NIGHTTIME_RESIDENCE | SP48 | Error | Primary [NAME] does not contain a valid code. | Active | 1
PRIMARY_NIGHTTIME_RESIDENCE | SP84 | Error | If [NAME] RESIDENCE = '00' then HOMELESS must be '0'. | Active | 1
PRIMARY_NIGHTTIME_RESIDENCE | SP85 | Error | If [NAME] is not '00' then HOMELESS must not be 0. | Active | 1
RACE_ASIAN_STUDENT | SP15 | Error | [NAME] is invalid.  It must = 1 (yes - Asian) or 0 (no - not Asian).  No other coding options are valid for this field. | Active | 1
RACE_BLACK_STUDENT | SP16 | Error | Race Black or African American is invalid.  It must = 1 (yes - Black) or 0 (no - not Black).  No other coding options are valid for this field. | Active | 1
RACE_HAWAIIAN_STUDENT | SP18 | Error | [NAME] or other Pacific Islander is invalid.  It must = 1 (yes - Native Hawaiian or other Pacific Islander) or 0 (no - not Native Hawaiian or other Pacific Islander).  No other coding op | Active | 1
RACE_INDIAN_STUDENT | SP14 | Error | Race American Indian is invalid.  It must = 1 (yes - American Indian) or 0 (no - not American Indian).  No other coding options are valid for this field. | Active | 1
RACE_WHITE_STUDENT | SP17 | Error | [NAME] is invalid.  It must = 1 (yes - White) or 0 (no - not White).  No other coding options are valid for this field. | Active | 1
RACE_WHITE_STUDENT | SP66 | Error | The five race fields (Race: American Indian, Race: Asian, Race:Black, Race:White, and Race:Native Hawaiian) cannot all = 00 (no).  At least one race category must not equal 00 UNLESS Attendance/Reside | Active | 1
REFUGEE | SP52 | Error | Refugee does not contain a valid code. | Active | 1
REGISTERED_HOMESCHOOLED | SP348 | Error | Registered Homeschooled is mandatory and must be a valid code | Inactive | 1 | [EMAIL] | 2013-08-26 08:59:19
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 | SP149 | Error | SASID duplicates not allowed. | Active | 1
SASID | SP5 | Error | SASID is required for non-homescholled students | Active | 1
SASID | SP6 | Error | SASID must be numeric | Active | 1
SASID | SP7 | Error | SASID must be 10 digits | Active | 1
SASID | SP8 | Error | Record must contain a valid SASID | Active | 1
SECTION_504 | SP175 | Warning | It is unlikely the pupil has both an IEP and a 504 Plan. | Active | 1
SECTION_504 | SP21 | Error | Section 504 Handicapped does not contain a valid code. | Active | 1
SPED_TRANSITION | SP104 | Error | If TRANSITION CODE is 1, 2 or 3 then Primary Disability must be reported. | Active | 1
SPED_TRANSITION | SP47 | Error | Transition does not contain a valid code. | Active | 1
TELEPHONE_PRIMARY_STUDENT | SP345 | Error | Student Primary Phone valid characters are (0-9) | Active | 1
TELEPHONE_SECONDARY_STUDENT | SP346 | Error | Student Secondary Phone valid characters are (0-9) | Active | 1