Skip to main content
California Department of Education Logo

Record Layout for the 2009 AYP Data File

Field names, types, and descriptions for 2009 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
api08b Character
5
2008 Base
11
api09g Character
5
2009 Growth
12
apichang Character
5
Change in API
13
met_all Character
5
Yes = Met all 2009 AYP Criteria, No = Did not Meet all 2009 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 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
eppm_hi Character
4
ELA Percent Proficient or Above met Hispanic
154
mv_hi Character
7
Math Valid scores Hispanic
155
mnp_hi Character
7
Math students scoring Proficient or Above Hispanic
156
mpp_hi Character
5
Math Percent of students scoring Proficient or Above Hispanic
157
mppm_hi Character
4
Math Percent Proficient or Above met Hispanic
158
ev_pi Character
7
ELA Valid scores Pacific Islander
159
enp_pi Character
7
ELA Number of students scoring Proficient or Above Pacific Islander
160
epp_pi Character
5
ELA Percent of students scoring Proficient or Above Pacific Islander
161
eppm_pi Character
4
ELA Percent Proficient or Above Met Pacific Islander
162
mv_pi Character
7
Math Valid scores Pacific Islander
163
mnp_pi Character
7
Math students scoring Proficient or Above Pacific Islander
164
mpp_pi 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
grad09 Character
5
Graduation Rate for 2009, Class of 2007–08
199
grad08 Character
5
Graduation Rate for 2008, Class of 2006–07
200
gr_chang Character
5
2007-2009 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
Y = Results on this report may change because the LEA exceeded the 1.0 percent cap on proficient or above scores based on 2008 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_targ09 Character
5
ELA 2009 Percent Proficient Target
214
m_targ09 Character
5
Math 2009 Percent Proficient Target
215
cma_ela1 Character
5

% CMA proficient and above ELA

216
cma_ela2 Character
5

CMA limit (2% unless CAPA<1% then 3%-CAPA) ELA

217
cma_ela3 Character
5
Over the CMA limit ELA
218
cma_math1 Character
5

% CMA proficient and above Math

219
cma_math2 Character
5

CMA limit (2% unless CAPA<1% then 3%-CAPA) Math

220
cma_math3 Character
5
Over the CMA limit Math

Questions: Academic Accountability Team | aau@cde.ca.gov | 916-319-0863 
Last Reviewed: Friday, May 6, 2016
Recently Posted in Accountability

  • State Accountability Report Card 2011-12 (PDF) (added 18-Nov-2016)
    California's State Accountability Report Card for 2011-12 as required by the federal Elementary and Secondary Education Act.
  • Updates to SARC Data 2015–16 (added 16-Nov-2016)
    Description of updates to data contained in the 2015–16 School Accountability Report Card (SARC) data files.
  • 2015-16 SARC Data Layout (DOC) (added 16-Nov-2016)
    School Accountability Report Card (SARC) Data Layout used to map field names to descriptive labels for each table.
  • Downloadable SARC Data Files (added 16-Nov-2016)
    Template table names, downloadable data files, and mapping document to populate School Accountability Report Card (SARC) Reports.
  • Data Element Definitions and Sources 2013-14 (DOC) (added 16-Nov-2016)
    Descriptions of data elements and their sources for the 2013-14 School Accountability Report Card (SARC).