School Enrollment Extract

Contents

Introduction

The School Enrollment extract is used to track student school enrollments. The extract is generated in a comma-delimited format.

Selection Criteria

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

Student Selection

The School Enrollment extract includes student records from the [Students] table that meet the following criteria:

Students who are not excluded from state reporting.
Students who are enrolled in a school not excluded from state reporting.
Students whose school enrollment Entry Date is on or before the report end date.
Students whose school enrollment Entry Date is on or after the report start date.
Students whose school enrollment Exit Date is after the report start date.

Report Input

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

Field	Description
Data to be Filled	Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.
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. Notes: If your district uses Sub-District functionality, see Report Input for Sub-District Functionality. The All Schools option is only available when running the report from the District Office.
Current Selection Students	Indicate which students to include in the report by selecting one of the following options: The Selected [number] Students Only All Students (default) Note: If running the report for a single student, or group of students, select the students prior to running report.
Start Date	Enter the first in session day of the school year.
End Date	Enter the last in session day of the school year. The end date is automatically populated with 6/30/YY. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms.

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.

Element #	Data Element	Description	[Table]FieldName
1	District Code	NDE Number for the district.	[Prefs]Name=districtnumber [Prefs]Value
2	Location Code	The report extracts the value in the Alternate School Number field, if populated on the Edit School page. Otherwise, the report extracts the value from the School Number field.	[Schools]Alternate_School_Number [Schools]School_Number [Students]SchoolID=[Schools]School_Number [ReEnrollments]SchoolID=[Schools]School_Number
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.	[Terms]LastDay
4	Student ID	State issued identification number.	[Students]State_StudentNumber
5	Date of Activity	The first day that the student attended school for the school enrollment. The date should not be greater than the current date. This date is extracted in the format YYYY-MM-DD.	[Students]EntryDate
6	Enrollment Date	The first day that the student attended school for the school enrollment. This date is extracted in the format YYYY-MM-DD.	[Students]EntryDate
7	Enrollment Code	See the Appendix for valid entry codes.	[Students]EntryCode
8	Enrollment Comment	Not collected.	N/A
9	Grade Level	If the field Kindergarten Student receiving less than 1,032 instructional program hours is set to Yes, then the report extracts HK. Otherwise, the report extracts the grade level.	[Students]Grade_Level [S_NE_STU_X]Kdg_Grade_HK
10	Residence Status Code	This field is named Enroll Option Status in PowerSchool.	[S_NE_STU_X]Enroll_Option_Status
11	Enroll Change Code	Not collected.	N/A

Back to Top