Legal Suffix Validation
Introduction
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.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
This report has no specified parameters.
Report Output
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.
Data Element | Description | Table/Field Name |
|---|---|---|
SchoolName | The name of the school the student attends. | [Schools]Name |
StudentID | The locally assigned student number. | [Students]Student_Number |
Core LastName | The student's preferred last name. | [Students]Last_Name |
Core FirstName | The student's preferred first name. | [Students]First_Name |
Core MiddleName | The student's preferred middle name. | [Students]Middle_Name |
Legal LastName | The student's legal last name. | [StudentCoreFields]PSCore_Legal_Last_Name |
Legal FirstName | The student's legal first name. | [StudentCoreFields]PSCore_Legal_First_Name |
Legal MiddleName | The student's legal middle name. | [StudentCoreFields]PSCore_Legal_Middle_Name |
OriginalSuffix | The previously entered suffix of the student. | Prior value in: [StudentCoreFields]PSCore_Legal_Suffix |
NewSuffix | The non-converted value. | Current value in: [StudentCoreFields]PSCore_Legal_Suffix |
Status | Indicates if the suffix value could not be converted to one of the standardized values. Valid statuses:
| Derived |