Record Layout for the 2010 AYP Data File

Field names, types, and descriptions for 2010 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	api09b	Character	5	2009 Base
11	api10g	Character	5	2010 Growth
12	apichang	Character	5	Change in API
13	met_all	Character	5	Yes = Met all 2010 AYP Criteria, No = Did not Meet all 2010 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 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 Black or African American
31	et_aa	Character	7	ELA Tested Black or African American
32	ep_aa	Character	5	ELA Participation Rate Black or African American
33	epm_aa	Character	4	ELA Participation Rate Met Black or African American
34	me_aa	Character	7	Math Enrollment Black or African American
35	mt_aa	Character	7	Math Tested Black or African American
36	mp_aa	Character	5	Math Participation Rate Black or African American
37	mpm_aa	Character	4	Math Participation Rate Met Black or African American
38	ee_ai	Character	7	ELA Enrollment American Indian/Alaska Native
39	et_ai	Character	7	ELA Tested American Indian/Alaska Native
40	ep_ai	Character	5	ELA Participation Rate American Indian/Alaska Native
41	epm_ai	Character	4	ELA Participation Rate met American Indian/Alaska Native
42	me_ai	Character	7	Math Enrollment American Indian/Alaska Native
43	mt_ai	Character	7	Math Tested American Indian/Alaska Native
44	mp_ai	Character	5	Math Participation Rate American Indian/Alaska Native
45	mpm_ai	Character	4	Math Participation Rate met American Indian/Alaska Native
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 or Latino
63	et_hi	Character	7	ELA Tested Hispanic or Latino
64	ep_hi	Character	5	ELA Participation Rate Hispanic or Latino
65	epm_hi	Character	4	ELA Participation Rate met Hispanic or Latino
66	me_hi	Character	7	Math Enrollment Hispanic or Latino
67	mt_hi	Character	7	Math Tested Hispanic or Latino
68	mp_hi	Character	5	Math Participation Rate Hispanic or Latino
69	mpm_hi	Character	4	Math Participation Rate met Hispanic or Latino
70	ee_pi	Character	7	ELA Enrollment Native Hawaiian/Pacific Islanders
71	et_pi	Character	7	ELA Tested Native Hawaiian/Pacific Islanders
72	ep_pi	Character	5	ELA Participation Rate Native Hawaiian/Pacific Islanders
73	epm_pi	Character	4	ELA Participation Rate met Native Hawaiian/Pacific Islanders
74	me_pi	Character	7	Math Enrollment Native Hawaiian/Pacific Islanders
75	mt_pi	Character	7	Math Tested Native Hawaiian/Pacific Islanders
76	mp_pi	Character	5	Math Participation Rate Native Hawaiian/Pacific Islanders
77	mpm_pi	Character	4	Math Participation Rate met Native Hawaiian/Pacific Islanders
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_mr	Character	7	ELA Enrollment 'Two or More Races'
87	et_mr	Character	7	ELA Tested 'Two or More Races'
88	ep_mr	Character	5	ELA Participation Rate 'Two or More Races'
89	epm_mr	Character	4	ELA Participation Rate met 'Two or More Races'
90	me_mr	Character	7	Math Enrollment 'Two or More Races'
91	mt_mr	Character	7	Math Tested 'Two or More Races'
92	mp_mr	Character	5	Math Participation Rate 'Two or More Races'
93	mpm_mr	Character	4	Math Participation Rate met 'Two or More Races'
94	ee_sd	Character	7	ELA Enrollment Socioeconomic Disadvantaged
95	et_sd	Character	7	ELA Tested Socioeconomic Disadvantaged
96	ep_sd	Character	5	ELA Participation Rate Socioeconomic Disadvantaged
97	epm_sd	Character	4	ELA Participation Rate met Socioeconomic Disadvantaged
98	me_sd	Character	7	Math Enrollment Socioeconomic Disadvantaged
99	mt_sd	Character	7	Math Tested Socioeconomic Disadvantaged
100	mp_sd	Character	5	Math Participation Rate Socioeconomic Disadvantaged
101	mpm_sd	Character	4	Math Participation Rate met Socioeconomic Disadvantaged
102	ee_el	Character	7	ELA Enrollment English Learner
103	et_el	Character	7	ELA Tested English Learner
104	ep_el	Character	5	ELA Participation Rate English Learner
105	epm_el	Character	4	ELA Participation Rate met English Learner
106	me_el	Character	7	Math Enrollment English Learner
107	mt_el	Character	7	Math Tested English Learner
108	mp_el	Character	5	Math Participation Rate English Learner
109	mpm_el	Character	4	Math Participation Rate met English Learner
110	ee_di	Character	7	ELA Enrollment Students with Disabilities
111	et_di	Character	7	ELA Tested Students with Disabilities
112	ep_di	Character	5	ELA Participation Rate Students with Disabilities
113	epm_di	Character	4	ELA Participation Rate met Students with Disabilities
114	me_di	Character	7	Math Enrollment Students with Disabilities
115	mt_di	Character	7	Math Tested Students with Disabilities
116	mp_di	Character	5	Math Participation Rate Students with Disabilities
117	mpm_di	Character	4	Math Participation Rate met Students with Disabilities
118	e_val	Character	7	Schoolwide or LEA-wide ELA Number of Valid scores
119	e_prof	Character	7	Schoolwide or LEA-wide ELA Number of students scoring Proficient or Above
120	e_pprof	Character	5	Schoolwide or LEA-wide ELA Percent of students scoring Proficient or Above
121	e_ppm	Character	4	Schoolwide or LEA-wide ELA Percent Proficient or Above met
122	m_val	Character	7	Schoolwide or LEA-wide Math Valid scores
123	m_prof	Character	7	Schoolwide Math number of students scoring Proficient or Above
124	m_pprof	Character	5	Schoolwide Math Percent of students scoring Proficient or Above
125	m_ppm	Character	4	Schoolwide Math Percent Proficient or Above met
126	ev_aa	Character	7	ELA Valid scores Black or African American
127	enp_aa	Character	7	ELA Number of students scoring Proficient or Above Black or African American
128	epp_aa	Character	5	ELA Percent Proficient or Above Black or African American
129	eppm_aa	Character	4	ELA Percent Proficient or Above met Black or African American
130	mv_aa	Character	7	Math Valid scores Black or African American
131	mnp_aa	Character	7	Math students scoring Proficient or Above Black or African American
132	mpp_aa	Character	5	Math Percent of students scoring Proficient or Above Black or African American
133	mppm_aa	Character	4	Math Percent Proficient or Above met Black or African American
134	ev_ai	Character	7	ELA Valid scores American Indian/Alaska Native
135	enp_ai	Character	7	ELA Number students scoring Proficient or Above American Indian/Alaska Native
136	epp_ai	Character	5	ELA Percent of students scoring Proficient or Above American Indian/Alaska Native
137	eppm_ai	Character	4	ELA Percent Proficient or Above met American Indian/Alaska Native
138	mv_ai	Character	7	Math Valid scores American Indian/Alaska Native
139	mnp_ai	Character	7	Math students scoring Proficient or Above American Indian/Alaska Native
140	mpp_ai	Character	5	Math Percent of students scoring Proficient or Above American Indian/Alaska Native
141	mppm_ai	Character	4	Math Percent Proficient or Above met American Indian/Alaska Native
142	ev_as	Character	7	ELA Valid scores Asian
143	enp_as	Character	7	ELA Number of students scoring Proficient or Above Asian
144	epp_as	Character	5	ELA Percent of students scoring Proficient or Above Asian
145	eppm_as	Character	4	ELA Percent Proficient or Above met Asian
146	mv_as	Character	7	Math Valid scores Asian
147	mnp_as	Character	7	Math students scoring Proficient or Above Asian
148	mpp_as	Character	5	Math Percent of students scoring Proficient or Above Asian
149	mppm_as	Character	4	Math Percent Proficient or Above met Asian
150	ev_fi	Character	7	ELA Valid scores Filipino
151	enp_fi	Character	7	ELA Number of students scoring Proficient or Above Filipino
152	epp_fi	Character	5	ELA Percent of students scoring Proficient or Above Filipino
153	eppm_fi	Character	4	ELA Percent Proficient or Above met Filipino
154	mv_fi	Character	7	Math Valid scores Filipino
155	mnp_fi	Character	7	Math students scoring Proficient or Above Filipino
156	mpp_fi	Character	5	Math Percent of students scoring Proficient or Above Filipino
157	mppm_fi	Character	4	Math Percent Proficient or Above met Filipino
158	ev_hi	Character	7	ELA Valid scores Hispanic or Latino
159	enp_hi	Character	7	ELA Number students scoring Proficient or Above Hispanic or Latino
160	epp_hi	Character	5	ELA Percent of students scoring Proficient or Above Hispanic or Latino
161	eppm_hi	Character	4	ELA Percent Proficient or Above met Hispanic or Latino
162	mv_hi	Character	7	Math Valid scores Hispanic or Latino
163	mnp_hi	Character	7	Math students scoring Proficient or Above Hispanic or Latino
164	mpp_hi	Character	5	Math Percent of students scoring Proficient or Above Hispanic or Latino
165	mppm_hi	Character	4	Math Percent Proficient or Above met Hispanic or Latino
166	ev_pi	Character	7	ELA Valid scores Native Hawaiian/Pacific Islander
167	enp_pi	Character	7	ELA Number of students scoring Proficient or Above Native Hawaiian/Pacific Islander
168	epp_pi	Character	5	ELA Percent of students scoring Proficient or Above Native Hawaiian/Pacific Islander
169	eppm_pi	Character	4	ELA Percent Proficient or Above Met Native Hawaiian/Pacific Islander
170	mv_pi	Character	7	Math Valid scores Native Hawaiian/Pacific Islander
171	mnp_pi	Character	7	Math students scoring Proficient or Above Native Hawaiian/Pacific Islander
172	mpp_pi	Character	5	Math Percent of students scoring Proficient or Above Native Hawaiian/Pacific Islander
173	mppm_pi	Character	4	Math Percent Proficient or Above Met Native Hawaiian/Pacific Islander
174	ev_wh	Character	7	ELA Valid scores White
175	enp_wh	Character	7	ELA Number of students scoring Proficient or Above White
176	epp_wh	Character	5	ELA Percent of students scoring Proficient or Above White
177	eppm_wh	Character	4	ELA Percent Proficient or Above Met White
178	mv_wh	Character	7	Math Valid scores White
179	mnp_wh	Character	7	Math students scoring Proficient or Above White
180	mpp_wh	Character	5	Math Percent of students scoring Proficient or Above White
181	mppm_wh	Character	4	Math Percent Proficient or Above Met White
182	ev_mr	Character	7	ELA Valid scores 'Two or More Races'
183	enp_mr	Character	7	ELA Number of students scoring Proficient or Above 'Two or More Races'
184	epp_mr	Character	5	ELA Percent of students scoring Proficient or Above 'Two or More Races'
185	eppm_mr	Character	4	ELA Percent Proficient or Above Met 'Two or More Races'
186	mv_mr	Character	7	Math Valid scores 'Two or More Races'
187	mnp_mr	Character	7	Math students scoring Proficient or Above 'Two or More Races'
188	mpp_mr	Character	5	Math Percent of students scoring Proficient or Above 'Two or More Races'
189	mppm_mr	Character	4	Math Percent Proficient or Above Met 'Two or More Races'
190	ev_sd	Character	7	ELA Valid scores Socioeconomic Disadvantaged
191	enp_sd	Character	7	ELA Number of students scoring Proficient or Above Socioeconomic Disadvantaged
192	epp_sd	Character	5	ELA Percent of students scoring Proficient or Above Socioeconomic Disadvantaged
193	eppm_sd	Character	4	ELA Percent Proficient or Above Met Socioeconomic Disadvantaged
194	mv_sd	Character	7	Math Valid scores Socioeconomic Disadvantaged
195	mnp_sd	Character	7	Math students scoring Proficient or Above Socioeconomic Disadvantaged
196	mpp_sd	Character	5	Math Percent of students scoring Proficient or Above Socioeconomic Disadvantaged
197	mppm_sd	Character	4	Math Percent Proficient or Above Met Socioeconomic Disadvantaged
198	ev_el	Character	7	ELA Valid scores English Learner
199	enp_el	Character	7	ELA students scoring Proficient or Above English Learner
200	epp_el	Character	5	ELA Percent of students scoring Proficient or Above English Learner
201	eppm_el	Character	4	ELA Percent Proficient or Above Met English Learner
202	mv_el	Character	7	Math Valid scores English Learner
203	mnp_el	Character	7	Math students scoring Proficient or Above English Learner
204	mpp_el	Character	5	Math Percent of students scoring Proficient or Above English Learner
205	mppm_el	Character	4	Math Percent Proficient or Above Met English Learner
206	ev_di	Character	7	ELA Valid scores Students with Disabilities
207	enp_di	Character	7	ELA students scoring Proficient or Above Students with Disabilities
208	epp_di	Character	5	ELA Percent of students scoring Proficient or Above Students with Disabilities
209	eppm_di	Character	4	ELA Percent Proficient or Above Met Students with Disabilities
210	mv_di	Character	7	Math students with a Valid scores Students with Disabilities
211	mnp_di	Character	7	Math Number of Students with Disabilities students scoring Proficient or Above
212	mpp_di	Character	5	Math Percent of Students with Disabilities scoring Proficient or Above
213	mppm_di	Character	4	Math Percent Proficient or Above Met Students with Disabilities
214	grad09	Character	6	Graduation Rate for 2009, Class of 2007–08
215	grad10	Character	6	Graduation Rate for 2010, Class of 2008–09
216	tr_10	Character	6	Target Rate for 2010
217	tr_11	Character	6	Target Rate for 2011
218	typtr_11	Character	8	Type of Target Rate Applied for 2011 (Fixed/Variable)
219	api_flag	Character	1	1= parent waiver, 2= testing irregularities, 3= Failed the 85% rule - no valid API given, 9 = under 50 valid scores
220	chg_data	Character	1	Results on this report may change because: C = the LEA will be changing data
221	exc_cap	Character	1	Y = Results on this report may change because the LEA exceeded the 1.0 percent cap on proficient or above scores based on 2009 CAPA
222	e_pr_app	Character	5	Participation Rate ELA (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)
223	m_pr_app	Character	5	Participation Rate Math (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)
224	e_pp_app	Character	5	Percent Proficient ELA (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A )
225	m_pp_app	Character	5	Percent Proficient Math (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)
226	api_app	Character	5	API Criteria (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)
227	grad_app	Character	5	Graduation Rate (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)
228	ela_met	Character	5	ELA met overall (Y=Yes, N=No)
229	math_met	Character	5	Math met overall (Y=Yes, N=No)
230	e_targ10	Character	5	ELA 2010 Percent Proficient Target
231	m_targ10	Character	5	Math 2010 Percent Proficient Target
232	cma_ela1	Character	5	% CMA proficient and above ELA
233	cma_ela2	Character	5	CMA limit (2% unless CAPA<1% then 3%-CAPA) ELA
234	cma_ela3	Character	5	Over the CMA limit ELA
235	cma_math1	Character	5	% CMA proficient and above Math
236	cma_math2	Character	5	CMA limit (2% unless CAPA<1% then 3%-CAPA) Math
237	cma_math3	Character	5	Over the CMA limit Math

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

Last Reviewed: Thursday, January 13, 2022