Skip to main content
Skip table of contents

Legal Suffix Validation



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 ElementDescriptionTable/Field Name


The name of the school the student attends.[Schools]Name
StudentIDThe locally assigned student number.[Students]Student_Number
Core LastName

The student's preferred last name.

Core FirstNameThe student's preferred first name.[Students]First_Name
Core MiddleNameThe student's preferred middle name.[Students]Middle_Name
Legal LastNameThe student's legal last name.[StudentCoreFields]PSCore_Legal_Last_Name
Legal FirstNameThe student's legal first name.[StudentCoreFields]PSCore_Legal_First_Name
Legal MiddleNameThe student's legal middle name.[StudentCoreFields]PSCore_Legal_Middle_Name
OriginalSuffixThe previously entered suffix of the student.Prior value in: [StudentCoreFields]PSCore_Legal_Suffix
NewSuffixThe 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.

Valid statuses:

  • ok
  • invalid suffix
  • verify last name fields


Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.