State Reporting 22.12.2.0 Release Notes

The reposchema is updated with a precondition to ensure the script runs (at the correct time); This will ensure all reports load as expected on the System Reports tab.

Attendance Summary by Grade: Version 2.0

Additional references:

PSSR-304242: Attendance Summary by Grade Report 1.7 - Reports by District of Residence When the DOR Parameter is Set to No.

PSSR-305319: Attendance Summary by Grade Report 1.7 - Duplicating Rows with Districts of Residence Selected

PSSR-307440: Attendance Summary By Grade Report 1.9 - Printing 2 Lines for Students with Special Programs

PSSR-305488: Does Not Calculate A Loss Or Ending When A Student Exits A Program And Re-Enrolls In It Next Reporting Term

PSSR-305010: Attendance Summary By Grade Report 1.7 - Missing Student Data

PSSR-307202: Attendance Summary By Grade 1.9 Inaccurate Results

PSSR-306897: Attendance Summary By Grade Days Absent/ Days Attended Incorrect (does not match MSA)

1. The report now ignores any value set for the District of Residence when ‘Report by District of Residence’ to set to ‘No’.
2. The report will no longer generate duplicate rows for students when when ‘Report by District of Residence’ to set to ‘Yes’.
3. The report will no longer generate duplicate rows for students when being run with one or more special programs selected
4. The report will now calculate losses and ending in total for students who enter/exit programs during the reporting period.
5. The report will now output results for all students, as expected.

The updated logic for reporting excluded and Ineligible / non-ADA enrollments is outlined below:

1. When the report parameter: ‘Implement the 'Exclude from ADA' flag to exclude such enrollment records from this report ' is set to 'No’:

   1. Enrollments where the assigned FTE has all conversions mapped to an attendance value of 0 will be displayed in the report output as ‘IE’ (Ineligible), regardless of the value set for ‘Exclude this enrollment from CA ADA Reporting”.

   2. Enrollments where the assigned FTE is set to count for ADA will have these days reported normally, regardless of the value set for ‘Exclude this enrollment from CA ADA Reporting”.

2. When the report parameter: ‘Implement the ‘Exclude from ADA’ flag to exclude such enrollment records from this report ' is set to ‘Yes’:

   1. A student with multiple enrollments will be included in the report output when at least one enrollment has the “Exclude this enrollment from CA ADA Reporting” set to ‘No’.

      • Enrollments that meet the following conditions will be displayed in the audit table normally:

        1. “Exclude this enrollment from CA ADA Reporting” is set to “No”

        2. The assigned FTE is set to count for ADA.

      • Enrollments that meet the following conditions will be displayed in the audit table  as ‘IE’ (ineligible):

        1. “Exclude this enrollment from CA ADA Reporting” is set to ‘No”

        2. The assigned FTE has all conversions mapped to an attendance value of 0.

      • Enrollments that meet the following conditions will be displayed in the audit table as ‘EX’ (excluded):

        1. “Exclude this enrollment from CA ADA Reporting” is set to ‘Yes’.

        2. The assigned FTE is set to count for ADA.

      • Enrollments that meet the following conditions will be displayed in the audit table as ‘NE”

        1. “Exclude this enrollment from CA ADA Reporting” is set to ‘Yes’.

        2. The assigned FTE has all conversions mapped to an attendance value of 0.

3. Enrollments where ‘Exclude this enrollment from CA ADA Reporting’ is set to “Yes” will be excluded from the report results and are not considered in the following calculations:·     

   1. Actual Days

   2. Off track

   3. Days N/E

   4. Days Ineligible

   5. Days Absent

   6. Days Attended

CALPADS Student Program Utility: Version 2.4

Updated the report to prevent the following error from occurring:

• Failed ORA-06512: at "PS.CA_CALPADS_COMMON"

Updates were made to multiple state pages to remove all references to virtual tables. Pages impacted:

PSSR-298279:CA - GetCF technical debt #1
Concurrent (Non-Primary) Enrollments => (home.html, edit.html, new.html)
ELA Status/Program History => (home.html, stateCA_ELProgram.html, new.html, page_exclusion_list.txt)
Authorizations/Prohibitions Waivers => (EL Students) (home.html, edit.html, new.html)

PSSR-298342:CA - GetCF technical debt #2 - Update SSID Enrollment Records
Report: SSID Enrollment Records Version: 8.3

PSSR-298343: CA - GetCF technical debt #3 - Update Staff Assignments and Staff Demographics
Report: Staff Assignment Records Version 3.9

PSSR-298344:CA - GetCF technical debt #4 - Student Information Format
Report: Student Information Records Version: 6.2

PSSR-298347:CA - GetCF technical debt #5 - Update Student Course Section Records
Report:Student Course Sections Records version: 4.6

PSSR-298349: CA - GetCF technical debt #6 - Update Student Waiver Records and Cal-PASS
Report: Student Waiver Records (Legacy) Version: 1.4
Report:Cal-PASS Version: 1.7

PSSR-298350: CA - GetCF technical debt #7 - Student Program Records Package
CALPADS Program Eligibility =>( edit.html, home.html)
Report: Student Program Records Version: 5.5
Report: CALPADS Student Program Utility Version: 2.3
Package: CA_CALPADS_Programs_Body.sql

PSSR-298351: CA - GetCF technical debt #8 - Update Adult Education Enrollment and Class Size Average
Report: Class Size Average and Progress Calculation Version: 1.4
Report:Adult Education Enrollment Version: 1.2

PSSR-298352:CA - GetCF technical debt #9 - Update Postsecondary Status and Student Incident Records (SINC)
Report: Postsecondary Status Version: 1.9
Report: Student Incident Records (SINC) Version: 2.2

CA - GetCF technical debt #10 - Update Student Absenteeism and Student Absence Summary Records
Report: Student Absence Summary Records Version 3.6
Report: Student Absenteeism Report Version 3.2

PSSR-298354:CA - GetCF technical debt #11 - Update general-purpose views or functions
Function: CA_OralHealthRecId.sql
Report: Oral Health Assessment/Waiver Version: 2.1
View: CA_StudentProgram_VT.sql
Report: Perkins E-1 Secondary Extract Version: 1.6
View: CA_SchoolEnrollments.sql
Function: CA_CALPADS_EnrollStatus
Function: CA_CALPADS_STUDENT_LAST_DAY.sql

Monthly Student Attendance: Version 2.0

Additional reference:

1. PSSR-307996: Monthly Student Attendance 1.9 Not Counting Grade Changes as a Loss
2. PSSR-305366: Monthly Student Attendance Report - "No attendance data exists that meets the report criteria" When School Has Padded Years And Terms In Beginning Of The Year
3. PSSR-305081: Monthly Student Attendance Report - "No attendance data exists that meets the report criteria" When Orphaned Calendar_Day Records Exists Before First In-Session Day.

The Monthly Student Attendance report has been updated to correct all reported issues, as noted above.