Skip to main content
California Department of Education Logo

File Structure: Assignment Code File

File structure for the assignment/course code file.

Files: 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.

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:   Analysis Measurement & Accountability Reporting Division | dro@cde.ca.gov
Last Reviewed: Monday, March 03, 2025
Recently Posted in Accessing Educational Data
  • DataQuest Update, Issue #26 (added 01-Oct-2025)
    DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.
  • Information about JCCC Schools Data (added 01-Oct-2025)
    High-level overview regarding the collection and reporting of Juvenile Court and County Community (JCCC) Schools data.
  • File Structure: JCCC Schools Data – Dashboard (added 01-Oct-2025)
    File structure for the Juvenile Court and County Community (JCCC) Schools dashboard data from the California Longitudinal Pupil Achievement Data System (CALPADS).
  • File Structure: JCCC Schools Data – Grad Outcomes (added 01-Oct-2025)
    File structure for the Juvenile Court and County Community (JCCC) Schools Graduation outcomes data from the California Longitudinal Pupil Achievement Data System (CALPADS).
  • File Structure: JCCC Schools Data - Course (added 01-Oct-2025)
    File structure for the Juvenile Court and County Community (JCCC) Schools Course data from the California Longitudinal Pupil Achievement Data System (CALPADS).