Chronic Absenteeism Student Report | PowerSchool SIS Compliance

Introduction

The Chronic Absenteeism Student Report is a new Mississippi state report that provides filtered and grouped student attendance data that meets the Mississippi chronic absenteeism threshold.

The administrators can use this information to perform daily interventions, monitor at-risk students, audit chronic absenteeism data for state reporting to MSIS, and enforce compulsory attendance.

The report considers the student’s total enrolled days based on Entry Date and Exit Date and school calendar in-session days.

Definitions

Chronic Absenteeism: A student is considered chronically absent when his total absences equal 10% or more of the enrolled days, calculated cumulatively across all schools where the student is enrolled within the district for the school year.

Absence: If a student misses 50% or more of an in-session school day, the absence for that day will count towards chronic absenteeism.

Summary Count

The report provides summary counts for the following levels:

District — total enrollment, total chronically absent days, chronic absenteeism rate
School — total enrollment, total chronically absent days, chronic absenteeism rate per school
Grade Level — total enrollment, total chronically absent days, chronic absenteeism rate per grade

Output File

The output file naming: MS_Chronic_Absenteeism_<timestamp> with extension based on selected output type HTML or CSV.

Student Selection criteria

A student is included when all applicable criteria below are met:

Student must be enrolled in the selected school year (from Students or ReEnrollments).
Student is not excluded from state reporting.
School is not excluded from state reporting.
If running at school level, only students from the selected school are included.
If running at district level and schools are selected, only students from selected schools are included.
If the student has one or more days where the absence is 50% or more of the school day, then the student is included in the report.
If Number of Days Missed (minimum) is blank, report will use 1 by default.
If Number of Days Missed (minimum) is entered, the report applies the entered value as the threshold (value entered must be greater than 0).

Report Input

Field	Description
School Year	Select the school year for which to run the report.
School (District-level filter)	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district.
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.
Grade Level	Select the grades from which to include students into the report (leave blank for all).
Gender	Select the gender of students to be included in the report (leave blank for all).
Race/Ethnicity	Select the race/ethnicity of students to be included in the report (leave blank for all).
Subgroups (SPED, EL, 504, Free/Reduced Lunch)	Select the relevant options from the list (leave blank for all).
Number of Days Missed (minimum)	The numeric threshold for total chronic absent days. (if blank, 1 is used by default)
Include Header Row	Valid values: Yes (Default) No
Report Output Type	Valid values: HTML (Default) CSV

Report Output

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	District Code / Name	The district identification number.	[MS_SRP_Chronic_Absenteeism]District_Code_Name	String	3
2	School Code	The three-digit school code.	[MS_SRP_Chronic_Absenteeism]School_Code_Name	String	3
3	School Name	The name of the school where the student is enrolled.	[MS_SRP_Chronic_Absenteeism]School_Identification	String	Variable
4	Student Name	The name of the student in the following format: Last, First, Middle	[MS_SRP_Chronic_Absenteeism]Last_First_Middle	String	Variable
5	MSIS Student ID	The state assigned student identifier. The MSIS ID must exist in MSIS in the format: 000000009.	[MS_SRP_Chronic_Absenteeism]MSIS_Student_Id	String	Variable
6	Student Number	The locally assigned student identifier.	[MS_SRP_Chronic_Absenteeism]State_Student_Identifier	String	Variable
7	Date of Birth	The date of birth of the student. Format: YYYY-MM-DD	[MS_SRP_Chronic_Absenteeism]Date_of_Birth	Date as String	10
8	Grade Level	The current grade level of the student.	[MS_SRP_Chronic_Absenteeism]Grade_Level	Number/String	Variable
9	Gender	The gender of the student.	[MS_SRP_Chronic_Absenteeism]Gender	String	1 (expected)
10	Race/Ethnicity	The race/ethnicity to which the student belongs.	MS_SRP_CHRONIC_ABSENTEEISM]Race_Ethnicity	String	Variable
11	SPED Indicator	Indicates if the student is enrolled in a SPED program. Valid values: Y N	[MS_SRP_Chronic_Absenteeism]SPED_Indicator	String	1
12	EL Indicator	Indicates if the student is enrolled in an EL program. Valid values: Y N	[MS_SRP_Chronic_Absenteeism]EL_Indicator	String	1
13	504 Indicator	Indicates if Section 504 is applicable for the student. Valid values: Y N	[MS_SRP_Chronic_Absenteeism]Section504_Indicator	String	1
14	Free/Reduced Lunch	Indicates if the student is eligible for Free/Reduced Lunch. Valid values: Y N	[MS_SRP_Chronic_Absenteeism]Free_Reduced_Lunch	String	1
15	Total Enrolled Instructional Days	This is determined by using the student’s Entry Date and Exit Date and only includes days that are in-session in the calendar.	[MS_SRP_Chronic_Absenteeism]Total_Enrolled_Instructional_Days	Number	Variable
16	Total Days Chronically Absent (50% of Day)	The count of days where present days percentage is less than or equal to 50%.	[MS_SRP_Chronic_Absenteeism]Total_Days_Absent	Number	Variable
17	Chronic Absenteeism Rate (%)	(Total Days Absent / Total Enrolled Instructional Days) × 100, rounded to 2 decimals.	MS_SRP_CHRONIC_ABSENTEEISM]Chronic_Absenteeism_Rate_PCT	Decimal	Variable
18	Last Known Date Present	The Last Known Present Date will reflect the current date if student has no absences and the attendance has been refreshed using Refresh Premier Attendance Views Data. If an absence is later added for the current day, then the most recent date when the student was present for more than 66%.	[MS_SRP_Chronic_Absenteeism]Last_Known_Date_Present	Date as String	10

Notes:

Field lengths are explicit only where the report logic enforces a fixed width (for example School Code and date formats).
Other output lengths are variable and depend on the source data in PowerSchool/state extension tables.