Skip to main content
California Department of Education Logo

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 
Last Reviewed: Thursday, July 30, 2015

Recently Posted in Accountability