Record Layout for the 2007 Growth API Data File

Field names, types and descriptions for the 2007 Growth Academic Performance Index (API) Data File.

Repository archive entry for the Academic Performance Index (API) in the Programs No Longer Administered by the California Department of Education (CDE) Section of the CDE Web site.

This information is for historical purposes only and it is possible that information contained here may not be current.

Return to API Data Files and Record Layouts

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	STYPE	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	FLAG	Character	5	Flag Values
11	VALID	Character	7	Number of Scores included in the 2007 Academic Performance Index (API)
12	API07	Character	5	2007 API (Growth)
13	API06	Character	5	2006 API (Base),"B," "C," (B=School did not have a valid 2006 API Base and there is no Growth or target information, C=School had significant demographic changes and there is no Growth or target information )
14	TARGET	Character	5	2006–2007 Growth Target, "A," "B," "C," "D," or "E". (A=Met Interim Performance Target of 800. B=School did not have a valid 2006 API Base and there is no Growth or target information. C=School had significant demographic changes and there is no Growth or target information D=There is no growth target for Districts or ASAM schools E= School was an Alternative Schools Accountability Model (ASAM) school in the API Base report and has no target information even though the school is no longer an ASAM school).
15	GROWTH	Character	5	2006–2007 API Growth, "B," "C," (B=School did not have a valid 2006 API Base and there is no Growth or target information, C=School had significant demographic changes and there is no Growth or target information.)
16	SCH_WIDE	Character	5	Met School-wide Growth Target
17	COMP_IMP	Character	5	Met Comparable Improvement (CI) Target
18	BOTH	Character	5	Met both School-wide/CI Target
19	AA_NUM	Character	7	Number of African Americans Included in API
20	AA_SIG	Character	5	African Americans Significant Both Years? (Yes/No)
21	AA_API07	Character	5	2007 African American API (Growth)
22	AA_API06	Character	5	2006 African American API (Base)
23	AA_TARG	Character	5	2006–2007 African American Subgroup Growth Target
24	AA_GROW	Character	5	2006–2007 African American Subgroup API Growth
25	AA_MET	Character	5	Met African American Subgroup Growth Target
26	AI_NUM	Character	7	Number of American Indians Included in API
27	AI_SIG	Character	5	American Indians Significant Both Years? (Yes/No)
28	AI_API07	Character	5	2007 American Indians API (Growth)
29	AI_API06	Character	5	2006 American Indians API (Base)
30	AI_TARG	Character	5	2006–2007 American Indians Subgroup Growth Target
31	AI_GROW	Character	5	2006–2007 American Indians Subgroup API Growth
32	AI_MET	Character	5	Met American Indians Subgroup Growth Target
33	AS_NUM	Character	7	Number of Asians Included in API
34	AS_SIG	Character	5	Asians Significant Both Years Both Years? (Yes/No)
35	AS_API07	Character	5	2007 Asian API (Growth)
36	AS_API06	Character	5	2006 Asian API (Base)
37	AS_TARG	Character	5	2006–2007 Asian Subgroup Growth Target
38	AS_GROW	Character	5	2006–2007 Asian Subgroup API Growth
39	AS_MET	Character	5	Met Asian Subgroup Growth Target
40	FI_NUM	Character	7	Number of Filipinos Included in API
41	FI_SIG	Character	5	Filipino Significant Both Years Both Years? (Yes/No)
42	FI_API07	Character	5	2007 Filipino API (Growth)
43	FI_API06	Character	5	2006 Filipino API (Base)
44	FI_TARG	Character	5	2006–2007 Filipino Subgroup Growth Target
45	FI_GROW	Character	5	2006–2007 Filipino Subgroup API Growth
46	FI_MET	Character	5	Met Filipino Subgroup Growth Target
47	HI_NUM	Character	7	Number of Hispanics included in API
48	HI_SIG	Character	5	Hispanics Significant Both Years Both Years? (Yes/No)
49	HI_API07	Character	5	2007 Hispanics API (Growth)
50	HI_API06	Character	5	2006 Hispanics API (Base)
51	HI_TARG	Character	5	2006–2007 Hispanics Subgroup Growth Target
52	HI_GROW	Character	5	2006–2007 Hispanics Subgroup API Growth
53	HI_MET	Character	5	Met Hispanic Subgroup Growth Target
54	PI_NUM	Character	7	Number of Pacific Islanders Included in API
55	PI_SIG	Character	5	Pacific Islanders Significant Both Years? (Yes/No)
56	PI_API07	Character	5	2007 Pacific Islanders API (Growth)
57	PI_API06	Character	5	2006 Pacific Islanders API (Base)
58	PI_TARG	Character	5	2006–2007 Pacific Islanders Subgroup Growth Target
59	PI_GROW	Character	5	2006–2007 Subgroup Growth
60	PI_MET	Character	5	Met Pacific Islander Subgroup Growth Target
61	WH_NUM	Character	7	Number of whites included in API
62	WH_SIG	Character	5	White Significant Both Years? (Yes/No)
63	WH_API07	Character	5	2007 Whites API (Growth)
64	WH_API06	Character	5	2006 White API (Base)
65	WH_TARG	Character	5	2006–2007 Whites Subgroup Growth Target
66	WH_GROW	Character	5	2006–2007 White Growth
67	WH_MET	Character	5	Met White Subgroup Growth Target
68	SD_NUM	Character	7	Number of Socioeconomically Disadvantaged (SD) Students Included in API
69	SD_SIG	Character	5	Socioeconomically Disadvantaged Significant? (Yes/No)
70	SD_API07	Character	5	2007 Socioeconomically Disadvantaged API (Growth)
71	SD_API06	Character	5	2006 Socioeconomically Disadvantaged API (Base)
72	SD_TARG	Character	5	2006–2007 Socioeconomically Disadvantaged subgroup Growth Target
73	SD_GROW	Character	5	2006–2007 Socioeconomically Disadvantaged Growth
74	SD_MET	Character	5	Met Socioeconomically Disadvantaged Subgroup Growth Target
75	EL_NUM	Character	7	Number of English Learners included in API
76	EL_SIG	Character	5	English Learners Significant Both Years? (Yes/No)
77	EL_API07	Character	5	2007 English Learners API (Growth)
78	EL_API06	Character	5	2006 English Learners API (Base)
79	EL_TARG	Character	5	2006–2007 English Learner Subgroup Growth Target
80	EL_GROW	Character	5	2006–2007 English Learners Subgroup API Growth
81	EL_MET	Character	5	Met English Learner Subgroup Growth Target
82	DI_NUM	Character	7	Number of Students With Disabilities included in API
83	DI_SIG	Character	5	Students With Disabilities Significant Both Years? (Yes/No)
84	DI_API07	Character	5	2007 Students With Disabilities API (Growth)
85	DI_API06	Character	5	2006 Students With Disabilities API (Base)
86	DI_TARG	Character	5	2006–2007 Students With Disabilities Subgroup Growth Target
87	DI_GROW	Character	5	2006–2007 Students With Disabilities Subgroup API Growth
88	DI_MET	Character	5	Met Students With Disabilities Subgroup Growth Target
89	PCT_AA	Character	5	Percent African American
90	PCT_AI	Character	5	Percent American Indian
91	PCT_AS	Character	5	Percent Asian
92	PCT_FI	Character	5	Percent Filipino
93	PCT_HI	Character	5	Percent Hispanic or Latino
94	PCT_PI	Character	5	Percent Pacific Islander
95	PCT_WH	Character	5	Percent White
96	MEALS	Character	5	Percentage of Students that are Participants in the Free or Reduced Price Meal Program
97	P_GATE	Character	5	Percent of participants in Gifted and Talented education programs (STAR)
98	P_MIGED	Character	5	Percent of participants in migrant education programs (STAR)
99	P_EL	Character	5	Percent of participants who are designated as English Learners
100	P_RFEP	Character	5	Percent of Reclassified Fluent-English-Proficient (RFEP) students (STAR)
101	P_DI	Character	5	Percent of Students with Disabilities (STAR)
102	YR_RND	Character	5	Multi-Track Year-Round School
103	CBMOB	Character	5	Percentage of Students counted as part of school enrollment in October 2006 CBEDS and has been continuously enrolled since that date
104	DMOB	Character	5	Percentage of Students counted as part of district enrollment in October 2006 CBEDS and has been continuously enrolled since that date
105	ACS_K3	Character	5	Average Class Size (Grades K-3)
106	ACS_46	Character	5	Average Class Size (Grades 4-6)
107	ACS_CORE	Character	5	Average Class Size for a Number of Core Academic Courses
108	PCT_RESP	Character	5	Percent of Student Answer Documents with Parent Education Level Information
109	NOT_HSG	Character	5	Parent Ed Level: Percent Not High School Graduate
110	HSG	Character	5	Parent Ed Level: Percent High School Graduate
111	SOME_COL	Character	5	Parent Ed Level: Percent Some College
112	COL_GRAD	Character	5	Parent Ed Level: Percent College Graduate
113	GRAD_SCH	Character	5	Parent Ed Level: Percent Graduate School
114	AVG_ED	Character	5	Average Parent Education Level
115	FULL	Character	5	Percent Teachers at this School with Full Credentials
116	EMER	Character	5	Percent Teachers at this school with Emergency Credentials
117	PEN_2	Character	5	Percent of Enrollments in grade 2 (STAR)
118	PEN_35	Character	5	Percent of Enrollments in grades 3-5 (STAR)
119	PEN_6	Character	5	Percent of Enrollments in grade 6 (STAR)
120	PEN_78	Character	5	Percent of Enrollments in grades 7-8 (STAR)
121	PEN_911	Character	5	Percent of Enrollments in grades 9-11(STAR)
122	ENROLL	Character	7	Number of Students Enrolled on the First Day of Testing for Grades 2-11
123	PAR_OPT	Character	6	Number of Students Excused from Testing by Parental Written Request
124	TESTED	Character	7	Number of Students Tested
125	MEDIAN07	Character	5	Median score of this school's similar schools group for 2007 Growth API
126	MEDIAN06	Character	5	Median score of this school's similar schools group for 2006 Base API
127	VCST_E28	Character	10	Valid Score for California Standards Test (CST) in English-language arts Grades 2-8
128	PCST_E28	Character	10	Product of Test Weights Multiplied by Valid Scores for CST in English-language arts Grades 2-8
129	VCST_E91	Character	10	Valid Score for CST in English-language arts Grades 9-11
130	PCST_E91	Character	10	Product of Test Weights Multiplied by Valid Scores for CST in English-language arts Grades 9-11
131	CW_CSTE	Character	5	School Content Area Weights Percentage in CST English-language arts
132	VCST_M28	Character	10	Valid Score for CST in mathematics Grades 2-8
133	PCST_M28	Character	10	Product of Test Weights Multiplied by Valid Scores for CST in mathematics Grades 2-8
134	VCST_M91	Character	10	Valid Score for CST in mathematics arts Grades 9-11
135	PCST_M91	Character	10	Product of Test Weights Multiplied by Valid Scores for CST in mathematics Grades 9-11
136	CW_CSTM	Character	5	School Content Area Weights Percentage in CST mathematics
137	VCST_S28	Character	10	Valid Score for CST in science Grades 2-8 (Includes ONLY Grades 5 & 8)
138	PCST_S28	Character	10	Product of Test Weights Multiplied by Valid Scores for CST in science Grades 2-8
139	VCST_S91	Character	10	Valid Score for CST in science Grades 9-11. End of Course, CST.
140	PCST_S91	Character	10	Product of Test Weights Multiplied by Valid Scores for CST in science Grades 9-11. End of Course, CST.
141	CWS_91	Character	5	School Content Area Weights Percentage in CST science Grades 9-11 End of Course
142	VCST_H28	Character	10	Valid Score for CST in history-social science Grades 2-8
143	PCST_H28	Character	10	Product of Test Weights Multiplied by Valid Scores for CST in history-social science Grades 2-8
144	VCST_H91	Character	10	Valid Score for CST in history-social science Grades 9-11.
145	PCST_H91	Character	10	Product of Test Weights Multiplied by Valid Scores for CST in history-social science Grades 9-11
146	CW_CSTH	Character	5	School Content Area Weights Percentage in CST history-social science
147	VNRT_R28	Character	10	Valid Score for Norm-Referenced Test (NRT) reading in Grades 2-8
148	PNRT_R28	Character	10	Product of Test Weights Multiplied by Valid scores for NRT reading in Grades 2-8
149	CW_NRTR	Character	5	School Content Area Weights Percentage in NRT reading
150	VNRT_L28	Character	10	Valid Score for NRT language in Grades 2-8
151	PNRT_L28	Character	10	Product of Test Weights Multiplied by Valid scores for NRT language in Grades 2-8
152	CW_NRTL	Character	5	School Content Area Weights Percentage in NRT language
153	VNRT_S28	Character	10	Valid Score for NRT spelling in Grades 2-8
154	PNRT_S28	Character	10	Product of Test Weights Multiplied by Valid scores for NRT spelling in Grades 2-8
155	CW_NRTS	Character	5	School Content Area Weights Percentage in NRT spelling
156	VNRT_M28	Character	10	Valid Score for NRT mathematics in Grades 2-8
157	PNRT_M28	Character	10	Product of Test Weights Multiplied by Valid scores for NRT mathematics in Grades 2-8
158	CW_NRTM	Character	5	School Content Area Weights Percentage in NRT mathematics
159	VCHS_E	Character	10	Valid Score for California High School Exit Exam (CAHSEE) English-Language Arts (ELA) in Grades 9-11
160	PCHS_E	Character	10	Product of Test Weights Multiplied by Valid scores for CAHSEE ELA in Grades 9-11
161	CW_CHSE	Character	5	School Content Area Weights Percentage in CAHSEE ELA
162	VCHS_M	Character	10	Valid Score for CAHSEE mathematics in Grades 9-11
163	PCHS_M	Character	10	Product of Test Weights Multiplied by Valid scores for CAHSEE mathematics in Grades 9-11
164	CW_CHSM	Character	5	School Content Area Weights Percentage in CAHSEE mathematics
165	TOT_28	Character	10	Product of Total of Test Weights Multiplied by Total of Valid scores in grades 2-8
166	TOT_91	Character	10	Product of Total of Test Weights Multiplied by Total of Valid scores in grades 9-11
167	sm07	Character	5	* =School was designated as a small school for Growth API purposes in 2007
168	sm06	Character	5	* =School was designated as a small school for Base API purposes in 2006
169	chg_data	Character	1	Results on this report may change because: C=the LEA will be changing data.
170	CW_SCI	Character	5	School Content Area Weights Percentage in CST Life Science Grade 10 and Grades 2-8
171	VCST_LS10	Character	10	Valid Score for CST in Life Science Grade 10 only
172	PCST_LS10	Character	10	Product of Test Weights Multiplied by Valid scores for CST in Life Science Grade 10 only
173	CWM2_28	Character	5	School Content Area Weights Percentage for Mathematics Assignment of 200 CST in grades 2-8
174	VCSTM2_28	Character	10	Valid Score for Mathematics Assignment of 200 CST in Grades 2-8
175	PCSTM2_28	Character	10	Product of Test Weights Multiplied by Valid scores for Mathematics Assignment of 200 CST in Grades 2-8
176	CWM2_91	Character	5	School Content Area Weights Percentage for Mathematics Assignment of 200 CST in grades 9-11
177	VCSTM2_91	Character	10	Valid Score for Mathematics Assignment of 200 CST in Grades 9-11
178	PCSTM2_91	Character	10	Product of Test Weights Multiplied by Valid scores for Mathematics Assignment of 200 CST in Grades 9-11
179	CWS2_91	Character	5	School Content Area Weights Percentage for Science Assignment of 200 CST in grades 9-11
180	VCSTS2_91	Character	10	Valid Score for Science Assignment of 200 CST in Grades 9-11
181	PCSTS2_91	Character	10	Product of Test Weights Multiplied by Valid scores for Science Assignment of 200 CST in Grades 9-11
182	IRG5	Character	1	Testing irregularities greater than zero but less than 5 percent (Y=Yes)

Questions: California Department of Education | 916-319-0800

Last Reviewed: Friday, November 5, 2021