Level Data should consider adding a tab of rules dedicated to ensuring READ Act data logged in PowerSchool for the READ Act Data Collection Snapshot is accurate for state reporting. Some potential rule examples:
K-3 READ Plan: for students in grades K-3, S_CO_STU_X.READ_PLAN must be a valid value.
K-3 READ Status: for students in grades K-3, S_CO_STU_X.STATUS_READ must be a valid value. If S_CO_STU_X.READ_PLAN is 1, then S_CO_STU_X.STATUS_READ must have a value of 1, 2, 4, or 6.
K-3 READ Test: for students in grades K-3, S_CO_STU_X.TEST_READ must be a valid value, and cannot be blank or 00.
K-3 READ Score: for students in grades K-3, a value must be entered in S_CO_STU_X.SCORE_READ.
READ Testing Date: for any student with a value other than blank/00 in S_CO_STU_X.TEST_READ, a valid date must be entered in S_CO_STU_X.TEST_DATE_READ. Date must fall within current school year.
4-12 READ Status/Plan Alignment: Students in grades 4-12 with any value other than blank in S_CO_STU_X.READ_PLAN must have a valid value in S_CO_STU_X.STATUS_READ.
4-12 READ Test: students in grades 4-12 may not have a blank value in S_CO_STU_X.TEST_READ.
4-12 READ Score: students in grades 4-12 with a value of 00 or 04 in S_CO_STU_X.TEST_READ must have a value of 9999 in S_CO_STU_X.SCORE_READ.
ML Student Exemption: only students with a value of 1 in S_CO_STU_X.LanguageProficiency may have a value of 4 in S_CO_STU_X.TEST_READ
K-3 Recommended Retention: All K-3 students with a S_CO_STU_X.STATUS_READ of 0, 1, or 4 must have a value of 2 in S_CO_STU_X.REC_RETEN_READ.
4-12 Recommended Retention: All 4-12 students with any value other than blank in S_CO_STU_X.READ_PLAN must have a value of 2 in S_CO_STU_X.REC_RETEN_READ.
Alternative Assessment: Any student with a value of 1 in S_CO_STU_X.CSAP_ALTERNATE_ASSESSMENT must have a value of 2 in S_CO_STU_X.REC_RETEN_READ
Further suggestions for READ act related rules can be found here in CDE’s file layout for this submission: https://ed.cde.state.co.us/fs/resource-manager/view/93c61294-5d72-4e55-8cb8-2bf802371547