School Enrollment Extract

Introduction

This extract generates a comma-delimited file with student enrollment and withdrawal transactions at each school in the district. The extract is used to track student mobility through the year. At least one record should exist for every student enrolled in a district at any time during the school year. Most students should have an Enrollment Code of E1.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The report selects course section records from the [Student] or [ReEnrollments] table based on the following criteria:

The student must not be excluded from state reporting.
The student must be enrolled in a school included in the report.
The student’s school enrollment Entry Date must occur on or after the report start date and on or before the report end date.
The student’s school enrollment Exit Date must occur after the report start date and on or before the report end date.
If the student is flagged for Charter School District Activities (CSDA) , the school must be flagged as an In District Charter School.
The student is HSDA-flagged.

Report Input

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

Field	Description
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. Note: The All Schools option is only available when running the report from the District Office.
Select Students	Choose one of the following: The Selected [x] Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school or district.
Start date for the report	Enter the report start date.
End date for the report	Enter the report end date.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Tables for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Begin / End Position
1	District Code	PED assigned three-digit district number.	[Prefs]Name=DistrictNumber [Prefs]Value	1/8
2	Location Code	The PED assigned three-digit school number. The alternate school number is extracted, if populated. Otherwise, the report extracts the Location Code from the eScholar Programs Fact Record page, which is automatically populated with the school number. Use the following Location Codes for special education students not enrolled at an actual district location: 993 – Students who are hospitalized 997 – Students who are enrolled in a private school 998 – Students who are homebound 999 – Students who are home schooled	[Schools]Alternate_School_Number [S_NM_STU_X]LocationCode [Schools]School_Number Location code logic for summer schools is as follows: [S_NM_STU_X]LocationCode [ReEnrollments]SchoolID [Schools]Alternate_School_Number	9/14
3	School Year	This value is automatically extracted as June 30^th. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms. To change terms, click Terms at the top of the page and choose a term from the list. The value is extracted in the format YYYY-MM-DD.	[Terms]LastDay	15/24
4	Student ID	The state assigned student identification number.	[Students]State_StudentNumber	25/36
5	Date of Activity	Not reported.	Not reported.	37/46
6	Enrollment Date	The first day of the student’s school enrollment. The date is extracted in the format YYYY-MM-DD.	[Students]EntryDate	47/56
7	Enrollment Code	The code that indicates the student’s reason for enrollment. See the STARS Manual Volume 2 document available at http://ped.state.nm.us/ped/STARS.html for a list of valid values.	[Students]EntryCode	57/61
8	Not Collected	N/A	N/A	N/A
9	Not Collected	N/A	N/A	N/A
10	Not Collected	N/A	N/A	N/A
11	Not Collected	N/A	N/A	N/A
12	Not Collected	N/A	N/A	N/A
13	Not Collected	N/A	N/A	N/A
14	Not Collected	N/A	N/A	N/A
15	Not Collected	N/A	N/A	N/A
16	Not Collected	N/A	N/A	N/A
17	Not Collected	N/A	N/A	N/A
18	Not Collected	N/A	N/A	N/A
19	Dental Exam Verification	Dental Exam Waiver for a student. This value will only extract if the student's earliest enrollment into the district has an entry date greater than or equal to 7/1/2021	[ S_NM_STU_X]DentalExamWaiver [S_NM_REN_X]DentalExamWaiver	N/A