Skip to content
Printer-friendly version

Record Layout for the 2012 AYP Data File

Field names, types, and descriptions for 2012 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

api11b

Character

5

2011 Base

11

api12g

Character

5

2012 Growth

12

apichang

Character

5

Change in API

13

met_all

Character

5

Yes = Met all 2012 AYP Criteria, No = Did not Meet all 2012 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 or Alaska Native

39

et_ai

Character

7

ELA Tested American Indian or Alaska Native

40

ep_ai

Character

5

ELA Participation Rate American Indian or Alaska Native

41

epm_ai

Character

4

ELA Participation Rate met American Indian or Alaska Native

42

me_ai

Character

7

Math Enrollment American Indian or Alaska Native

43

mt_ai

Character

7

Math Tested American Indian or Alaska Native

44

mp_ai

Character

5

Math Participation Rate American Indian or Alaska Native

45

mpm_ai

Character

4

Math Participation Rate met American Indian or 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 or Pacific Islanders

71

et_pi

Character

7

ELA Tested Native Hawaiian or Pacific Islanders

72

ep_pi

Character

5

ELA Participation Rate Native Hawaiian or Pacific Islanders

73

epm_pi

Character

4

ELA Participation Rate met Native Hawaiian or Pacific Islanders

74

me_pi

Character

7

Math Enrollment Native Hawaiian or Pacific Islanders

75

mt_pi

Character

7

Math Tested Native Hawaiian or Pacific Islanders

76

mp_pi

Character

5

Math Participation Rate Native Hawaiian or Pacific Islanders

77

mpm_pi

Character

4

Math Participation Rate met Native Hawaiian or 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 or Alaska Native

135

enp_ai

Character

7

ELA Number students scoring Proficient or Above American Indian or Alaska Native

136

epp_ai

Character

5

ELA Percent of students scoring Proficient or Above American Indian or Alaska Native

137

eppm_ai

Character

4

ELA Percent Proficient or Above met American Indian or Alaska Native

138

mv_ai

Character

7

Math Valid scores American Indian or Alaska Native

139

mnp_ai

Character

7

Math students scoring Proficient or Above American Indian or Alaska Native

140

mpp_ai

Character

5

Math Percent of students scoring Proficient or Above American Indian or Alaska Native

141

mppm_ai

Character

4

Math Percent Proficient or Above met American Indian or 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 or Pacific Islander

167

enp_pi

Character

7

ELA Number of students scoring Proficient or Above Native Hawaiian or Pacific Islander

168

epp_pi

Character

5

ELA Percent of students scoring Proficient or Above Native Hawaiian or Pacific Islander

169

eppm_pi

Character

4

ELA Percent Proficient or Above Met Native Hawaiian or Pacific Islander

170

mv_pi

Character

7

Math Valid scores Native Hawaiian or Pacific Islander

171

mnp_pi

Character

7

Math students scoring Proficient or Above Native Hawaiian or Pacific Islander

172

mpp_pi

Character

5

Math Percent of students scoring Proficient or Above Native Hawaiian or Pacific Islander

173

mppm_pi

Character

4

Math Percent Proficient or Above Met Native Hawaiian or 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

grad11

Character

6

Graduation Rate for 2011, Class of 2009–10

215

grad12

Character

6

Graduation Rate for 2012, Class of 2010–11

216

tr_12

Character

6

LEA or SchoolwideTarget Rate for 2012

217

api_flag

Character

2

1= parent waiver, 2= testing irregularities, 3= Failed the 85% rule - no valid API given, 5= decrease of more than 20 percent of students, 7= potential data error or decrease of more than 20 percentage points, 8=This school had a confirmed security breach during the administration of the 2012 Standardized Testing and Reporting, 9 = under 50 valid scores, 10 = potential data error or decrease of more than 20 percentage points and this school had a confirmed security breach during the administration of the 2012 Standardized Testing and Reporting

218

chg_data

Character

1

Results on this report may change because: C = the LEA will be changing data

219

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 2012 CAPA

220

e_pr_app

Character

5

Participation Rate ELA (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)

221

m_pr_app

Character

5

Participation Rate Math (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)

222

e_pp_app

Character

5

Percent Proficient ELA (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A )

223

m_pp_app

Character

5

Percent Proficient Math (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)

224

api_app

Character

5

API Criteria (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)

225

grad_app

Character

5

Graduation Rate (Y=Yes, N=No, YMA=Yes Met on Appeal, N/A)

Note: To meet this criteria the graduation rate must be met at the schoolwide or LEA level and for all numerically significant student groups.

226

ela_met

Character

5

ELA met overall (Y=Yes, N=No)

227

math_met

Character

5

Math met overall (Y=Yes, N=No)

228

e_targ12

Character

5

ELA 2012 Percent Proficient Target

229

m_targ12

Character

5

Math 2012 Percent Proficient Target

230

cma_ela1

Character

5

% CMA proficient and above ELA

231

cma_ela2

Character

5

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

232

cma_ela3

Character

5

Over the CMA limit ELA

233

cma_math1

Character

5

% CMA proficient and above Math

234

cma_math2

Character

5

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

235

cma_math3

Character

5

Over the CMA limit Math

Questions: Academic Accountability Team | aau@cde.ca.gov | 916-319-0863 
Download Free Readers