File Structure: Course Data 2010–11

REC_ID

Character

10

This code is a randomly generated number assigned to each staff. The code assigned for one year may not be the same code assigned to the same staff member for another year. Therefore, the code cannot be used to match records over time.

CDS_CODE

Character

14

This 14-digit code is the official, unique identification of the school to which the staff member is assigned. The first two digits identify the county, the next five digits identify the school district, and the last seven digits identify the school. If a staff member works at more than one school, all data regarding the assignments will be shown at the school with the largest portion of assignments; this may result in small data anomalies.

ASN_CODE

Character

4

This 4-digit code is from an extensive list of assignment code numbers for teaching assignments, administrative assignments and pupil services assignments. For a list of all codes and course and assignment titles, use the assignment code file posted on the California Department of Education Staff Assignment and Course Data Web page.

ASN_PCT

Numeric

4

This field indicates the percent of time certificated staff spends "on the job" devoted to each assignment. It does not represent "total" time spent on the job. See field PERC_TIME for total time on the job.

M_ENROLL

Numeric

4

Male enrollment in this class or course.

F_ENROLL

Numeric

4

Female enrollment in this class or course.

UC_CSU

Character

1

Course designated as meeting the University of California (UC) / California State University (CSU) requirements for admission. This field is coded as follows:

• Y = Yes
• N = No
• Blank = No response

GD_LEV

Character

1

Grade level of majority of students in this class. This field is coded as follows:

• KN = Kindergarten
• 01 = Grade one
• 02 = Grade two
• 03 = Grade three
• 04 = Grade four
• 05 = Grade five
• 06 = Grade six
• 07 = Grade seven
• 08 = Grade eight
• 09 = Grade nine
• 10 = Grade ten
• 11 = Grade eleven
• 12 = Grade twelve
• 13 = Multiple grades, no majority (Kindergarten through grade eight)
• 14 = Multiple grades, no majority (nine through twelve)
• US = Ungraded
• Blank = No response

PERC_TIME

Numeric

4

This field indicates the total percent of time certificated staff spends "on the job" devoted to this assignment. This percentage represents whether or not the certificated staff person is Full or Part time.

FTE

Float

8

This field indicates the full-time equivalent (FTE) time staff spends in this course.

CTYPE

Character

1

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

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

NCLB_CORE

This field indicates whether or not this class is a core academic class under No Child Left Behind (NCLB). The field is coded as follows:

• E = Core Elementary Class
• S = Core Secondary Class
• N = Non-Core Class
• Blank = Field is not relative to the assignment

NCLB_HQT

This field indicates whether or not a teacher is NCLB compliant to teach the course. The field is coded as follows:

• A = Compliant on the basis of passage of an approved exam
• B = Compliant on the basis of coursework
• C = Compliant on the basis of national board certification
• D = Compliant on the basis of High Objective Uniform State Standard Evaluation (HOUSSE)
• G = Compliant on the basis of the Subject Matter Verification Process for Middle and High School Level Teachers in Special Settings (VPSS) option
• N = Not NCLB compliant
• Blank = Field is not relative to the assignment

This field indicates whether or not this class is taught through distance learning. The field is coded as follows:

• Y = Yes
• N = No
• Blank = No/Not Applicable

This field indicates whether or not this class is a special education class. The field is coded as follows:

• Y = Yes
• N = No
• Blank = No/Not Applicable

This field indicates whether or not this class is an independent study class. The field is coded as follows:

• Y = Yes
• N = No
• Blank = No/Not Applicable

This field indicates whether or not this class is taught by an itinerant teacher. The field is coded as follows:

• Y = Yes
• N = No
• Blank = No/Not Applicable