Skip to content
Printer-friendly version

Record Layout for the 2008 AYP Data File

Field names, types, and descriptions for 2008 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
api07b Character
5
2007 Base
11
api08g Character
5
2008 Growth
12
apichang Character
5
Change in API
13
met_all Character
5
Yes=Met all 2008 AYP Criteria, No=Did not Meet all 2008 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 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
grad08 Character
5
Graduation Rate for 2008, Class of 2006-07
199
grad07 Character
5
Graduation Rate for 2007, Class of 2005-06
200
gr_chang Character
5
2006-2008 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 2007 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_targ08 Character
5
ELA 2008 Percent Proficient Target
214
m_targ08 Character
5
Math 2008 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 
Download Free Readers