Uniq-ID State ID Request File

Contents

Report Description

This report is designed to select all students or students without a state ID for submission to DESE. Only current and pre-registered students will be reported.

This report can only be run for the entire district.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students]table based on the following criteria:

The student’s school must not be excluded from state reporting.
The student must not be excluded from state reporting.
The student must be currently enrolled or pre-registered.
If the report is run for students without a MOSIS Student Number (StateID), then the student must not be assigned a value for State Student Number on the Student Core Information student page.

Report Input

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

Field

Description

Student Type

Choose one of the following from the pop-up menu:

All Students – Include students in the report who are assigned a MOSIS Student ID as well as those not assigned a MOSIS Student ID.
Without StateID – Include students in the report who are not assigned a MOSIS Student ID.

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.

Item #	Data Element	Description	[Table]FieldName	Req
1	Record Type	Always “ID"	N/A (Derived)	R
2	Current School Code	The school where the student is enrolled.	[Students]SchoolID	R
3	Resident District Code	The student’s district of residence.	[Students]DistrictOfResidence	R
4	Legal Last Name	The student’s legal last name.	[StudentCoreFields]PSCore_Legal_Last_Name Or, if NULL: [Students]Last_Name	R
5	Legal First Name	The student’s legal first name.	[StudentCoreFields]PSCore_Legal_First_Name Or, if NULL: [Students]First_Name	R
6	Legal Middle Name	The student’s legal middle name.	[StudentCoreFields]PSCore_Legal_Middle_Name Or, if NULL: [Students]Middle_Name	O
7	Legal Name Suffix	The student’s legal suffix	[StudentCoreFields]PSCore_Legal_Suffix	O
8	Gender	The student’s legal gender.	[StudentCoreFields]PSCore_Legal_Gender Or, if NULL: [Students]Gender	R
9	Date of Birth	The student’s date of birth.	[Students]DOB	R
10	Current Grade Level	The student’s grade level. If the student’s grade level is stored as 0, the report extracts K. If the grade level is stored as less than 0, then the report extracts PK.	[Students]Grade_Level	R
11	Local Student ID	The student’s locally assigned student number.	[Students]Student_Number	R
12	Social Security Number	This column is output as NULL. Student SSN’s are no longer accepted in the file.	N/A	O
13	Race/Ethnicity	The student’s ethnicity. Note: For code sets go to MO Core Data/MOSIS	[Students]FedEthnicity [StudentsRace]RaceCD	R
14	State ID	The state-assigned student number. For more information, see MOSIS Reference Manual. Can be null if student has not yet been assigned a MOSIS ID	[Students]State_StudentNumber	O
15	Current District Code	The student’s attending district number.	[S_MO_STU_X]AttendingDistrict	R
16	Current School Year	School ending year based on current enrollment, must have ‘yyyy’ format.	[Students]ExitDate (YYYY)	R

Back to Top