Unique ID Request - Legacy

This report is used to maintain State Student Identifiers (SSID) and basic student demographic information in the USOE database. This extract is created for active students based on student selection, and can be created at the district level or for a single school, and for all students or a student selection. The extract is a comma delimited text file.

The UT Unique ID Request File Report is uploaded to the USOE.

New IDs – A student enrolling for the first time in the state of Utah, including kindergarten students who do not have an SSID in the State Student Number field
Retrieve – A student or a selection of students who have transferred from another school in a Utah district
Update – A student whose attributes need to be updated based on a student SSID, LEA number and student number
Verify – A student or selection of students whose SSIDs need to be verified

Report Input

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

Field	Description
Use	If run at the district level, choose one of the following from the pop-up menu: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Current School Only – Includes all records associated with the current school that meet the selection criteria. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Students to Include	Indicate which students to include in the report by selecting one of the following options: Select The selected students only to run the report for students in the current selection enrolled in the specified date range. Select All students to run the report for all students in the current school enrolled in the specified date range. Note: If running the report for a single student, or group of students, select the students prior to runningreport.
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyyor mm-dd-yyyyin order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05.
Type of report to run: New Ids or Retrieve, Update or Verify*	Choose one of the following required options from the pop-up menu: New IDs – To obtain a new SSID for any student in PowerSchool who does not have an SSID in the State Student Number field. Retrieve – To obtain the SSID from the state system of a student or a selection of students who have transferred from another school in a Utah district. Update – To update a student’s attributes based on a student SSID, LEA number and student number. Verify – To confirm a student or selection of students SSIDs.

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.

Data Element	Description	[Table]FieldName	Data Type	Field Length	Begin / End Position
SSID	The number assigned to the student using the Statewide Student Identifier – SSID process. Note: Populated for Verify and Update Extracts.	[Students]State_StudentNumber	N	10	N/A
School Year	The school year. Format: CCYY	[Terms]LastDay	N	4	N/A
Last Name	The student’s last name.	[Students]Last_Name	A	30	N/A
First Name	The student’s first name.	[Students]First_Name	A	20	N/A
Middle Name	The student’s middle name. Note: Optional for all updates.	[Students]Middle_Name	A	20	N/A
Birth Date	The student’s date of birth. Format: YYYYMMDD	[Students]DOB	N	10	N/A
Gender	The student’s gender.	[Students]Gender	A	1	N/A
LEA Number	The District Number. State assigned and approved LEA number.	[Prefs]DistrictNumber	N	3	N/A
LEA School Number	State assigned and approved school number. Note: The Alternative School Number is extracted if populated on the Edit School page at the district level.	[Schools]SchoolID or [Schools]Alternate_School_Number	N	4	N/A
LEA Student Number	LEA assigned student number. Note: Must not equal 0 (zero).	[Students]Student_Number	N	10	N/A
Request Type	The report request type. The type of report selected run. Valid values: N – New IDs R – Retrieve U – Update V – Verify	N/A	A	1	N/A