File Structure: Teaching AMO Data

File structure for data files containing teaching Assignment Monitoring Outcome (AMO) data disaggregated by subject, school type, school grade span, teacher credential level and experience level. Data reported in full-time equivalency (FTE) units.

General Description of the File

The downloadable data files provide the Full-Time Equivalent (FTE) data for each classroom-based teaching assignment reported by local educational agencies (LEAs) to the California Department of Education (CDE) through the California Longitudinal Pupil Achievement Data System (CALPADS). The CDE provides the California Commission on Teacher Credential (CTC) with the CALPADS assignment data, which the CTC compares against their credential authorization data as part of the annual assignment monitoring process conducted through California Statewide Assignment Accountability System (CalSAAS). This process evaluates each assignment based on the Statewide Educator Identification (SEID) associated with the assignment to determine if or how the teacher is authorized to teach the assigned course and the students enrolled in the course. For more information about the Teaching Assignment Monitoring Outcome (AMO) data, including how the Teaching AMO data are calculated, please visit the Information about the Teaching AMO Report webpage.

Source 

Classroom-based teaching assignments and FTE submitted and certified by LEAs and/or charter schools as part of the annual CALPADS Fall 2 submission and assignment monitoring outcome data determined during the annual assignment monitoring process conducted by the CTC through CalSAAS.

Note

These files include state, county, district, and school-level data. Please refer to the file structure for details on what data are contained in the file. These files also contain aggregate data with disaggregated data subsets at different levels and reporting categories to provide enhanced analytical flexibility. For more detailed examples about how to properly use these data, please refer to the Using the Teaching AMO Data File examples below. Data for classroom-based teaching assignments taught by teachers without a SEID are not included in the Teacher AMO report and downloadable data file. Data are not included for districts and independently reporting charter schools (IRCs) that did not certify their CALPADS Fall 2 submission. Due to rounding error, partial FTE counts by AMO may not sum exactly to the Total FTE displayed in the report or file for the selected reporting level and filters.

