ID Chronic Absenteeism Report

Introduction

The report displays the chronic absenteeism status for students enrolled during the dates selected while running the report.

Output file name format: ChronicAbsenteeism_[DistrictNum]_[Timestamp].csv

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.

Students selection

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

The student’s school exit date must occur 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 after their school entry date.
The school must not be excluded from state reporting.
The student must not be excluded from enrollment reporting.

Report input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools	Choose one of the following: Current School Only – This option is for troubleshooting purposes and Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – This option is only available when running the report from the District Office. Includes all student records on the PowerSchool server that meet selection criteria.
Select Students	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. If running the report for a single student, or group of students, select the students prior to running report.
Start Date	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy for the first day of the report date range.
End Date	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy for the last day of the report date range.

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	Field Name	[Table]FieldName	Field Type	Field Length	Reqd
1	stateStudentNumber	The Idaho student number.	State Student ID	[Students]State_StudentNumber	Varchar	9	Yes
2	lastName	The student’s last name. Note: If populated, the student's legal name overrides the student's preferred name.	Legal Name (Last) Name (Last)	[StudentCoreFields]PSCore_Legal_Last_Name [Students]Last_Name	Varchar	35	Yes
3	firstName	The student’s first name. Note: If populated, the student's legal name overrides the student's preferred name.	Legal Name (First) Name (First)	[StudentCoreFields]PSCore_Legal_First_Name [Students]First_Name	Varchar	35	Yes
4	middleName	The student’s middle name. Note: If populated, the student's legal name overrides the student's preferred name.	Legal Name (Middle) Name (Middle)	[StudentCoreFields]PSCore_Legal_Middle_Name [Students]Middle_Name	Varchar	30	No
5	suffix	The suffix for the student name. Note: If populated, the student's legal suffix overrides the student's preferred suffix.	Legal Name (Suffix) Suffix	[StudentCoreFields]PSCore_Legal_Suffix [S_ID_STU_X]Suffix	Varchar	8	No
6	gender	The student’s gender. Note: If populated, the student's legal gender overrides the student's preferred gender.	Legal Gender Gender	[StudentCoreFields]PSCore_Legal_Gender [Students]Gender	Option Set	1	Yes
7	schoolNumber	The school number.	Base School ID	[S_ID_STU_X]BaseSchoolId [S_ID_REN_X]BaseSchoolId [Schools]Alternate_School_Number [Schools]School_Number	Option Set	4	Yes
8	gradeLevel	The student’s grade level. PowerSchool grade levels below 0 report as PK. PowerSchool grade level 0 reports as KG	Grade Level	[Students]Grade_Level [ReEnrollments]Grade_Level [S_ID_STU_X]No_Grade [S_ID_REN_X]No_Grade	Option Set	2	Yes
9	chronicallyAbsent	A student is considered chronically absent if the student was enrolled for at least ten school days and absent for at least 10% or more of the total school days. Valid values: Yes - Y No - N If a student's school enrollment is excluded from enrollment reporting or if a student has been enrolled for less than 10 days, chronically absent is reported as N.		Calculated using the student schedule based on their day and not the school day Potential_Minutes_Present and Minutes_Absent	String	1	Cond