Unique ID State ID Request File

Introduction

The Unique ID State ID Request File is used to request state-assigned identification numbers for one or more students. The extract is generated in a comma-delimited format.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The Unique ID State ID Request File extract includes student records from the [Students] or [ReEnrollments] table that meet the following criteria:

Students who are not excluded from state reporting.
Students who are enrolled in a school that is not excluded from state reporting.
Students whose school enrollment Exit Date is after the report start date.
Students whose school enrollment Entry Date is on or before the report end date.
Students whose school enrollment Exit Date is after the Entry Date.

Report Input

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

Field	Description
Data to be Filled	Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.
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. Notes: If your district uses Sub-District functionality, see Report Input for Sub-District Functionality. The All Schools option is only available when running the report from the District Office.
Current Selection Students	Indicate which students to include in the report by selecting one of the following options: The Selected Number of Students Only All Students (default) Note: If running the report for a single student, or group of students, select the students prior to running report.
Start Date	Enter the start date for the report, such as the first in session day of the school year.
End Date	Enter the current date.

Back to Top

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.

The Unique-ID State ID Request File report is updated to extract Legal Names for Columns B, C and D. If the legal names are empty then the fields extract blank. The middle name is not shortened or truncated. Columns N and O extract the Preferred First Name and Last Name.

Additionally, the report is updated to support special characters like apostrophes, tildes, and ampersand (except comma).

Element #	Data Element	Description	[Table]FieldName
1	ID	The report extracts “ID”	N/A
2	School Number	The school number associated with the student. The report extracts the alternate school number, if populated.	[Schools]Alternate_School_Number Or [Schools]School_Number
3	District of Residence	The student’s district of residence.	[Students]DistrictofResidence
4	Student Name	The student’s last, first and middle names. Note: Legal Names will be extracted for Columns B, C and D	[Students]Legal_Last_Name [Students]Legal_First_Name [Students]Legal_Middle_Name
5	Gender	The student’s gender.	[Students]Gender
6	Date of Birth	The student’s date of birth.	[Students]DOB
7	Grade Level	The student’s grade level. If the student’s grade level equals zero, the report extracts KG. If the student’s grade level is less than 0, the report extracts PK. Otherwise, the report extracts the grade level entered for the student.	[Students]Grade_Level
8	Student Number	The locally assigned student identification number.	[Students]Student_Number
9	SSN	The student’s social security number, extracted without dashes.	[Students]SSN
10	Ethnicity	Not collected.	N/A
11	Student ID	The state assigned student identification number.	[Students]State_StudentNumber
12	District Code	The district number.	[Prefs]Value [Prefs]Name = districtnumber
13	Exit Date	The exit date for the student’s school enrollment. The report extracts the date in the format YYYY.	[Students]Exit_Date

Back to Top