File Structure - ASGNCODE File

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 on the CBEDS Course Codes and Definitions Web page.

CTYPE

Character

1

This field indicates whether this assignment is a teaching assignment (T), an administrative assignment (A) or a pupil services assignment (P).

SUBJ_CODE

Character

2

This is the subject of the assignment as categorized in the CBEDS Administrative Manual.
"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 as categorized in the CBEDS Administrative Manual.
"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

The codes represent the CBEDS Administrative Manual topic heading under which the assignment is listed.
"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 the CBEDS Administrative Manual topic heading under which the assignment is listed.
"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