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

Download Free Readers