Skip to content
Printer-friendly version

Record Layout for the 2006 Base API Data File

Field names, types and descriptions for the 2006 Base Academic Performance Index (API) 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
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 2006 Academic Performance Index (API)
12
API06B
Character
5

2006 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
2006–07 API Growth Target (A = means the school or subgroup scored at or above the statewide performance target of 800 in 2006, 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
2007 API Target (A = means the school or subgroup scored at or above the statewide performance target of 800 in 2006, 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
2006 African American API (Base)
20
AA_GT
Character
5
2006–07African American Subgroup Growth Target
21
AA_TARG
Character
5
2007 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
2006 American Indians API (Base)
25
AI_GT
Character
5
2006–07 American Indians Subgroup Growth Target
26
AI_TARG
Character
5
2007 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
2006 Asian API (Base)
30
AS_GT
Character
5
2006–07 Asian Subgroup Growth Target
31
AS_TARG
Character
5
2007 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

2006 Filipino API (Base)

35
FI_GT
Character
5
2006–07 Filipino Subgroup Growth Target
36
FI_TARG
Character
5
2007 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
2006 Hispanics API (Base)
40
HI_GT
Character
5
2006–07 Hispanics Subgroup Growth Target
41
HI_TARG
Character
5
2007 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
2006 Pacific Islanders API (Base)
45
PI_GT
Character
5
2006–07 Pacific Islanders Subgroup Growth Target
46
PI_TARG
Character
5
2007 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
2006 Whites API (Base)
50
WH_GT
Character
5
2006–07 Whites Subgroup Growth Target
51
WH_TARG
Character
5
2007 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
2006 Socioeconomically Disadvantaged API (Base)
55
SD_GT
Character
5
2006–07 Socioeconomically Disadvantaged subgroup Growth Target
56
SD_TARG
Character
5
2007 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
2006 English Learner API (Base)
60
EL_GT
Character
5
2006–07 English Learner subgroup Growth Target
61
EL_TARG
Character
5
2007 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
2006 Students with Disabilities API (Base)
65
DI_GT
Character
5
2006–07 Students with Disabilities subgroup Growth Target
66
DI_TARG
Character
5
2007 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 2005 CBEDS and has been continuously enrolled since that date
82
DMOB
Character
5
Percentage of Students counted as part of district enrollment in October 2005 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 Ed Level: Percent Not HS Graduate
88
HSG
Character
5
Parent Ed Level: Percent HS Graduate
89
SOME_COL
Character
5
Parent Ed Level: Percent Some College
90
COL_GRAD
Character
5
Parent Ed Level: Percent College Graduate
91
GRAD_SCH
Character
5
Parent Ed 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
117
PCST_S91
Character
10
Product of Test Weights Multiplied by Valid scores for CST in science Grades 9-11
118
CW_CSTS
Character
5
School Content Area Weights Percentage in CST science
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_LS10
Character
5
School Content Area Weights Percentage in CST Life Science Grade 10 only
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)
Questions: Academic Accountability Team | aau@cde.ca.gov | 916-319-0863 
Download Free Readers