Skip to content
Printer-friendly version

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 Staff Assignment and Course Data 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 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 
Download Free Readers