Report 14.2 - Student Absences-Student List

(Updated 05/01/2026)

Description: Reports a student list of positive attendance and student absenteeism by days of expected attendance, days attended and days absent. Absences are totaled by days excused, days unexcused, and days missed due to out-of-school suspensions.

Security Role Required: EOY Reports

Data As Of:

  • Snapshot version, any time in the reported academic year (7/1 – 6/30)

Basic selection criteria:

  • Any open or closed enrollment within the LEA at any time during the Report Period (7/1/2024 - 6/30/2025) qualifies for selection.

  • Enrollment Status Code = Primary Enrollment (10), Short Term Enrollment (30)

  • Default Grade Level = TK – 12

  • Qualifying Data:

  • Student Absent Summary Record (Record Type \= STAS) for the Academic Year being reported

  • Student Enrollment (SENR) reported or used for selecting student subgroups (e.g. Enrollment Status and Grade Level) are associated with the most recent qualifying enrollment at the school during the Report Period - Student Information (SINF) data reported or used for selecting student subgroups (e.g. Ethnicity/Race) are selected from the most recent SINF record with Effective Start Date and Effective End Date (if exists) that overlap the most recent qualifying enrollment at the school during the Report Period - Student Program (SPRG) data used for selecting student subgroups (e.g., Special Education Program) are selected from the most recent SPRG record for the same school of attendance as the STAS record with the Education Program membership Start Date and Education program Membership End Date (if exists) that overlap with the most recent qualifying enrollment at the school during the Report
  • Student English Language Acquisition Status (SELA) data reported or used for selecting student subgroups (e.g. ELAS Status) are selected from SELA record for students with a qualifying enrollment. Student English Language Acquisition (SELA) reporting will need to find the most recent status on the report date (using Effective Start Date) that was effective during the reporting period, regardless of Reporting LEA (unless specified otherwise in the specific report data field).

Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed

  • Academic Year
  • LEA
  • Status
  • School Type
  • School
  • Grade
  • Gender
  • Ethnicity/Race
  • Enrollment Status
  • English Language Acquisition Status
  • Socio-economically Disadvantaged
  • Students with Disabilities
  • Homeless Program Eligible
  • Title I Part C Migrant
  • Foster Youth
  • Hourly Attendance Indicator
  • Period-by-Period Attendance Method Indicator
  • Absenteeism Category
  • Absence Type*
  • Expected Attendance Days Indicator
  • Days Attended Indicator

*Note: This filter will affect the formula for determining the absence rate for each student when being displayed on the report. When a specific absence type is selected, only those records with at least one day in the selected absence type will appear on the report with all of the record’s data populated. Example: When Out-of-School Suspension is selected, the formula rate \= Out of School Suspension Days/Expected Attendance Days multiplied by 100.

Report Logic


Report 14.2 Screenshot

Click image to expand


# Column Description
1 School Code Derived from user ID permission and Expected Schools table
2 School Name Determined by #1 and the Expected Schools Table
3 SENR Field 1.08 Unique identifier for the student assigned by the first California district of enrollment. This number follows the student throughout their enrollment within the California educational system
4 Student Name SINF 2.13 (Student Legal Last Name), SINF 2.11 (Student Legal First Name), and SINF 2.12 (Student Legal Middle Name)
5 SENR Field 1.09 Identifier assigned to the student by a local educational agency
6 Gender SINF Field 2.19 (Student Gender Code)
7 Grade SENR Field 1.25 (Grade Level Code) = TK–12
8 Ethnicity/Race Identified using SINF fields 2.24 (Student Hispanic Ethnicity Indicator), 2.25 (Student Ethnicity Missing Indicator), 2.26–2.30 (Student Race 1–5 Code), and 2.31 (Student Race Missing Indicator) per the following rules:

