Student Enrollment Report

Field

Description

Schools to Include

Indicate which schools to include in the report by selecting from the following options:

If sub-districts are not enabled:

• Current School Only – Includes all student 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.

• District Wide – Includes all student records on the PowerSchool server that meet the selection criteria.

• Default

If sub-districts are enabled:

• Select Sub-district - Select the sub-district for which you want to run the report.

• Current School Only – Run the report for only the current selected school. Includes all student records associated with the selected schools that meet the selection criteria.

• All Schools in selected sub-district (default) – Run the report for all schools in the selected sub-district. Includes all student records on the PowerSchool server that meet the selection criteria.

Current Selection Students

Choose 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.

Report Start Date*

Enter the report start date.

Report End Date*

Enter the report end date.

Include Students Name In Output File

Choose whether to include the students' names in the report output file.

Data Element

Description

[Table]FieldName

Data Type

Field Length

SAUID

The NEO Organization ID for the attending School Administrative Unit (SAU).

This is the SAU ID used for uploading and entering the student's data.

Note: The district number on import must match the district number tied to the student’s enrollment. If they do not match, the following error message appears: “Student does not have an enrollment in this SAU ID, School ID, and school year.”

[Prefs]Name = ME_SAUID

[Prefs]Value

If sub-districts are enabled:

[CST_SubDistricts]Subdistrict_Number

Int

4

StateStudentID

The student's state ID.

Note: The student's state ID must match the existing state ID for the student; otherwise, the following error message appears: "There are currently no students enrolled with this state ID."

[Students]State_StudentNumber

Varchar

9

SchoolStudentID

The NEO Organization ID for the school the student attends.

Note: The school ID must match the school number of the school in which the student is enrolled for the year. If they do not match, the following error appears: “Student does not have an enrollment in this SAU Id, School ID, and school year.”

[Students]Student_Number

Varchar

10

YearCode

The school year designation.

Derived

Varchar

4

ResidentTown

The ID of the student's resident town.

[S_ME_STU_X]ResidentTown

[S_ME_STU_X]ResidentTownCode

Varchar

3

StartStatus

The reason the student started in the school.

See Enrollment Start Status Codesfor valid codes.

Blank is allowed.

[S_ME_STU_X]StartStatus

and

[S_ME_REN_X]StartStatus

Varchar

2

GradeLevelCode

The student's grade level.

[S_ME_STU_X]GradeLevelCode

and

[S_ME_REN_X]GradeLevelCode

Varchar

2

Effective Date

The effective date of enrollment.

Note: If the student's Effective Date field is not populated, the student's Entry Date is reported.

[S_ME_STU_X]EnrollmentEffectiveDate

and

[S_ME_REN_X]EnrollmentEffectiveDate

Date

N/A

ExitTypeCode

The reason the student left the school.

Required if exit date is entered.

See Enrollment Exit Type Status Codes for valid codes.

[S_ME_STU_X]EnrollmentExitType

and

[S_ME_REN_X]EnrollmentExitType

Varchar

5

ExitDate

Enter the student’s school enrollment exit date.

Note: This date is the day after the last day of school enrollment, even if that day occurs during a weekend.

This field is blank if ExitTypeCode is not populated.

[Students]ExitDate

Date

6-10

FiscalResponsibilityCode

Designation of who is responsible for the cost of the student's education.

See Fiscal Responsibility Codes for valid codes.

[S_ME_STU_X]FiscalResponsibility

and

[S_ME_REN_X]FiscalResponsibility

Varchar

1

Title1AFlagMath

The student's Title 1A status for math.

Valid values:

• Y – Yes

• N – No

[S_ME_STU_X]Title1AMath_YN

and

[S_ME_REN_X]Title1AMath_YN

Varchar

1

Title1AFlagEnglish

The student's Title 1A status for English.

Valid values:

• Y – Yes

• N – No

[S_ME_STU_X]Title1AELA_YN

and

[S_ME_REN_X]Title1AELA_YN

Varchar

1

AlternativeEdFlag

Indicates if the student is participating in an Alternative Education program.

Valid values:

• Y – Yes

• N – No

Required if applicable.

[S_ME_STU_X]AlternativeEducationflag_YN

and

[S_ME_REN_X]AlternativeEducationflag_YN

Varchar

1

HomeSchooledFlag

Indicates if the student is home schooled and attending a local school in the district part time or home schooled and receiving only Special Education Services.

Valid values:

• Y – Yes

• N – No

[S_ME_STU_X]HomeSchooledFlag_YN

and

[S_ME_REN_X]HomeSchooledFlag_YN

Varchar

1

FTE

The percent of time spent at school by a home schooled student. Also an option to designate only Special Education services received at school.

Required if Home Schooled is Y.

[S_ME_STU_X]PercentageSchoolDayCode

and

[S_ME_REN_X]PercentageSchoolDayCode

Varchar

2

Chapter504StatusFlag

Indicates if the student participates in a Chapter 504 program.

[S_ME_STU_X]Chapter504StatusFlag_YN

Varchar

1

GiftedTalentedAcademic

Indicates if the student participates in an Intellectual/Academic based Gifted and Talented program.

Valid values:

• Y – Yes

• N – No

Required if applicable.

[S_ME_STU_X]GiftedTalentedAcademic_YN

and

[S_ME_REN_X]GiftedTalentedAcademic_YN

Varchar

1

MilitaryFamilyFlag

Indicates the student's military connection.

Note: If the student's Military Family Fag field is blank, then the report extracts 'Unknown'.

[S_ME_STU_X]MilitaryConnection

and

[S_ME_REN_X]MilitaryConnection

Varchar

25

HomelessCode

Indicates the appropriate Homeless Night-time Residence.

Required if applicable.

See Homeless Nighttime Residence Code for valid codes.

[S_ME_STU_X]HomelessNightTimeResidence

and

[S_ME_REN_X]HomelessNightTimeResidence

Varchar

15

Unaccompanied Youth

Indicates the student's Unaccompanied Youth status.

Valid values:

• Y – Yes

• N – No

[S_ME_STU_X]UnaccompaniedYouth_YN

and

[S_ME_REN_X]UnaccompaniedYouth_YN

Varchar

1

Transitional Bilingual Education or Early Exit Education

Indicates whether the student is eligible or receiving services in an EL program for Transitional Bilingual Education or Early Exit Bilingual Education.

[S_ME_STU_X]TraBilingEarlyExit_YN

and

[S_ME_REN_X]TraBilingEarlyExit_YN

Varchar

1

Dual Language or Two Way Immersion

Indicates whether the student is eligible or receiving services in an EL program for Dual Language or Two-way Immersion.

[S_ME_STU_X]DualLangTwoWayImmer_YN

and

[S_ME_REN_X]DualLangTwoWayImmer_YN

Varchar

1

English as a Second Language or Language Development

Indicates whether the student is eligible or receiving services in an EL program for English as a Second Language (ESL) or English Language Development (ELD).

[S_ME_STU_X]ESLELD_YN

and

[S_ME_REN_X]ESLELD_YN

Varchar

1

Content Classes with Integrated ESL Support

Indicates whether the student is eligible or receiving services in an EL program in Content Classes with Integrated ESL Support.

[S_ME_STU_X]ContentClasses_YN

and

[S_ME_REN_X]ContentClasses_YN

Varchar

1

NewComer Programs

Indicates whether the student is eligible or receiving services in an EL program for Newcomer Program.

[S_ME_STU_X]Newcomer_YN

and

[S_ME_REN_X]Newcomer_YN

Varchar

1