Field Name	Description
Academic Year	The academic year corresponding to the Census Day associated with the annual California Longitudinal Pupil Achievement Data System (CALPADS) Fall 2 submission through which local educational agencies (LEAs) submit and certify official staff demographic, staff assignments and full-time equivalency (FTE) information, course offerings, and student course enrollment data. LEAs include school districts, charter schools, and county offices of education. Census Day or Information Day is always the first Wednesday in October. Prior to CALPADS, these data were submitted to the CDE by LEAs as part of the Professional Assignment Information Form (PAIF) collected through the annual California Basic Educational Data System (CBEDS) submission.
Aggregate Level	An indicator of the aggregation level. T = State C = County D = District S = School Note: One of these values must be chosen to obtain an unduplicated count at the selected level.
County Code	A unique two-digit code corresponding to the county.
District Code	A unique five-digit code corresponding to the district.
School Code	A unique seven-digit code corresponding to the school.
County Name	County Name.
District Name	District or Administrative Authority Name.
School Name	School Name.
Charter School	An indicator of whether data for all schools, only charter schools, or only non-charter schools are included: ALL: Includes data for all schools regardless of charter status. For Aggregate Level=S, all schools are included. For Aggregate Levels T, C, and D, data for all schools are included in the aggregate. Y: Includes *only data for charter schools. For Aggregate Level=S, only charter schools are included. For Aggregate Levels T, C, and D, only data for charter schools are included in the aggregate. N: Includes only data for non-charter schools. For Aggregate Level=S, only non-charter schools are included. For Aggregate Levels T, C, and D, only data for non-charter schools are included in the aggregate. Note:* One of these values must be chosen to obtain an unduplicated count at the selected level.
DASS	An indicator of whether data for all schools, only schools participating in the Dashboard Alternative School Status Program (DASS), or only non-DASS schools are included: ALL: Includes data for *all* schools regardless of DASS status. For Aggregate Level=S, all schools are included. For Aggregate Levels T, C, and D, data for all schools are included in the aggregate. Y: Includes *only data for DASS schools. For Aggregate Level=S, only DASS schools are included. For Aggregate Levels T, C, and D, only data for DASS schools are included in the aggregate. N: Includes only data for non-DASS schools. For Aggregate Level=S, only data for non-DASS schools are included. For Aggregate Levels T, C, and D, only data for non-DASS schools are included in the aggregate. Note:* One of these values must be chosen to obtain an unduplicated count at the selected level.
School Grade Span	An indication of the grade levels associated with the students enrolled at a school based on the lowest and highest K–12 grades offered at a school. ALL: Includes data for all schools regardless of school grade span. For Aggregate Level = S, all schools are included. For Aggregate Levels T, C, and D, data for all schools are included in the aggregate. Select School Grade Span = All for aggregate totals without consideration of a specific School Grade Span. GRK6: Includes data for Grade K–6 schools where the lowest and highest grades offered are grades 6 or less, inclusive (e.g., grade K, grades K-1, grades K-6, grades 1-5, grade 6). For Aggregate Levels T, C, and D, only data for GRK6 schools are included in the aggregate. GR69: Includes data for Grade 6–9 schools where the lowest grades offered are grades 6-8, inclusive, and the highest grades offered are grades 7-9, inclusive (e.g., grades 6-9, grades 6-8, grades 7-9). For Aggregate Levels T, C, and D, only data for GR69 schools are included in the aggregate. GR912: Includes data for Grade 9–12 schools where the lowest grades offered are grades 9-11, inclusive, and the highest grades offered are grades 9-12, inclusive (e.g., grade 9, grades 9-10, grades 10-12, grade 12). For Aggregate Levels T, C, and D, only data for GR912 schools are included in the aggregate. GRK12: Includes data for Grade K–12 schools where the lowest grades offered are grades K-8, inclusive, and the highest grades offered are grades 7-12, inclusive (e.g., grades K-12, grades K-8, grades 1-12, grades 6-12, grades 8-9, grades 7-12). For Aggregate Levels T, C, and D, only data for GRK12 schools are included in the aggregate. Note: One of these options must be chosen to obtain the desired count at the selected level.
Teacher Experience Level	An indication of whether a teacher is considered to be “experienced” or "inexperienced" based on a count of the cumulative number of years a teacher has been providing educational services in a certificated position within any educational institution. ALL: Includes data for *all* teachers regardless of teacher experience level at the selected Aggregate Level and other reporting levels. Select Teacher Experience Level = All for aggregate totals without consideration of teacher experience level. EXP: Includes only data for teachers who are experienced at the selected Aggregate Level and other reporting levels. *INEXP:* Includes only data for teachers who are inexperienced at the selected Aggregate Level and other reporting levels. Note: One of these options must be chosen to obtain the desired count at the selected level.
Teacher Credential Level	An indication of whether a teacher holds a "clear or preliminary teaching credential" or not. Teachers are defined as “fully credentialed” if they possess a clear or preliminary teaching credential. Teachers are defined as “not fully credentialed” if they do not possess a clear or preliminary teaching credential. ALL: Includes data for *all* teachers regardless of teacher credential level at the selected Aggregate Level and other reporting levels. Select Teacher Credential Level = All for aggregate totals without consideration of teacher credential level. FC: Includes only data for teachers who are fully credentialed at the selected Aggregate Level and other reporting levels. NFC: Includes only data for teachers who are not fully credentialed at the selected Aggregate Level and other reporting levels. Note: One of these options must be chosen to obtain the desired count at the selected level.
Subject Area	A high-level summary grouping of state course codes (formerly known as CBEDS assignment codes) that share similarities in subject content area covered in a specific course (e.g., English/Language Arts or Mathematics). Information about the state course codes is included in the CALPADS Code Set, under Course Group State, and information about the mapping of state course codes to subject content areas can be found in the CALPADS Valid Code Combinations document under the Course Group Master Combo tab. These CALPADS documents are publicly available on the CDE CALPADS System Documentation webpage. AGRI = Agriculture ARTS = Art BUSN = Business CTED = Career Technical Education CPTE = Computer Education DNCE = Dance DRMT = Drama/Theater ENLA = English Language Arts FRLG = Foreign Languages GADM = General Administration HLTH = Health Education HISS = History/Social Science MATH = Mathematics MDAR = Media Arts MUSC = Music OTHR = Other Instruction-Related Assignments PHYS = Physical Education SCIE = Science SCCL = Self-Contained Class SDSU = Special Designated Subjects TA = All Subjects Note: One of these options must be chosen to obtain the desired count at the selected level. Select Reporting Category = TA for aggregate totals without consideration of a Subject Area.
Total FTE (count)	This count includes the total FTE for the classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).
Clear FTE (count)	Where the assignment monitoring outcome is clear, this count includes the FTE for the associated classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).
Out-of-Field FTE (count)	Where the assignment monitoring outcome is out-of-field, this count includes the FTE for the associated classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).
Intern FTE (count)	Where the assignment monitoring outcome is intern, this count includes the FTE for the associated classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).
Ineffective FTE (count)	Where the assignment monitoring outcome is ineffective, this count includes the FTE for the associated classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).
Incomplete FTE (count)	Where the assignment monitoring outcome is incomplete, this count includes the FTE for the associated classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).
Unknown FTE (count)	Where the assignment monitoring outcome is unknown, this count includes the FTE for the associated classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).
N/A FTE (count)	Where the assignment monitoring outcome is N/A, this count includes the FTE for the associated classroom-based teaching assignments at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).
Clear FTE (percent)	The Clear FTE (percent) is calculated by taking the Clear FTE (count) divided by the Total FTE (count) at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).
Out-of-Field FTE (percent)	The Out-of-Field FTE (percent) is calculated by taking the Out-of-Field FTE (count) divided by the Total FTE (count) at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).
Intern FTE (percent)	The Intern FTE (percent) is calculated by taking the Intern FTE (count) divided by the Total FTE (count) at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).
Ineffective FTE (percent)	The Ineffective FTE (percent) is calculated by taking the Ineffective FTE (count) divided by the Total FTE (count) at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).
Incomplete FTE (percent)	The Incomplete FTE (percent) is calculated by taking the Incomplete FTE (count) divided by the Total FTE (count) at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).
Unknown FTE (percent)	The Unknown FTE (percent) is calculated by taking the Unknown FTE (count) divided by the Total FTE (count) at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).
N/A FTE (percent)	The N/A FTE (percent) is calculated by taking the N/A FTE (count) divided by the Total FTE (count) at the selected aggregate level (i.e., T, C, D, or S) and at the selected data summary levels (i.e., Charter, DASS, School Grade Span, Teacher Experience Level, Teacher Credential Level, and Subject Area).

