Skip to main content
California Department of Education Logo

File Structure: Truancy Data

File structure for downloadable files containing aggregate truancy data. The file contains the total number of truancies reported by each local educational agency, including Census Day enrollment, cumulative enrollment, and rates.

File Name: truancy12.txt, truancy13.txt, truancy14.txt

For each aggregation level (AggLevel), there is one record for every instance where there is data.

Field Name Type Field Width Description

Year

Character

4

The academic year associated with the year for which truancy data were reported to the California Basic Educational System (CBEDS).

CDS Code

Character

14

This 14-digit code is the official unique identification of a school within California. The first two digits identify the county, the next five digits identify the school district, and the last seven digits identify the school.

AggLevel

Character

1

D=Local educational agency totals (includes districts and direct funded charter schools)

O=County totals

S=School totals

T=State totals

Name Character 100 Name of the county, district, or school depending on the AggLevel.
Truant Students Numeric 7 The aggregate count students who were reported as being truant at least one time during the academic year.

Census Enrollment

Numeric

7

The total unique or unduplicated number of primary enrollments on the CALPADS Fall 1 Census Day, which is the first Wednesday in October of the associated academic year.

Cumulative Enrollment

Numeric

7

The total number of unique or unduplicated primary, secondary, and short-term enrollments within the academic year (July 1 to June 30), regardless of whether the student is enrolled multiple times within a school or district.

Truancy Rate

Decimal

10.6

The number of truant students divided by the cumulative enrollment, multiplied by 100.

Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Tuesday, April 30, 2019
Recently Posted in Demographics
  • DataQuest Update 4 (added 24-Feb-2020)
    DataQuest Update 4, January 2020, Release of New Data
  • DataQuest Update Issue #2 (added 03-Feb-2020)
    The DataQuest Update is intended to keep DataQuest users informed about upcoming data releases, new reports and downloadable data files, enhancements and changes to DataQuest, and provide tips on how to use DataQuest
  • DataQuest Update Issue #1 (added 03-Feb-2020)
    The DataQuest Update is intended to keep DataQuest users informed about upcoming data releases, new reports and downloadable data files, enhancements and changes to DataQuest, and provide tips on how to use DataQuest
  • DataQuest Update Issue #3 (added 03-Feb-2020)
    The DataQuest Update is intended to keep DataQuest users informed about upcoming data releases, new reports and downloadable data files, enhancements and changes to DataQuest, and provide tips on how to use DataQuest
  • File Structure: One-Year Graduate Counts (added 29-Jan-2020)
    File structure for downloadable data files for one-year graduates by race/ethnicity, student program subgroup, and gender.