00_Student_Match

Report Description

This file is used to submit student information to retrieve unique state identifier. This report produces the student match extract for all currently enrolled students data in a comma-delimited format.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Select Students	Choose one of the following: The Selected [x] Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school or district.
File Path	Enter the file path. If applicable, select the associated checkbox to save as the default value.
Data Collection Name	Choose the applicable Data Collection from the pop-up menu. 01_Student_Match
SFTP Connections	Choose a selection from the pop-up menu. The default value is Disable.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Note: If the student has previous and current school enrollments for the year, the report displays only one record representing their current school enrollment.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	ADMINID	The student's SU/SD ID.	[S_VT_District_S]AdminID	String	6
2	ENRORGID	The school's enrolling org ID issued by the AOE.	[S_VT_Schools_X]EmpOrgID	String	6
3	LCLSTUNUM	The student's local student ID.	[Students]Student_Number	String	20
4	PERMNUMBER	The student's state-assigned student ID.	[Students]State_StudentNumber	Number	10
5	FNAME	The student's first name.	[Students]First_Name	String	20
6	MNAME	The student's middle name.	[Students]Middle_Name	String	20
7	LNAME	The student's last name.	[Students]Last_Name	String	36
8	POSTNAME	The student's post name.	[StudentCoreFields]PSCore_Legal_Suffix	String	5
9	DOB	The student's date of birth. Note: MM/DD/YYYY format.	[Students]DOB	Date	N/A
10	GENDER	The student's gender.(F/M)	[Students]Gender	String	1