AMI Attendance Audit Report
Contents
Introduction
The purpose of the Student Attendance Audit Report is to provide the school districts with the on-demand attendance rates for students when a combination of in-seat and remote instructions are being used. This report is not required for state submission.
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] and [ReEnrollments] tables based on the following criteria:
The student’s school must not be excluded from state reporting.
The student must have a school enrollment at the school included in the report.
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’s school exit date must occur on or after the entry date.
The student tracking must be set up as per requirement. For tracking setup and see PowerSchool SIS 20.4.3.0 v20.11. This section also contains information about disabling tracking when required.
The two new membership types must be added to the calendar set up for remote students.
School Selection
The report selects records from the [Schools] table if the school is not excluded from state reporting.
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:
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 | Specify the students to include in the report:
When running the report for a single student or a group of students, select the students prior to running the report. |
Start Date and End Date | Enter the beginning and ending date for the report date range. |
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Data Element | Description | [Table]FieldName |
| SchoolCode | The school is 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 |
| StateID | Export the student’s State ID Number. | [Students]State_StudentNumber |
| LocalStudentID | Export the student number. | [Students]Student_Number |
| LastName | Export student’s last name. | [StudentCoreFields]PSCore_Legal_Last_Name or If null [Students]Last_Name |
| FirstName | Export student’s first name. | [StudentCoreFields]PSCore_Legal_First_Name or If null [Students]First_Name |
| MiddleName | Export student’s middle name, if there are no export blank spaces. | [StudentCoreFields]PSCore_Legal_Middle_Name or If null [Students]Middle_Name |
| Suffix | Export student’s generation, if there are no export blank spaces. | [StudentCoreFields]PSCore_Legal_Suffix |
| StudentGradeLevel | The student’s grade level for enrollment 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 |
Total Potential Attendance Hrs (TotPotentialAttendHrs) | Export total scheduled hours after converting days to hours. Rule:
| Based on calendar and bell schedule. Considering all in-session days. Cumulative of all onsite and remote hours |
| Total Potential Onsite Hrs (TotPotentialOnsiteHrs) | This is the total hours, the student can potentially attend classes physically at the school. Rule:
For example, for a student on track A and A track is physical (Calendar membership code: A). For a student on track B and B track is physical (Calendar membership code: B) | Based on calendar and bell schedule. Considering all in-session days. Cumulative of all onsite hours. |
| Total Potential Remote Hrs (TotPotentialRemoteHrs) | This is the total hours the student can potentially attend classes remotely. Rule:
For example, a student on track A and B track is physical or All Remote (Calendar membership code: B or C). For a student on track B and A track is physical or All Remote (Calendar membership code: A or C).
| Based on the calendar, bell schedule, class enrollments, and student’s school entry and exit. Considering all in-session days. Cumulative of all remote hours. |
| Onsite Present Hrs (OnsitePresentHrs) | The number of hours the student was physically present in school (OnSite) on the days the student’s track is physical. The student’s track code should match with the physical membership type for that day. The hours are based on the start date and end date values of params. | Calculate the total hours the student was present (Blank andany Present Attendance Codes)from Field 10 ‘Total Potential Onsite Hrs’ |
| Onsite Absent Hrs (OnsiteAbsentHrs) | The number of hours the student was physically absent in school (OnSite) on the days the student’s track is physical. The student’s track code should match with the physical membership type for that day. The hours are based on the start date and end date values of params. | Calculate the total hours the student was absent (Absent Attendance codes) from Field 10 ‘Total Potential Onsite Hrs’ |
| Remote Present Hrs (RemotePresentHrs) | The number of hours the student was present remotely (Remote) on the days the student’s track is remote. The student’s track code should NOT match with the physical membership type for that day. The hours are based on the start date and end date values of params. | Calculate the total hours the student was present (Blank and any Present Attendance Codes)from Field 11 ‘Total Potential Remote Hrs’ |
| Remote Absent Hrs (RemoteAbsentHrs) | The number of hours the student was absent remotely (Remote) on the days the student’s track is remote. The student’s track code should NOT match with the physical membership type for that day. The hours are based on the start date and end date values of params. | Calculate the total hours the student was absent (Absent Attendance codes) from Field 11 ‘Total Potential Remote Hrs’. |
| Onsite Attendance Rate(OnsiteAttendanceRate) | The attendance percentage of the student when onsite Rule: Use the “Onsite Present Attendance percentage” calculation For example, a district with 1,100 calendar hours:
Hence: 515.63/550 Onsite Attendance Rate = 93.75% | (Field 12 ‘Onsite Present Hrs’ /Field 10 ‘Total Potential OnsiteHrs’) * 100 |
| Remote Attendance Rate (RemoteAttendanceRate) | The attendance percentage of the student when remote Rule: Use the “Remote Attendance Rate” calculation below For example, a district with 1,100 calendar hours:
Hence: 515.63/550 Remote Attendance Rate = 93.75% | (Field 14 ‘Remote Present Hrs’ /Field 11 ‘Total Potential RemoteHrs’) * 100 |
| Adjusted Attendance Hours(AdjustedAttendanceHrs) | The final attendance hours calculate the ‘Regular Hours Attended’ field of the June Attendance report. Final attendance is based on the student’s onsite attendance rate. Rule: Use the “in seat present attendance percentage” to calculate the total attendance percentage For example, a district with 1,100 calendar hours:
Attendance Hours = 1,031.25 hours Rounded to four decimals, reported in the format 0000.0000. | [(Field 16 ‘Onsite Attendance Rate’) * (Field 09 ‘Total Potential Attendance Hrs’)]/100 |