Claiming/Unclaiming Extract

Introduction

The Claiming Extract will include students enrolled with an Entry Date within the date range entered. The Unclaiming Extract will include students who have an Exit Date within the date range entered.

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 based on the following criteria:

The school is in a non-SIF District.
The student has an Entry Date within the date range entered OR
The student has an Exit date within the date range entered.

Report Input

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

Field	Description
Select Schools	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. 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.
Select Students*	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current student selection from the currently selected schools. All students – Run the report for all students who meet the selection criteria in the currently selected school(s). Note: If running the report for a single student, or group of students, select the students prior to running the report.
Extract Format*	Select to which report to run: Claiming Data Unclaiming Data
Report State Date*	Enter the report start date.
Report End Date*	Enter the report end date.
Include No Show Students (i.e., where Entry Date = Exit Date)?*	Indicate if the report should include no show students.
Processing Options	Select when to run the report: Run now – the report runs when the Submit button is clicked. Schedule – set up the date, time and recurrence of the report.

Back to Top

Report Output

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

Data Element	Description	[Table]FieldName	Field Type	Field Length
SASID	The State Assigned Student ID.	[Students]State_StudentNumber	Alpha-numeric	10
LastName	The last name of the student. This field is extracted from the Demographics page. Note: If populated, the student's legal name overrides the student's preferred name.	[StudentCoreFields]PSCore_Legal_Last_Name [Students]Last_Name	Alpha-numeric	50
FirstName	The first name of the student. This field is extracted from the Demographics page. Note: If populated, the student's legal name overrides the student's preferred name.	[StudentCoreFields]PSCore_Legal_First_Name [Students]First_Name	Alpha-numeric	32
MiddleName	The middle name of the student. This field is extracted from the Demographics page. If a value is entered on the SIMS Data Elements page (DOE004), that value is reported. Note: If populated, the student's legal name overrides the student's preferred name.	[StudentCoreFields]PSCore_Legal_Middle_Name [S_MA_STU_Demographic_X]LongMiddleName [Students]Middle_Name	Alpha-numeric	32
BirthDate	The birth date of the student.	[Students]DOB	Date	10
SchlNum	The 4-digit state assigned school number.	[Schools]School_Number	Alpha-numeric	4
DistNum	Enter the 4-digit state assigned district number followed by 4 zeros.	[Prefs]Value where [Prefs]Name = districtnumber	Alpha-numeric	8
GradeLevel	The student's grade level.	[Students]Grade_Level [ReEnrollments]Grade_Level	Alpha-numeric	2
SchoolYear	The school year of this enrollment record.	[Terms]ID	Date	4
EntryDate	The student's school enrollment entry date.	[Students]EntryDate [ReEnrollments]EntryDate	Date	10
ExitDate	The student's school enrollment exit date.	[Students]ExitDate [ReEnrollments]ExitDate	Date	10

Back to Top