Skip to main content
Skip table of contents

Unique ID State ID Request File


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.



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.


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





The report extracts “ID”



School Number

The school number associated with the student. The report extracts the alternate school number, if populated.





District of Residence

The student’s district of residence.



Student Name

The student’s last, first and middle names.

Note: Legal Names will be extracted for Columns B, C and D






The student’s gender.



Date of Birth

The student’s date of birth.



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.



Student Number

The locally assigned student identification number.




The student’s social security number, extracted without dashes.




Not collected.



Student ID

The state assigned student identification number.



District Code

The district number.


[Prefs]Name = districtnumber


Exit Date

The exit date for the student’s school enrollment. The report extracts the date in the format YYYY.


Back to Top

JavaScript errors detected

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

If this problem persists, please contact our support.