Spreadsheet: 3380d8dd-609b-4250-b7e1-f2330c997e3c
Sheet: Sheet1

 |  |  | Colorado Department of Education |  |  | Page: 1
 |  |  | Business Rules
School Year: | 2013-14 | Dataset: | Staff Profile & Assignments | File Type: | Human Resources Snapshot
Data Element Name | Error/Warning Code | Error Type | Message | Status | Tier | Last Updated User | Last Updated Date
BASE_SALARY | [NAME] | Error | For Job Class Code 101, Base Salary divided by FTE must be less than 275,000. | Active | 1 | stfadmin | 2012-09-19 10:53:54.999000
BASE_SALARY | HR002 | Error | If Job Class Code is not 101, Base Salary divided by FTE must be less than 270,000. | Active | 1 | stfadmin | 2012-09-19 11:04:34
BASE_SALARY | HR003 | Error | Base Salary divided by FTE does not meet minimum wage requirements. | Active | 1
BASE_SALARY | HR004 | Error | Base Salary divided by the FTE is higher than the expected maximum for the jobclass code. | Active | 1
SCHOOL_CODE | HR005 | Error | Every Public School (except PK-PK [NAME]) should have at least one record with a Job Class Code of 201-206. | Active | 1
SCHOOL_CODE | HR006 | Error | There must be active teachers reported for all schools. | Active | 1
JOB_CLASSIFICATION_CODE | [NAME] | Error | A Full Time (0.85 FTE or above) active teacher must be reported at all schools. | Active | 1
SCHOOL_CODE | HR008 | Error | Every K-12 school must have at least one teacher reported with a teaching subject area that is a core content class as defined by [NAME] and Secondary Education Act highly qualified requirements. | Active | 1
SCHOOL_CODE | HR009 | Error | All preschools must have either a Teacher or a Teaching Assistant reported. | Active | 1
JOB_CLASSIFICATION_CODE | [NAME] | Warning | No superintendent reported. | Active | 1
JOB_CLASSIFICATION_CODE | HR011 | Warning | More than one Superintendent reported. | Active | 1
JOB_CLASSIFICATION_CODE | HR012 | Warning | Each Public School must report at least one Princpal. | Active | 1
JOB_CLASSIFICATION_CODE | [NAME] | Warning | Schools can only report one Principal. | Active | 1
SCHOOL_CODE | HR014 | Warning | No records received indicating individual having district wide responsibility. (eg. Superintendent) | Active | 1
JOB_CLASSIFICATION_CODE | HR016 | Warning | No Administrators (100's) were reported. | Active | 1
JOB_CLASSIFICATION_CODE | HR017 | Warning | No Professional-Instructional (200's) were reported. | Active | 1
JOB_CLASSIFICATION_CODE | HR018 | Warning | No Professional-Other (300's) were reported. | Active | 1
JOB_CLASSIFICATION_CODE | HR019 | Warning | No Paraprofessionals (400's) were reported. | Active | 1
JOB_CLASSIFICATION_CODE | HR020 | Warning | No Office Administrative Support (500's) were reported. | Active | 1
JOB_CLASSIFICATION_CODE | HR021 | Warning | No Crafts/Trades/Services (600's) were reported. | Active | 1
JOB_CLASSIFICATION_CODE | HR022 | Warning | Long term substitutes should be reported as 201 regular teachers. Only permanent substitutes with full-time contracts should be reported in jobclass code 204. | Active | 1
JOB_CLASSIFICATION_CODE | HR023 | Warning | Do not include individuals employed only for extra-curricular activities outside of the normal school day in jobclass code 210. These individuals are to be reported in jobclass code 407. | Active | 1
BASE_SALARY | HR025 | Warning | Average teacher salary for the district is either 5% greater or 5% less than the average teacher salary from last year. | Active | 1
BASE_SALARY | HR026 | Warning | Average administrator's salary for the district is either 5% greater or 5% less than the average administrator's salary from last year. | Active | 1
HOURLY_RATE_OF_PAY | HR027 | Warning | Average hourly rate of pay should not be less than minimum wage ($7.36). | Inactive | 1 | [EMAIL] | 2013-05-23 13:20:33
JOB_CLASSIFICATION_CODE | HR028 | Warning | More than 5 FTE Teaching Assistants (415-419) were reported as district-wide (9980). Teaching Assistants should be attributed to the buildings they serve if at all possible. | Active | 1
SCHOOL_CODE | HR029 | Warning | No Title I funded teachers were reported for your Title I targeted assisted school. | Active | 1 | stfadmin | 2012-09-19 14:27:20
SCHOOL_CODE | HR030 | Warning | No Title I funded teachers were reported for your Title I schoolwide school. | Active | 1
SCHOOL_CODE | HR031 | Warning | Schools should have a pupil/teacher FTE ratio that is less than 40. With a pupil/teacher FTE ratio greater then 40.0, it implies there are 40+ students per 1 teacher. | Active | 1
HIGHEST_LEVEL_EDUCATION_COMP | HR032 | Warning | Highest Level of Education is mandatory if Job Class Code is 100-299, 415, 418, 419 | Active | 1 | stfadmin | 2012-09-20 14:11:40
HIGHEST_LEVEL_EDUCATION_COMP | HR033 | Error | If Subject Area of Degree is valid then Highest Level of Education must be 16 or higher. | Active | 1 | [EMAIL] | 2013-12-19 08:18:52.999000
DEGREE_INSTITUTION_CODE | HR034 | Error | Institution or State Code cannot be zero-filled if Job Class Code is 100-299. | Active | 1
YEARS_TEACHING_EXP_CO | HR035 | Error | Years of Prior Pre/K-12 Teaching Experience Instate is mandatory if Job Class Code is 100-299 | Active | 1 | stfadmin | 2012-09-20 13:17:24
YEARS_TEACHING_EXP_NON_CO | HR036 | Error | Years of  Teaching Experience Out of State is mandatory if Job Class Code is 100-299 | Active | 1 | stfadmin | 2012-09-20 13:18:02
YEARS_EDUCATION_EXP_CO | HR037 | Warning | Years of  Education Experience Instate is mandatory if Job Class Code is 100-299 | Active | 1 | stfadmin | 2012-09-20 14:12:07
SUBJECT_AREA_OF_DEGREE_1 | HR038 | Error | If highest level of education is 16 or above, a subject area of degree is required. | Active | 1 | stfadmin | 2012-09-20 13:23:11.999000
YEARS_PRINCIPAL_AT_ANY_SCHOOL | HR042 | Error | Years Principal at any School is mandatory for Principals or Superintendent serving as Principal. | Active | 1 | [EMAIL] | 2013-04-01 11:49:33
YEARS_PRINCIPAL_AT_ANY_SCHOOL | HR043 | Error | Years Principal at any School is greater than current age minus 20. | Active | 1
YEARS_PRINCIPAL_AT_ANY_SCHOOL | HR044 | Error | Years Principal at any School should be greater than or equal to Years Principal at this School. | Active | 1
YEARS_PRINCIPAL_AT_ANY_SCHOOL | HR045 | Warning | Years Principal at any School should increment by one from the previous year. | Active | 1
PASSED_PARAPRO_TEST | HR046 | Error | Passed Paraprofessional Test must be marked as Yes or No if Job Class Code is 415, 416, 418, or 419 | Active | 1 | stfadmin | 2012-11-01 15:18:52
OVERALL_RATING_TEACHER | HR047 | Error | Teacher Overall Performance Evaluation Rating  is mandatory. | Active | 1 | [EMAIL] | 2013-03-20 13:54:21.999000
OVERALL_RATING_TEACHER | HR048 | Error | A Teacher Overall Performance Evaluation Rating  other than 05-Not Yet Evaluated must be provided for all teachers hired prior to July 1st of the current school year. | Active | 1
OVERALL_RATING_PRINCIPAL | HR049 | Error | Principal Overall Performance Evaluation  Rating  is mandatory for all principals and assistant principals. | Active | 1 | stfadmin | 2012-09-20 16:21:59
OVERALL_RATING_PRINCIPAL | HR050 | Error | A Principal Overall Performance Evaluation Rating  other than 05-Not Yet Evaluated must be provided for all Principals hired prior to July 1st of the current school year. | Active | 1
YEARS_EDUCATION_EXP_CO | HR051 | Error | The sum of Years of  Education Experience Instate and Out of State should be less than or equal to the current age minus 14 | Active | 1 | [EMAIL] | 2013-03-14 10:34:50
YEARS_EDUCATION_EXP_CO | HR052 | Warning | The sum of Years of  Education Experience Instate and Out of State should be less than or equal to the current age minus 18 | Active | 1
SUBJECT_AREA_OF_DEGREE_1 | HR053 | Error | At least one Subject Area of Degree is required for Classroom Instructional Staff. | Active | 1 | stfadmin | 2012-09-20 13:24:27.999000
HIGHEST_LEVEL_EDUCATION_COMP | HR054 | Warning | Highest Level of Education Completed should be 16-20 if Job Class Code is 100-299 | Active | 1 | stfadmin | 2012-09-20 16:36:46
EMPLOYMENT_STATUS | HR055 | Error | There must be more than 1 detail record for staff that have an Employment Status Code of 10. | Active | 1
EMPLOYMENT_STATUS | [NAME] | Error | There must be more than 1 detail record with an Employment Status Code of 01, 02 or 08 and a different school code for staff that have an employment status code of 10. | Active | 1
CORE_CONTENT_OUTSIDE_CO | HR057 | Error | The State in which the elementary core content test was passed must be reported in the  State Core Content Test Administered (outside of Colorado) field.  If it was taken and passed in CO, both fields | Active | 1 | stfadmin | 2012-09-21 10:15:29
JOB_CLASSIFICATION_CODE | HR058 | Warning | HQ Requirements Not Met - This teacher needs a valid Colorado teaching license in order to be considered Highly Qualified. | Active | 1 | stfadmin | 2012-09-21 10:51:58
JOB_CLASSIFICATION_CODE | HR059 | Error | HQ Requirements Not Met - This teacher needs to demonstrate content knowledge at the elementary level via an elementary content test or elementary HOUSSE. If the teacher is eligible for the Elementary | Active | 1 | stfadmin | 2012-09-21 10:51:39
JOB_CLASSIFICATION_CODE | [NAME] | Error | HQ Requirements Not Met - This teacher needs to demonstrate knowledge at the elementary levelor in the assigned area. | Active | 1 | stfadmin | 2012-09-21 11:02:54
JOB_CLASSIFICATION_CODE | HR064 | Error | HQ Requirements Not Met  - To be considered highly qualified, this paraprofessional needs to hold at least a high school diploma or its equivalent. | Active | 1 | [EMAIL] | 2013-03-28 15:30:47
JOB_CLASSIFICATION_CODE | [NAME] | Error | Paraprofdssinal requires either a two year degree or passing a paraporfessional test. | Active | 1 | [EMAIL] | 2013-03-20 15:22:19
JOB_CLASSIFICATION_CODE | HR066 | Error | HQ Requirements Not Met - This teacher needs to demonstrate content knowledge at the elementary level via an elementary content test or elementary HOUSSE. | Active | 1
QUALITY_STANDARD_TEACHER_1 | HR067 | Warning | Teacher Quality Standard 1 must be provided for all teachers with an Overall Performance Rating | Active | 1 | [EMAIL] | 2013-12-17 11:11:00.999000
QUALITY_STANDARD_TEACHER_2 | HR068 | Warning | Teacher Quality Standard 2 must be provided for all teachers with an Overall Performance Rating | Active | 1 | [EMAIL] | 2013-12-17 11:11:17
QUALITY_STANDARD_TEACHER_3 | HR069 | Warning | Teacher Quality Standard 3 must be provided for all teachers with an Overall Performance Rating | Active | 1 | [EMAIL] | 2013-12-17 11:14:51
QUALITY_STANDARD_TEACHER_4 | HR070 | Warning | Teacher Quality Standard 4 must be provided for all teachers with an Overall Performance Rating | Active | 1 | [EMAIL] | 2013-12-17 11:12:21
[NAME] | HR071 | Warning | Teacher Quality Standard 5 must be provided for all teachers with an Overall Performance Rating | Active | 1 | [EMAIL] | 2013-12-17 11:12:45
QUALITY_STANDARD_TEACHER_6 | HR072 | Warning | Teacher Quality Standard 6 must be provided for all teachers with an Overall Performance Rating | Active | 1 | [EMAIL] | 2013-12-17 11:13:01
QUALITY_STANDARD_PRINCIPAL_1 | HR073 | Warning | Principal Quality Standard 1 must be provided for all principals with an Overall Performance Rating | Active | 1 | stfadmin | 2012-09-21 11:58:12
QUALITY_STANDARD_PRINCIPAL_2 | HR074 | Warning | Principal Quality Standard 2 must be provided for all principals with an Overall Performance Rating | Active | 1 | stfadmin | 2012-09-21 11:57:55
[NAME] | HR075 | Warning | Principal Quality Standard 3 must be provided for all principals with an Overall Performance Rating | Active | 1
QUALITY_STANDARD_PRINCIPAL_4 | [NAME] | Warning | Principal Quality Standard 4 must be provided for all principals with an Overall Performance Rating | Active | 1
QUALITY_STANDARD_PRINCIPAL_5 | [NAME] | Warning | Principal Quality Standard 5 must be provided for all principals with an Overall Performance Rating | Active | 1
QUALITY_STANDARD_PRINCIPAL_6 | HR078 | Warning | Principal Quality Standard 6 must be provided for all principals with an Overall Performance Rating | Active | 1
QUALITY_STANDARD_PRINCIPAL_7 | [NAME] | Warning | Principal Quality Standard 7 must be provided for all principals with an Overall Performance Rating | Active | 1
ADMIN_INSTRUCT_AREA | HR080 | Error | Job Class Code 238 can only be reported as a non special education employee if the administrative/instructional area code is for Coordianated Early Intervening Services ( code 0039) AND [NAME] is | Active | 1
ADMIN_INSTRUCT_AREA | [NAME] | Warning | Librarians/Media Consultants should have Job Class Code 216 and Library/Media Assistants should have Job Class Code 411. | Active | 1
JOB_CLASSIFICATION_CODE | HR082 | Error | Title I teachers must be reported as 206. | Active | 1 | [EMAIL] | 2013-04-19 07:48:06
GRANT_PROJECT_FUND_STAFF | HR083 | Warning | TITLE I teachers should be reported with funding/grant code of 4010, 5010 or 6010 for Title I funds. | Active | 1
TEACHING_SUBJECT_AREA | HR084 | Error | Title I Teachers must list General Elementary Education or Core Subject as the Subject Area Code. | Active | 1 | [EMAIL] | 2013-04-17 12:09:10
JOB_CLASSIFICATION_CODE | HR087 | Error | Title I staff reported at a non-Title I School for Pre-Kindergarten grade level. | Active | 1
HOURLY_RATE_OF_PAY | HR089 | Error | Either [NAME] of Pay or Base Salary must be greater than 0. | Active | 1 | [EMAIL] | 2013-04-15 14:55:35
HOURLY_RATE_OF_PAY | HR090 | Error | Hourly rate of pay must be at least minimum wage | Active | 1
HOURS_WORKED_PER_DAY | HR092 | Error | FTE total for each individual must be between 0.01 and 1.7 | Active | 1
YEARS_PRINCIPAL_AT_SCHOOL | [NAME] | Error | Years Principal at this School should be less than or equal to the years employed at the district. | Inactive | 1 | [EMAIL] | 2013-09-18 13:59:21.999000
JOB_CLASSIFICATION_CODE | [NAME] | Warning | HQ Requirements Not Met - This teacher needs to demonstrate knowledge at the elementary level (i.e., and elementary content test or elementary HOUSSE) or in the assigned content area | Active | 1 | stfadmin | 2012-09-21 10:50:28
JOB_CLASSIFICATION_CODE | [NAME] | Warning | HQ Requirements Not Met - This teacher needs a degree to be considered highly qualified. | Active | 1 | stfadmin | 2012-09-21 10:43:58
JOB_CLASSIFICATION_CODE | [NAME] | Warning | HQ Requirements Not Met - This teacher needs to demonstrate content knowledge in the assigned content area via a core test, a degree, 24 hours, National Board Certification, Rural HOUSSE or an endorse | Active | 1 | stfadmin | 2012-09-21 10:43:35
JOB_CLASSIFICATION_CODE | HR101 | Error | If jobclass code = 206 then the school must be designated as either Title I School Wide OR Title I Targeted Assistance | Active | 1