Student Enrollment and Attendance Report

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.

Year*

The pop-up menu defaults to the currently selected school year. To change the school year, click Term at the top of the page and choose the appropriate school year term.

Reporting Cycle*

Choose the appropriate reporting cycle from the pop-up menu.

Note: If you do not want to calculate chronic absenteeism, choose On Demand - No Chronic Absenteeism.

Start Date*

Enter the start date for the report date range.

End Date*

Enter the end date for the report date range.

Report Validation Errors?

Choose one of the following:

Note: It is highly recommended that the Validation Report be run prior to Producing the extract file.

• Yes-Report Validation Errors: A Validation Report will process and include all of the errors.
  
• No-Produce Extract File: The Student Enrollment and Attendance Extract will process. If there were errors that did not get corrected, the field with the error will not be reported. If no errors were found, a “No Validation Errors Found” message appears.

Include Virtual Attendance?

Choose No to run the report without including virtual attendance calculations.

Choose Yes to include virtual attendance calculations, including the capping of attendance for virtual attendance students, where applicable.

005

Collection Version

The version is the end year of the current school year, such as 2012 for the 2011-2012 school year and the reporting cycle chosen at runtime, followed by 1.0StuEnrlAttnd.

For example:

2012Aug1.0StuEnrlAttnd

[Terms]LastDay YYYY

R

R

010

Current School Year

The end year of the current school year, such as 2012 for the 2011-2012 school year.

[Terms]LastDayLastDay YYYY

R

R

015

Attending District Code

The DESE-assigned 6-digit county district code for the district where the student attends classes.

For code sets, see MO Core Data/MOSIS

[S_MO_STU_X]AttendingDistrict

[S_MO_REN_X]AttendingDistrict

R

O

020

Attending School Code

The DESE-assigned 4-digit code for the school where the student attends classes.

[S_MO_STU_X]AttendingSchool

[S_MO_REN_X]AttendingSchool

R

O

025

Reporting District Code

The district responsible for reporting the student’s data.

[Prefs]Value

[Prefs]Name=districtnumber

R

R

030

Reporting School Code

The school responsible for reporting the student’s data. The report extracts the alternate school number, if populated. Otherwise, the school number is reported.

[Schools]Alternate_School_Number

[Schools]School_Number

R

R

035

Resident District Code

The 6-digit code for the district where the student resides.

[Students]DistrictOfResidence

[ReEnrollments]DistrictOfResidence

R

O

040

Resident School Code

The 4-digit code for the student’s school of residence.

[S_MO_STU_X]SchoolofResidence

[S_MO_REN_X]SchoolofResidence

R

O

045

State ID

The state-assigned student number. For more information, see the MOSIS Reference Manual.

All submitted students must have a unique state ID.

[Students]State_StudentNumber

R

R

050

Local Student ID

The locally assigned student identifier.

[Students]Student_Number

O

O

055

Last Name

The student’s legal last name.

[StudentCoreFields]PSCore_Legal_Last_Name

Or, if NULL:

[Students]Last_Name

O

O

060

First Name

The student’s legal first name.

[StudentCoreFields]PSCore_Legal_First_Name

Or, if NULL:

[Students]First_Name

O

O

065

Middle Name

The student’s legal middle name.

[StudentCoreFields]PSCore_Legal_Middle_Name

Or, if NULL:

[Students]Middle_Name

O

O

070

Suffix

This element is not collected.

[StudentCoreFields]PSCore_Legal_Suffix

O

O

075

Date of Birth

The student’s date of birth, reported in the format MM/DD/YYYY.

[Students]DOB

R

R

080

Student Grade Level

The student’s grade level for the enrollment that occurs during the reporting cycle. If the student’s grade level is equal to 0, the value is extracted from the Kindergarten Enrollment field. If the student’s grade level is less than zero, it is reported as PK.

[S_MO_STU_X]Kindergarten

[S_MO_REN_X]Kindergarten

[Students]Grade_Level

[ReEnrollments]Grade_Level

R

R

090

Residency Status

The student’s residency status.

For code sets, see MO Core Data/MOSIS

