Skip to main content
California Department of Education Logo

File Structure: Assignment Code File

File structure for the assignment/course code file.

File Name: ASGNCODE.TXT and ASGNCODE.DBF

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 California Department of Education Staff Assignment and Course Data Web page files.

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

Field Name Field Type Width Description

ASGN_CODE

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).

ASGN_NAME

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 California Department of Education CALPADS System Documentation Web page.

CTYPE

Character

1

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

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

SUBJ_CODE

Character

2

This is the subject code of the assignment.

  • 01 = Agriculture Education
  • 02 = Art
  • 03 = Business Education-Marketing
  • 04 = Business Education-Office
  • 05 = Computer Education
  • 06 = Dance
  • 07 = Department Chair
  • 08 = Drama
  • 09 = English
  • 10 = Foreign Languages
  • 11 = Administrative Assignments
  • 12 = Health Education
  • 13 = Health Careers
  • 14 = Consumer Home Economics Education
  • 15 = Home Economics Related Occupations
  • 16 = Humanities
  • 17 = Applied Technology
  • 18 = Industrial & Technology Education
  • 19 = Diversified Occupations
  • 20 = Electronics Technology
  • 21 = Explorations in Industrial Technology (for grades K-8)
  • 22 = Manufacturing Technology
  • 23 = Power, Energy & Transportation Technology
  • 24 = Visual Communications, Drafting
  • 25 = Visual Communications, Graphics
  • 26 = Mathematics
  • 27 = Music
  • 28 = Non-Teaching Assignment
  • 29 = Other Instruction-Related Assignment
  • 30 = Physical Education
  • 31 = Administrative Assignments
  • 32 = Science
  • 33 = Self-contained Classroom
  • 34 = Social Science
  • 35 = Special Designated Subjects
  • 36 = Special Education
  • 37 = Student Support Services
  • 38 = Support Teaching Assignments
  • 39 = Work Experience Education
  • 40 = Art Media

SUBJECT

Character

15

This is the subject of the assignment.

  • agr_ed = Agriculture Education
  • art = Art
  • bus_market = Business Education-Marketing
  • bus_office = Business Education-Office
  • compu_ed = Computer Education
  • dance = Dance
  • dep_chair = Department Chair
  • drama = Drama
  • english = English
  • forg_lang = Foreign Languages
  • gen_admin= Administrative Assignments
  • health = Health Education
  • health_career = Health Careers
  • home_ec_cons = Consumer Home Economics Education
  • home_ec_related = Home Economics Related Occupations
  • humanities = Humanities
  • it_applied = Applied Technology
  • it_const = Industrial & Technology Education
  • it_diversified = Diversified Occupations
  • it_elect = Electronics Technology
  • it_explor = Explorations in Industrial Technology (for grades K-8)
  • it_manuf = Manufacturing Technology
  • it_power = Power, Energy & Transportation Technology
  • it_visual_draft = Visual Communications, Drafting
  • it_visual_graph = Visual Communications, Graphics
  • math = Mathematics
  • music = Music
  • non-teach = Non-Teaching Assignment
  • other_inst = Other Instruction-Related Assignment
  • phys_ed = Physical Education
  • prog_admin = Administrative Assignments
  • science = Science
  • self_con = Self-contained Classroom
  • soc_sci = Social Science
  • spec_des = Special Designated Subjects
  • special_ed = Special Education
  • stu_support = Pupil Service Assignments
  • work_exp = Work Experience Education
  • art_media = Art Media

TOPIC_CODE

Character

2

This is the topic heading code for the assignment.

  • 01 = Teacher Assignment-Advanced Placement (AP) for Grades 9-12 Only
  • 02 = Teacher Assignments-International Baccalaureate (IB)
  • 03 = Administrative, Pupil Service, and Clinical or Rehabilitative Assignments
  • 04 = Non-Teaching Assignments
  • 05 = Teacher Assignments
  • 06 = Teacher Assignments-by Subject Area
  • 07 = Teacher Assignments-Vocational Education
  • 08 = Teacher Assignments-International Baccalaureate (IB) in Middle Years Program (MYP)

TOPIC_HEAD

Character

15

This is topic heading for the assignment.

  • adm_pupil = Administrative, Pupil Service, and Clinical or Rehabilitative Assignments
  • AP = Teacher Assignment-Advanced Placement (AP) for Grades 9-12 Only
  • IB = Teacher Assignments-International Baccalaureate (IB)
  • IB_MYP = Teacher Assignments-International Baccalaureate (IB) for Middle Years Program
  • non-teach = Non-Teaching Assignments
  • teach_asgn = Teacher Assignments
  • teach_subj = Teacher Assignments-by Subject Area
  • voc_ed = Teacher Assignments-Vocational Education

START_DT

Character

4

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

LAST_DT

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.

UC_CSU_REQ

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
Comments Character 100 Notes on changes made to the record.
Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Last Reviewed: Tuesday, August 28, 2018
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.