Spreadsheet: 0cd4a5fe-1eab-4509-a63e-2c3e1e9b5341
Sheet: Page1_1

 |  |  | Colorado Department of Education |  |  | Page: 1
 |  |  | Business Rules
School Year: | 2013-14 | Dataset: | CMAS SBD | File Type: | CMAS SBD File
Data Element Name | Error/Warning Code | Error Type | Message | Status | Tier | Last Updated User | Last Updated Date
BILINGUAL | CM022 | Error | Bilingual field must be a valid code. | Active | 1
BILINGUAL | CM056 | Error | Bilingual field must be 0 when [NAME] is English. | Active | 1 | [EMAIL] | 2014-04-30 11:27:42
BIRTH_DATE_STUDENT | CM002 | Error | Date of Birth must be a valid date in MMDDYYYY format. | Active | 1
BIRTH_DATE_STUDENT | CM003 | Error | Date of Birth is a mandatory field.. | Active | 1 | [EMAIL] | 2014-02-28 07:04:56
CMAS_ADMIN_CODE_TEST_TYPE | CM064 | Error | Admin Code/Test Type may not be changed during SBD. | Active | 1
CMAS_CONTENT_AREA | CM065 | Error | Content Area may not be changed during SBD. | Active | 1
CMAS_INVALIDATION_CODES | CM067 | Error | Invalidation must be a valid code. | Active | 1 | [EMAIL] | 2014-03-20 15:10:43
CMAS_INVALIDATION_CODES | CM068 | Error | Invalidation is a mandatory field. | Active | 1
CMAS_INVALIDATION_CODES | CM069 | Error | The invalidation code for this record is "98 = State Use 1".  This code can only be used with permission from CDE.  Please call the Assessment Unit. | Active | 1 | [EMAIL] | 2014-04-30 11:28:38.999000
CMAS_INVALIDATION_CODES | CM070 | Error | The invalidation code for this record is "99 = State Use 1".  This code can only be used with permission from CDE.  Please call the Assessment Unit. | Active | 1 | [EMAIL] | 2014-04-30 11:29:03
CMAS_INVALIDATION_CODES | [NAME] | Error | More than 70% of your records are shown as Misadministration. If this is accurate, please call the Assessment Unit. | Active | 1 | [EMAIL] | 2014-04-30 11:29:25.999000
COLORADO_CONTINUOUSLY | CM024 | Error | Colorado Continuously must be a valid code. | Active | 1
COLORADO_CONTINUOUSLY | CM058 | Warning | Your file indicates that more than 95% of the records are for students who have been continuously enrolled in colorado for 3 years. | Active | 1
CONTINUOUS_IN_DISTRICT | CM025 | Error | Continuous in District must be a valid code. | Active | 1
CONTINUOUS_IN_DISTRICT | [NAME] | Warning | Your file indicates that more than 95% of your students have been continuously enrolled in the district for 1 year or more. | Active | 1
CONTINUOUS_IN_SCHOOL | CM026 | Error | Continuous in School must be a valid code. | Active | 1
CONTINUOUS_IN_SCHOOL | CM060 | Warning | Your file indicates that more than 95% of your students have been continuously enrolled in a school for 1 year or more. | Active | 1
[NAME] | [NAME] | Error | Date Most Recently Enrolled in US must be a valid date in MMDDYYYY format. | Active | 1
[NAME] | CM061 | Error | Date Most Recently Enrolled in a US School must be a valid date less than 25 years ago. | Active | 1
[NAME] | CM072 | Error | Date Most Recently Enrolled in US is a mandatory field. | Active | 1
ENTRY_GRADE_LEVEL | CM047 | Error | May not be changed during SBD.  This is the Assessment grade level administered to student. | Active | 1
ESL_STATUS | CM023 | Error | ESL field must be a valid code. | Active | 1
ESL_STATUS | CM057 | Error | ESL Status must be 0 when [NAME] is English. | Active | 1 | [EMAIL] | 2014-04-30 11:27:57
ETHNICITY_STUDENT | CM006 | Error | Hispanic or Latino must be a valid code. | Active | 1
EXPELLED_EDUCATION | CM028 | Error | Expelled field must be a valid code. | Active | 1
FIRST_NAME_STUDENT | CM045 | Error | Student First Name may contain only characters a-z, A-Z, 0-9, space, apostrophe, hyphen, comma and period. | Active | 1
FREE_REDUCED_LUNCH | CM012 | Error | Free/Reduced Lunch Eligible must be a valid code. | Active | 1
FREE_REDUCED_LUNCH | CM015 | Error | Migrant pupils are eligible for free lunch and should be marked as such. | Active | 1
FREE_REDUCED_LUNCH | CM020 | Error | Homeless pupils are eligible for free lunch and should be marked as such. | Active | 1
GENDER_STUDENT | CM004 | Error | Gender must be a valid code. | Active | 1
GENDER_STUDENT | CM005 | Error | Gender is a mandatory field. | Active | 1
GIFTED_AND_TALENTED | CM029 | Error | Gifted/Talented field must be a valid code. | Active | 1
HOMELESS | CM019 | Error | Homeless field must be a valid code. | Active | 1
IEP_CMAS | CM030 | Error | IEP field must be a valid code. | Active | 1
IMMIGRANT | CM016 | Error | Immigrant field must be a valid code. | Active | 1
LANGUAGE_BACKGROUND | CM017 | Error | [NAME] must be a valid code. | Active | 1
LANGUAGE_PROFICIENCY | CM021 | Error | [NAME] must be a valid code. | Active | 1
LANGUAGE_PROFICIENCY | CM051 | 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 | [EMAIL] | 2014-04-30 11:25:49
LANGUAGE_PROFICIENCY | CM052 | Error | Pupils reported as NEP or LEP cannot be reported as monitored or exited from an ESL Program. | Active | 1 | [EMAIL] | 2014-04-30 11:26:08
LANGUAGE_PROFICIENCY | CM053 | Error | Pupils reported as NEP or LEP cannot be reported as monitored or exited from a Bilingual Program. | Active | 1 | [EMAIL] | 2014-04-30 11:26:38.999000
LANGUAGE_PROFICIENCY | [NAME] | Error | If [NAME]  is English then Language Proficiency must be  0 for Not Applicable. | Active | 1 | [EMAIL] | 2014-04-30 11:26:57
LANGUAGE_PROFICIENCY | CM055 | Error | Pupils with [NAME] other than English must be reported as NEP, LEP, or FEP, PHLOTE or FELL for Language Proficiency. | Active | 1 | [EMAIL] | 2014-04-30 11:27:20
LAST_NAME_STUDENT | [NAME] | Error | Student Last Name may contain only characters a-z, A-Z, 0-9, space, apostrophe, hyphen, comma and period. | Active | 1
MIDDLE_NAME_STUDENT | [NAME] | Error | Student Middle Name may contain only characters a-z, A-Z, 0-9, blank, apostrophe, hyphen, comma and period. | Active | 1
MIGRANT | CM014 | Error | Migrant field must be a valid code. | Active | 1
OCTOBER_NEW_TO_SCHOOL | CM062 | Error | Pupil cannot be new to the school as of Oct 1 AND Continuous in School | Active | 1
OCTOBER_NEW_TO_SCHOOL | CM063 | Error | For at least one or more grade levels, you have coded more than 75% of your students as new to school after October 1.  Please contact the Accountabilty and Data Analysis Unit. | Active | 1
OCTOBER_NEW_TO_SCHOOL | CM073 | Error | The expected value for students who were not included in the October Count for this school is '1'. Students not included in October count are assumed to have enrolled after October 1st, and so to be new to the school | Active | 1
OCTOBER_NEW_TO_SCHOOL | CM074 | Warning | The expected value for students who were included in October Count for this school is '0'. These students should only be coded as '1' in cases where they were officially withdrawn from school after October Count and subsequently reenrolled prior to testing. Such students are considered to be new to the school due to the break in enrollment. | Active | 1
OCTOBER_NEW_TO_SCHOOL | CM075 | Error | October New to School must be a valid code. The value should reflect a [NAME] enrollment status as of October 1 of the current school year. Students who are enrolled in the school on October 1 are considered NOT to be ¿new to school¿ and should be coded as ¿0¿. Students who enroll after October 1 are considered to be ¿new to school¿ and should be coded as ¿1¿. | Active | 1
PEARSON_STUDENT_ID | CM066 | Error | Pearson Student ID may not be changed during SBD. | Active | 1
PRIMARY_DISABILITY | CM018 | Error | Primary Disability must be a valid code. | Active | 1
PRIMARY_DISABILITY | [NAME] | Error | Students with an IEP must also have a reported Disability. | Active | 1 | [EMAIL] | 2014-04-30 11:24:11
PRIMARY_DISABILITY | CM049 | Error | Student must have a Primary Disability indicated in order to take the Alternate assessment. | Active | 1
PRIMARY_DISABILITY | CM050 | Error | Students with a Primary Disability must have either an IEP or a 504 Plan. | Active | 1 | [EMAIL] | 2014-04-30 11:25:24.999000
RACE_ASIAN_STUDENT | CM008 | Error | Asian field must be a valid code. | Active | 1
RACE_BLACK_STUDENT | CM009 | Error | Black or African American must be a valid code. | Active | 1
RACE_HAWAIIAN_STUDENT | CM011 | Error | Native Hawaiian or Other Pacific Islander must be a valid code. | Active | 1
RACE_INDIAN_STUDENT | CM007 | Error | American Indian or Alaskan Native must be a valid code. | Active | 1
RACE_WHITE_STUDENT | CM010 | Error | White field must be a valid code. | Active | 1
REPORTING_DISTRICT_CODE_CMAS | CM035 | Error | Reporting District Code may not be changed during SBD.  If change is needed call the Assessment Unit. | Active | 1
REPORTING_DISTRICT_NAME_CMAS | [NAME] | Error | Reporting District Name may not be changed during SBD.  If change is needed call the Assessment Unit. | Active | 1
REPORTING_SCHOOL_CODE_CMAS | CM036 | Error | Reporting School Code must be valid CDE school code in reporting district. | Active | 1
REPORTING_SCHOOL_NAME_CMAS | CM038 | Error | Reporting School Name may not be changed during SBD.  If change is needed call the Assessment Unit. | Inactive | 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 | CM001 | Error | SASID is a mandatory field. | Active | 1
SECTION_504 | CM013 | Error | 504 Plan must be a valid code. | Active | 1
SECTION_504 | CM048 | Warning | A student has both a 504 Plan AND an IEP, which is unlikely. | Active | 1
SEQUENCE_CMAS | CM033 | Error | Sequence Number must be a unique value and the same one supplied in your extract download. | Active | 1
SEQUENCE_CMAS | CM034 | Error | The number of records being uploaded to Data Pipeline must match the number of records in the extract download. | Active | 1
TESTING_DISTRICT_CODE_CMAS | CM039 | Error | Testing District Code may not be changed during SBD. | Active | 1
TESTING_DISTRICT_NAME_CMAS | CM041 | Error | Testing District Name may not be changed during SBD. | Active | 1
TESTING_SCHOOL_CODE_CMAS | CM040 | Error | Testing School Code may not be changed during SBD. | Active | 1
TESTING_SCHOOL_NAME_CMAS | CM042 | Error | Testing School Name may not be changed during SBD. | Active | 1