[S_MO_STU_X]ResidencyStatus

[S_MO_REN_X]ResidencyStatus

R

R

095

Regular Hours Attended

[Attendance]Att_Date

[Students]EntryDate

[Students]ExitDate

For Resident II students only:

[S_MO_STU_X]HrsPresent

[S_MO_REN_X]HrsPresent

C

N

100

Regular Hours Absent

The number of hours the student is absent during the report date range, rounded to four decimals and reported in the format 0000.0000.

[Attendance]Att_Date

[Attendance]Attendance_CodeID

[Attendance_Code]Presence_Status_CD = Absent

[Students]EntryDate

[Students]ExitDate

For Resident II students only:

[S_MO_STU_X]HrsAbsent

[S_MO_REN_X]HrsAbsent

C

N

105

Remedial Hours Attended

The number of remedial hours the student attended, for each school in the current school year and reported in the format 0000.0000.

This element must not exceed 9 characters.

[S_MO_STU_X]RemHrsAttended

R

N

110

Hours in Session

Required for Resident II students only. The number of hours possible for the entire year at the school the student attended. Must be a minimum of 1,044 hours. This element must not exceed 9 characters.

For Resident II students only:

[S_MO_STU_X]HoursInSession

[S_MO_REN_X]HoursInSession

C

N

115

Summer Attendance

The total number of hours the student attended school, rounded to four decimals, reported in the format 0000.0000.

[Attendance]Att_Date

[Students]EntryDate

[Students]ExitDate

N

R

120

Summer Membership

The total number of hours the student was a member of the school, rounded to four decimals and reported in the format 0000.0000.

[Students]EntryDate

[Students]ExitDate

N

R

125

Entry Date

The student’s school entry date for the reporting period.

[Students]ExitDate

[ReEnrollments}ExitDate

R

N

130

Entry Code

The student’s school entry code for the reporting period.

[Students]EntryCode

[ReEnrollments]Entrycode

R

N

135

Exit Date

The student’s school exit date for the reporting period.

[Students]ExitDate

[ReEnrollments}ExitDate

R

N

140

Exit Code

The student’s school exit code for the reporting period.

[Students]ExitCode

[ReEnrollments]ExitCode

R

N

145

Exit Destination District Code

The DESE-assigned 6-digit county district code for the district the student is confirmed to be transferred to. This field is required if a student is marked as "Transfer Out to another school or district in the state".

Note: This code is required if the Exit Code equals T002 or T001.

[S_MO_STU_X]ExitDestDistrictCode

[S_MO_REN_X]ExitDestDistrictCode

C

N

150

Exit Destination School Code

The DESE-assigned 4-digit school code for the school the student is confirmed to be transferred to. This field is required if a student is marked as "Transfer Out to another school or district in the state".

Note: This code is required if the Exit Code equals T002 or T001.

[S_MO_STU_X]ExitDestSchoolCode

[S_MO_REN_X]ExitDestSchoolCode

C

N

155

Exit Destination Comment

A detailed comment that describes the student's exit from the school or district.

Note: A comment is required if the Exit Code equals T003, T004, T005, T006, T007, or T008.

[S_MO_STU_X]ExitDestComment

[S_MO_REN_X]ExitDestComment

C

N

156

School Choice

The student’s school choice status.

Students enrolled in a Title I school are eligible for school choice when their school is in the first and subsequent years of school improvement, corrective action, and restructuring.

[S_MO_STU_X]SchoolChoice

[S_MO_REN_X]SchoolChoice

C

N

157

Extended School Hours

Number of extended school year hours of special education and related services provided to a child with a disability. These are hours beyond the normal school year of the public agency and, in accordance with the child's IEP, are at no cost to the parents of the child, and meet the standards of the State Education Agency.

[S_MO_STU_X]ExtSchlHours

[S_MO_REN_X]ExtSchlHours

N

R

The number of absences where a student's actual attendance is less than half of his or her potential attendance.

When a student is absent for 50% or more of the school day, he or she is marked as absent for the day. If the number of days absent is greater than half the number of days of potential attendance, the value for Chronic Absenteeism is the total number of school days absent.