Spreadsheet: ccdad3b0-81fa-44ec-ac81-bf4d8369a6a8
Sheet: Page1_1

 |  |  | Colorado Department of Education |  |  | Page: 1
 |  |  | Business Rules
School Year: | 2013-14 | Dataset: | Staff Profile & Assignments | File Type: | Staff Assignment Association
Data Element Name | Error/Warning Code | Error Type | Message | Status | Tier
ADMIN_INSTRUCT_AREA | ST063 | Error | Administrator/Instructional Area is an invalid code. | Inactive | 1
ADMIN_INSTRUCT_AREA | ST064 | Error | Administrator/Instructional area must be a valid code if not zero-filled. | Active | 1
ADMIN_INSTRUCT_AREA | ST154 | Error | Administrator/Instruction Area is required if Job Class Code is 100-299, 401, 411, 415, 416, 417, or 420. | Active | 1
ADMIN_INSTRUCT_AREA | ST155 | Error | Administrator/Instruction Area is required if Job Class Code is 100-299, 401, 411, 416, 417, or 420. | Active | 1
ADMIN_INSTRUCT_AREA | ST156 | Error | This Administrator/Instructional Area should not be used for a teacher (job class codes 201-206). Either change the administrative/instructional area code or the jobclass code for this individual. | Active | 1
ADMIN_INSTRUCT_AREA | [NAME] | Error | Job Class Code 211 (Counselor) must be reported with admin/instructional area code 0021. | Active | 1
ADMIN_INSTRUCT_AREA | ST159 | Error | Librarians/Media Consultants should have Job Class Code 216 and Library/Media Assistants should have Job Class Code 411. | Active | 1
ADMIN_INSTRUCT_AREA | ST219 | Error | Special Education Teachers reported as teaching a specialty subject must be reported with administrator/instructional area code of 0037 (Specialty). | Active | 1
ADMIN_INSTRUCT_AREA | ST221 | Error | Administrator/Instructional Area 0033, Transitional Services, is for 8th-12th grade providers. | Active | 1
ADMIN_INSTRUCT_AREA | ST222 | Error | Administrator/Instructional Area 0034, is for Infant providers. | Active | 1
ADMIN_INSTRUCT_AREA | ST223 | Error | Administrator/Instructional Area must be 0034 if Grade Level Infant is 1. | Active | 1
ADMIN_INSTRUCT_AREA | ST224 | Error | PK providers must report Administrator/Instructional Area as 0035. | Active | 1
ADMIN_INSTRUCT_AREA | ST226 | Error | Teaching Subject Area 1792 must be reported with Administrator/Instructional Area 0034. | Active | 1
ADMIN_INSTRUCT_AREA | ST244 | Error | Job Class Code must be 202 for P. E., Family and Consumer or Industrial Arts Speciality teachers (Administrator/Instructional Area code equal to 0037) | Active | 1
BASE_SALARY | ST058 | Error | Base Salary or Wage must be numeric. | Active | 1
BASE_SALARY | ST059 | Error | Base Salary or Wage must not contain a decimal. | Active | 1
BASE_SALARY | ST060 | Error | Base Salary or Wage must be 6 digits | Active | 1
BASE_SALARY | ST105 | Error | Base Salary or Wage is mandatory and cannot be zero-filled if [NAME] is blank or zero-filled. | Active | 1
BASE_SALARY | ST106 | Error | Base Salary or Wage is mandatory and cannot be zero-filled if [NAME] is blank or zero-filled. | Active | 1
BASE_SALARY | [NAME] | Error | Base Salary or Wage is mandatory and must not be zero-filled if Employment Status Code is 01,02,04,08,10. | Active | 1
BASE_SALARY | [NAME] | Error | Base Salary or Wage must be between 1 and 275,000. | Active | 1
BASE_SALARY | ST109 | Error | Base Salary or Wage is mandatory and must not be zero-filled if Employment Status Code is 01,02,04,08,10. | Active | 1
BASE_SALARY | ST198 | Warning | Base Salary or Wage out of min/[NAME] salary schedule. This is a reasonability check. If base salary not provided, salary is computed using standard hours per day (8) x hourly pay rate x contract days. | Active | 1
BIRTH_DATE_STAFF | ST020 | Error | [NAME] is mandatory. | Active | 1
BIRTH_DATE_STAFF | ST021 | Error | Birth Date must be a valid date. | Active | 1
BIRTH_DATE_STAFF | ST094 | Error | Reported Birth Date and Beginning Date indicate staff person began working at district prior to being 14 or after turning 88 years old. | Active | 1
CLASSES_TAUGHT_IN_SUBJECT | ST087 | Error | Number of Classes Taught in Subject must be numeric with no decimal. | Active | 1
CLASSES_TAUGHT_IN_SUBJECT | ST088 | Error | Number of Classes Taught in Subject must be numeric with no decimal. | Active | 1
CLASSES_TAUGHT_IN_SUBJECT | [NAME] | Error | Number of Classes Taught in Subject is mandatory where Staff Classification = 201-206  AND (Grade Level 7th = 1 OR Grade Level 8th =1 OR Grade Level 9th = 1 OR Grade Level 10th = 1 OR Grade Level 11th | Active | 1
CLASSES_TAUGHT_IN_SUBJECT | ST189 | Error | Number of Classes Taught in Subject should be greater than zero and less than 16 | Active | 1
DISTRICT_CODE | ST001 | Error | District Number is invalid. | Inactive | 1
EDID | 99998 | Error | EDID Validation Failed | Active | 1
EDID | ST006 | Error | EDID is invalid.  It cannot be blank or zero-filled, it must be numeric and 8 digits, and it must be in the EDIS system. | Active | 1
EDID | ST045 | Error | EDID in Staff Assignment Association file must match a EDID from the staff file, EDID must be in both files | Active | 1
EDID | ST197 | Warning | Duplicate detail records not allowed. | Active | 1
EMPLOYMENT_STATUS | ST050 | Error | Employment Status Code is an invalid code. | Active | 1
EMPLOYMENT_STATUS | ST097 | Error | Employment Status Code cannot be 10 if Job Class Code is 210 or 407 | Active | 1
END_DATE_OF_ASSIGNMENT | ST288 | Error | Ending Date at School Assignment must be a valid date if provided. | Active | 1
END_DATE_OF_ASSIGNMENT | ST291 | Error | End Date at School Assignment must be after Begin Date at School Assignment | Active | 1
FIRST_NAME_STAFF | [NAME] | Error | First Name is mandatory. | Active | 1
FIRST_NAME_STAFF | ST008 | Error | First Name must contain valid characters (a-z, A-Z, ' ', '-', '.', ''', '/'). | Active | 1
FIRST_NAME_STAFF | ST201 | Error | First Name may only contain one space between name parts (e.g. [NAME]). | Active | 1
GENDER_STAFF | [NAME] | Error | Gender is an invalid gender code. | Active | 1
GRADE_LEVEL_1 | ST074 | Error | Grade Level 1st is an invalid code. | Active | 1
GRADE_LEVEL_1 | ST112 | Error | If Subject Area Code is 0040 than only infant and PK grade levels can be 1. | Active | 1
GRADE_LEVEL_1 | ST141 | Error | Teaching Subject Area 0015, General 7th/8th Grade, is for only 6th, 7th and/or 8th grade teachers. | Active | 1
GRADE_LEVEL_1 | ST171 | Error | Teachers and Paraprofessionals teaching within an Early Childhood or Head Start Program, can only teach preschool students. | Active | 1
GRADE_LEVEL_1 | ST238 | Error | The reported Job class Code is applicable for a secondary setting, please verify for accuracy the grade selected. | Active | 1
GRADE_LEVEL_1 | ST251 | Error | If grade level is marked as infant, no other grade levels can be reported in the same detail record.  A separate detail record must be used for any additional grades. | Active | 1
GRADE_LEVEL_10 | ST083 | Error | [NAME] 10th is an invalid code. | Active | 1
GRADE_LEVEL_10 | ST121 | Error | If Subject Area Code is 0040 than only infant and PK grade levels can be 1. | Active | 1
GRADE_LEVEL_10 | [NAME] | Error | Teaching Subject Area 0015, General 7th/8th Grade, is for only 6th, 7th and/or 8th grade teachers. | Active | 1
GRADE_LEVEL_10 | [NAME] | Error | 10th grade teacher is listed as a PK-5th teacher | Active | 1
GRADE_LEVEL_10 | ST180 | Error | Teachers and Paraprofessionals teaching within an Early Childhood or Head Start Program, can only teach preschool students. | Active | 1
GRADE_LEVEL_10 | ST260 | Error | If grade level is marked as infant, no other grade levels can be reported in the same detail record.  A separate detail record must be used for any additional grades. | Active | 1
GRADE_LEVEL_11 | ST084 | Error | Grade Level 11th is an invalid code. | Active | 1
GRADE_LEVEL_11 | ST122 | Error | If Subject Area Code is 0040 than only infant and PK grade levels can be 1. | Active | 1
GRADE_LEVEL_11 | ST148 | Error | Teaching Subject Area 0015, General 7th/8th Grade, is for only 6th, 7th and/or 8th grade teachers. | Active | 1
GRADE_LEVEL_11 | ST167 | Error | 11th grade teacher is listed as a PK-5th teacher | Active | 1
GRADE_LEVEL_11 | ST181 | Error | Teachers and Paraprofessionals teaching within an Early Childhood or Head Start Program, can only teach preschool students. | Active | 1
GRADE_LEVEL_11 | ST261 | Error | If grade level is marked as infant, no other grade levels can be reported in the same detail record.  A separate detail record must be used for any additional grades. | Active | 1
GRADE_LEVEL_12 | ST085 | Error | [NAME] 12th is an invalid code. | Active | 1
GRADE_LEVEL_12 | ST123 | Error | If Subject Area Code is 0040 than only infant and PK grade levels can be 1. | Active | 1
GRADE_LEVEL_12 | [NAME] | Error | Teaching Subject Area 0015, General 7th/8th Grade, is for only 6th, 7th and/or 8th grade teachers. | Active | 1
GRADE_LEVEL_12 | ST168 | Error | 12th grade teacher is listed as a PK-5th teacher | Active | 1
GRADE_LEVEL_12 | ST182 | Error | Teachers and Paraprofessionals teaching within an Early Childhood or Head Start Program, can only teach preschool students. | Active | 1
GRADE_LEVEL_12 | ST262 | Error | If grade level is marked as infant, no other grade levels can be reported in the same detail record.  A separate detail record must be used for any additional grades. | Active | 1
GRADE_LEVEL_2 | ST075 | Error | [NAME] 2nd is an invalid code. | Active | 1
GRADE_LEVEL_2 | ST113 | Error | If Subject Area Code is 0040 than only infant and PK grade levels can be 1. | Active | 1
GRADE_LEVEL_2 | ST142 | Error | Teaching Subject Area 0015, General 7th/8th Grade, is for only 6th, 7th and/or 8th grade teachers. | Active | 1
GRADE_LEVEL_2 | ST172 | Error | Teachers and Paraprofessionals teaching within an Early Childhood or Head Start Program, can only teach preschool students. | Active | 1
GRADE_LEVEL_2 | ST239 | Error | The reported Job class Code is applicable for a secondary setting, please verify for accuracy the grade selected. | Active | 1
GRADE_LEVEL_2 | ST252 | Error | If grade level is marked as infant, no other grade levels can be reported in the same detail record.  A separate detail record must be used for any additional grades. | Active | 1
GRADE_LEVEL_3 | ST076 | Error | Grade Level 3rd is an invalid code. | Active | 1
GRADE_LEVEL_3 | ST114 | Error | If Subject Area Code is 0040 than only infant and PK grade levels can be 1. | Active | 1
GRADE_LEVEL_3 | [NAME] | Error | Teaching Subject Area 0015, General 7th/8th Grade, is for only 6th, 7th and/or 8th grade teachers. | Active | 1
GRADE_LEVEL_3 | ST173 | Error | Teachers and Paraprofessionals teaching within an Early Childhood or Head Start Program, can only teach preschool students. | Active | 1
GRADE_LEVEL_3 | ST240 | Error | The reported Job class Code is applicable for a secondary setting, please verify for accuracy the grade selected. | Active | 1
GRADE_LEVEL_3 | ST253 | Error | If grade level is marked as infant, no other grade levels can be reported in the same detail record.  A separate detail record must be used for any additional grades. | Active | 1
GRADE_LEVEL_4 | [NAME] | Error | Grade Level 4th is an invalid code. | Active | 1
GRADE_LEVEL_4 | ST115 | Error | If Subject Area Code is 0040 than only infant and PK grade levels can be 1. | Active | 1
GRADE_LEVEL_4 | ST144 | Error | Teaching Subject Area 0015, General 7th/8th Grade, is for only 6th, 7th and/or 8th grade teachers. | Active | 1
GRADE_LEVEL_4 | [NAME] | Error | Teachers and Paraprofessionals teaching within an Early Childhood or Head Start Program, can only teach preschool students. | Active | 1
GRADE_LEVEL_4 | ST241 | Error | The reported Job class Code is applicable for a secondary setting, please verify for accuracy the grade selected. | Active | 1
GRADE_LEVEL_4 | ST254 | Error | If grade level is marked as infant, no other grade levels can be reported in the same detail record.  A separate detail record must be used for any additional grades. | Active | 1
GRADE_LEVEL_5 | ST078 | Error | Grade Level 5th is an invalid code. | Active | 1
GRADE_LEVEL_5 | ST116 | Error | If Subject Area Code is 0040 than only infant and PK grade levels can be 1. | Active | 1
GRADE_LEVEL_5 | ST145 | Error | Teaching Subject Area 0015, General 7th/8th Grade, is for only 6th, 7th and/or 8th grade teachers. | Active | 1
GRADE_LEVEL_5 | ST175 | Error | Teachers and Paraprofessionals teaching within an Early Childhood or Head Start Program, can only teach preschool students. | Active | 1
GRADE_LEVEL_5 | ST242 | Error | The reported Job class Code is applicable for a secondary setting, please verify for accuracy the grade selected. | Active | 1
GRADE_LEVEL_5 | ST255 | Error | If grade level is marked as infant, no other grade levels can be reported in the same detail record.  A separate detail record must be used for any additional grades. | Active | 1
GRADE_LEVEL_6 | ST079 | Error | [NAME] is an invalid code. | Active | 1
GRADE_LEVEL_6 | ST117 | Error | If Subject Area Code is 0040 than only infant and PK grade levels can be 1. | Active | 1
GRADE_LEVEL_6 | ST176 | Error | Teachers and Paraprofessionals teaching within an Early Childhood or Head Start Program, can only teach preschool students. | Active | 1
GRADE_LEVEL_6 | ST243 | Error | The reported Job class Code is applicable for a secondary setting, please verify for accuracy the grade selected. | Active | 1
GRADE_LEVEL_6 | ST256 | Error | If grade level is marked as infant, no other grade levels can be reported in the same detail record.  A separate detail record must be used for any additional grades. | Active | 1
GRADE_LEVEL_7 | ST080 | Error | [NAME] is an invalid code. | Active | 1
GRADE_LEVEL_7 | [NAME] | Error | If Subject Area Code is 0040 than only infant and PK grade levels can be 1. | Active | 1
GRADE_LEVEL_7 | ST163 | Error | 7th grade teacher is listed as a PK-5th teacher | Active | 1
GRADE_LEVEL_7 | ST177 | Error | Teachers and Paraprofessionals teaching within an Early Childhood or Head Start Program, can only teach preschool students. | Active | 1
GRADE_LEVEL_7 | ST257 | Error | If grade level is marked as infant, no other grade levels can be reported in the same detail record.  A separate detail record must be used for any additional grades. | Active | 1
GRADE_LEVEL_8 | ST081 | Error | Grade Level 8th is an invalid code. | Active | 1
GRADE_LEVEL_8 | ST119 | Error | If Subject Area Code is 0040 than only infant and PK grade levels can be 1. | Active | 1
GRADE_LEVEL_8 | ST164 | Error | 8th grade teacher is listed as a PK-5th teacher | Active | 1
GRADE_LEVEL_8 | ST178 | Error | Teachers and Paraprofessionals teaching within an Early Childhood or Head Start Program, can only teach preschool students. | Active | 1
GRADE_LEVEL_8 | [NAME] | Error | If grade level is marked as infant, no other grade levels can be reported in the same detail record.  A separate detail record must be used for any additional grades. | Active | 1
GRADE_LEVEL_9 | ST082 | Error | Grade Level 9th is an invalid code. | Active | 1
GRADE_LEVEL_9 | ST120 | Error | If Subject Area Code is 0040 than only infant and PK grade levels can be 1. | Active | 1
GRADE_LEVEL_9 | ST146 | Error | Teaching Subject Area 0015, General 7th/8th Grade, is for only 6th, 7th and/or 8th grade teachers. | Active | 1
GRADE_LEVEL_9 | ST165 | Error | 9th grade teacher is listed as a PK-5th teacher | Active | 1
GRADE_LEVEL_9 | ST179 | Error | Teachers and Paraprofessionals teaching within an Early Childhood or Head Start Program, can only teach preschool students. | Active | 1
GRADE_LEVEL_9 | ST259 | Error | If grade level is marked as infant, no other grade levels can be reported in the same detail record.  A separate detail record must be used for any additional grades. | Active | 1
GRADE_LEVEL_INFANT | ST071 | Error | Grade Level Infant is an invalid code. | Active | 1
GRADE_LEVEL_INFANT | ST138 | Error | Teaching Subject Area 0015, General 7th/8th Grade, is for only 6th, 7th and/or 8th grade teachers. | Active | 1
GRADE_LEVEL_INFANT | ST161 | Error | All Classroom Instructional Staff must have at least one grade level selected. | Active | 1
GRADE_LEVEL_INFANT | [NAME] | Error | The Grade Level(s) selected does not match the Grade Level(s) for this school. | Inactive | 1
GRADE_LEVEL_INFANT | [NAME] | Error | The reported Job class Code is applicable for a secondary setting, please verify for accuracy the grade selected. | Active | 1
GRADE_LEVEL_K | ST073 | Error | Grade Level K is an invalid code. | Active | 1
GRADE_LEVEL_K | ST111 | Error | If Subject Area Code is 0040 than only infant and PK grade levels can be 1. | Active | 1
GRADE_LEVEL_K | [NAME] | Error | Teaching Subject Area 0015, General 7th/8th Grade, is for only 6th, 7th and/or 8th grade teachers. | Active | 1
GRADE_LEVEL_K | ST170 | Error | Teachers and Paraprofessionals teaching within an Early Childhood or Head Start Program, can only teach preschool students. | Active | 1
GRADE_LEVEL_K | ST237 | Error | The reported Job class Code is applicable for a secondary setting, please verify for accuracy the grade selected. | Active | 1
GRADE_LEVEL_K | [NAME] | Error | If grade level is marked as infant, no other grade levels can be reported in the same detail record.  A separate detail record must be used for any additional grades. | Active | 1
GRADE_LEVEL_PREK | ST072 | Error | Grade Level PK is an invalid code. | Active | 1
GRADE_LEVEL_PREK | ST139 | Error | Teaching Subject Area 0015, General 7th/8th Grade, is for only 6th, 7th and/or 8th grade teachers. | Active | 1
GRADE_LEVEL_PREK | [NAME] | Error | Teachers and Paraprofessionals teaching within an Early Childhood or Head Start Program, can only teach preschool students. | Active | 1
GRADE_LEVEL_PREK | ST232 | Error | Grant/Project Funding Source of 3131 (State Share Special Education Preschool Grant) may only be used for PK grade level. | Active | 1
GRADE_LEVEL_PREK | ST236 | Error | The reported Job class Code is applicable for a secondary setting, please verify for accuracy the grade selected. | Active | 1
GRADE_LEVEL_PREK | ST249 | Error | If grade level is marked as infant, no other grade levels can be reported in the same detail record.  A separate detail record must be used for any additional grades. | Active | 1
GRANT_PROJECT_FUND_STAFF | ST065 | Error | Grant/Project Funding Source is an invalid code. | Active | 1
GRANT_PROJECT_FUND_STAFF | ST160 | Error | Title I teachers should be reported with funding/grant code of 4010, 5010, or 6010 for Title I funds. | Active | 1
GRANT_PROJECT_FUND_STAFF | ST227 | Error | Grant/Project Funding Source of 3131 (State Share Special Education Preschool Grant) may only be used for PK grade level. | Active | 1
HOURLY_RATE_OF_PAY | [NAME] | Error | [NAME] of Pay  must be numeric. | Active | 1
HOURLY_RATE_OF_PAY | ST056 | Error | [NAME] of Pay  must not contain a decimal. | Active | 1
HOURLY_RATE_OF_PAY | ST057 | Error | [NAME] of Pay must be 5 digits. | Active | 1
HOURLY_RATE_OF_PAY | ST102 | Error | [NAME] is mandatory. If Employment Status Code is 01,02,04,08,10. | Active | 1
HOURLY_RATE_OF_PAY | ST103 | Error | [NAME] is invalid.  It must be between mimimum wage and 200 if Employment Status Code is 01,02,04,08,10. | Active | 1
HOURLY_RATE_OF_PAY | ST104 | Error | [NAME] of Pay must be blanks or zero-filled if Base Salary or Wage is not blank or zero-filled. | Active | 1
HOURS_WORKED_PER_DAY | ST053 | Error | Hours per Day must be numeric and not blank or zero-filled. | Active | 1
HOURS_WORKED_PER_DAY | ST054 | Error | Hours per Day must not contain a decimal. | Active | 1
HOURS_WORKED_PER_DAY | [NAME] | Error | Hours Worked per Day is mandatory. If Employment Status Code is 01,02,04,08,10. | Active | 1
HOURS_WORKED_PER_DAY | ST101 | Error | Hours Worked per Day is mandatory. If Employment Status Code is 01,02,04,08,10. | Active | 1
HOURS_WORKED_PER_DAY | ST196 | Warning | Hours Worked per Day for an individual must be between .5 and 10. | Active | 1
HOURS_WORKED_PER_DAY | ST289 | Error | Hours per Day must be numeric and not blank or zero-filled | Active | 1
HOURS_WORKED_PER_DAY | ST290 | Error | Hours per Day must be numeric and not blank or zero-filled | Active | 1
JOB_CLASSIFICATION_CODE | ST061 | Error | Job Class Code is an invalid code. | Active | 1
JOB_CLASSIFICATION_CODE | ST192 | Error | Superintendent must be reported as job code 101 even though multiple assignments are applicable. | Active | 1
JOB_CLASSIFICATION_CODE | ST233 | Error | Job Class Code must be 202 (Teacher) for Administrator/Instructional Area 0032 (Home/Hospital Instruction). | Active | 1
JOB_CLASSIFICATION_CODE | [NAME] | Error | If Administrator/Instructional Area is 0037 Job Class Code must be 202 | Active | 1
JOB_CLASSIFICATION_CODE | ST292 | Error | Special Education Staff who have a JOBCLASS CODE of 416 must have a SUBJECT AREA CODE in the 1700 series | Active | 1
LAST_NAME_STAFF | [NAME] | Error | Last Name is mandatory. | Active | 1
LAST_NAME_STAFF | ST011 | Error | Last Name must contain valid characters (a-z, A-Z, ' ', '-', '.', ''', '/'). | Active | 1
LAST_NAME_STAFF | ST205 | Error | Last Name may only contain one space between name parts (e.g. [NAME]). | Active | 1
NUM_CONTRACT_DAYS | ST051 | Error | Contract Days must be numeric. | Active | 1
NUM_CONTRACT_DAYS | ST052 | Error | Contract Days is required and can't be zero-filled if Employment Status Code is 01, 02, 04, 08, 10 | Active | 1
NUM_CONTRACT_DAYS | [NAME] | Error | Number of Contract Days is mandatory. If Employment Status Code is 01,02,04,08,10. | Active | 1
NUM_CONTRACT_DAYS | ST099 | Error | Number of Contract Days is invalid.  It must be between 1-280 if Employment Status Code is 01,02,04,08,10. | Active | 1
SCHOOL_CODE | ST047 | Error | School Code is an invalid code for the reported district. | Inactive | 1
SCHOOL_CODE | ST048 | Error | School Code is an invalid code. | Active | 1
SCHOOL_CODE | [NAME] | Error | School Code is mandatory. | Active | 1
SCHOOL_CODE | [NAME] | Error | Superintendent/BOCES Director must be reported as district wide (school_code 9980). | Active | 1
SCHOOL_CODE | ST199 | Warning | Teachers are to be assigned to schools and not to 9980. | Active | 1
SCHOOL_CODE | ST214 | Error | School Building Code must be zero-filled for State Operated Programs. | Active | 1
SEMESTER_HOURS_24 | ST086 | Error | 24 Semester Hours is an invalid code. | Active | 1
SEMESTER_HOURS_24 | ST187 | Error | 24 Semester Hours is required for teachers (JOBCLASS_CODE 201-206) who are not general education teachers. | Active | 1
SPED_ASSIGNMENT_FLAG | ST294 | Error | SPED Assignment must be a valid code | Active | 1
SPED_ASSIGNMENT_FLAG | ST296 | Error | Related service providers, coordinators and instructional para's serving preschool in addition to elementary or secondary must have a separate detail record. | Active | 1
START_DATE_OF_ASSIGNMENT | ST286 | Error | Beginning Date at School Assignment must be a valid date. | Active | 1
START_DATE_OF_ASSIGNMENT | ST287 | Error | Beginning Date at School Assignment must be on or prior to current date. | Active | 1
TEACHING_SUBJECT_AREA | ST062 | Error | Teaching Subject Area is an invalid code. | Active | 1
TEACHING_SUBJECT_AREA | ST110 | Error | Teaching Subject Area is mandatory if Job Class Code is 201-206 or 415-419 | Active | 1
TEACHING_SUBJECT_AREA | ST124 | Error | Title I Teachers must list General Education or Core Subject as the Subject Area Code. | Inactive | 1
TEACHING_SUBJECT_AREA | ST125 | Error | Title I funded teachers in a Targeted Assistance program must list 0040 (general preschool education), 0010 (general elementary education), 05xx (English language arts), or 11xx (mathematics) as the Teaching Subject Area. | Active | 1
TEACHING_SUBJECT_AREA | [NAME] | Error | Teachers (job class codes 201-206) need to be assigned to a specific subject, not general education. | Active | 1
TEACHING_SUBJECT_AREA | ST128 | Error | Teaching Subject Area is inappropriate for this Administrator/Instructional Area. | Active | 1
TEACHING_SUBJECT_AREA | ST129 | Error | Teachers (job class code 201-206) who are marked as Even Start should have a Subject Area Code of General Education (0010-0060). | Active | 1
TEACHING_SUBJECT_AREA | ST130 | Error | Teachers (job class codes 201-206) need to be assigned to a specific subject, not general education. | Active | 1
TEACHING_SUBJECT_AREA | ST132 | Error | Teaching Subject Area should be 0510 ([NAME]) if teacher is a general ESL teacher. | Active | 1
TEACHING_SUBJECT_AREA | ST133 | Error | Teaching Subject Area should be 0800-0890 for teachers who are coded with an Administrator/Instructional Area Code of 0014. | Active | 1
TEACHING_SUBJECT_AREA | ST134 | Error | Teaching Subject Area is inappropriate for this Administrator/Instructional Area. | Active | 1
TEACHING_SUBJECT_AREA | ST135 | Error | Teaching Subject Area is inappropriate for this Administrator/Instructional Area. | Active | 1
TEACHING_SUBJECT_AREA | ST136 | Error | Teaching Subject Area is inappropriate for this Administrator/Instructional Area. | Active | 1
TEACHING_SUBJECT_AREA | ST150 | Error | Teaching Subject Area 0015, General 7th/8th Grade, is only for teachers. | Active | 1
TEACHING_SUBJECT_AREA | ST151 | Error | Teachers teaching grades 7th or above must report teaching subject area other than General [NAME]. | Active | 1
TEACHING_SUBJECT_AREA | ST152 | Error | Teachers teaching grades 6th and above and not [NAME] must list a teaching subject area other than General [NAME]. | Active | 1
TEACHING_SUBJECT_AREA | [NAME] | Error | Teaching subject area cannot be used in combination with the administrative/instructional area code used. | Inactive | 1
TEACHING_SUBJECT_AREA | ST158 | Error | Program Area Codes [NAME], 0026, or [NAME], 0037, may be more appropriate. | Active | 1
TEACHING_SUBJECT_AREA | ST216 | Error | Teaching Subject Area 0070, Co-Alt Only, is only for teachers (Job Class Code 202). | Active | 1
TEACHING_SUBJECT_AREA | ST218 | Error | Home/Hospital teachers must be reported as teaching general special education (Teaching Subject Area Code 1700). | Active | 1
TEACHING_SUBJECT_AREA | ST220 | Error | Teachers providing transitional services must be reported as teaching general special education (Teaching Subject Area Code 1700). | Active | 1
TEACHING_SUBJECT_AREA | ST225 | Error | For Preschool special education teachers Teaching Subject Area must be 1791 and Administrator/Instructional Area must be 0035. | Active | 1
TEACHING_SUBJECT_AREA | ST293 | Error | Special Education Staff who have a JOBCLASS CODE  of 416 must have a SUBJECT AREA CODE  in the 1700 series | Active | 1
YEARS_PRINCIPAL_AT_SCHOOL | ST070 | Error | Years Principal at this School must be numeric. | Active | 1
YEARS_PRINCIPAL_AT_SCHOOL | ST183 | Error | Years Principal at this School is required for Principals (jobclass code 105) or [NAME] serving as [NAME] (2410). | Active | 1
YEARS_PRINCIPAL_AT_SCHOOL | ST184 | Error | Years Principal at this School does not match years employed at this district. | Active | 1
YEARS_PRINCIPAL_AT_SCHOOL | ST185 | Error | Years Principal at this School should be less than or equal to the years employed at the district. | Active | 1
YEARS_PRINCIPAL_AT_SCHOOL | ST186 | Error | Years Principal at this School should increment by one from the previous year. | Active | 1