Spreadsheet: 26814eaa-ffa5-4a17-97d8-ca237e8af6b3
Sheet: Page1_1

 |  |  | Colorado Department of Education |  |  | Page: 1
 |  |  | Business Rules
School Year: | 2013-14 | Dataset: | Special Education IEP Interchange | File Type: | Sp. [NAME] December Count Staff
Data Element Name | Error/Warning Code | Error Type | Message | Status | Tier | Last Updated User | Last Updated Date
ADMIN_UNIT_CODE | DC034 | Warning | Warning: No records received indicating individual having district wide responsibility. (eg. Director of Special Education) | Inactive | 2
ADMIN_UNIT_CODE | DC036 | Warning | Warning: No Administrators (100's) were reported | Inactive | 2
ADMIN_UNIT_CODE | [NAME] | Warning | Warning:  No Professional-Instructional (200's) were reported | Inactive | 2
ADMIN_UNIT_CODE | DC038 | Warning | Warning: No Professional-Other (300's) were reported | Inactive | 2
ADMIN_UNIT_CODE | DC039 | Warning | Warning:  No Paraprofessionals (400's) were reported | Inactive | 2
ADMIN_UNIT_CODE | DC040 | Warning | Warning: No Office Administrative Support (500's) were reported | Inactive | 2
ADMIN_UNIT_CODE | DC041 | Warning | Warning:  No Special Education purchased service staff were reported. | Inactive | 2
ADMIN_UNIT_CODE | DC042 | Warning | Warning:  More than 5 FTE Paraprofessionals (416) were reported as district-wide (9980). Paraprofessionals should be attributed to the buildings they serve if at all possible | Inactive | 2
ADMIN_UNIT_CODE | DC043 | Warning | Warning:  No Child Find Coordinator was reported | Inactive | 2
ADMIN_UNIT_CODE | DC044 | Warning | Warning:  No related services staff were reported | Inactive | 2
BASE_SALARY | DC017 | Error | Base Salary/FTE does not meet minimum wage requirements. | Inactive | 2
DEGREE_INSTITUTION_CODE | DC005 | Error | INSTITUTION OR STATE CODE is required if JOB CLASS CODE  is 100-299. | Active | 2 | [EMAIL] | 2013-12-11 13:19:27
FTE | [NAME] | Error | FTE total for each individual must be between 0.005 and 1.71 | Active | 1
HIGHEST_LEVEL_EDUCATION_COMP | DC001 | Error | Education Level is required if Job Class Code is 100-299 or 416 | Active | 1 | [EMAIL] | 2013-10-16 08:59:17
HIGHEST_LEVEL_EDUCATION_COMP | DC002 | Error | ED LEVEL must be 16-20 if JOB CLASS CODE is 100-299. | Inactive | 2 | [EMAIL] | 2013-06-06 13:06:02
HIGHEST_LEVEL_EDUCATION_COMP | DC004 | Error | ED LEVEL is required for State Operated Programs if JOB CLASS CODE is 201 or 202. | Inactive | 2
HIGHEST_LEVEL_EDUCATION_COMP | DC010 | Error | If Highest Level of Education Completed is 16 or above, and Job Class Code is 201 or 202, Subject Area of Degree cannot be 2100 zero-filled | Inactive | 2
HIGHEST_LEVEL_EDUCATION_COMP | DC145 | Warning | Warning: To be considered highly qualified, this paraprofessional must hold at least a high school diploma or its equivalent | Inactive | 1
JOB_CLASSIFICATION_CODE | DC019 | Error | JOBCLASS CODES 202 (Teachers) and 238 (Speech Language Pathologists) must have a student caseload. | Inactive | 2
JOB_CLASSIFICATION_CODE | DC020 | Error | Teaching grade level must be an exact match to the grades of the students reported on the caseload. | Inactive | 2
JOB_CLASSIFICATION_CODE | DC021 | Error | This teacher needs a valid Colorado teaching license in order to be considered Highly Qualified. | Inactive | 2
JOB_CLASSIFICATION_CODE | DC022 | Error | This teacher needs to demonstrate content knowledge at the elementary level via an elementary content test, elementary HOUSSE or National Board Certification. If the teacher is eligible for the Elementary HOUSSE, the LEA may submit this information through the online HQ system. | Active | 2
JOB_CLASSIFICATION_CODE | [NAME] | Error | HQ Requirements Not Met - This teacher needs to demonstrate content knowledge at the elementary level (i.e., and elementary content test, elementary HOUSSE, National Board Certification) or in the assigned content area). If the teacher is eligible for the Elementary HOUSSE, the LEA may submit this information through the online HQ system. | Active | 2
JOB_CLASSIFICATION_CODE | DC024 | Error | This teacher needs to demonstrate content knowledge in the assigned content area via a core test, a degree, 24 hours, National Board Certification, Special Education HOUSSE, Rural HOUSSE or an endorsement in the content area. If the teacher is eligible for the Special Education HOUSSE or Rural HOUSSE, the LEA may submit this information through the online HQ system. | Active | 2
JOB_CLASSIFICATION_CODE | DC025 | Error | This teacher needs to demonstrate knowledge at the elementary level (i.e., elementary content test, elementary HOUSSE, National Board Certification) or in the assigned content area (i.e., a core test, a degree, 24 hours, an endorsement, [NAME], Rural HOUSSE or National Board Certification in the content area). If the teacher is eligible for the Elementary, Special Education or Rural HOUSSE, the LEA may submit this information through the online HQ system. | Active | 2
JOB_CLASSIFICATION_CODE | DC026 | Error | If Job Classification Code is 416 then education level must be greater than or equal to 10. | Inactive | 2 | [EMAIL] | 2013-06-05 13:59:09
JOB_CLASSIFICATION_CODE | DC027 | Error | To be considered highly qualified, this paraprofessional needs to show basic content competency by (1) obtaining an associates degree or two years of college (48 semester hours), or (2) passing an approved paraprofessional test. | Inactive | 2 | [EMAIL] | 2013-06-07 14:15:01
JOB_CLASSIFICATION_CODE | DC029 | Error | No Special Education teachers were reported | Inactive | 2
JOB_CLASSIFICATION_CODE | DC030 | Error | District wide personnel who aren't assigned to a specific elementary or secondary setting must be reported with grades K-12 at school code 9980. | Inactive | 2
JOB_CLASSIFICATION_CODE | [NAME] | Error | Identical detail records for the same individual are not allowed . | Inactive | 2
JOB_CLASSIFICATION_CODE | DC033 | Warning | Warning - No Director of Special Education reported | Inactive | 2
JOB_CLASSIFICATION_CODE | DC035 | Warning | Warning: Teachers are to be assigned to schools and not to 9980. | Inactive | 2
JOB_CLASSIFICATION_CODE | DC045 | Warning | Warning:  JOBCLASS CODE requires a CDE license, the SOC_SEC_NBR  or a valid license was not found on the licensure data base. | Active | 2
JOB_CLASSIFICATION_CODE | DC140 | Warning | Warning: This teacher needs a valid Colorado teaching license in order to be considered Highly Qualified. | Inactive | 1
JOB_CLASSIFICATION_CODE | DC141 | Warning | Warning: This teacher needs to demonstrate content knowledge at the elementary level via an elementary content test, elementary HOUSSE or National Board Certification. If the teacher is eligible for the Elementary HOUSSE, the LEA may submit this information through the online HQ system. | Inactive | 1
JOB_CLASSIFICATION_CODE | DC142 | Warning | Warning: HQ Requirements Not Met - This teacher needs to demonstrate content knowledge at the elementary level (i.e., and elementary content test, elementary HOUSSE, National Board Certification) or in the assigned content area (i.e., a core test, a degree, 24 hours, an endorsement or National Board Certification in the content area).  If the teacher is eligible for the Elementary HOUSSE, the LEA may submit this information through the online HQ system. | Inactive | 1
JOB_CLASSIFICATION_CODE | DC143 | Warning | Warning: This teacher needs to demonstrate content knowledge in the assigned content area via a core test, a degree, 24 hours, National Board Certification, Special Education HOUSSE, Rural HOUSSE or an endorsement in the content area. If the teacher is eligible for the Special Education HOUSSE or Rural HOUSSE, the LEA may submit this information through the online HQ system. | Inactive | 1
JOB_CLASSIFICATION_CODE | [NAME] | Warning | Warning: This teacher needs to demonstrate knowledge at the elementary level (i.e., elementary content test, elementary HOUSSE, National Board Certification) or in the assigned content area (i.e., a core test, a degree, 24 hours, an endorsement, [NAME], Rural HOUSSE or National Board Certification in the content area). If the teacher is eligible for the Elementary, Special Education or Rural HOUSSE, the LEA may submit this information through the online HQ system. | Inactive | 1
JOB_CLASSIFICATION_CODE | [NAME] | Warning | Warning: To be considered highly qualified, this paraprofessional needs to show basic content competency by (1) obtaining an associates degree or two years of college (48 semester hours), or (2) passing an approved paraprofessional test . | Inactive | 1
OVERALL_RATING_TEACHER | DC016 | Error | Teacher Overall Performance Evaluation Rating from the Prior Year is required for all teachers. | Inactive | 2
OVERALL_RATING_TEACHER | DC032 | Error | A Teacher Overall Performance Evaluation Rating from the Prior Year cannot be 05-Not Yet Evaluated if the teacher was hired prior to July 1st of the current school year. | Active | 2
PASSED_PARAPRO_TEST | DC012 | Error | PASS PARAPROFESSIONAL TEST is required for JOB CLASS CODE 416. | Inactive | 2
QUALITY_STANDARD_TEACHER_1 | DC148 | Warning | Teacher Quality Standard 1 must be provided for all teachers with an Overall Performance Rating | Active | 1 | [EMAIL] | 2013-12-17 16:31:16
QUALITY_STANDARD_TEACHER_2 | DC149 | Warning | Teacher Quality Standard 2 must be provided for all teachers with an Overall Performance Rating | Active | 1
QUALITY_STANDARD_TEACHER_3 | DC150 | Warning | Teacher Quality Standard 3 must be provided for all teachers with an Overall Performance Rating | Active | 1 | [EMAIL] | 2013-10-02 09:07:42
QUALITY_STANDARD_TEACHER_4 | DC151 | Warning | Teacher Quality Standard 4 must be provided for all teachers with an Overall Performance Rating | Active | 1
[NAME] | [NAME] | Warning | Teacher Quality Standard 5 must be provided for all teachers with an Overall Performance Rating | Active | 1
QUALITY_STANDARD_TEACHER_6 | DC153 | Warning | Teacher Quality Standard 6 must be provided for all teachers with an Overall Performance Rating | Active | 1
SCHOOL_CODE | [NAME] | Error | As reported, this paraprofessional does not meet the NCLB highly qualified requirements for an instructional paraprofessional in a Title I schoolwide program. Please verify the accuracy of the data reported in the Highest Level of Education Completed and Passed Professional Test fields. If the paraprofessional does not currently meet these requirements, contact CDE. | Inactive | 2
SCHOOL_CODE | [NAME] | Warning | Warning: As reported, this paraprofessional does not meet the NCLB highly qualified requirements for an instructional paraprofessional in a Title I schoolwide program.  Please verify the accuracy of the data reported in the Highest Level of Education Completed  and Passed Professional Test fields.  If the paraprofessional does not currently meet these requirements, contact CDE. | Inactive | 1
SUBJECT_AREA_OF_DEGREE_1 | DC003 | Error | If subject area of degree is valid then highest level of education must be 16 or higher. | Active | 2 | [EMAIL] | 2013-11-01 16:10:18.999000
SUBJECT_AREA_OF_DEGREE_1 | DC009 | Error | At least one Subject Area of Degree is required for  Classroom Instructional Staff teaching 7th grade or higher | Inactive | 2
SUBJECT_AREA_OF_DEGREE_1 | DC011 | Error | At least one Subject Area of Degree is required for Administrative Units for Classroom Instructional Staff teaching 7th grade or higher. | Inactive | 2
TEACHER_PROBATIONARY_STATUS | DC015 | Error | Teacher [NAME] is required and not zero-filled for all teachers. | Inactive | 2 | [EMAIL] | 2013-06-07 08:40:10.999000
TEACHING_SUBJECT_AREA | DC018 | Error | Only core content regular teachers are to be reported for NCLB requirements.  The core content teaching subject areas are: general elementary, general 7th/8th grade classroom, art, English, foreign la | Inactive | 2
YEARS_EDUCATION_EXP_CO | DC008 | Error | YEARS EDUCATION EXPERIENCE IN STATE  is required if JOB CLASS CODE is 100-299 | Inactive | 2
YEARS_EDUCATION_EXP_CO | [NAME] | Error | Total years education experience (in/out of state) must be less than or equal to the individuals age minus 16. | Inactive | 2
YEARS_TEACHING_EXP_CO | DC006 | Error | Years Teaching Experience In-State is required if Job Class Code is 100-299. | Inactive | 2
YEARS_TEACHING_EXP_CO | DC014 | Error | Total years teaching experience (in/out of state) must be less than or equal to the individuals age minus 21. | Inactive | 2
YEARS_TEACHING_EXP_NON_CO | DC007 | Error | Years Teaching Experience Out-of-State is required if Job Class Code is 100-299. | Active | 2