Skip to main content
California Department of Education Logo

Record Layout for the 2003 Base API Data File

Field names, types and descriptions for the 2003 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, A=ASAM,)
3
STYPE Character
1
School Type: (E=Elem, M=Middle, H=High, S=Small)
4
SNAME Character
40
School Name
5
DNAME Character
30
District Name
6
CNAME Character
15
County Name
7
FLAG Character
5
Flag Values
8
VALID_NUM Character
7
Number of Students Included in the 2003 API
9
API03 Character
5
Tested 2003 API (Base)
(Note: Should have asterisk if Valid_Num < 100)
10
ST_RANK Character
5
Statewide Rank
(Note: Should have asterisk if Valid_Num < 100)
11
SIM_RANK Character
5
Similar Schools Rank
12
GR_TARG Character
5
2003 API Growth Target
13
API_TARG Character
5
2003 API Target
14
AA_NUM Character
7
Number of African Americans Included in API
15
AA_SIG Character
5
African Americans Significant? (Yes/No)
16
AA_API Character
5
2003 African American API (Base)
17
AA_GT Character
5
2003 African American Subgroup Growth Target
18
AA_TARG Character
5
2003 African American Subgroup API Target
19
AI_NUM Character
7
Number of American Indians Included in API
20
AI_SIG Character
5
American Indians Significant? (Yes/No)
21
AI_API Character
5
2003 American Indians API (Base)
22
AI_GT Character
5
2003 American Indians Subgroup Growth Target
23
AI_TARG Character
5
2003 American Indians Subgroup API Target
24
AS_NUM Character
7
Number of Asians Included in API
25
AS_SIG Character
5
Asians Significant? (Yes/No)
26
AS_API Character
5
2003 Asian API (Base)
27
AS_GT Character
5
2003 Asian Subgroup Growth Target
28
AS_TARG Character
5
2003 Asian Subgroup API Target
29
FI_NUM Character
7
Number of Filipinos Included in API
30
FI_SIG Character
5
Filipino Significant? (Yes/No)
31
FI_API Character
5

2003 Filipino API (Base)

32
FI_GT Character
5
2003 Filipino Subgroup Growth Target
33
FI_TARG Character
5
2003 Filipino Subgroup API Target
34
HI_NUM Character
7
Number of Hispanics Included in API
35
HI_SIG Character
5
Hispanics Significant? (Yes/No)
36
HI_API Character
5
2003 Hispanics API (Base)
37
HI_GT Character
5
2003 Hispanics Subgroup Growth Target
38
HI_TARG Character
5
2003 Hispanics Subgroup API Target
39
PI_NUM Character
7
Number of Pacific Islanders Included in API
40
PI_SIG Character
5
Pacific Islanders Significant? (Yes/No)
41
PI_API Character
5
2003 Pacific Islanders API (Base)
42
PI_GT Character
5
2003 Pacific Islanders Subgroup Growth Target
43
PI_TARG Character
5
2003 Subgroup API Target
44
WH_NUM Character
7
Number of whites included in API
45
WH_SIG Character
5
White Significant? (Yes/No)
46
WH_API Character
5
2003 Whites API (Base)
47
WH_GT Character
5
2003 Whites Subgroup Growth Target
48
WH_TARG Character
5
2003 White API Target
49
SD_NUM Character
7
Number of Socioeconomically Disadvantaged (SD) Students Included in API
50
SD_SIG Character
5
Socioeconomically Disadvantaged Significant? (Yes/No)
51
SD_API Character
5
2003 Socioeconomically Disadvantaged API (Base)
52
SD_GT Character
5
2003 Socioeconomically Disadvantaged subgroup Growth Target
53
SD_TARG Character
5
2003 Socioeconomically Disadvantaged API Target
54
PCT_AA Character
5
Percent African American
55
PCT_AI Character
5
Percent American Indian
56
PCT_AS Character
5
Percent Asian
57
PCT_FI Character
5
Percent Filipino
58
PCT_HI Character
5
Percent Hispanic or Latino
59
PCT_PI Character
5
Percent Pacific Islander
60
PCT_WH Character
5
Percent White
61
MEALS Character
5
Percentage of Students Tested that are Participants in the Free or Reduced Price Lunch Program
62
EL Character
5
Percent English Learners
63
YR_RND Character
5
Year Round School
64
SMOB Character
5
Percentage of Students Who First Attended this School in the Present Year
65
DMOB Character
5
Percentage of Students counted as part of district enrollment in October 2003 CBEDS and has been continuously enrolled since that date
66
ACS_K3 Character
5
Average Class Size (Grades K-3)
67
ACS_46 Character
5
Average Class Size (Grades 4-6)
68
ACS_CORE Character
5
Number of Core Academic Courses
69
PCT_RESP Character
5
Percent of Student Answer Documents with Parent Education Level Information
70
NOT_HSG Character
5
Parent Ed Level: Percent Not High School Graduate
71
HSG Character
5
Parent Ed Level: Percent High School Graduate
72
SOME_COL Character
5
Parent Ed Level: Percent Some College
73
COL_GRAD Character
5
Parent Ed Level: Percent College Graduate
74
GRAD_SCH Character
5
Parent Ed Level: Percent Graduate School
75
AVG_ED Character
5
Average Parent Education Level
76
FULL Character
5
Percent Teachers at This School with Full Credentials
77
EMER Character
5
Percent Teachers at this school with Emergency Credentials
78
ENROLL Character
7
Number of Students Enrolled on the First Day of Testing for Grades 2-11
79
CAPAM Character
7
Students marked as taking the CAPA
80
PARENT_OPT Character
7
Number of Students Excused from Testing by Parental Written Request
81
TESTED Character
7
Number of Students Tested on STAR
82
CAPAT Character
7
Number of Students Tested on CAPA
83
CBMOB Character
5
School Mobility from CBEDS
84
SCI Character
10
School Characteristic Index
Questions: Academic Accountability Team | aau@cde.ca.gov | 916-319-0863 
Last Reviewed: Wednesday, November 4, 2015
Recently Posted in Accountability

  • State Accountability Report Card 2011-12 (PDF) (added 18-Nov-2016)
    California's State Accountability Report Card for 2011-12 as required by the federal Elementary and Secondary Education Act.
  • Updates to SARC Data 2015–16 (added 16-Nov-2016)
    Description of updates to data contained in the 2015–16 School Accountability Report Card (SARC) data files.
  • 2015-16 SARC Data Layout (DOC) (added 16-Nov-2016)
    School Accountability Report Card (SARC) Data Layout used to map field names to descriptive labels for each table.
  • Downloadable SARC Data Files (added 16-Nov-2016)
    Template table names, downloadable data files, and mapping document to populate School Accountability Report Card (SARC) Reports.
  • Data Element Definitions and Sources 2013-14 (DOC) (added 16-Nov-2016)
    Descriptions of data elements and their sources for the 2013-14 School Accountability Report Card (SARC).