Record Layout for the 2007 Base API Data File

Field names, types, and descriptions for the 2007 Base 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, S=State Special Schools
5	SIZE	Character	1	S=Small (11-99 Valid Scores), T=Under 11 Valid 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 Students Included in the 2007 Academic Performance Index (API)
12	API07B	Character	5	2007 API (Base)
13	ST_RANK	Character	5	Statewide Rank (I=Invalid data, B=District or ASAM, C=Special Education School. Note: Should have asterisk if Valid_Num < 100)
14	SIM_RANK	Character	5	Similar Schools Rank (I=Invalid data, B= District or ASAM, C=Special Education School, O=Schools with SCI changed because of data change, but similar school ranks not changed, S - Schools whose SCI changed and their Similar School Ranks also changed. Blank=the school did not have an SCI score with p3 data or the school did not have SCI score change with updated data.)
15	GR_TARG	Character	5	2007–08 API Growth Target (A=means the school or subgroup scored at or above the statewide performance target of 800 in 2007, B=means this is either an LEA or an Alternative Schools Accountability Model (ASAM) school, C=means this is a special education school.)
16	API_TARG	Character	5	2008 API Target (A=means the school or subgroup scored at or above the statewide performance target of 800 in 2007, B= means this is either an LEA or an Alternative Schools Accountability Model (ASAM) school, C=means this is a special education school.)
17	AA_NUM	Character	7	Number of African Americans Included in API
18	AA_SIG	Character	5	African Americans Significant?(Yes/No)
19	AA_API	Character	5	2007 African American API (Base)
20	AA_GT	Character	5	2007–08 African American Subgroup Growth Target
21	AA_TARG	Character	5	2008 African American Subgroup API Target
22	AI_NUM	Character	7	Number of American Indians Included in API
23	AI_SIG	Character	5	American Indians Significant?(Yes/No)
24	AI_API	Character	5	2007 American Indians API (Base)
25	AI_GT	Character	5	2007–08 American Indians Subgroup Growth Target
26	AI_TARG	Character	5	2008 American Indians Subgroup API Target
27	AS_NUM	Character	7	Number of Asians Included in API
28	AS_SIG	Character	5	Asians Significant?(Yes/No)
29	AS_API	Character	5	2007 Asian API (Base)
30	AS_GT	Character	5	2007–08 Asian Subgroup Growth Target
31	AS_TARG	Character	5	2008 Asian Subgroup API Target
32	FI_NUM	Character	7	Number of Filipinos Included in API
33	FI_SIG	Character	5	Filipino Significant?(Yes/No)
34	FI_API	Character	5	2007Filipino API (Base)
35	FI_GT	Character	5	2007–08 Filipino Subgroup Growth Target
36	FI_TARG	Character	5	2008 Filipino Subgroup API Target
37	HI_NUM	Character	7	Number of Hispanics included in API
38	HI_SIG	Character	5	Hispanics Significant?(Yes/No)
39	HI_API	Character	5	2007 Hispanics API (Base)
40	HI_GT	Character	5	2007–08 Hispanics Subgroup Growth Target
41	HI_TARG	Character	5	2008 Hispanics Subgroup API Target
42	PI_NUM	Character	7	Number of Pacific Islanders Included in API
43	PI_SIG	Character	5	Pacific Islanders Significant?(Yes/No)
44	PI_API	Character	5	2007 Pacific Islanders API (Base)
45	PI_GT	Character	5	2007–08 Pacific Islanders Subgroup Growth Target
46	PI_TARG	Character	5	2008 Subgroup API Target
47	WH_NUM	Character	7	Number of whites included in API
48	WH_SIG	Character	5	White Significant?(Yes/No)
49	WH_API	Character	5	2007 Whites API (Base)
50	WH_GT	Character	5	2007–08 Whites Subgroup Growth Target
51	WH_TARG	Character	5	2008 White API Target
52	SD_NUM	Character	7	Number of Socioeconomically Disadvantaged (SD) Students Included in API
53	SD_SIG	Character	5	Socioeconomically Disadvantaged Significant?(Yes/No)
54	SD_API	Character	5	2007 Socioeconomically Disadvantaged API (Base)
55	SD_GT	Character	5	2007–08 Socioeconomically Disadvantaged subgroup Growth Target
56	SD_TARG	Character	5	2008 Socioeconomically Disadvantaged API Target
57	EL_NUM	Character	7	Number of English Learner Students Included in API
58	EL_SIG	Character	5	English Learner Significant?(Yes/No)
59	EL_API	Character	5	2007 English Learner API (Base)
60	EL_GT	Character	5	2007–08 English Learner subgroup Growth Target
61	EL_TARG	Character	5	2008 English Learner API Target
62	DI_NUM	Character	7	Number of Included in API
63	DI_SIG	Character	5	Students with Disabilities Significant?(Yes/No)
64	DI_API	Character	5	2007 Students with Disabilities API (Base)
65	DI_GT	Character	5	2007–08 Students with Disabilities subgroup Growth Target
66	DI_TARG	Character	5	2008 Students with Disabilities API Target
67	PCT_AA	Character	5	Percent African American
68	PCT_AI	Character	5	Percent American Indian
69	PCT_AS	Character	5	Percent Asian
70	PCT_FI	Character	5	Percent Filipino
71	PCT_HI	Character	5	Percent Hispanic or Latino
72	PCT_PI	Character	5	Percent Pacific Islander
73	PCT_WH	Character	5	Percent White
74	MEALS	Character	5	Percentage of Students Tested that are Participants in the Free or Reduced Price Lunch Program
75	P_GATE	Character	5	Percent of participants in Gifted and Talented education programs (STAR)
76	P_MIGED	Character	5	Percent of participants in migrant education programs (STAR)
77	P_EL	Character	5	Percent English Learners
78	P_RFEP	Character	5	Percent of Reclassified Fluent-English-Proficient (RFEP) students (STAR)
79	P_DI	Character	5	Percent of Students with Disabilities (STAR)
80	YR_RND	Character	5	Year Round School
81	CBMOB	Character	5	Percentage of Students counted as part of school enrollment in October 2006 CBEDS and has been continuously enrolled since that date
82	DMOB	Character	5	Percentage of Students counted as part of district enrollment in October 2006 CBEDS and has been continuously enrolled since that date
83	ACS_K3	Character	5	Average Class Size (Grades K-3)
84	ACS_46	Character	5	Average Class Size (Grades 4-6)
85	ACS_CORE	Character	5	Number of Core Academic Courses
86	PCT_RESP	Character	5	Percent of Student Answer Documents with Parent Education Level Information
87	NOT_HSG	Character	5	Parent Education Level: Percent Not High School Graduate
88	HSG	Character	5	Parent Education Level: Percent High School Graduate
89	SOME_COL	Character	5	Parent Education Level: Percent Some College
90	COL_GRAD	Character	5	Parent Education Level: Percent College Graduate
91	GRAD_SCH	Character	5	Parent Education Level: Percent Graduate School
92	AVG_ED	Character	5	Average Parent Education Level
93	FULL	Character	5	Percent Teachers at this school with Full Credentials
94	EMER	Character	5	Percent Teachers at this school with Emergency Credentials
95	PEN_2	Character	5	Percent of Enrollments in grade 2 (STAR)
96	PEN_35	Character	5	Percent of Enrollments in grades 3-5 (STAR)
97	PEN_6	Character	5	Percent of Enrollments in grade 6 (STAR)
98	PEN_78	Character	5	Percent of Enrollments in grades 7-8 (STAR)
99	PEN_91	Character	5	Percent of Enrollments in grades 9-11 (STAR)
100	ENROLL	Character	7	Number of Students Enrolled on the First Day of Testing for Grades 2-11
101	PARENT_OPT	Character	7	Number of Students Excused from Testing by Parental Written Request
102	TESTED	Character	7	Number of Students Tested on STAR
103	SCI	Character	15	School Characteristic Index
104	VCST_E28	Character	10	Valid Score for California Standards Test (CST) in English-language arts Grades 2-8
105	PCST_E28	Character	10	Product of Test Weights Multiplied by Valid scores for CST in English-language arts Grades 2-8
106	VCST_E91	Character	10	Valid Score for CST in English-language arts Grades 9-11
107	PCST_E91	Character	10	Product of Test Weights Multiplied by Valid scores for CST in English-language arts Grades 9-11
108	CW_CSTE	Character	5	School Content Area Weights Percentage in CST English-language arts
109	VCST_M28	Character	10	Valid Score for CST in mathematics Grades 2-8
110	PCST_M28	Character	10	Product of Test Weights Multiplied by Valid scores for CST in mathematics Grades 2-8
111	VCST_M91	Character	10	Valid Score for CST in mathematics Grades 9-11
112	PCST_M91	Character	10	Product of Test Weights Multiplied by Valid scores for CST in mathematics Grades 9-11
113	CW_CSTM	Character	5	School Content Area Weights Percentage in CST mathematics
114	VCST_S28	Character	10	Valid Score for CST in science Grades 2-8
115	PCST_S28	Character	10	Product of Test Weights Multiplied by Valid scores for CST in science Grades 2-8
116	VCST_S91	Character	10	Valid Score for CST in science Grades 9-11 (End of Course, CST )
117	PCST_S91	Character	10	Product of Test Weights Multiplied by Valid scores for CST in science Grades 9-11 (End of Course, CST )
118	CWS_91	Character	5	School Content Area Weights Percentage in CST science (End of Course, CST )
119	VCST_H28	Character	10	Valid Score for CST in history-social science Grades 2-8
120	PCST_H28	Character	10	Product of Test Weights Multiplied by Valid scores for CST in history-social science Grades 2-8
121	VCST_H91	Character	10	Valid Score for CST in history-social science Grades 9-11
122	PCST_H91	Character	10	Product of Test Weights Multiplied by Valid scores for CST in history-social science Grades 9-11
123	CW_CSTH	Character	5	School Content Area Weights Percentage in CST history-social science
124	VNRT_R28	Character	10	Valid Score for Norm-Referenced Test (NRT) Reading in Grades 2-8
125	PNRT_R28	Character	10	Product of Test Weights Multiplied by Valid scores for NRT Reading in Grades 2-8
126	CW_NRTR	Character	5	School Content Area Weights Percentage in NRT Reading
127	VNRT_L28	Character	10	Valid Score for NRT Language in Grades 2-8
128	PNRT_L28	Character	10	Product of Test Weights Multiplied by Valid scores for NRT Language in Grades 2-8
129	CW_NRTL	Character	5	School Content Area Weights Percentage in NRT Language
130	VNRT_S28	Character	10	Valid Score for NRT Spelling in Grades 2-8
131	PNRT_S28	Character	10	Product of Test Weights Multiplied by Valid scores for NRT Spelling in Grades 2-8
132	CW_NRTS	Character	5	School Content Area Weights Percentage in NRT Spelling
133	VNRT_M28	Character	10	Valid Score for NRT Mathematics in Grades 2-8
134	PNRT_M28	Character	10	Product of Test Weights Multiplied by Valid scores for NRT Mathematics in Grades 2-8
135	CW_NRTM	Character	5	School Content Area Weights Percentage in NRT Mathematics
136	VCHS_E91	Character	10	Valid Score for California High School Exit Exam (CAHSEE) ELA in Grades 9-11
137	PCHS_E91	Character	10	Product of Test Weights Multiplied by Valid scores for CAHSEE ELA in Grades 9-11
138	CW_CHSE	Character	5	School Content Area Weights Percentage in CAHSEE ELA
139	VCHS_M91	Character	10	Valid Score for CAHSEE mathematics in Grades 9-11
140	PCHS_M91	Character	10	Product of Test Weights Multiplied by Valid scores for CAHSEE mathematics in Grades 9-11
141	CW_CHSM	Character	5	School Content Area Weights Percentage in CAHSEE mathematics
142	TOT_28	Character	10	Product of Total of Test Weights Multiplied by Total of Valid scores in Grades 2-8
143	TOT_91	Character	10	Product of Total of Test Weights Multiplied by Total of Valid scores in Grades 9-11
144	CW_SCI	Character	5	School Content Area Weights Percentage in CST Life Science Grade 10 and Grades 2-8
145	VCST_LS10	Character	10	Valid Score for CST in Life Science Grade 10 only
146	PCST_LS10	Character	10	Product of Test Weights Multiplied by Valid scores for CST in Life Science Grade 10 only
147	CWM2_28	Character	5	School Content Area Weights Percentage for Mathematics Assignment of 200 CST in grades 2-8
148	VCSTM2_28	Character	10	Valid Score for Mathematics Assignment of 200 CST in Grades 2-8
149	PCSTM2_28	Character	10	Product of Test Weights Multiplied by Valid scores for Mathematics Assignment of 200 CST in Grades 2-8
150	CWM2_91	Character	5	School Content Area Weights Percentage for Mathematics Assignment of 200 CST in grades 9-11
151	VCSTM2_91	Character	10	Valid Score for Mathematics Assignment of 200 CST in Grades 9-11
152	PCSTM2_91	Character	10	Product of Test Weights Multiplied by Valid scores for Mathematics Assignment of 200 CST in Grades 9-11
153	CWS2_91	Character	5	School Content Area Weights Percentage for Science Assignment of 200 CST in grades 9-11
154	VCSTS2_91	Character	10	Valid Score for Science Assignment of 200 CST in Grades 9-11
155	PCSTS2_91	Character	10	Product of Test Weights Multiplied by Valid scores for Science Assignment of 200 CST in Grades 9-11
156	IRG5	Character	1	Testing irregularities greater than zero but less than 5 percent. (Y=Yes)
157	CMA_ADJ	Character	5	The number of valid records excluded for any of the content areas due to the CMA adjustment.

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

Last Reviewed: Friday, November 05, 2021