File Name: paif11.txt
Note: This file contains hundreds of thousands of records and must be read by high powered database software (i.e., Access, Dbase, Foxpro, etc.). This file cannot be read by a software that limits the number of records that can be read (i.e., Excel).
Field Name |
Type Field | Width | Description |
|---|---|---|---|
REC_ID |
Character |
4-7 |
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 a school within California. The first two digits identify the county, the next five digits identify the school district, and the last seven digits identify the school. |
| COUNTY | Character | 15 | County name. |
| DISTRICT | Character | 35 | District name. |
| SCHOOL | Character | 35 | School name. |
GENDER |
Character |
1 |
This field is a coded field identifying gender. The gender is coded as follows:
|
ED_LEVEL |
Character |
1 |
This is a coded field for staff member's highest educational level (honorary degrees not included). The highest educational levels are coded as follows:
|
ETHNIC_GP |
Character |
1 |
This is a coded field for staff member's racial/ethnic designation. The code indicates the racial or ethnic designation to which the certificated staff belongs or with which he/she most closely identifies. The racial/ethnic designations are coded as follows:
(See Glossary for complete definitions of the ethnic groups). |
YRS_TEACH |
Numeric |
3 |
Total years of public and/or private educational service. Includes services in this district, other districts, other states, and countries. Does not include substitute teaching or classified staff service. The first year of service is counted as 1 year. |
YRS_DIST |
Numeric |
3 |
Total years of service in a certificated position in the district. The first year of service is counted as 1 year |
STATUS |
Character |
1 |
Indicates whether the teacher's position is tenured, probationary, or long-term substitute or temporary employee.
|
| TEACH | Character | 1 | An employee of the school district who holds a position requiring certification and whose duties require direct instruction to the pupils in the school(s) of that district.
|
| PCTTEACH | Number | 3 | An employee of the school district who holds a position requiring certification and whose duties require direct instruction to the pupils in the school(s) of that district. Full-time equivalent (FTE) percentage of teachers. |
| ADMIN | Character | 1 | An employee of the district in a position requiring certification but who is not required to provide direct instruction to pupils or direct services to pupils.
|
| PCTADMIN | Number | 3 | An employee of the district in a position requiring certification but who is not required to provide direct instruction to pupils or direct services to pupils. FTE percentage of administrators. |
| PUPIL | Character | 1 | An employee of the district in a position requiring a standard designated services credential, health, development credential, or a librarian credential and who performs direct services to pupils (e.g. counselors, guidance and welfare personnel, librarians, psychologists, etc).
|
| PCTPUPIL | Number | 3 | An employee of the district in a position requiring a standard designated services credential, health, development credential, or a librarian credential and who performs direct services to pupils (e.g. counselors, guidance and welfare personnel, librarians, psychologists, etc). FTE percentage of pupil services. |