State Reporting 21.6.2.0 Release Notes

Attendance Profile Report: Version 1.1
The Attendance Profile report PDF library is updated and the pagination from ‘Page X of Y’ to ‘Page X’.

Additionally, due to the large PDF size that can result if the report is run for a large selection of students, a validation is added to the report page to restrict the number of students to 200.

Digital Equity and Learning Preferences page is updated to show the data while editing, even if there are special characters inside the data.

The Miscellaneous page in District is updated to save the Pref to Enable Digital Equity and Learning Preference in the Public Portal correctly.

The RecompilePSSchema.sql files for all states are updated with the compile_all => FALSE constraint, in the DBMS_UTILITY function.

Sub-District functionality is updated and now end users are alerted if Sub-District functionality is enabled but the following setup steps have not been completed:

• No Sub-Districts have been defined.
• One or more schools have not been assigned to a Sub-District. This logic does not apply to schools that are excluded from state reporting.

In either case, the following message displays:

'Sub-District functionality is enabled but setup is incomplete. All schools not excluded from state reporting must be assigned to a sub-district.'

PSSR-262686

LA EdLink Calendars Report Update

PSSR-264947

LA EdLink Calendars Report Update

LA EdLink Transcripts: Version 1.3

Numerous columns have been updated in the sts_transcript output:

• Course_part_num and DE_post_secondary_credit_hrs_earned were reporting "-99" if no data was found. These are updated to be empty between the tab delimiters.
• Course_sponsor_cd, Course_site_cd, Distance_learning_course_type_cd, DE_secondary_site, Work_based_learning_category, and Work_based_learning_business_name were reporting "--" if no data was found. These are updated to be empty between the tab delimiters.
• Course_BSSY was reporting the term ID (e.g. 3001 for 2020-21 semester 1). This is updated to report the starting year of the corresponding school year (e.g., 2020).
• Grade_pt_max_cnt was choosing a parameter value to report based on the course typeset at the Sections level, and from the StoredGrades level only if the Sections field was null. This is updated to make the choice based first upon the StoredGrades field, then the Sections field, and finally the Courses field. It is also enhanced to allow more flexibility in how the parameter values are entered, by removing decimal points and right-padding as needed. For example, parameter values of "100", "1.00", "1", and "1.0" are all reported as "100" as desired.

The reports listed below now support the use of sub-districts. When running the report from the district office, users who have enabled sub-districts will see a new parameter allowing them to select which sub-district to run for. Only schools assigned to that sub-district are included in the output. Running the report from a single school behaves as before.

When the Sub-district functionality is enabled, the first 3 characters of the Sub District number will be extracted in the District Code column.

• LA EdLink Courses Extract: Version 1.6
• LA EdLink Enrollments: Version 1.9
• LA EdLink Students: Version 1.8
• LA EdLink Staff Extract: Version 1.6
• LA EdLink Calendar: Version 1.5

LA EdLink Staff: Version 1.6

All the fields that were earlier reported " " to represent NULL values are now extracted as <tab><tab>.