Using the Teaching AMO Data File

This file contains different subsets of data based on the values of different variables. If these sub-setting variables are not used properly, it is easy to end up with incorrect data. Please refer to the following examples below as a guide for properly using these data:

Get school-level teaching FTE data by assignment monitoring outcomes for all schools without further summary-level disaggregation:
- Aggregate Level = S (School)
- Charter = ALL
- DASS = ALL
- School Grade Span = ALL
- Teaching Experience Level = ALL
- Teaching Credential Level = ALL
- Subject Area = TA
Get school-level teaching FTE data by assignment monitoring outcomes for all charter schools that are also DASS schools for Mathematics teaching assignments:
- Aggregate Level = S (School)
- Charter = Y
- DASS = Y
- School Grade Span = ALL
- Teaching Experience Level = ALL
- Teaching Credential Level = ALL
- Subject Area = MATH
Get district-level teaching FTE data by assignment monitoring outcomes for all non-charter schools and for all Subject Areas with a district-level total:
- Aggregate Level = D (District)
- Charter School = N
- DASS = ALL
- School Grade Span = ALL
- Teaching Experience Level = ALL
- Teaching Credential Level = ALL
- Subject Area = AGRI, ARTS, BUSN, CTED, CPTE, DNCE, DRMT, ENLA, FRLG, GADM, HLTH, HISS, MATH, MDAR, MUSC, OTHR, PHYS, SCIE, SCCL, SDSU, and TA
Get county-level teaching FTE data by assignment monitoring outcomes for all schools where the School Grade Span is 9–12 and where the Teaching Experience Level is inexperienced:
- Aggregate Level = C (County)
- Charter School = ALL
- DASS = ALL
- School Grade Span = GR912
- Teaching Experience Level = INEXP
- Teaching Credential Level = ALL
- Subject Area = TA
Get state-level teaching FTE data by assignment monitoring outcomes for DASS schools where Teaching Credential Level is “not fully credentialed”:
- Aggregate Level = T (State)
- Charter School = ALL
- DASS = Y
- School Grade Span = ALL
- Teaching Experience Level = ALL
- Teaching Credential Level = NFC
- Subject Area = TA

Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219

Last Reviewed: Wednesday, July 12, 2023

Trending in Accessing Educational Data

Recently Posted in Accessing Educational Data

Two-Month Average Data Reports (added 09-Apr-2024)
The page displays two-month average Early Education Division (EED) enrollment data for children by Program Length and Statutory Age for October/April in 2020−23.
Single-Month Reports (added 09-Apr-2024)
The page displays California State Preschool Program (CSPP) Enrollment by Program Length, Statutory Age, Agency Classification, and Race/Ethnicity.
CSPP Enrollment by Provider County Reports (added 09-Apr-2024)
The page provides links to annual October California State Preschool Program (CSPP) enrollment reports by provider county for 2020−22 in XLSX format.
Annual Aggregate Reports (added 09-Apr-2024)
The page displays the annual California State Preschool Program enrollment data by Statutory Age and Program Length for fiscal years 2020−23, providing an unduplicated count of children served by the California Department of Education (CDE).