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 3, 2025

Trending in Accessing Educational Data

Recently Posted in Accessing Educational Data

DataQuest Update, Issue #24 (added 17-Jul-2025)
DataQuest is an online data reporting resource that provides access to a wide variety of data reports and downloadable data files.
Information about the Staff Experience Data (added 17-Jul-2025)
Overview of the Staff Experience data, including data sources, DataQuest reports, downloadable files, definitions, and other information helpful to understanding the data, reports, and downloadable files.
Information about the Staff Race/Ethnicity Data (added 17-Jul-2025)
Overview of the Staff Race/Ethnicity data, including data sources, DataQuest reports, downloadable files, definitions, and other information helpful to understanding the data, reports, and downloadable files.
Student/Staff Ratios Downloadable Data Files (added 17-Jul-2025)
Downloadable data files about student/staff ratios as of Census Day disaggregated by staff type, academic year, and school grade span.
Staff Experience Downloadable Data Files (added 17-Jul-2025)
Downloadable data files about certificated staff employed on Census Day disaggregated by years of experience, academic year, staff type, school grade span, and gender.

File Structure: Staff Race/Ethnicity Data (added 17-Jul-2025)
File structure for downloadable data files containing Certificated Staff by Race/Ethnicity disaggregated by academic year, staff type, school grade span, and gender.
File Structure: Staff Experience Data (added 17-Jul-2025)
File structure for downloadable data files containing Certificated Staff Experience disaggregated by academic year, staff type, school grade span, and gender.
File Structure: Staff Education Data (added 17-Jul-2025)
File structure for downloadable data files containing Certificated Staff Education disaggregated by academic year, staff type, school grade span, and gender.
Staff Counts by Experience (added 17-Jul-2025)
Reports and data about certificated staff employed on Census Day disaggregated by years of experience, academic year, staff type, school grade span, and gender.
Staff Counts by Education (added 17-Jul-2025)
Reports and data about certificated staff employed on Census Day disaggregated by education level, academic year, staff type, school grade span, and gender.