Record Layout for the 2010 AYP Data File

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

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: Academic Accountability Team | aau@cde.ca.gov | 916-319-0863

Download Free Readers