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:
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:
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:
|
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:
|
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 |