Student Absenteeism Report
Introduction
The Student Absenteeism Report extract generates the following two csv files that can be used to audit the CALPADS Student Absence Summary Records (STAS) extract. See the Student Absence Summary (STAS) Report for more information.
Student Absentee Detail: Reports detailed information about absenteeism for each student at a district or at a specific school.
Student Absentee Count: Reports attendance and student absenteeism counts as a percentage of the total cumulative enrollment by school.
Important Note: To ensure accurate report output, a CALPADS Attendance Category must be applied to all Attendance Codes with a "Presence Status" of 'Absent' (Start Page > School Setup > Attendance Codes > Edit/New Attendance Code > CALPADS Information).
Selection Criteria
Student Selection
The same criteria are used for all submissions throughout the year regardless of the submission period:
The student must be assigned an SSID.
The student must not be excluded from state reporting.
The student's school enrollment is not excluded from state reporting.
The student is enrolled in a school that is not excluded from state reporting.
The student must have a school enrollment with an Exit Date after the report start date and an Entry Date on or before the report end date. No shows (i.e. enrolled for only 1 day) are excluded.
School Selection
The school must not be excluded from state reporting.
The California Department of Education (CDE) has added a new grade level of ‘TK’ that districts must use when reporting Transitional Kindergarten students to CALPADS. This new grade level will be effective starting with the 2023-2024 school year.
To support this functionality, PowerSchool has updated all California state reporting pages and reports to honor the grade level mappings as defined by each district.
The grade level is reported as mapped in all CA-specific reports once you meet the following criteria:
You are on PS Version 23.1 or higher
LTK Pref is enabled
While running the report, the selected school year is 23-24 or higher.
LTK Grade Level Mapping - valid values:
Grade 0 = KN
Grades -1 and below = TK, PS, IN
Grades >12 = AD
Report Input
This report can be run at the District and School level.
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Report Parameters | Select the checkboxes next to the filter fields to save the settings as defaults. To select all checkboxes, choose Select All from the Report Parameters pop-up menu. To clear all checkboxes, choose Clear All. |
Select Schools [District only] | 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. |
Select Students | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Select Attendance Date Range | Select an option for the attendance date range:
|
Grade Level (blank for all) | To select a single grade level, click it. To select multiple grade levels, click the first value and drag your cursor down or use Ctl+Click (Command+Click for Macintosh). To select all grade levels, make no selection. |
Race/Ethnicity (blank for all) | To select a single Race/Ethnicity, click it. To select multiple Race/Ethnicity value, click the first value and drag your cursor down or use Ctl+Click (or Command+Click for Macintosh). To select all race/ethnicity values, make no selections. |
Enrollment Status (blank for all) | Select one of the following options.
|
EL Acquisition Status (blank for all) | Select an English Learner Acquisition Status or leave blank to include all statuses in the report. English Learner Acquisition Status definitions:
|
Gender | Select one of the following options:
|
Socio-Economically Disadvantaged | Select one of the following options:
|
Migrant Immigrant (135) | Select one of the following options:
|
Special Ed (144) | Select one of the following options:
|
Foster Youth (190) | Select one of the following options:
|
Armed Forces Family Member (192) | Select one of the following options:
|
Incomplete Independent Study Days | Select one of the following options: All Values: Students with and without incomplete Independent Study Days are reported. = 0: Only students with 0 Independent Study Days are reported. > 0: Only students with greater than 0 Independent Study Days are reported. |
Out-of-School Suspension Days | Select one of the following options: All Values: Students with and without Out-of-School Suspension Days are reported. = 0: Only students with 0 Out-of-School Suspension Days are reported. > 0: Only students with greater than 0 Out-of-School Suspension Days are reported. |
In-School Suspension Days | Select one of the following options: All Values: Students with and without In-School Suspension Days are reported. = 0: Only students with 0 In-School Suspension Days are reported. > 0: Only students with greater than 0 In-School Suspension Days are reported. |
Excused Absence Days | Select one of the following options: All Values: Students with and without Excused Absence Days are reported. = 0: Only students with 0 Excused Absence Days are reported. > 0: Only students with greater than 0 Excused Absence Days are reported. |
Unexcused Absence Days | Select one of the following options: All Values: Students with and without Unexcused Absence Days are reported. = 0: Only students with 0 Unexcused Absence Days are reported. > 0: Only students with greater than 0 Unexcused Absence Days are reported. |
Chronically Absent | Select one of the following options: All Values: All students are reported, regardless of whether they are chronically absent (% Absence is 10 or greater). Yes: Chronically absent students are reported. No: Chronically absent students are not reported. |
Student Enrolled < 30 Days | Select one of the following options: All Values: All students are reported, regardless of whether they have been enrolled for less than 30 days. Yes: Students enrolled less than 30 days are reported. No: Students enrolled less than 30 days are not reported. |
Exemption Indicator | Select one of the following options: All Values: All students are reported, regardless of whether they are attendance exempt. Yes: Only students who are attendance exempt are reported. No: Attendance exempt students are not reported. |
Implement the 'Exclude from ADA' flag to exclude designated student enrollments from this report | Select Yes to exclude ADA student enrollments from the output. Select No to include ADA student enrollments in the output. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Tables for a definition of each column in the table.
Student Absentee Details
Note: Some data in this file is pulled from the View “PS_ADAADM_Defaults All” rather than from a table.
Data Element | Description | [Table]FieldName |
School Code | The school number. | [Schools]School_Number |
School Name | The school name. Note: If the CDS School Name is populated, the report will extract it. If not, it will extract the normal school name. | [Schools]Name [S_CA_SCH_X]CDS_SchoolName |
SSID | The student’s Statewide Student Identifier (SSID) provided by the State of California. | [Students]State_StudentNumber |
Student Name | The student’s name. | [Students]Last_Name [Students]First_Name [Students]Middle_Name [Students]LastFirst |
Student Number | The student’s number. | [Students]Student_Number |
Grade | The student’s grade level. The Translated Text value from the appropriate Grade Level Mapping is used, if present. Otherwise, the numeric value from the Grade Level field is extracted in a 2-character format. EX: 1 = 01 State Business Rules: Student Exit Reason and Grade Level must be a valid combination. | [Students]Grade_Level |
Gender | The student’s gender. | [Students]Gender |
Race/Ethnicity | The student’s race or ethnicity | [StudentRace]Racecd [Students]Fedethnicity |
Enrollment Status | The student’s enrollment status code. | [S_CA_STU_X]EnrollmentStatus [S_CA_REN_X]EnrollmentStatus |
English Learner | The student’s current English language acquisition status. Valid values:
| [S_CA_STU_ELA_C]ELAStatus |
Socio-Economically Disadvantaged | Students are counted as economically disadvantaged if they have a free or reduced CALPADS lunch record (181 or 182) at any point in the reporting period. | [S_CA_STU_CALPADS_Programs_C] ProgramMembershipCode = 181 or 182 |
Exemption Indicator | Indicates whether the student is exempt from the attendance report. Note: If this is indicator is Y, the following fields are blank in the report:
| if [S_CA_STU_X]STASExemptionIndicator or [S_CA_REN_X]STASExemptionIndicator = 1, then Y or if [S_CA_SCH_X]StateSchoolNumber = '0000001' then Y or if [S_CA_SCH_X]SchoolType = '40' or '45', then Y otherwise NULL |
Days Expected | The number of days the student was expected to attend the school. | daysExpected [PS_ADAADM_Defaults_All]potential_attendancevalue |
Days Attended | The number of days the student attended the school. | daysAttended [PS_ADAADM_Defaults_All]attendancevalue |
Days Absent | The number of days the student was absent. This number is determined by subtracting Days Attended from Days Expected. | daysExpected [PS_ADAADM_Defaults_All]potential_attendancevalue daysAttended [PS_ADAADM_Defaults_All]attendancevalue |
% Absence | The percentage of days on which the student was absent. The absence percentage is calculated as follows: Days Attended is subtracted from Days Expected to get Days Absent. Days Absent is divided by Days Expected and then multiplied by 100. For example: If Days Expected are 59 and Days Attended are 51, the percentage calculation is: 59-51 = 8 / 59 = 0.13559 * 100 = 13.56% | daysExpected [PS_ADAADM_Defaults_All]potential attendancevalue daysAbsent [PS_ADAADM_Defaults_All]attendancevalue |
Independent Study Days Missed Coursework | A count of the number of Independent Study Days on which the student did not complete coursework. Note: Attendance setup is required. See Important Note. | [Attendance_Code]Unused1 = (II) Incomplete Independent Study |
Days Absent due to Out-Of-School Suspensions | A count of the days the student was absent due to an out-of-school suspension. Note: Attendance setup is required. See Important Note. | [Attendance_Code]Unused1 = (OS) Out-of-School Suspension |
In-School Suspension Days | A count of the number of in-school suspension days for the student. Note: Attendance setup is required. See Important Note. | [Attendance_Code]Unused1 = (IS) In-School Suspension (All Day) |
Days Excused Absences | A count of the number of days in which the student had an excused absence. Note: Attendance setup is required. See Important Note. | [Attendance_Code]Unused1 = (EX) Excused, Non-Suspension |
Days Unexcused Absence | A count of the number of days in which the student had an unexcused absence. Note: Attendance setup is required. See Important Note. | [Attendance_Code]Unused1 = (UX) Unexcused, Non-Suspension |
Chronically Absent | A student is considered chronically absent if the % Absence is 10 or greater. | % Absence >= 10% |
Enrolled < 30 days | Indicates whether the student has been enrolled less than 30 days. | daysExpected [PS_ADAADM_Defaults_All]potentialattendancevalue |
Student Absentee Count
Note: Some data in this file is pulled from the View “PS_ADAADM_DEFAULTS_ALL” rather than from a table.
Data Element | Description | [Table]FieldName |
School Code | The school number | [Schools]School_Number |
School Name | The school name | [Schools]Name |
Grade Level | The student’s grade level | [Students]Grade_Level |
Gender | The student’s gender | [Students]Gender |
Ethnicity/Race | The student’s ethnicity or race | [Students]Fedethnicity [StudentRace]Racecd |
Total Unduplicated | Count of students who do not have multiple enrollments in the district. Note: If a student is at more than one school within a district during the year, the student will count in each school; however, the count will be unduplicated at the district level. | [Students]ID |
Total Duplicated | Count of student who have multiple enrollments in the district. | [Students]ID |
# Stu. w/ Absence Data | A count of the number of students who have absence data. This is a sum of the number of students where Days Absent is greater than 0. Note: Attendance setup is required. See Important Note. | daysAbsent [PS_ADAADM_Defaults_All]attendancevalue [Attendance_Code]Unused1 = (OS) Out-of-School Suspension [Attendance_Code]Unused1 = (EX) Excused, Non-Suspension [Attendance_Code]Unused1 = (UX) Unexcused, Non-Suspension |
#Stu. w/ Absence Data Exemptions | Sum of students with an Exemption Indicator of 'Y' in the Student Absentee Details extract. | [S_CA_SCH_X]StateSchoolNumber [S_CA_SCH_X]SchoolType |
Student Absent < 5% Total | Sum of students where Days Absent divided by Expected Days = < 5%. | daysExpected [PS_ADAADM_ Defaults_All]potential attendancevalue daysAbsent [PS_ADAADM_ Defaults_All]attendancevalue |
Student Absent < 5% Percent | Sum of students with absences of < 5% divided by the sum of students with Absence data. | daysExpected [PS_ADAADM_ Defaults_All]potential attendancevalue daysAbsent [PS_ADAADM_ Defaults_All]attendancevalue |
Student Absent > 5% and < 10% Total | Sum of students where Days Absent divided by Expected Days >= 5% and < 10% | daysExpected [PS_ADAADM_Defaults_All]potentialattendancevalue daysAbsent [PS_ADAADM_ Defaults_All]attendancevalue |
Student Absent > 5% and < 10% Percent | Sum of students with absences >= 5% and < 10% divided by the sum of students with Absence data. | daysExpected [PS_ADAADM_Defaults_All]potential attendancevalue daysAbsent [PS_ADAADM_Defaults_All]attendancevalue |
Student Absent > 10% and < 20% Total | Sum of students where Days Absent divided by Expected Days >= 10% and < 20%. | daysExpected [PS_ADAADM_Defaults_All]potential attendancevalue daysAbsent [PS_ADAADM_ Defaults_All]attendancevalue |
Student Absent > 10% and < 20% Percent | Sum of students with absences >= 10% and < 20% divided by the sum of students with Absence data. | daysExpected [PS_ADAADM_ Defaults_All]potential attendancevalue daysAbsent [PS_ADAADM_Defaults_All]attendancevalue |
Student Absent => 20% Total | Sum of students where Days Absent divided by Expected Days >= 20%. | daysExpected [PS_ADAADM_Defaults_All]potentialattendancevalue daysAbsent [PS_ADAADM_ Defaults_All]attendancevalue |
Student Absent => 20% Percent | Sum of students with absences >= 20% divided by the sum of students with Absence data. | daysExpected [PS_ADAADM_Defaults_All]potentialattendancevalue daysAbsent [PS_ADAADM_ Defaults_All]attendancevalue |