Skip to content
Printer-friendly version

File Structure: Course Data 1997 & 1998

File structure for statewide course data Including course enrollment, grade level, and UC/CSU indicator, as well as assignment information including type of staff and time base.

File Name: ASSIGN97.DBF and ASSIGN98.DBF

This file contains the course data by assignment code. This file is used to reference and match assignment codes to the staff demographics files and the assignment code file. Files must be from the same year to match staff identification codes (REC_ID).

Note: This file contains numerous records and must be viewed with a high powered database software (i.e., Access, Dbase, Foxpro, etc.). It cannot be viewed by a software that limits the number of records it can read (i.e., Excel).

Field Name Field Type Width
Description

REC_ID

Character

6

This 6-digit code is the unique record identification code assigned to each certificated staff member in California public schools for this specific year. The code is an identifier with no meaning. The code assigned to a record for this specific year will not match the code assigned to the same staff members' record for prior or future years. 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.

ASGN_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 Staff Assignment and Course Data page.

ASGN_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 or California (UC) / California State University (CSU) requirements for admission. This field is coded as follows:

  • Code Y = Yes
  • Code N = No
  • Code is blank = No response

GD_LEV

Character

1

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

  • Code A = Kindergarten through grade three
  • Code B = Grade four
  • Code C = Grade five
  • Code D = Grade six
  • Code E = Grade seven
  • Code F = Grade eight
  • Code G = Grade nine
  • Code H = Grade ten
  • Code I = Grade eleven
  • Code J = Grade twelve
  • Code is 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 FTE (full-time equivalent) 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
Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Download Free Readers