Obsolete - School Enrollment Extract

The data for this extract is now included in the Student Attendance Extract. This file contains all students enrolled in regular day school, evening high school, and part-time programs. This was formerly the September 30^th School Enrollment Extract. The September 30^th Enrollment Extract report is now included in the Student Attendance Extract.

Selection Criteria

Selection criteria determine which database records are used in the report. For the September 30 School Enrollment Extract, student are selected.

Student Selection

The report selects which student records to use based on the following criteria:

The student’s school ID must match the school IDs selected for the report.
The student’s entry date must be less than the Report End date and the exit date must be greater than the Report Start date.
The Exclude Student from State Reporting indicator must equal No for the student.

Report Input

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

Field	Description
Use	If run at the district level, choose one of the following from the pop-up menu: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Current School Only – Includes all records associated with the current school that meet the selection criteria. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. 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.
Students to Include	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 selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05.
Report Start Date	Type the first date in the range of dates for the student data to be included in the extract.
Report End Date	Type the last date in the range of dates for the student data to be included in the extract.
Run From Extract Viewer	Select Yes to create an extract file from the records in the Extract viewer. The default is No. If No is selected, the records that currently exist in the Extract Viewer are replaced.

Report Output — Extract

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	Field Type	Field Length	Begin / End Position
1	School System	This field contains the two-digit identification code of the local education agency (LEA). This field is extracted from the Edit District Information page, Start Page > District Setup > District Information.	[Prefs]MD_DistrictLEA	Alpha-numeric	2	N/A
2	School Number	This field is calculated.	[Students]SchoolID Or [ReEnrollments]SchoolID	Alpha-numeric	4	N/A
3	SASID	This field contains the student identification number assigned by the Maryland State Department of Education. This field is extracted from the Maryland State Information page, Start Page > Student Selection > Maryland State Information.	[Students]State_StudentNumber	Alpha-numeric	10	N/A
4	Student ID Number	This field contains the student identification number assigned by the school. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]Student_Number	Alpha-numeric	10	N/A
5	Last Name	This field contains the last name of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]Last_Name	Alpha-numeric	25	N/A
6	First Name	This field contains the first name of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]First_Name	Alpha-numeric	15	N/A
7	Middle Initial	This field contains the middle initial of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]Middle_Name	Alpha-numeric	1	N/A
8	Generation Suffix	This field contains the generational suffix that is part of the student’s name, if applicable. This field is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information.	[Students]MD_Generation	Numeric	3	N/A
9	DOB	This field contains the birth date of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]DOB	Date	8	N/A
10	Grade	This field contains the student identification number assigned by the school. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]Grade_Level Or [ReEnrollments]Grade_Level	Alpha-numeric	2	N/A
11	Gender	This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics. The alpha character will be converted to the two digit numeric code when the report is run.	[Students]Gender	Alpha-numeric	1	N/A
12	Hispanic/Latino Ethnicity	This field contains a Y if the student’s ethnicity is Hispanic or Latino or an N if the student’s ethnicity is not Hispanic or Latino. This field value is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics. If the Ethnicity: Is the student Hispanic or Latino? Field is blank, this field value is extracted from the Hispanic or Latino field on the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information.	[Students]FedEthnicity OR [Students]MD_Hispan_Lat	Numeric	1	N/A
13	Race/Ethnicity	This field contains the five-digit number identifying each race code that applies to this student. Race is reported as a five position field, with each code assigned a value from 1 through 5. If a check box is not selected, a 0 is assigned to that position. For example, a student record with the Asian and African American race check boxes selected is 02300. The race code values are extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics. If the race code check boxes are not populated on the Edit Demographics page, the values are extracted from the race code check boxes on the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information.	[StudentRace]RaceCd OR [Students] MD_Eth_Amer_Ind MD_Eth_Asian MD_Eth_Black MD_Eth_Hawaiian MD_Eth_White	Numeric	5	N/A
14	Social Security Number	This field contains the social security number of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]SSN	Alpha-numeric	9	N/A
15	Race/Ethnicity	This field contains the previously assigned ethnicity of the student. This field is extracted from the Edit Demographics page, Start Page > Student Selection> General Demographics.	[Students]Ethnicity	Numeric	1	N/A
16	Filler	This field is not currently used.	N/A	Alpha-numeric	1	N/A
17	Filler	This field is not currently used.	N/A	Alpha-numeric	1	N/A
18	Filler	This field is not currently used.	N/A	Alpha-numeric	1	N/A
19	Filler	This field is not currently used.	N/A	Alpha-numeric	1	N/A
20	Filler	This field is not currently used.	N/A	Alpha-numeric	1	N/A
21	Filler	This field is not currently used.	N/A	Alpha-numeric	8	N/A
22	Filler	This field is not currently used.	N/A	Alpha-numeric	1	N/A
23	Filler	This field is not currently used.	N/A	Alpha-numeric	1	N/A
24	Filler	This field is not currently used.	N/A	Alpha-numeric	8	N/A
25	Filler	This field is not currently used.	N/A	Alpha-numeric	8	N/A
26	Filler	This field is not currently used.	N/A	Alpha-numeric	1	N/A
27	Submission Date	This field contains the current date.	N/A	Date	8	N/A
28	Full-Time Status	This field contains a Y if the student attends a full-time Kindergarten or Pre-Kindergarten program in your school district. Otherwise, this field defaults to N. This field is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information	[Students]MD_FulltimeStatus	Alpha-numeric	1	N/A
29	Filler	This field is not currently used.	N/A	Alpha-numeric	4	N/A
30	Entry Status	This field contains the letter that corresponds to the type of entry to the school assigned to this student. This field is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information. If this field is blank, this field is extracted from the Edit Current Enrollment page, Start Page > Student Selection > Transfer Info > Edit [Current/Previous] Enrollment.	[Students]MD_EntryStatus or [Students]EntryCode or [ReEnrollments]EntryCode	Alpha-numeric	1	N/A
31	Entry Code	This field contains the entry code that identifies the type of entry to the school assigned to this student. This field is extracted from the Edit Current Enrollment page, Start Page > Student Selection> Edit Current Enrollment.	[Students]EntryCode Or [ReEnrollments]EntryCode	Alpha-numeric	2	N/A
32	Entry Date	This field contains the date the student entered the school. This field is extracted from the Edit Current Enrollment, Start Page > Student Selection> Edit Current Enrollment.	[Students]EntryDate Or [ReEnrollments]EntryDate	Date	8	N/A
33	Withdrawal Status	This field contains the letter that corresponds to the type of withdrawal from the school assigned to this student. This field is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information. If this field is blank, this field is extracted from the Edit Current Enrollment page, Start Page > Student Selection > Transfer Info > Edit [Current/Previous] Enrollment.	[Students]MD_ExitStatus	Alpha-numeric	1	N/A
34	Withdrawal Code	This field contains the entry code that identifies the type of withdrawal from the school assigned to this student. This field is extracted from the Edit Current Enrollment, Start Page > Student Selection> Edit Current Enrollment.	[Students]ExitCode Or [ReEnrollments]ExitCode	Alpha-numeric	2	N/A
35	Withdrawal Date	This field contains the date the student withdrew from the school. This field is extracted from the Edit Current Enrollment, Start Page > Student Selection> Edit Current Enrollment.	[Students]ExitDate Or [ReEnrollments]ExitDate	Date	8	N/A
36	Days Attended	This field is calculated. It shows the aggregate number of days the student was in attendance during the current school year, to the nearest half-day (implied decimal). If the student has multiple records, there must be an attendance item for each period of the time a student was enrolled in a school.	N/A	Numeric	4	N/A
37	Days in Membership	This field is calculated. It shows the aggregate number of membership days for the student.	N/A	Numeric	4	N/A
38	State Aid Eligibility	This field identifies a student who is or is not eligible for state aid. This field is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information.	[Students]MD_StateAidEligibility	Numeric	2	N/A
39	Evening High Student	This field contains a Y if the student is an evening high school student. This field is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information.	[Students]MD_EveningHighStudent	Numeric	1	N/A
40	EH Number of Courses	This field contains the number of course in which the evening high school student is currently enrolled. This field is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information.	[Students]MD_NumberOfCourses	Alpha-numeric	1	N/A
41	Part-time Student	This field contains a Y if the student is a part-time student in a day school (excludes evening high school students). This field is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information.	[Students]MD_ParttimeDayStudent	Numeric	1	N/A
42	PT Number of Courses	This field contains the number of course in which the part-time student is currently enrolled. This field is extracted from the Maryland State Reporting page, Start Page > Student Selection > Maryland State Information.	[Students]MD_NumberOfCourses	Alpha-numeric	1	N/A