Skip to content
Printer-friendly version

File Structure - FTE by Subject and School

File structure for California Basic Educational Data System (CBEDS) Professional Assignment Information Form (PAIF) full-time equivalent (FTE) teachers by subject area and school.

For years 1999-2000 through the current year

File Name: TEASCH99.EXE

Field Name Field Type Width
Description

CDS_CODE

Character

14

County-District-School identification code.

COUNTY

Character

15

County name.

DISTRICT

Character

50

District name.

SCHOOL

Character

50

School name.

AGR_ED

Numeric

6

Agriculture education teachers (Includes codes 4010, 4020, 4030, 4040, 4050, 4060, 4070, 4080, and 4098).

ART

Numeric

6

Art teachers (Includes codes 2800-2821, 2860, 2899, and 2870-2872).

BUS_ED

Numeric

6

Business education teachers (Includes codes 4100-4122, 4198, 4600, 4601, 4608-4610, 4613-4615, 4618, 4620, 4621, 4623, 4630, 4633, 4637, 4650, and 4698).

COMPU_ED

Numeric

6

Computer education teachers (Includes codes 2450, 2451, 2453, 2454, 2458, 2465, 2466, 2470, and 2471).

DANCE

Numeric

6

Dance teachers (Includes codes 2352-2358).

DRAMA

Numeric

6

Drama/Theater teachers (Includes codes 2900, 2901, 2904-2906, 2908, 2910, 2960, and 2998).

ENGLISH

Numeric

6

English teachers (Includes codes 2100, 2101, 2105-2117, 2120, 2198, 2160, and 2170-2172).

FORG_LANG

Numeric

6

Foreign language teachers (Includes codes 2200-2226, 2230, 2298, 2270-2276, and 2260-2264).

HEALTH

Numeric

6

Health careers teachers and health education teachers (Includes codes 2531-2535, 2537, 2538, 4224-4227, 4234, 4235, 4242, 4243, 4255, 4256, 4260,4262, 4266-4268, 4276, 4277, 4280, 4288, 4289, 4294, and 4298).

HOME_EC

Numeric

6

Consumer home economics education and home economics related occupations teachers (Includes codes 4310-4312, 4312, 4321, 4322, 4331, 4332, 4341, 4351, 4361-4363, 4371, 4381, 4391, 4396, 4398, 4400, 4401, 4410-4412, 4420, 4421, 4430, 4441-4444, 4451, 4452, 4461, 4471, 4472, and 4498).

HUMANITIES

Numeric

6

Humanities teachers (Includes codes 2748 and 2768).

IT

Numeric

6

Industrial & Technology education teachers (Includes codes 5501-5525, 5527-5531, 5549, 5551, 5553-5568, 5570, 5598, 5601, 5603-5618, 5620, 5649, 5940, 5945, 5950, 5955, 5960, 5651-5662, 5664, 5666, 5670-5672, 5674-5676, 5678-5680, 5682, 5684, 5686, 5688, 5698, 5701, 5703-5710, 5749, 5751, 5753-5762, 5770, 5798, 5811, 5812, 5814, 5819, 5831, 5833, 5839, 5842, 5847, 5849, 5859, 5861, 5862, 5864-5866, 5869, 5970, 5972, 5975, 5980, and 5985).

MATH

Numeric

6

Mathematics teachers (Includes codes 2400-2411, 2414, 2415, 2417, 2418, 2420, 2421, 2323-2427, 2460-2463, 2480, 2481, 2483, and 2498).

MUSIC

Numeric

6

Music teachers (Includes codes 2300-2303, 2305-2311, 2313-2316, 2320-2322, 2360, 2398, and 2370).

NON_TEACH

Numeric

6

Non-teaching assignments (Includes codes 6002, 6010, and 6017).

OTHER_INST

Numeric

6

Other instructional staff (Includes codes 6001, 6003-6005, 6007, 6013, 6014, 6023, 2536, and 6098).

PHYS_ED

Numeric

6

Physical education teachers (Includes codes 2500-2502, and 2598).

SCIENCE

Numeric

6

Science teachers (Includes codes 2600, 2601, 2603-2615, 2617-2629, 2633, 2635, 2636, 2698, 2670-2674, 2660-2664, and 2666).

SELF_CON

Numeric

6

Self-contained classrooms (Includes codes 1001-1015, 2016, and 2017).

SOC_SCI

Numeric

6

Social science teachers (Includes codes 2700-2703, 2705-2715, 2719, 2722, 2724, 2726, 2728, 2730, 2732, 2734, 2760-2767, 2770-2776, and 2798).

SPEC_DES

Numeric

6

Special designated subjects (2505, 2545, 2546, 2548, and 2602).

SPEC_ED

Numeric

6

Special education teachers (Includes codes 3000-3002, 3004, 3007, and 3103-3106).

WORK_EXP

Numeric

6

Work experience education teachers (Code 4900).

TOTAL

Numeric

8

Total teachers.

Questions:   Educational Demographics Office | Write Ed Demo | 916-327-0219
Download Free Readers