Spreadsheet: 0fb7e9cc-8e01-430a-a940-c73492e37235
Sheet: Business Rule READ File

Business Rule
POSTED: 5/1/14   School Year - 13-14      Data Set : READ     BUSINESS RULES
 | Data Element | Error Type | Error Code | Error Message
1 | DISTRICT_CODE | Error | RD001 | District Code is required and must be a valid School District/BOCES Code. Refer to School District/BOCES Codes Table.
2 | SCHOOL_CODE | Error | RD002 | School Code is required and must be a valid Public School Code for the reporting district/BOCES. Refer to School Building Code Table.
3 | GENDER_STUDENT | Error | RD003 | Student's Gender is an invalid code.
4 | BIRTH_DATE_STUDENT | Error | RD004 | Student's Date of Birth must be a valid date in MMDDYYYY format.
5 | ENTRY_GRADE_LEVEL | Error | [NAME] | A corresponding record could not be found in the Student School Association file of the Student Profile interchange for your district.  Please ensure the record exists and save the record from the Edit Record screen or upload the data again to update Entry Grade Level.
6 | STUDENT_STATUS_READ | Error | RD006 | Student READ Status must be reported using a valid code. Refer to Colorado READ Act Data Elements and Definitions.
7 | TEST_READ | Error | [NAME] | READ Test must be reported using a valid code. Refer to Colorado READ Act Data Elements and Definitions
8 | TESTING_ACCOMMODATIONS_READ | Error | RD008 | READ - Allowable Testing Accommodations must be reported using a valid code. Refer to Colorado READ Act Data Elements and Definitions.
9 | TEST_DATE_READ | Error | RD009 | Test date must be valid for the current school year (ex: MMDDYYYY)
10 | RECOMMEND_RETENTION_READ | Error | [NAME] | Recommended Retention code must be a valid code, 0 if not applicable. Refer to READ data elements and definitions.
11 | RETAINED_READ | Error | RD011 | Retention code must be a valid code, 0 if not applicable. Refer to READ data elements and definitions.
12 | [NAME] | Error | RD012 | Per-Pupil Funding Code (Full-Day Kindergarten) must be a valid code, 0 if not applicable. Refer to READ data elements and definitions.
13 | SUMMER_SCHOOL_READ | Error | RD013 | Per-Pupil Funding Code (Summer School) must be a valid code, 0 if not applicable. Refer to READ data elements and definitions.
14 | TUTOR_READ | Error | [NAME] | Per-Pupil Funding Code (Tutoring) must be a valid code, 0 if not applicable. Refer to READ data elements and definitions.
15 | INTERVENTION_SERVICES_READ | Error | RD015 | Per-Pupil Funding Code (Other Targeted Scientifically Based or Evidence Based Intervention Services) must be a valid code, 0 if not applicable. Refer to READ data elements and definitions.
16 | SASID | Error | RD016 | SASID cannot be duplicated.
17 | LAST_NAME_STUDENT | Error | RD017 | Student's Last Name is mandatory
18 | FIRST_NAME_STUDENT | Error | RD018 | Student's First Name is mandatory
19 | BIRTH_DATE_STUDENT | Error | RD019 | Student's age must be greater than or equal to 4 and less than or equal to 20 as of 10/01 of the current school year.
20 | ENTRY_GRADE_LEVEL | Warning | RD020 | [NAME] is outside the expected range based on the student's age.
21 | STUDENT_STATUS_READ | Error | RD021 | Student READ Status cannot be 3 (CoAlt) for K-3 students who were not part of December 1 Special Education count, unless the student is on the Special Education exemption list.
22 | STUDENT_STATUS_READ | Error | RD022 | Student READ Status must be 1 or 2 if prior year READ 3rd Grade Cohort Group=1 (yes) in any district.
23 | STUDENT_STATUS_READ | Warning | RD023 | Student READ Status is 2 in the current year, but not in the prior year in any district.
24 | STUDENT_STATUS_READ | Warning | RD024 | Student READ Status was 2 in the prior year, but not in the current year in any district.
25 | STUDENT_STATUS_READ | Error | [NAME] | These K-3 students were indicated as continuing in your district based on prior year EOY data but they do not show a READ status for the current year.
26 | TEST_READ | Error | RD026 | READ Test cannot be 00 if the student’s [NAME] is kindergarten through 3rd grade
27 | TEST_READ | Error | RD027 | READ Test must be 00 if the student's grade level is 4th through 12th.
28 | TEST_READ | Error | RD028 | READ Test cannot equal 04 (Exception - New English Language Learner) in the current year if the student has an entry date in the prior year before May 1.
29 | TEST_READ | Error | RD029 | READ Test cannot equal 05 (Exception – Special Education) in the current year if student was not included in special education December count.
30 | TEST_READ | Error | [NAME] | READ Test = 06 (Exception: Student has part-time attendance status), then Grade Level must equal 006, 007, 010, 020, or 030 AND October 1 Public School Finance Act Funding Status for the reported school year must = 82, 85, 86, 93, 94, 95 or 96.
31 | TEST_READ | Warning | RD031 | These K-3 students were indicated as continuing in your district based on prior year EOY data but they do not show a READ test for the current year.
32 | SCORE_READ | Error | RD032 | READ Score must be 0001 through 0040, or AAAA if READ Test = 01 (DRA2). Code AAAA is used to report students who took the Level A DRA-2 test and did not advance to the next level on the assessment.
33 | SCORE_READ | Error | RD033 | READ Score must be 0000 through 0299 if READ Test = 02 (DIBELS 6th edition).
34 | SCORE_READ | Error | RD034 | READ Score must be 0000 through 0102 if READ Test = 03 (PALS).
35 | SCORE_READ | Error | RD035 | READ Score must be 0000 through 0812 if READ Test = 07 (DIBELS 7th edition).
36 | SCORE_READ | Warning | RD036 | Warning: More than 20 percent of the K-3 students with READ Test = 02, 03 or 07 have READ Score = 0000. Note: Only applies to schools with grades K, 1, 2, and/or 3.
37 | SCORE_READ | Warning | [NAME] | WARNING: More than 20 percent of K-3 students have READ Score equal to 9999.
38 | SCORE_READ | Error | RD038 | If READ test is 04 score must be 9999 and READ status must be 0
39 | SCORE_READ | Warning | RD039 | WARNING: These K-3 students were indicated as continuing in your district based on prior year EOY data but they do not show a READ score for the current year.
40 | TESTING_ACCOMMODATIONS_READ | Warning | RD040 | WARNING – If more than 5% of K-3 students have READ Allowable Testing Accommodations = 1 (Yes – student was provided allowable accommodations).
41 | TESTING_ACCOMMODATIONS_READ | Error | RD041 | READ Allowable Testing Accommodations must be ‘0’ if READ test is ‘00’, ‘04’, ‘05’, ’06.’
42 | TEST_DATE_READ | Error | RD042 | Test date must be between 04/01/(current school year) and 06/15/(current school year).
43 | RECOMMEND_RETENTION_READ | Error | RD043 | Recommended Retention code must equal 0 (no) or 1 (yes) if READ Status=2.
44 | RETAINED_READ | Error | RD044 | Current year grade level must equal prior year grade level if prior year retention code = 1 (yes)
45 | RETAINED_READ | Warning | RD045 | Current grade level equal prior year’s grade+1 if prior year retention code=0 (no).
46 | RETAINED_READ | Error | [NAME] | Retention code may equal 1 (yes) only if recommended retention=1 (yes)
47 | RETAINED_READ | Error | RD047 | Retention code must equal 0 (no) or 1 (yes) if READ Status=2.
48 | RETAINED_READ | Warning | RD048 | Warning: If prior year retention code=1 (yes) in any district
49 | SCORE_READ | Error | RD049 | If Grade Level equals 040, 050, 060, 070, 080, 090, 100, 110, or 120, then READ Score must be 9999
50 | RECOMMEND_RETENTION_READ | Error | RD050 | If Read Status = 0, 1, 3, 4, 5 then Recommended Retention must be 2.
51 | RETAINED_READ | Error | RD051 | If Read Status = 0, 1, 3, 4, 5 then Retention must be 2.
52 | ENTRY_GRADE_LEVEL | Error | [NAME] | [NAME] must be valid grade for the School and Year being reported
53 | [NAME] | Error | RD053 | Per-Pupil Funding Code (Full-Day Kindergarten) may equal 2 (yes) only if grade level=007.
54 | DISTRICT_CODE | Error | RD054 | District Code must match the district code against which the data was uploaded.
55 | SCORE_READ | Warning | RD055 | Warning: More than 20 percent of the K-3 students with READ Test = 01 have READ Score = AAA. Note: Only applies to schools with grades K, 1, 2, and/or 3.
56 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must = 1 if Read score >= 0081 and Grade Level 006 or 007 and Read Test = 03
57 | STUDENT_STATUS_READ | Error | RD057 | Read Status must = 2 or 4  if Read score < 0081 and Grade Level 006 or 007 and Read Test = 03
58 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must = 1 if Grade Level 0010 and Read Test = 03 and Read Score  >= 035
59 | STUDENT_STATUS_READ | Error | RD059 | Read Status must = 2 or 4 if Grade Level 0010 and Read Test = 03 and Read Score <0035
60 | STUDENT_STATUS_READ | Error | RD060 | Read Status must = 1 if Grade Level 020 and Read Test = 03 and Read Score  >= 0054
61 | STUDENT_STATUS_READ | Error | RD061 | Read Status must = 2 or 4 if Grade Level 020 and Read Test = 03 and Read Score < 0054
62 | STUDENT_STATUS_READ | Error | RD062 | Read Status must = 1 if Grade Level 030 and Read Test = 03 and Read Score  >= 0065
63 | STUDENT_STATUS_READ | Error | RD063 | Read Status  must = 2 or 4 if Grade Level 030 and Read Test = 03 and Read Score < 0065
64 | STUDENT_STATUS_READ | Error | RD064 | Read status must be 1 if  Grade Level 006 or 007 and Read Test = 01 and READ Score >= '0010'
65 | STUDENT_STATUS_READ | Error | RD065 | Read Status must be 2 or 4 if Grade Level 006 or 007 and Read Test = 01 and READ score is 'AAAA'
66 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must be 1 if Grade Level 010 and Read Test = 01 and Read Score > 0010
67 | STUDENT_STATUS_READ | Error | RD067 | Read Status must be 2 or 4 if Grade Level 010 and Read Test = 01 and Read Score <= 0010 or = 'AAAA'
68 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must be 1, if Grade Level 020 and Read Test = 01 and Read Score > '0018'
69 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must be 2 or 4, if Grade Level 020 and Read Test = 01 and Read Score <= '0018' or 'AAAA'
70 | STUDENT_STATUS_READ | Error | RD070 | Read Status must be 1, if [NAME] 030 and Read Test = 01 and Read Score > '0028'
71 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must be 2 or 4, if [NAME] 030 and Read Test = 01 and Read Score <= '0028' or 'AAAA'
72 | STUDENT_STATUS_READ | Error | RD072 | Read status must be 1 if  Grade Level 006 or 007 and Read Test = 02 and READ Score > '0014'
73 | STUDENT_STATUS_READ | Error | RD073 | Read Status must be 2 or 4 if Grade Level 006 or 007 and Read Test = 02 and READ score is <= '0014'
74 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must be 1 if Grade Level 010 and Read Test = 02 and Read Score > 0019
75 | STUDENT_STATUS_READ | Error | RD075 | Read Status must be 2 or 4 if Grade Level 010 and Read Test = 02 and Read Score <= 0019
76 | STUDENT_STATUS_READ | Error | RD076 | Read Status must be 1, if Grade Level 020 and Read Test = 02 and Read Score > '0069'
77 | STUDENT_STATUS_READ | Error | RD077 | Read Status must be 2 or 4, if Grade Level 020 and Read Test = 02 and Read Score <= '0069'
78 | STUDENT_STATUS_READ | Error | RD078 | Read Status must be 1, if [NAME] 030 and Read Test = 02 and Read Score > '0070'
79 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must be 2 or 4, if [NAME] 030 and Read Test = 02 and Read Score <= '0079'
80 | STUDENT_STATUS_READ | Error | [NAME] | Read status must be 1 if  Grade Level 006 or 007 and Read Test = 07 and READ Score > '0088'
81 | STUDENT_STATUS_READ | Error | RD081 | Read Status must be 2 or 4 if Grade Level 006 or 007 and Read Test = 07 and READ score is <= '0088'
82 | STUDENT_STATUS_READ | Error | RD082 | Read Status must be 1 if Grade Level 010 and Read Test = 07 and Read Score > 0110
83 | STUDENT_STATUS_READ | Error | RD083 | Read Status must be 2 or 4 if Grade Level 010 and Read Test = 07 and Read Score <= 0110
84 | STUDENT_STATUS_READ | Error | RD084 | Read Status must be 1, if Grade Level 020 and Read Test = 07 and Read Score > '0179'
85 | STUDENT_STATUS_READ | Error | RD085 | Read Status must be 2 or 4, if Grade Level 020 and Read Test = 07 and Read Score <= '0179'
86 | STUDENT_STATUS_READ | Error | RD086 | Read Status must be 1, if [NAME] 030 and Read Test = 07 and Read Score > '0279'
87 | STUDENT_STATUS_READ | Error | RD087 | Read Status must be 2 or 4, if [NAME] 030 and Read Test = 07 and Read Score <= '0279'
88 | ENTRY_GRADE_LEVEL | Error | [NAME] | A student in grades 4-12 may not be reported if prior year READ Cohort=0 in any district
89 | SCORE_READ | Error | RD089 | If Read Test is 05, Read Score must be 9999 and Read Status Code must be 0 or 3
90 | SASID | Error | RD090 | SASID and Last Name, First Name, DOB, Gender must match to RITS
91 | SASID | Error | RD091 | SASID Required
92 | SASID | Error | [NAME] | SASID must be numeric and valid SASID as reported in RITS
93 | SCORE_READ | Error | RD093 | READ Score must be 0000 through 0298 if READ Test =08 (Aims Web)
94 | STUDENT_STATUS_READ | Error | RD094 | Read status must be 1 if  Grade Level 006 or 007 and Read Test = 08 and READ Score > = '0022'
95 | STUDENT_STATUS_READ | Error | RD095 | Read Status must be 2 or 4 if Grade Level 006 or 007 and Read Test = 08 and READ score is < '0022'
96 | STUDENT_STATUS_READ | Error | RD096 | Read Status must be 1 if Grade Level 010 and Read Test = 08 and Read Score > = 0024
97 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must be 2 or 4 if Grade Level 010 and Read Test = 08 and Read Score < 0024
98 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must be 1, if Grade Level 020 and Read Test = 08 and Read Score > = '0061'
99 | STUDENT_STATUS_READ | Error | RD099 | Read Status must be 2 or 4, if Grade Level 020 and Read Test = 08 and Read Score < '0061'
100 | STUDENT_STATUS_READ | Error | RD100 | Read Status must be 1, if [NAME] 030 and Read Test = 08 and Read Score > = '0083'
101 | STUDENT_STATUS_READ | Error | RD101 | Read Status must be 2 or 4, if [NAME] 030 and Read Test = 08 and Read Score < '0083'
102 | SCORE_READ | Error | RD102 | READ Score must be 0359 through 0650 if READ Test = 09 (FAST)
103 | STUDENT_STATUS_READ | Error | RD103 | Read status must be 1 if  Grade Level 006 or 007 and Read Test = 09 and READ Score > '0399'
104 | STUDENT_STATUS_READ | Error | RD104 | Read Status must be 2 or 4 if Grade Level 006 or 007 and Read Test = 09 and READ score is <= '0399'
105 | STUDENT_STATUS_READ | Error | RD105 | Read Status must be 1 if Grade Level 010 and Read Test = 09 and Read Score > 0440
106 | STUDENT_STATUS_READ | Error | RD106 | Read Status must be 2 or 4 if Grade Level 010 and Read Test = 09 and Read Score <= 0440
107 | STUDENT_STATUS_READ | Error | RD107 | Read Status must be 1, if Grade Level 020 and Read Test = 09 and Read Score > '0463'
108 | STUDENT_STATUS_READ | Error | RD108 | Read Status must be 2 or 4, if Grade Level 020 and Read Test = 09 and Read Score <= '0463'
109 | STUDENT_STATUS_READ | Error | RD109 | Read Status must be 1, if [NAME] 030 and Read Test = 09 and Read Score > '0471'
110 | STUDENT_STATUS_READ | Error | RD110 | Read Status must be 2 or 4, if [NAME] 030 and Read Test = 09 and Read Score <= '0471'
111 | SCORE_READ | Error | RD111 | READ Score must be 0100 through 0800 if READ Test  = 10 (iReady)
112 | STUDENT_STATUS_READ | Error | RD112 | Read status must be 1 if  Grade Level 006 or 007 and Read Test = 10 and READ Score > = '0361'
113 | STUDENT_STATUS_READ | Error | RD113 | Read Status must be 2 or 4 if Grade Level 006 or 007 and Read Test = 10 and READ score is < '0361'
114 | STUDENT_STATUS_READ | Error | RD114 | Read Status must be 1 if Grade Level 010 and Read Test = 10 and Read Score > = 0408
115 | STUDENT_STATUS_READ | Error | RD115 | Read Status must be 2 or 4 if Grade Level 010 and Read Test = 10 and Read Score < 0408
116 | STUDENT_STATUS_READ | Error | RD116 | Read Status must be 1, if Grade Level 020 and Read Test = 10 and Read Score > = '0448'
117 | STUDENT_STATUS_READ | Error | RD117 | Read Status must be 2 or 4, if Grade Level 020 and Read Test = 10 and Read Score < '0448'
118 | STUDENT_STATUS_READ | Error | RD118 | Read Status must be 1, if [NAME] 030 and Read Test = 10 and Read Score > = '0480'
119 | STUDENT_STATUS_READ | Error | RD119 | Read Status must be 2 or 4, if [NAME] 030 and Read Test = 10 and Read Score < '0480'
120 | SCORE_READ | Error | RD120 | READ Score must be 0139-0330 if READ Test = 11 (ISIP)
121 | STUDENT_STATUS_READ | Error | RD121 | Read status must be 1 if  Grade Level 006 or 007 and Read Test = 11 and READ Score > '0195'
122 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must be 2 or 4 if Grade Level 006 or 007 and Read Test = 11 and READ score is <= '0195'
123 | STUDENT_STATUS_READ | Error | RD123 | Read Status must be 1 if Grade Level 010 and Read Test = 11 and Read Score > 0217
124 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must be 2 or 4 if Grade Level 010 and Read Test = 11 and Read Score <= 0217
125 | STUDENT_STATUS_READ | Error | RD125 | Read Status must be 1, if Grade Level 020 and Read Test = 11 and Read Score > '0232'
126 | STUDENT_STATUS_READ | Error | RD126 | Read Status must be 2 or 4, if Grade Level 020 and Read Test = 11 and Read Score <= '0232'
127 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must be 1, if [NAME] 030 and Read Test = 11 and Read Score > '0241'
128 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must be 2 or 4, if [NAME] 030 and Read Test = 11 and Read Score <= '0241'
129 | SCORE_READ | Error | RD129 | READ Score must be 0000 through 1400 if READ Test = 12 (STAR)
130 | STUDENT_STATUS_READ | Error | RD130 | Read status must be 1 if  Grade Level 006 or 007 and Read Test = 12 and READ Score > '0739'
131 | STUDENT_STATUS_READ | Error | RD131 | Read Status must be 2 or 4 if Grade Level 006 or 007 and Read Test = 12 and READ score is <= '0739'
132 | STUDENT_STATUS_READ | Error | RD132 | Read Status must be 1 if Grade Level 010 and Read Test = 12 and Read Score > 0794
133 | STUDENT_STATUS_READ | Error | RD133 | Read Status must be 2 or 4 if Grade Level 010 and Read Test = 12 and Read Score <= 0794
134 | STUDENT_STATUS_READ | Error | RD134 | Read Status must be 1, if Grade Level 020 and Read Test = 12 and Read Score > '0846'
135 | STUDENT_STATUS_READ | Error | RD135 | Read Status must be 2 or 4, if Grade Level 020 and Read Test = 12 and Read Score <= '0846'
136 | STUDENT_STATUS_READ | Error | RD136 | Read Status must be 1, if [NAME] 030 and Read Test = 12 and Read Score > '0854'
137 | STUDENT_STATUS_READ | Error | [NAME] | Read Status must be 2 or 4, if [NAME] 030 and Read Test = 12 and Read Score <= '0854'
138 | SCORE_READ | Error | RD138 | If Read Test is 06, Read Score must be 9999 and Read Status Code must be 5
202 | GRADE_LEVEL_STUDENT | Warning | RD202 | WARNING: Unable to determine Grade Level for Student, could cause erroneous errors or missed errors
200 | BIRTH_DATE_STUDENT | Error | RD200 | Birthdate is required
201 | TEST_DATE_STUDENT | Error | RD201 | Testing date is required
202 |  | Error | 99999 | Must update mismatched student information in RITS or modify READ submission to match what is currently in RITS