Legal Suffix Validation

Contents

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: ok invalid suffix verify last name fields	Derived

Back to Top