Record Layout for the 2006 AYP Data File

Field names, types and descriptions for 2006 Adequate Yearly Progress Report (AYP) data file.

Repository archive entry for the Adequate Yearly Progress (AYP) in the Programs No Longer Administered by the California Department of Education (CDE) Section of the CDE Web site.\

This information is for historical purposes only and it is possible that information contained here may not be current.

Return to AYP Data Files

Field #	Field Name	Type	Width	Description
1	cds	Character	14	County/District/School code
2	rtype	Character	1	Record Type D=District, S=School, X=State
3	type	Character	1	Type 1=Unified, 2=Elementary District, 3=9-12 High District, 4=7-12 High District, E=Elementary School, M=Middle School, H=High School
4	sped	Character	1	A= Alternative Schools Accountability Model (ASAM), E=Special Education, and C=Combination ASAM and Special Education
5	size	Character	1	S=Small (11-99 Valid API Scores), T=Under 11 Valid API Scores
6	charter	Character	1	Y=Charter, Not Direct Funded, D=Direct Funded Charter, Blank=Not a Charter School
7	sname	Character	40	School Name
8	dname	Character	30	District Name
9	cname	Character	15	County Name
10	api05b	Character	5	2005 Base
11	api06g	Character	5	2006 Growth
12	apichang	Character	5	Change in API
13	met_all	Character	5	Yes = Met all 2006 AYP Criteria, No = Did not Meet all 2006 AYP Criteria
14	crit1	Character	5	Number of AYP criteria met
15	crit2	Character	5	Number of AYP criteria possible
16	capa_ela1	Character	5	ELA (CAPA) Percent proficient and above
17	capa_ela2	Character	5	ELA (CAPA) Above 1.0
18	capa_ela3	Character	5	ELA (CAPA) Exception Approved (Blank, Yes, Adj=Adjustment made for districts exceeding ELA CAPA cap)
19	capa_math1	Character	5	Math (CAPA) Percent proficient and above
20	capa_math2	Character	5	Math (CAPA) Above 1.0
21	capa_math3	Character	5	Math (CAPA) Exception Approved (Blank, Yes, Adj=Adjustment made for districts exceeding ELA CAPA cap)
22	e_enr	Character	7	Schoolwide or LEA-wide ELA Enrollment First Day of Testing
23	e_tst	Character	7	Schoolwide or LEA-wide ELA Number of Students Tested
24	e_prate	Character	5	Schoolwide or LEA-wide ELA Participation Rate
25	e_pr_met	Character	4	Schoolwide or LEA-wide ELA Participation Rate Met
26	m_enr	Character	7	Schoolwide or LEA-wide Math Enrollment First Day of Testing
27	m_tst	Character	7	Schoolwide or LEA-wide Math Number of Students Tested
28	m_prate	Character	5	Schoolwide or LEA-wide Math Participation Rate
29	m_pr_met	Character	4	Schoolwide or LEA-wide Math Participation Rate met
30	ee_aa	Character	7	ELA Enrollment African American
31	et_aa	Character	7	ELA Tested African American
32	ep_aa	Character	5	ELA Participation Rate African American
33	epm_aa	Character	4	ELA Participation Rate Met African American
34	me_aa	Character	7	Math Enrollment African American
35	mt_aa	Character	7	Math Tested African American
36	mp_aa	Character	5	Math Participation Rate African American
37	mpm_aa	Character	4	Math Participation Rate Met African American
38	ee_ai	Character	7	ELA Enrollment American Indian
39	et_ai	Character	7	ELA Tested American Indian
40	ep_ai	Character	5	ELA Participation Rate American Indian
41	epm_ai	Character	4	ELA Participation Rate met American Indian
42	me_ai	Character	7	Math Enrollment American Indian
43	mt_ai	Character	7	Math Tested American Indian
44	mp_ai	Character	5	Math Participation Rate American Indian
45	mpm_ai	Character	4	Math Participation Rate met American Indian
46	ee_as	Character	7	ELA Enrollment Asian
47	et_as	Character	7	ELA Tested Asian
48	ep_as	Character	5	ELA Participation Rate Asian
49	epm_as	Character	4	ELA Participation Rate Met Asian
50	me_as	Character	7	Math Enrollment Asian
51	mt_as	Character	7	Math Tested Asian
52	mp_as	Character	5	Math Participation Rate Asian
53	mpm_as	Character	4	Math Participation Rate Met Asian
54	ee_fi	Character	7	EL A Enrollment Filipino
55	et_fi	Character	7	ELA Tested Filipino
56	ep_fi	Character	5	ELA Participation Rate Filipino
57	epm_fi	Character	4	ELA Participation Rate Met Filipino
58	me_fi	Character	7	Math Enrollment Filipino
59	mt_fi	Character	7	Math Tested Filipino
60	mp_fi	Character	5	Math Participation Rate Filipino
61	mpm_fi	Character	4	Math Participation Rate Met Filipino
62	ee_hi	Character	7	ELA Enrollment Hispanic
63	et_hi	Character	7	ELA Tested Hispanic
64	ep_hi	Character	5	ELA Participation Rate Hispanic
65	epm_hi	Character	4	ELA Participation Rate met Hispanic
66	me_hi	Character	7	Math Enrollment Hispanic
67	mt_hi	Character	7	Math Tested Hispanic
68	mp_hi	Character	5	Math Participation Rate Hispanic
69	mpm_hi	Character	4	Math Participation Rate met Hispanic
70	ee_pi	Character	7	ELA Enrollment Pacific Islander
71	et_pi	Character	7	ELA Tested Pacific Islander
72	ep_pi	Character	5	ELA Participation Rate Pacific Islander
73	epm_pi	Character	4	ELA Participation Rate met Pacific Islander
74	me_pi	Character	7	Math Enrollment Pacific Islander
75	mt_pi	Character	7	Math Tested Pacific Islander
76	mp_pi	Character	5	Math Participation Rate Pacific Islander
77	mpm_pi	Character	4	Math Participation Rate met Pacific Islander
78	ee_wh	Character	7	ELA Enrollment White
79	et_wh	Character	7	ELA Tested White
80	ep_wh	Character	5	ELA Participation Rate White
81	epm_wh	Character	4	ELA Participation Rate met White
82	me_wh	Character	7	Math Enrollment White
83	mt_wh	Character	7	Math Tested White
84	mp_wh	Character	5	Math Participation Rate White
85	mpm_wh	Character	4	Math Participation Rate met White
86	ee_sd	Character	7	ELA Enrollment Socioeconomic Disadvantaged
87	et_sd	Character	7	ELA Tested Socioeconomic Disadvantaged
88	ep_sd	Character	5	ELA Participation Rate Socioeconomic Disadvantaged
89	epm_sd	Character	4	ELA Participation Rate met Socioeconomic Disadvantaged
90	me_sd	Character	7	Math Enrollment Socioeconomic Disadvantaged
91	mt_sd	Character	7	Math Tested Socioeconomic Disadvantaged
92	mp_sd	Character	5	Math Participation Rate Socioeconomic Disadvantaged
93	mpm_sd	Character	4	Math Participation Rate met Socioeconomic Disadvantaged
94	ee_el	Character	7	ELA Enrollment English Learner
95	et_el	Character	7	ELA Tested English Learner
96	ep_el	Character	5	ELA Participation Rate English Learner
97	epm_el	Character	4	ELA Participation Rate met English Learner
98	me_el	Character	7	Math Enrollment English Learner
99	mt_el	Character	7	Math Tested English Learner
100	mp_el	Character	5	Math Participation Rate English Learner
101	mpm_el	Character	4	Math Participation Rate met English Learner
102	ee_di	Character	7	ELA Enrollment Students with Disabilities
103	et_di	Character	7	ELA Tested Students with Disabilities
104	ep_di	Character	5	ELA Participation Rate Students with Disabilities
105	epm_di	Character	5	ELA Participation Rate met Students with Disabilities
106	me_di	Character	7	Math Enrollment Students with Disabilities
107	mt_di	Character	7	Math Tested Students with Disabilities
108	mp_di	Character	5	Math Participation Rate Students with Disabilities
109	mpm_di	Character	4	Math Participation Rate met Students with Disabilities
110	e_val	Character	7	Schoolwide or LEA-wide ELA Number of Valid scores
111	e_prof	Character	7	Schoolwide or LEA-wide ELA Number of students scoring Proficient or Above
112	e_pprof	Character	5	Schoolwide or LEA-wide ELA Percent of students scoring Proficient or Above
113	e_ppm	Character	4	Schoolwide or LEA-wide ELA Percent Proficient or Above met
114	m_val	Character	7	Schoolwide or LEA-wide Math Valid scores
115	m_prof	Character	7	Schoolwide Math number of students scoring Proficient or Above
116	m_pprof	Character	5	Schoolwide Math Percent of students scoring Proficient or Above
117	m_ppm	Character	4	Schoolwide Math Percent Proficient or Above met
118	ev_aa	Character	7	ELA Valid scores African American
119	enp_aa	Character	7	ELA Number of students scoring Proficient or Above African American
120	epp_aa	Character	5	ELA Percent Proficient or Above African American
121	eppm_aa	Character	4	ELA Percent Proficient or Above met African American
122	mv_aa	Character	7	Math Valid scores African American
123	mnp_aa	Character	7	Math students scoring Proficient or Above African American
124	mpp_aa	Character	5	Math Percent of students scoring Proficient or Above African American
125	mppm_aa	Character	4	Math Percent Proficient or Above met African American
126	ev_ai	Character	7	ELA Valid scores American Indian
127	enp_ai	Character	7	ELA Number students scoring Proficient or Above American Indian
128	epp_ai	Character	5	ELA Percent of students scoring Proficient or Above American Indian
129	eppm_ai	Character	4	ELA Percent Proficient or Above met American Indian
130	mv_ai	Character	7	Math Valid scores American Indian
131	mnp_ai	Character	7	Math students scoring Proficient or Above American Indian
132	mpp_ai	Character	5	Math Percent of students scoring Proficient or Above American Indian
133	mppm_ai	Character	4	Math Percent Proficient or Above met American Indian
134	ev_as	Character	7	ELA Valid scores Asian
135	enp_as	Character	7	ELA Number of students scoring Proficient or Above Asian
136	epp_as	Character	5	ELA Percent of students scoring Proficient or Above Asian
137	eppm_as	Character	4	ELA Percent Proficient or Above met Asian
138	mv_as	Character	7	Math Valid scores Asian
139	mnp_as	Character	7	Math students scoring Proficient or Above Asian
140	mpp_as	Character	5	Math Percent of students scoring Proficient or Above Asian
141	mppm_as	Character	4	Math Percent Proficient or Above met Asian
142	ev_fi	Character	7	ELA Valid scores Filipino
143	enp_fi	Character	7	ELA Number of students scoring Proficient or Above Filipino
144	epp_fi	Character	5	ELA Percent of students scoring Proficient or Above Filipino
145	eppm_fi	Character	4	ELA Percent Proficient or Above met Filipino
146	mv_fi	Character	7	Math Valid scores Filipino
147	mnp_fi	Character	7	Math students scoring Proficient or Above Filipino
148	mpp_fi	Character	5	Math Percent of students scoring Proficient or Above Filipino
149	mppm_fi	Character	4	Math Percent Proficient or Above met Filipino
150	ev_hi	Character	7	ELA Valid scores Hispanic
151	enp_hi	Character	7	ELA Number students scoring Proficient or Above Hispanic
152	epp_hi	Character	5	ELA Percent of students scoring Proficient or Above Hispanic
153	pyemia	Character	4	ELA Percent Proficient or Above met Hispanic
154	Novi	Character	7	Math Valid scores Hispanic
155	nippy	Character	7	Math students scoring Proficient or Above Hispanic
156	myopia	Character	5	Math Percent of students scoring Proficient or Above Hispanic
157	Miamis	Character	4	Math Percent Proficient or Above met Hispanic
158	Vaupes	Character	7	ELA Valid scores Pacific Islander
159	nappe	Character	7	ELA Number of students scoring Proficient or Above Pacific Islander
160	Apia	Character	5	ELA Percent of students scoring Proficient or Above Pacific Islander
161	Pompeii	Character	4	ELA Percent Proficient or Above Met Pacific Islander
162	myopia	Character	7	Math Valid scores Pacific Islander
163	nippy	Character	7	Math students scoring Proficient or Above Pacific Islander
164	myopia	Character	5	Math Percent of students scoring Proficient or Above Pacific Islander
165	mppm_pi	Character	4	Math Percent Proficient or Above Met Pacific Islander
166	ev_wh	Character	7	ELA Valid scores White
167	enp_wh	Character	7	ELA Number of students scoring Proficient or Above White
168	epp_wh	Character	5	ELA Percent of students scoring Proficient or Above White
169	eppm_wh	Character	4	ELA Percent Proficient or Above Met White
170	mv_wh	Character	7	Math Valid scores White
171	mnp_wh	Character	7	Math students scoring Proficient or Above White
172	mpp_wh	Character	5	Math Percent of students scoring Proficient or Above White
173	mppm_wh	Character	4	Math Percent Proficient or Above Met White
174	ev_sd	Character	7	ELA Valid scores Socioeconomic Disadvantaged
175	enp_sd	Character	7	ELA Number of students scoring Proficient or Above Socioeconomic Disadvantaged
176	epp_sd	Character	5	ELA Percent of students scoring Proficient or Above Socioeconomic Disadvantaged
177	eppm_sd	Character	4	ELA Percent Proficient or Above Met Socioeconomic Disadvantaged
178	mv_sd	Character	7	Math Valid scores Socioeconomic Disadvantaged
179	mnp_sd	Character	7	Math students scoring Proficient or Above Socioeconomic Disadvantaged
180	mpp_sd	Character	5	Math Percent of students scoring Proficient or Above Socioeconomic Disadvantaged
181	mppm_sd	Character	4	Math Percent Proficient or Above Met Socioeconomic Disadvantaged
182	ev_el	Character	7	ELA Valid scores English Learner
183	enp_el	Character	7	ELA students scoring Proficient or Above English Learner
184	epp_el	Character	5	ELA Percent of students scoring Proficient or Above English Learner
185	eppm_el	Character	4	ELA Percent Proficient or Above Met English Learner
186	mv_el	Character	7	Math Valid scores English Learner
187	mnp_el	Character	7	Math students scoring Proficient or Above English Learner
188	mpp_el	Character	5	Math Percent of students scoring Proficient or Above English Learner
189	mppm_el	Character	4	Math Percent Proficient or Above Met English Learner
190	ev_di	Character	7	ELA Valid scores Students with Disabilities
191	enp_di	Character	7	ELA students scoring Proficient or Above Students with Disabilities
192	epp_di	Character	5	ELA Percent of students scoring Proficient or Above Students with Disabilities
193	eppm_di	Character	4	ELA Percent Proficient or Above Met Students with Disabilities
194	mv_di	Character	7	Math students with a Valid scores Students with Disabilities
195	mnp_di	Character	7	Math Number of Students with Disabilities students scoring Proficient or Above
196	mpp_di	Character	5	Math Percent of Students with Disabilities scoring Proficient or Above
197	mppm_di	Character	4	Math Percent Proficient or Above Met Students with Disabilities
198	grad06	Character	5	Graduation Rate for 2006, Class of 2004–05
199	grad05	Character	5	Graduation Rate for 2005, Class of 2003–04
200	gr_chang	Character	5	2004–2005 Change in Graduation Rate
201	chang2	Character	5	Grad rate average; 2-year change
202	api_flag	Character	1	1= parent waiver, 2= testing irregularities, 3= Failed the 85% rule - no valid API given, 4= under 11 valid scores, 6 = CAHSEE data but no valid STAR data.
203	chg_data	Character	1	Results on this report may change because: C = the LEA will be changing data.
204	exc_cap	Character	1	Results on this report may change because the LEA exceeded the 1.0 percent cap on proficient or above scores based on 2005 CAPA.
205	e_pr_app	Character	5	Participation Rate ELA (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)
206	m_pr_app	Character	5	Participation Rate Math (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)
207	e_pp_app	Character	5	Percent Proficient ELA (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)
208	m_pp_app	Character	5	Percent Proficient Math (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)
209	api_app	Character	5	API Criteria (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)
210	grad_app	Character	5	Graduation Rate (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)
211	ela_met	Character	5	ELA met overall (Y=Yes, N=No)
212	math_met	Character	5	Math met overall (Y=Yes, N=No)
213	e_adj_di	Character	5	ELA Percent Adjustment for the Students with Disabilities
214	m_adj_di	Character	5	Math Percent Adjustment for the Students with Disabilities
215	e_targ06	Character	5	ELA 2006 Percent Proficient Target
216	m_targ06	Character	5	Math 2006 Percent Proficient Target

Questions: California Department of Education | 916-319-0800

Last Reviewed: Monday, January 24, 2022