State Reporting 20.7.2.0 Release Notes

PSSR-239818

Extract 052 Updated to Use Extended Fields

Description: Extract 052 needs to be updated to use the extended fields.
Resolution: Extract 052 is updated to use the extended fields.

PSSR-237976

Replace Getcf calls on Incident Query Export report with extended tables and fields

Incident Query Export Report: Version 1.1
Modifications have been made to improve the performance of the Incident Query Export report by accessing extended table data directly.

PSSR-238240

Replace Getcf calls on "studentoptions" Query with extended tables and fields

Replaced all Getcf calls on "studentoptions" (504 alert) Query with extended tables and fields.

Page Impacted:-

Following tabs are present under Louisiana State page (State/Province-LA) which are impacted.

1. Genral

2. Language

3. Grade 9/T9

4. Homeless

5. Academics/Progress

6. 504/SPED

7. Program Info

8. DEWS

9. CRDC

10. DRC Accommodations

11. K-3 Assessment Data

12. Industry Based Credentials (IBC) Data

PSSR-238002

LA - convert GetCF to direct extended field on LASATS Daily Feed Report

Replaced all Getcf calls on LASATS Daily Feed Report with extended tables and fields.
Version: 1.2

PSSR-238007

Replace Getcf calls on SPC - Sponsor Site Calendar report with extended tables and fields

Replaced all Getcf calls on SPC - Sponsor Site Calendar report with extended tables and fields.
Version: 1.5

PSSR-178205

LA - Student Upload 1.1 fails with 'ORA-01427 single-row subquery returns more than one row

Student Upload Report: Version 1.2

The Student Upload version 1.1 fails with 'ORA-01427 single-row subquery returns more than one row when StudentRace table contains more than one of the same RaceCD value for a student.

This issue has been resolved and the report can now handle the scenario where a student has multiple duplicate values for their Student Race data.