State Reporting 22.9.1.0 Release Notes

PSSR-297912

New Iowa Stored Class Rank and GPA Data Verification Report

Update Stored Class Rank and GPA Data Verification Report: Version 22.9.1
As a follow-on to the Iowa eTranscript Data Collection and the new Iowa Class Rank tab added in the prior release, a new process and report are now available to assist districts in managing cumulative GPA’s and Class Rank data.

• Summary

  • This report copies and stores calculated Class Rank and GPA data for selected students from the PowerSchool core Class Rank table to the Iowa State extended fields in order to preserve official rank information for use with the Iowa eTranscript.

  • The current values for the Weighted and Non-weighted GPA Methods specified in District > Schools/School Info for the student’s current or most recent reportable school are used to identify the Rank and GPA data to store.

  • The report also supports the ability to delete the stored Class Rank and GPA data and/or to delete any overrides to these calculated fields previously entered or imported by the district.

  • The values copied from the Class Rank table and any district overrides are available for review on the State/Province - IA > Class Rank/GPA tab.

  • A verification report with options for CSV or PDF output is also provided to allow the district to validate these data and to identify records with non-matching data that may be out-of-date.

  • When eTranscript records are transmitted to the state via SIF, the following hierarchy of data sources is used. The first non-NULL values in the order listed will be extracted.Rank and GPA Overrides on the IA Class Rank/GPA tabStored Rank and GPA’s as calculated in PowerSchool and copied to the IA Class Rank/GPA tabCurrent Rank and GPA’s from the PowerSchool Class Rank table

• Report Parameters

  • Standard Selection of Schools and Students

  • Action to Take (required)Select Option (equivalent of NULL)Store New Rank/GPA DataDelete Stored Rank/GPA DataReport OnlyIf either the Store or Delete option is selected, additional parameters for the GPA/Rank Type and Rank GPA Overrides are displayed.If the Report Only option is selected, no actions are taken and the verification report is generated using existing data in the tables.

  • GPA/Rank TypeBoth Non-weighted and Weighted GPA/Rank (default)Non-weighted GPA/Rank onlyWeighted GPA/Rank only

  • Rank/GPA OverridesNo Action (default)Delete Non-weighted OverridesDelete Weighted OverridesDelete Both

  • File Output: Select CSV or PDF (default is CSV)

• Verification Report Output: Non-matching values between the GPA/Rank values last stored in the Iowa fields versus the current PowerSchool Class Rank table values are flagged with an asterisk character.Student DemographicsStudent NameLocal IDState IDGrade LevelGenderSchool NumberSchool NameNon-Weighted Rank and GPA (overrides, stored values, current Class Rank table values)Ovr Nwgt Class SizeOvr Nwgt GPAOvr Nwgt RankOvr Nwgt Rank DateOvr Nwgt SchoolOvr Nwgt Date EnteredStored Non-Wgt RankStored Non-Wgt Class SizeStored Non-Wgt GPAStored Non-Wgt Rank DateStored Non-Wgt SchoolStored Non-Wgt Date CopiedCurrent Non-Wgt RankCurrent Non-Wgt Class SizeCurrent Non-Wgt GPACurrent Non-Wgt Rank DateCurrent Non-Wgt SchoolWeighted Rank and GPA (overrides, stored values, current Class Rank table values)Ovr Wgt Class SizeOvr Wgt GPAOvr Wgt RankOvr Wgt Rank DateOvr Wgt SchoolStored Wgt RankStored Wgt Class SizeStored Wgt GPAStored Wgt Rank DateStored Wgt SchoolStored Wgt Rank Date CopiedCurrent Wgt RankCurrent Wgt Class SizeCurrent Wgt GPACurrent Wgt Rank DateCurrent Wgt School

PSSR-302258

 Section 504 Status Updated in ELL Extract

Iowa ELL Extract: Version 22.9.1
The Iowa ELL Extract is updated to report the 504 Status as Y and N rather than 1 and 0. Additionally, any 504 values that remain NULL in the database are reported as N.