File Name: ASSIGN06.DBF
This file contains the course data by assignment code from the Administrative Manual for CBEDS Coordinators and School Principals. This file is used to reference and match assignment codes to the PAIF files: ASGNCODE and PAIF05 (the PAIF file and the ASSIGN file must be of 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 |
10 |
This 10-digit code is the unique record identification code assigned to each certificated staff member in California public schools for 2006-07. This code is assigned by the California Department of Education for this year and has no meaning locally. The code assigned to a record for 2006-07 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. |
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 file asgncode.exe. |
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 UC/CSU requirements for admission. This field is coded as follows:
|
GD_LEV |
Character |
1 |
Grade level of majority of students in this class. This field is coded as follows:
|
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 whether or not this certificated staff person is a teacher (T), Administrator (A) or pupil services staff (P). |
NCLB_CORE |
Character |
1 |
This field indicates whether or not this class is a core academic class under No Child Left Behind (NCLB). Core elementary classes are denoted with an (E), core secondary classes are denoted with a (S), and non core classes are denoted with a (N). A blank record indicates this field is not relative to the assignment. |
NCLB_HQT |
Character |
1 |
This field indicates whether or not a teacher is NCLB compliant to teach the course. A (Y) indicates the teacher is NCLB compliant on the basis of education and/or training, a (H) indicates the teacher is NCLB compliant on the basis of High Objective Uniform State Standard Evaluation (HOUSSE), and a (N) indicates the teacher is not NCLB compliant. A blank record indicates this field is not relative to the assignment. |
