Skip to content
Printer-friendly version

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