File Name: paif08.dbf
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 |
10 |
This code is the District Assigned Staff Identification Number (DASIN) reported by the district. 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. |
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 |
OVER_100 |
Logical |
1 |
Indicates teacher is paid to teach in excess of the districts' full-time teaching position (i.e., an extra period or more). Does not include mentor teacher, coaching, adult education, ROP, department chair, or non-teaching assignments.
|
STATUS |
Character |
1 |
Indicates whether the teacher's position is tenured, probationary, or long-term substitute or temporary employee.
|
F_P_TIME |
Character |
1 |
Indicates whether the position is Full or Part time as defined by the district. For Part time employees, see field PERC_TIME below for percentage of full time position held.
|
PERC_TIME |
Numeric |
4 |
Indicates percent of full position reported in field F_P_TIME above. |
FULL_CRED |
Logical |
1 |
Completed a teacher preparation program and holds a preliminary, clear, professional clear, or life credential
|
UNIV_INT |
Logical |
1 |
University credential program in which the intern is enrolled in the University taking coursework while teaching
|
DIST_INT |
Logical |
1 |
District credential program in which interns participate in preparation that includes staff development, but may not include college coursework
|
EMERGENCY |
Logical |
1 |
Requested by an employer on behalf of an individual who does not qualify for a credential or internship but meets minimum certification requirements. The permit holder completes credential requirements through a college or university for renewal.
|
WAIVER |
Logical |
1 |
Requested by an employer on behalf of an individual when the employer is unable to find credentialed teachers or individuals who qualify for an emergency permit.
|
ELEM |
Logical |
1 |
Indicates the teaching credential held by the certificated staff member. Authorizes teaching in an elementary/self-contained classroom
|
SEC |
Logical |
1 |
Authorized teaching area for a secondary/subject-specific classroom
|
GEN_SEC |
Logical |
1 |
Authorized teaching area for general secondary (all subjects)
|
AGRI |
Logical |
1 |
Authorized teaching area for agriculture
|
ART |
Logical |
1 |
Authorized teaching area for art
|
BUSINESS |
Logical |
1 |
Authorized teaching area for business
|
ENGLISH |
Logical |
1 |
Authorized teaching area for English
|
FOR_LANG |
Logical |
1 |
Authorized teaching area for foreign language
|
HEALTH |
Logical |
1 |
Authorized teaching area for health
|
HOME_ECON |
Logical |
1 |
Authorized teaching area for home economics
|
IND_TECH |
Logical |
1 |
Authorized teaching area for industrial and technology
|
LIFE_SCI |
Logical |
1 |
Authorized teaching area for life science
|
MATH |
Logical |
1 |
Authorized teaching area for mathematics
|
MUSIC |
Logical |
1 |
Authorized teaching area for music
|
PHYS_ED |
Logical |
1 |
Authorized teaching area for physical education
|
PHYS_SCI |
Logical |
1 |
Authorized teaching area for physical science
|
SOC_SCI |
Logical |
1 |
Authorized teaching area for social science
|
VOC |
Logical |
1 |
Authorized teaching area for vocational
|
SPEC_ED |
Logical |
1 |
Authorized teaching area for special education specialist
|
READING |
Logical |
1 |
Authorized teaching area for reading specialist
|
BCC |
Logical |
1 |
Authorized teaching area for bilingual
|
ELD |
Logical |
1 |
Authorized teaching area for English language development
|
SDAIE |
Logical |
1 |
Authorized teaching area for specially designed academic instruction in English
|
ADULT |
Logical |
1 |
Authorized teaching area for adult education
|
SPECSUBJ |
Logical |
1 |
Authorized teaching area for special subjects
|
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.
|
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.
|
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).
|
| PIP | Logical | 1 | The Provisional Internship Permit (PIP) was created in response to the phasing out of emergency permits and
became effective on July 1, 2005. It allows an employing agency to fill an immediate staffing need by hiring an
individual who has not yet met the subject matter competence requirement needed to enter an internship program.
|
| STSP | Logical | 1 | The Short-Term Staff Permit (STSP) was created in response to the phasing out of emergency permits and
became effective on July 1, 2005. It allows an employing agency to fill an acute staffing need when
|