Attendance Hours Audit

Contents

Report Description

Attendance hours provides detailed student attendance and absence data by grade level and residency status as shown on DESE Screen 14 - Attendance specific to MSIP/NCLB sections only. This report provides present, absent and percentage attendance hours for students based on IEP, LEP, and FRL status, as well as gender and ethnicity. This report can only be run at the School level.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students]table based on the following criteria:

The student’s school must not be excluded from state reporting.
The student must have a school enrollment for the current school.
The student's school exit date must occur on or after the report start date.
The student's school entry date must occur on or before the report end date.
The student cannot have a Residency Status of Resident II (R2)

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 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.
Begin Date and Ending Date	Enter the beginning and ending date for the report date range.
Include Virtual Attendance?	Select No to run the report without including virtual attendance calculations. Select Yes to include virtual attendance calculations, including the capping of attendance for virtual attendance students, where applicable.
Include IEP, FRL, & ELL	Select Yes to include IEP, FRL, and ELL data. Default is No.

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.

Item #	Data Element	Description	[Table]FieldName
Header 1	Report Start Date	The first day of the attendance period, entered at report runtime.	User Defined
Header 2	Report End Date	The last day of the attendance period, entered at report runtime.	User Defined
Header 3	School Name	The name of the school	[Schools]Name
Header 4	School Attendance Hours Cap	The value from the field, Actual Attendance Hours (from DESE Screen 10). This represents the maximum attendance hours for a full-time student. Note: Attendance capping is now invoked only for students taking virtual classes.	[S_MO_SCH_X]CalendarHours
Header 5	School ID	The school number. The alternate school number is reported, if populated, otherwise the school number is reported.	[Schools]Alternate_School_Number [Schools]School_Number
1	School ID	The school number. The alternate school number is reported, if populated, otherwise the school number is reported.	[Schools]Alternate_School_Number [Schools]School_Number
2	Grade	The grade level for the student's school enrollment.	[Students]Grade_Level [ReEnrollments]Grade_Level
3	Student Number	The locally assigned student number.	[Students]Student_Number
4	Name	The student's first and last name.	[Students]LastFirst
5	Gender	The student's gender.	[Students]Gender
6	Ethnicity	The student's ethnicity. Note: For code sets go to MO Code Set Document	[Students]FedEthnicity [StudentRace]RaceCd
7	District of Residence	The district of residence assigned to the student's school enrollment.	[Students]DistrictOfResidence [ReEnrollments]DistrictOfResidence
8	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
9	DesegIn	No longer collected for state reporting Indicates if the student was transferred into the current district, where both the current and previous districts were within the jurisdiction of a desegregation court order.	[S_MO_STU_X]ResidencyStatus
10	Federal Lands	No longer collected for state reporting Indicates that the student lives on federal lands, but attends school within the current district.	[S_MO_STU_X]ResidencyStatus
11	Tuition Payer	No longer collected for state reporting Indicates that the student pays tuition for the school.	[S_MO_STU_X]ResidencyStatus
12	Part Time Indicator	Indicates that the student attends school part-time.	[Students]parttimestudent
13	Regular Attendance Hours	The total number of regular present attendance hours for the student during the report date range, rounded to four decimals, reported in the format 0000.0000. Review additional information about troubleshooting attendance.	Calculated based on: Potential Minutes Present – (Potential Minutes Present – Total Minutes Present) Minutes are summed, converted to hours (/60), and reported to four decimal places. Database References: [PS_Membership_Defaults]Potential_Minutes_Present [PS_Attendance_Daily]Total_Minutes
14	Virtual Attendance Hours	The total number of virtual attendance hours for the student is calculated based on the Course Completion Status: If the student has completed the course then 94% or 95% virtual attendance is awarded. 95% attendance is awarded when the student is participating in an A+ program (Y) or the student has completed the A+ program (C) and the program code is 50 or 52. If the student partially completed the course then 47% virtual attendance is awarded. If the student course is incomplete then no virtual hours are awarded. If the student's Course Completion Status is blank then the following calculation applies: If the student was enrolled on the section midpoint date, the student will receive the 47% Virtual Award as entered in PowerSchool. If the student was enrolled on the last day of the term for the school where the section is created, the student receives a 47% Virtual Award as entered. If the student was enrolled on both the Mid-point and the last day of the term, the student receives both awards, totaling 94% for the class (47% + 47% = 94%). The Virtual Hours value for the course or section must be greater than 0.	[S_MO_CC_X]cc_status [S_MO_SEC_X]VirtualHours [S_MO_CRS_X]VirtualHours [S_MO_SEC_X]SectionMidpoint
15	Total Attendance Hours	The total number of regular and virtual attendance hours present or the student during the report date range. When the Virtual Attendance option is selected at runtime, the student's calculated Virtual Attendance Hours are added to the Regular Attendance Hours. Attendance Capping: If a student's Total Attendance Hours exceed the maximum possible for the school based on the Actual Attendance Hours (from DESE Screen 10) field, the Total Hours are capped to equal the school's maximum. Note that capping applies only to students with virtual attendance.	The calculations for Regular Attendance Hours and Virtual Attendance Hours are used. Minutes are summed, converted to hours (/60), and reported to four decimal places. When Attendance Capping is required, the Actual Attendance Hours for the school are referenced: [S_MO_SCH_X]CalendarHours
16	Absence Hours	The total number of absent attendance hours for the student during the report date range. Review additional information about troubleshooting attendance.	Calculated based on: Potential Minutes Present - Total Minutes Present Minutes are converted to hours (/60), and reported to four decimal places. Database References: [PS_Membership_Defaults]Potential_Minutes_Present [PS_Attendance_Daily]Total_Minutes
17	Total Hours	The total hours for the student, including hours attended (with virtual attendance, if selected, and if applicable to the student) and hours absent.	[PS_Membership_Defaults]Potential_Minutes_Present Minutes are converted to hours (/60), and reported to four decimal places.
18	Attendance Percent	The percentage of time a student has been in attendance calculated as Attendance Hours/Total Hours and rounded to two decimal places.	(Total Hrs Attended)/(Total Hrs Attended + Total Hrs Absent)
19	IEP	Indicates whether the student participates in special education.	Derived from [S_MO_STU_X]Handicapping_Conditions and [S_MO_STU_X]SPEDExit_Date If [S_MO_STU_X]Handicapping_Conditions not = NULL or 00 AND [S_MO_STU_X]SPEDExit_Date = NULL or is a future date: 'Yes' Otherwise: 'No'
20	FRL	Indicates whether the student receives a free or reduced lunch.	Derived from [Students]LunchStatus If [Students]LunchStatus = F R, FDC, or T: 'Yes' Otherwise: 'No'
21	LEP	Indicates if the student is identified as Limited English Proficient.	Derived from [S_MO_STU_X]LEPELL IF [S_MO_STU_X]LEPELL = RCV: 'Yes' Otherwise: 'No'
22	Total Hours	The total attendance hours for all students.	Grand Total derived using the same attendance calculations as previously described.
23	Total Black Male	The total attendance hours for black male students.	[Students]FedEthnicity = N [StudentRace]RaceCd = B [Students]Gender = M
24	Total Black Female	The total attendance hours for black female students.	[Students]FedEthnicity = N [StudentRace]RaceCd = B [Students]Gender = F
25	Total White Male	The total attendance hours for white male students.	[Students]FedEthnicity = N [StudentRace]RaceCd = W [Students]Gender = M
26	Total White Female	The total attendance hours for white female students.	[Students]FedEthnicity = N [StudentRace]RaceCd = W [Students]Gender = F
27	Total Hispanic Male	The total attendance hours for Hispanic male students.	[Students]FedEthnicity = Y [Students]Gender = M
28	Total Hispanic Female	The total attendance hours for Hispanic female students.	[Students]FedEthnicity = Y [Students]Gender = F
29	Total Asian Male	The total attendance hours for Asian male students.	[Students]FedEthnicity = N [StudentRace]RaceCd = A [Students]Gender = M
30	Total Asian Female	The total attendance hours for Asian female students.	[Students]FedEthnicity = N [StudentRace]RaceCd = A [Students]Gender = F
31	Total Native American Male	The total attendance hours for Native American male students.	[Students]FedEthnicity = N [StudentRace]RaceCd = I [Students]Gender = M
32	Total Native American Female	The total attendance hours for Native American female students.	[Students]FedEthnicity = N [StudentRace]RaceCd = I [Students]Gender = F
33	Total Hawaiian or Pacific Islander Male	The total attendance hours for Hawaiian or Pacific Islander male students.	[Students]FedEthnicity = N [StudentRace]RaceCd = P [Students]Gender = M
34	Total Hawaiian or Pacific Islander Female	The total attendance hours for Hawaiian or Pacific Islander female students.	[Students]FedEthnicity = N [StudentRace]RaceCd = P [Students]Gender = F
35	Total Multi-Race Male	The total attendance hours for Multi-Race male students.	[Students]FedEthnicity = N COUNT([StudentRace]RaceCd>1 [Students]Gender = M
36	Total Multi-Race Female	The total attendance hours for Multi-Race female students.	[Students]FedEthnicity = N COUNT([StudentRace]RaceCd>1 [Students]Gender = F