Spreadsheet: 1532263b-b909-492c-a526-81fe87bb7cb6
Sheet: Page1_1

 |  |  | Colorado Department of Education |  |  | Page: 1
 |  |  | Business Rules
School Year: | 2013-14 | Dataset: | Report Card | File Type: | Report Card
Data Element Name | Error/Warning Code | Error Type | Message | Status | Tier | Last Updated User | Last Updated Date
ADVANCED_PLACEMENT | [NAME] | Error | Advanced Placement Flag must be a valid code. | Active | 1
ADVANCED_PLACEMENT | RC028 | Error | Advanced Placement Flag must be No (0) for schools that do not serve grades 10-12. | Active | 1
ASSISTANCE_YOUTH_ENROLL | RC039 | Error | Assistance of Out-of-School Youth to Re-Enroll Flag must be a valid code. | Active | 1
ASSISTANCE_YOUTH_ENROLL | RC040 | Error | Assistance of Out-of-School Youth to Re-Enroll Flag must be No (0) for schools that do not serve grades 7-12. | Active | 1
ATHLETICS | [NAME] | Error | Athletics Flag must be a valid code. | Active | 1
BEFORE_AFTER_CARE | RC008 | Error | Before and After School Care Programs Flag must be a valid code. | Active | 1
BEFORE_AFTER_CARE | RC009 | Error | Before and After School Care Programs Flag must be No (0) for schools that do not serve grades PK-5. | Active | 1
CAREER_TECHNOLOGY_ED | RC021 | Error | Career and?Technical Education Flag must be a valid code. | Active | 1
CAREER_TECHNOLOGY_ED | RC022 | Error | Career and Technical Education Flag must be No (0) for schools that do not serve grades 7-12. | Active | 1
CIVICS | RC020 | Error | Civics Flag must be a valid code. | Active | 1 | [EMAIL] | 2012-12-10 00:00:00
COMMUNITY_ENGAGEMENT | RC025 | Error | Opportunities for Civic or Community Engagement Flag must be a valid code. | Active | 1
COMPREHENSIVE_HEALTH_ED | RC015 | Error | Comprehensive Health Education Flag must be a valid code. | Active | 1 | [EMAIL] | 2012-12-10 00:00:00
CONCURRENT_ENROLLMENT | RC023 | Error | Concurrent Enrollment Classes on School Property Flag | Active | 1 | [EMAIL] | 2012-12-10 00:00:00
CONCURRENT_ENROLLMENT | RC024 | Error | Concurrent Enrollment Classes on School Property Flag must be No (0) for schools that do not serve grades 10-12. | Active | 1
CREDIT_RECOVERY_PROGRAM | RC037 | Error | Credit Recovery Programs Flag must be a valid code. | Active | 1
CREDIT_RECOVERY_PROGRAM | RC038 | Error | Credit Recovery Programs Flag must be No (0) for schools that do not serve grades 7-12. | Active | 1
DANCE | RC013 | Error | [NAME] must be a valid code. | Active | 1
DISTRICT_CODE | RC001 | Error | District Code must be a valid code. | Active | 1
DISTRICT_CODE | RC054 | Error | The entered district code value is not consistent with the district code for which the data was uploaded.  Please correct the district code. | Active | 1
DRAMA_THEATER | RC011 | Error | Drama or Theatre Flag must be a valid code. | Active | 1
[NAME] | RC016 | Error | Economics Flag must be a valid code. | Active | 1
EXTRACIRRICULAR_ACTIVITIES | RC034 | Error | Extracurricular Activities Flag must be a valid code. | Active | 1
FEDERAL_BREAKFAST_PROGRAM | RC046 | Error | Uses Federal School Breakfast Program in Classroom Flag must be a valid code. | Active | 1
FULL_DAY_KG | RC006 | Error | Full-Day Kindergarten Flag must be a valid code. | Active | 1
FULL_DAY_KG | [NAME] | Error | Full-Day Kindergarten Flag must be No (0) for schools that do not serve grades PK-5. | Active | 1
GEOGRAPHY | RC019 | Error | Geography Flag must be a valid code. | Active | 1
HISTORY | RC018 | Error | History Flag must be a valid code. | Active | 1
HONORS_COURSES | [NAME] | Error | Honors Courses Flag must be a valid code. | Active | 1
HONORS_COURSES | [NAME] | Error | Honors Courses Flag must be No (0) for schools that do not serve grades 10-12. | Active | 1
INTERNATIONAL_BACCALAUREATE | RC029 | Error | International Baccalaureate Flag must be a valid code. | Active | 1
INTERNET_SAFETY | RC026 | Error | Internet Safety Programs Flag must be a valid code. | Active | 1
[NAME] | RC036 | Error | [NAME] must be a valid code. | Active | 1
LICENSED_SCHOOL_NURSE | RC047 | Error | CDE Licensed School Nurse is Available During School Hours Flag must be a valid code. | Active | 1
MONTESSORI_CURRICULA | RC032 | Error | Montessori [NAME] must be a valid code. | Active | 1
MONTESSORI_CURRICULA | RC033 | Error | Montessori [NAME] must be No (0) for schools that do not serve grades PK-5. | Active | 1
MUSIC | RC012 | Error | Music Flag must be a valid code. | Active | 1
PHYSICAL_ACTIVITY | RC041 | Error | Physical Activity Flag must be a valid code. | Active | 1
[NAME] | RC014 | Error | Physical Education Flag must be a valid code. | Active | 1
PRESCHOOL_PROGRAM | RC004 | Error | Preschool Program Flag must be a valid code. | Active | 1
PRESCHOOL_PROGRAM | RC005 | Error | Preschool Program Flag must be No (0) for schools that do not serve grades PK-5. | Active | 1
PROFESSIONAL_DEVELOPMENT | RC048 | Error | Professional Development Days must be type numeric. | Active | 1
PROFESSIONAL_DEVELOPMENT | RC049 | Error | Professional Development Days is mandatory. | Active | 1 | [EMAIL] | 2013-03-06 01:20:51.999000
PROFESSIONAL_DEVELOPMENT | RC050 | Warning | Warning: Professional Development days is greater than 14 days. | Active | 1 | [EMAIL] | 2013-03-06 01:08:35.999000
PROFESSIONAL_DEVELOPMENT | RC055 | Error | Professional Developme days must be a numeric value.  You may use decimal places to report a half day but no other decimals are allowed. | Active | 1 | NULL
REQUIRED_COMPREHENSIVE_HEALTH | RC045 | Error | Comprehensive Health Education Required for all Students Flag must be a valid code. | Active | 1
REQUIRED_PHYSICAL_EDUCATION | [NAME] | Error | Physical Education Required for all Students Flag must be a valid code. | Active | 1
SCHOOL_CODE | [NAME] | Error | School Code must be a valid code. | Active | 1 | [EMAIL] | 2013-02-11 22:54:14.999000
SCHOOL_CODE | [NAME] | Error | You may only submit one record for a school per batch. | Active | 1
SCHOOL_CODE | [NAME] | Error | The school does not exist as part of the CDE Directory.  If this is a valid school that should be added to Report Card March then contact CDE. | Active | 1
SCHOOL_CODE | RC053 | Error | There must be at least one program marked for this school.  All program codes cannot be zero-filled | Active | 1
SCHOOL_HEALTH_CENTER | RC043 | Error | School Based Health Center Flag must be a valid code. | Active | 1
SCHOOL_HEALTH_TEAM | RC042 | Error | School Health Team of School Wellness Committee Flag must be a valid code. | Active | 1
VISUAL_ARTS | [NAME] | Error | Visual Art Flag must be a valid code. | Active | 1
WORLD_LANGUAGES | RC017 | Error | World Languages Flag must be a valid code. | Active | 1
YEAR_ROUND | [NAME] | Error | Year Round Flag must be a valid code. | Active | 1