SC38 Chronic Absenteeism School Report
Introduction
This report displays the total number of absences per student broken down by attendance code category in either a PDF or CSV format.
Note: This report works on PowerSchool 10.1 and higher.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to the selection criteria for analysis when the report does not return the correct records.
The SC37 Chronic Absenteeism Update Process must be run prior to running the report.
The student must be enrolled at a school for at least 10 membership days to be included in the calculation.
The student will be flagged as a ‘Y’ (chronically absent) if recorded in PowerSchool as absent a minimum of 10 percent of membership days. Absences are excused, unexcused, and/or out of school suspensions.
Note: A student is considered absent if not present 50% or more of the school day.The student must be coded with an entry code of 'E'.
The student must not be excluded from state reporting.
Report Input
For additional help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools | Select the school. Note: This report can only be run at a school level. |
Select Only Students in These Grades | Select the checkbox next to the grade to include students in that grade level in the report. |
Sort By | Select a sort option:
|
Report Output | Select the appropriate report output file type. |
Select ONLY students enrolled in Alternative School | Select Yes to include only students enrolled in an alternative school during the school year, and select No to include all students. |
Run Now | Select this option to run the report immediately. |
Schedule | Select this option to run this report on a scheduled basis. Once this option is selected the following choices are: Run Once
Repeat
Date Range – Select No End Date or a date that the re-occurrence should end. |
Report Output - PDF
A student will be identified as ‘Y’ on the Chronic Absenteeism table if they have been enrolled at the school for more than 10 membership days and they have been absent 10 percent of their enrolled academic year (more details below). Each time the Chronic Absenteeism Update is run and a change is made to a student’s attendance record, a new record is created.
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.
Position | Field | Description | [Table]Field Name |
Report Header | |||
1 | Date | The date the report is run. | N/A |
3 | BEDS Code | BEDS Code is the combination of the District Code and School Code. | Derived |
4 | District Name | The name of the district. | [Prefs]Value [Prefs]Name=districtname |
5 | School Name | The name of the school. | [Schools]Name |
Report Body | |||
6 | Student Number | The student's ID. | [Students]Student_Number |
7 | Student Name | The student's name. Note: The student's name is displayed in parenthesis if the student is not active on the end date of the report. | [Students]LastFirst |
8 | Membership Days Flagged | The number of membership days. | [S_SC_STU_ChronicABSENCE_C]Membership_Days |
9 | Excused | The number of excused absences. | [S_SC_STU_ChronicABSENCE_C]Excused_Days_Absent |
10 | Unexcused | The number of unexcused absences. | [S_SC_STU_ChronicABSENCE_C]Unexcused_Days_Absent |
11 | Out-School Suspension | The number of days absent for out-of-school suspensions. | [S_SC_STU_ChronicABSENCE_C]OSS_Days_Absent |
12 | Total Absences | The total number of absences. | Calculated |
13 | Absence Percentage | The percentage of absences. Student’s total absence across all categories on total membership where calendar date is between the term firstdate and current date in the current school. | Calculated (excused_days_absent + unexcused_days_absent + oss_days_absent) / SUM (studentMembership * calendarMembership) *100 |
14 | Grade Level | The student's grade level. | [Students]Grade_Level |
15 | Current Membership Days | The current membership days. | Calculated |
Report Output - CSV
A student will be identified as ‘Y’ on the Chronic Absenteeism table if they have been enrolled at the school for more than 10 membership days and they have been absent 10 percent of their enrolled academic year (more details below). Each time the Chronic Absenteeism Update is run and a change is made to a student’s attendance record, a new record is created.
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.
Position | Field | Description | [Table]Field Name |
1 | Student Number | The student's ID. | [Students]Student_Number |
2 | Student Name | The student's name. Note: The student's name is displayed in parenthesis if the student is not active on the end date of the report. | [Students]LastFirst |
3 | Grade Level | The student's grade level. | [Students]Grade_Level |
4 | Membership Days Flagged | The number of membership days. | [S_SC_STU_ChronicABSENCE_C]Membership_Days |
5 | Current Membership Days | The current membership days. | Calculated |
6 | Excused | The number of excused absences. | [S_SC_STU_ChronicABSENCE_C]Excused_Days_Absent |
7 | Unexcused | The number of unexcused absences. | [S_SC_STU_ChronicABSENCE_C]Unexcused_Days_Absent |
8 | Out-School Suspension | The number of days absent for out-of-school suspensions. | [S_SC_STU_ChronicABSENCE_C]OSS_Days_Absent |
9 | Total Absences | The total number of absences. | Calculated |
10 | Absence Percentage | The percentage of absences. Student’s total absence across all categories on total membership where calendar date is between the term firstdate and current date in the current school. | Calculated (excused_days_absent + unexcused_days_absent + oss_days_absent) / SUM (studentMembership * calendarMembership) *100 |