Skip to main content
California Department of Education Logo

File Structure: Assignment Codes 2012–13 On

File structure for the assignment code file for 2012–13 to current.

File Name: StaffAssignmentCodes12On.txt

This file contains the assignment code and assignment code name for each teaching assignment, administrative assignment, and pupil service assignment. This file is used to reference and match assignment codes to the Staff Assignment and Course Data files.

Note: A staff person may have more than one assignment.

Field Name Field Type Width Description

AssignmentCode

Character

4

This is a 4-digit code from the assignment code list that identifies a course taught or other assignment for certificated staff (teachers, administrators and pupil services staff).

AssignmentName

Character

47

This is the name of a course taught or other assignment for teachers. Complete definitions of these assignments are available in the CALPADS Code Sets document, which is located on the CALPADS System Documentation Web page.

AssignmentType Character 1

This field indicates the type of certificated staff. The field is coded as follows:

  • T = Teacher
  • A = Administrator
  • P = Pupil Services

AssignmentSubject

Character

50

This is the subject of the assignment.

  • Administration
  • Agriculture and Natural Resources
  • Art
  • Arts, Media, and Entertainment
  • Building and Construction Trades
  • Business and Finance
  • Computer Education
  • Dance
  • Drama/Theater
  • Education, Child Development, and Family Services
  • Energy and Utilities
  • Engineering and Architecture
  • English Language Arts
  • Fashion and Interior Design
  • Foreign Languages
  • Health Science and Medical Technology
  • History/Social Science
  • Hospitality, Tourism, and Recreation
  • Information and Communication Technologies
  • Manufacturing and Product Development
  • Marketing, Sales, and Service
  • Mathematics
  • Music
  • Other Instruction-Related Assignments
  • Physical Education
  • Public Services
  • Science
  • Self-Contained Class
  • Special Designated Subjects
  • Transportation

AP Course

Character

1

This code indicates if the class is designated Advanced Placement (AP) coded as:

Y=Yes

N=No

IB Course

Character

1

This code indicates if the class is designated as an International Baccalaureate (IB) class and is coded as:

Y=Yes

N=No

CTE Course

Character

1

This code indicates if the class is designated as an Career Technical Education (CTE) class and is coded as:

Y=Yes

N=No

MeetsUC/CSU Requirements

Character

1

Indicates whether the course is eligible to be designated as meeting the UC/CSU requirements for admission.

  • Y = always or almost always approved as UC "a-g" course
  • N = cannot be approved as UC "a-g" course
  • U = sometimes approved as UC "a-g" course
  • Blank = not a teaching assignment

EffectiveStartDate

Character

4

This is the first year in which the assignment code was used.

EffectiveEndDate

Character

4

This is the final year in which the assignment code was used. This field will be unpopulated if the assignment code is still in use.

Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Thursday, May 2, 2019
Recently Posted in Demographics
  • File Structure: Classified Staff 2018 (added 02-Aug-2019)
    File structure for classified staff data by race/ethnicity, gender, and school for 2018–19.
  • File Structure: CBEDS Data About Schools/Districts (added 02-Aug-2019)
    File structure for California Basic Educational Data System (CBEDS) data about schools and districts for 2018–19.
  • File Structure: CGR Data (12-Month) (added 11-Jul-2019)
    File structure for the College-Going Rate (CGR) 12 months after high school completion reported by race/ethnicity, student group, and academic year.
  • File Structure: CGR Data (16-Month) (added 11-Jul-2019)
    File structure for the College-Going Rate (CGR) 16 months after high school completion reported by race/ethnicity, student group, and academic year.
  • Using the CGR Data File (added 11-Jul-2019)
    This page explains how to effectively use the sub-setting variables included in this CGR data file to obtain the desired counts.