This report allows districts to verify the conversion of Student Legal Suffix values from text to a dropdown list of standardized values. The "invalid suffix" status displays for each student with a Legal Suffix whose value could not be converted to one of the standard dropdown list options. The validation also examines the student core and legal last name fields to identify the potential existence of suffix values within the last name. If either of the last name fields contains strings of characters separated by a space, the report searches for typical suffixes such as Jr., JR, II, III at the end of the last name. If potential suffixes are identified, the report outputs a status of "verify last name fields."
For any student flagged with an invalid value, the district must manually update the suffix on the Iowa Student Names tab and submit the page in order to clear the invalid value from the database and set the new value correctly. If a suffix does not apply to the student, do not select a suffix, and then submit the page to clear the existing value and reset it to NULL in the database. Districts are encouraged to run this report for all students and to correct any discrepancies within PowerSchool.
For help with navigation and running the report, see How to Find and Generate a Report.
This report has no specified parameters.
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
|The name of the school the student attends.
|The locally assigned student number.
The student's preferred last name.
|The student's preferred first name.
|The student's preferred middle name.
|The student's legal last name.
|The student's legal first name.
|The student's legal middle name.
|The previously entered suffix of the student.
|Prior value in: [StudentCoreFields]PSCore_Legal_Suffix
|The non-converted value.
|Current value in: [StudentCoreFields]PSCore_Legal_Suffix
Indicates if the suffix value could not be converted to one of the standardized values.