1. If Field 2.24 = Y, always roll up to Hispanic, even if one or more races are selected or Field 2.31 = Y
2. If Field 2.24 = N or null and Field 2.25 = Y or null and Race 1–5 Codes (Fields 2.26–2.30) are indicated, roll up per rule 5
3. If Field 2.24 = N and Field 2.31 = Y, roll up to Missing
4. If Field 2.24 = N or null and Field 2.31 = Y, roll up to Missing
5. If Field 2.24 = N or null, Field 2.31 = N or null, and Race 1–5 Codes (Fields 2.26–2.30) are indicated:
• Single race = 100 → American Indian or Alaska Native
• One or more Asian subgroups (201–208, 299) only → Asian
• Single race = 400 → Filipino
• Filipino (400) + one or more Asian subgroups only → Filipino
• One or more Hawaiian/Pacific Islander subgroups (301–304, 399) only → Hawaiian/Pacific Islander
• Single race = 600 → Black or African American
• Single race = 700 → White
• More than one of the above race categories → Multiple

Note: The above rules apply to Snapshot reports starting AY 2016–2017 and ODS reports. For ODS reports displaying Ethnicity/Race generated in AY 2016–2017, Filipino will not be displayed as a separate ethnicity/race or counted within the Asian category.
9 SENR Field 1.23 Enrollment Status Code
10 SELA Field 12.13 Student ELAS Status Code
11 Socioeconomically Disadvantaged Yes/No indication of whether the student meets socioeconomically disadvantaged criteria via any of the following options:
• Option 1: Parent/Guardian Highest Education Level Code (SINF Field 2.50 = 14 – Not HS Graduate) from most recent SINF record
• Option 2: SPRG Field 3.13 = 181 or 182
• Option 3: Migrant Eligible based on weekly MSIN file
• Option 4: SPRG Field 3.13 = 191
• Option 5: Foster Program Eligible
• Option 6: Direct Certification = Y
• Option 7: Student enrolled in a Juvenile Court School
• Option 8: SPRG Field 3.13 = 193
12 STAS Field 13.13 Student Absence Summary Data Collection Exemption Indicator
13 STAS Field 13.23 Period-by-Period Attendance Method Indicator
14 STAS Field 13.15 Expected Attendance Days
15 STAS Field 13.22 ADA-Generating Independent Study Days
16 STAS Field 13.16 Days Attended In-Person
17 STAS Field 13.17 Days Absent Out-of-School Suspension
18 STAS Field 13.18 Days in Attendance In-School Suspension
19 STAS Field 13.19 Days Absent In-Person Excused Non-Suspension
20 STAS Field 13.20 Days Absent In-Person Unexcused Non-Suspension
21 STAS Field 13.21 Incomplete Non-ADA Generating Independent Study Days
22 Days Absent Sum of fields 17 + 19 + 20 + 21.

Calculation: Days Absent Out-of-School Suspension + Days Absent Excused Non-Suspension + Days Absent Unexcused Non-Suspension + Incomplete Independent Study Days.
Note: Excludes STAS records where Exemption Indicator = Y.
23 % Absent Calculation: (Fields 17 + 19 + 20 + 21) ÷ Field 14 × 100.

Days Absent Out-of-School Suspension + Days Absent Excused Non-Suspension + Days Absent Unexcused Non-Suspension + Incomplete Independent Study Days, divided by Expected Attendance Days, multiplied by 100. Rate is expressed as a percent to the second decimal (000.00%).
Note: This formula is dependent on the filters selected for absent type.
24 Chronically Absent — DataQuest (≥10%) Definition used for Absenteeism reports on DataQuest.

Calculation: If % Absent ≥ 10% and Expected Attendance Days > 30, then Y; else blank.
25 Chronically Absent — Accountability (≥10%) Definition used in the Dashboard.

Calculation: If % Absent ≥ 10% and Expected Attendance Days > 30 and student is in Grades TK–8, then Y; else blank.
26 Attendance Recovery Days Attendance Recovery Days for the student. If no STAS records are submitted, displays as 0.

Additional Resources

CALPADS File SpecificationsForm

Look for Student Enrollment (SENR), Student Information (SINF), and Student Absence Summary (STAS) tabs for the fields indicated in the report logic.

CALPADS Data Guide

Chapter 2.1.6 provides additional information on Cumulative Enrollment and Student Absence.

CALPADS Code Sets

This document contains the current code values referenced in the file specifications for the coded value data elements. The program code definitions are listed in this document.