Spreadsheet: 44ee2b2f-81b4-44b0-966a-9299a34113fe
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Colorado Department of Education | Unnamed: 4 | Unnamed: 5 | Page: 1
 |  |  | Business Rules
School Year: | 2013-14 | Dataset: | Staff Profile & Assignments | File Type: | Staff
Data Element Name | Error/Warning Code | Error Type | Message | Status | Tier
ADMIN_UNIT_CODE | ST285 | Error | Admin Unit/SOP code must be a valid code | Active | 1
BIRTH_DATE_STAFF | ST020 | Error | Date of Birth is mandatory. | Active | 1
BIRTH_DATE_STAFF | ST021 | Error | Date of Birth must be a valid date. | Active | 1
BIRTH_DATE_STAFF | ST091 | Error | Age of the individual must be between 18 and 88. | Active | 1
CORE_CONTENT_OUTSIDE_CO | ST090 | Error | State Core Content Test Administered (outside of Colorado) is an invalid code. | Active | 1
DEGREE_INSTITUTION_CODE | ST024 | Error | Institution Code is an invalid code. | Active | 1
DEGREE_STATE_CODE | ST025 | Error | State Code is an invalid code. | Active | 1
DISTRICT_BEGIN_DATE_STAFF | ST030 | Error | Beginning Date at School District is mandatory. | Active | 1
DISTRICT_BEGIN_DATE_STAFF | ST031 | Error | Beginning Date at School District must be a valid date. | Active | 1
DISTRICT_BEGIN_DATE_STAFF | ST295 | Error | End Date at Disctrict must be after Begin Date at District | Active | 1
DISTRICT_CODE | ST001 | Error | District Number is invalid. | Active | 1
DISTRICT_OF_RESIDENCE_STAFF | ST022 | Error | District of Residence is an invalid district or state code. | Active | 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
ETHNICITY_STAFF | ST012 | Error | Ethnicity: Hispanic or Latino is invalid. | 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 | ST096 | Warning | Possible duplicate header records (first name, last name, birth date). | Active | 1
FIRST_NAME_STAFF | ST202 | Error | First Name may only contain one space between name parts (e.g. [NAME]). | Active | 1
GENDER_STAFF | [NAME] | Error | Sex is an invalid gender code. | Active | 1
HIGHEST_LEVEL_EDUCATION_COMP | ST023 | Error | Education Level is an invalid code. | 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
MIDDLE_NAME_STAFF | ST009 | Error | Middle Name must contain valid characters (a-z, A-Z, ' ', '-', '.', ''', '/'). | Active | 1
MIDDLE_NAME_STAFF | ST203 | Error | Middle Name is required.  Use NMN if staff does not have a middle name | Active | 1
MIDDLE_NAME_STAFF | ST204 | Error | Middle Name may only contain one space between name parts (e.g. [NAME]). | Active | 1
OVERALL_RATING_PRINCIPAL | ST044 | Error | Principal Overall Performance Evaluation Rating is an invalid code. | Active | 1
OVERALL_RATING_TEACHER | ST043 | Error | Teacher Overall Performance Evaluation Rating is an invalid code. | Active | 1
PASSED_ELM_CORE_CONTENT_TEST | ST089 | Error | Passed an Out of State [NAME] or Early Childhood Core Content Test is an invalid code. | Active | 1
PASSED_PARAPRO_TEST | ST039 | Error | Passed Paraprofessional Test is an invalid code. | Active | 1
RACE_ASIAN_STAFF | ST014 | Error | [NAME] is invalid. | Active | 1
RACE_BLACK_STAFF | ST015 | Error | Race Black or African American is invalid. | Active | 1
RACE_HAWAIIAN_STAFF | ST017 | Error | [NAME] or other Pacific Islander is invalid. | Active | 1
RACE_INDIAN_STAFF | ST013 | Error | Race American Indian is invalid. | Active | 1
RACE_INDIAN_STAFF | ST095 | Error | The five race fields ("Race:  American Indian", "Race:  Asian", "Race:  Black", "Race:  White", and "Race:  Pacific Islander") cannot all = 0 (no).  At least one race category must not equal 0. | Active | 1
RACE_WHITE_STAFF | ST016 | Error | [NAME] is invalid. | Active | 1
SSN_STAFF | ST002 | Error | SSN is mandatory. | Active | 1
SSN_STAFF | ST003 | Error | SSN cannot be zero-filled. | Active | 1
SSN_STAFF | ST004 | Error | SSN must be numeric. | Active | 1
SSN_STAFF | ST005 | Error | SSN must be 9 digits. | Active | 1
SUBJECT_AREA_OF_DEGREE_1 | ST033 | Error | Subject Area of Degree 1 is an invalid code. | Active | 1
SUBJECT_AREA_OF_DEGREE_2 | ST034 | Error | Subject Area of Degree 2 is an invalid code. | Active | 1
SUBJECT_AREA_OF_DEGREE_3 | ST035 | Error | Subject Area of Degree 3 is an invalid code. | Active | 1
SUBJECT_AREA_OF_DEGREE_4 | ST036 | Error | Subject Area of Degree 4 is an invalid code. | Active | 1
SUBJECT_AREA_OF_DEGREE_5 | ST037 | Error | Subject Area of Degree 5 is an invalid code. | Active | 1
TEACHER_PROBATIONARY_STATUS | ST040 | Error | Teacher [NAME] is an invalid code. | Active | 1
YEARS_EDUCATION_EXP_CO | ST028 | Error | Years Education Experience Instate must be numeric. | Active | 1
YEARS_EDUCATION_EXP_NON_CO | ST029 | Error | Years Education Experience Out of State must be numeric. | Active | 1
YEARS_PRINCIPAL_AT_ANY_SCHOOL | ST038 | Error | Years Principal at any School must be numeric. | Active | 1
YEARS_TEACHING_EXP_CO | ST026 | Error | Years Teaching Instate must be numeric. | Active | 1
YEARS_TEACHING_EXP_CO | ST092 | Error | Years of Teaching Experience Instate must be less than or equal to Years of  Education Experience Instate. | Active | 1
YEARS_TEACHING_EXP_NON_CO | [NAME] | Error | Years Teaching Out of State must be numeric. | Active | 1
YEARS_TEACHING_EXP_NON_CO | ST093 | Error | Years of Teaching Experience Out of State must be less than or equal to Years of  Education Experience Out of State. | Active | 1