home sort-asc sort-desc sort square-o search plus minus caret-up quotes-left quotes-right angle-left angle-right
skip to main content

2020–21 Fixed-Length* ASCII Research Files Record Definitions

The Fixed-Length* ASCII Research Files Record Definitions page provides the following information:

  • Type Legend — data format of individual data fields
  • Entities File Layout — layout of entity file data fields
  • Research File Layout — layout of research file data fields
  • Table A — Student Groups
  • Table B — Grades
  • Table C — Test IDs and Names
Report Options

Type Legend

Type Description
T Alphabetic text (letters only)
A Alphanumeric text (letters and numbers allowed)
N Number (numbers only)
SA Alphanumeric with left-filled spaces
AS Alphanumeric with right-filled spaces
ZA Alphanumeric with left-filled zeroes
AZ Alphanumeric with right-filled zeroes
ZN Numeric with left-filled zeroes
NZ Numeric with right-filled zeroes
SN Numeric with left-filled spaces
4Y 4-digit year

Entities File Layout

Data Type Length Start Position End Position
County Code ZN 2 1 2
District Code ZN 5 3 7
School Code ZN 7 8 14
Filler ZN 4 15 18
Test Year ZN 4 19 22
Type ID

(04 = State

 05 = County

 06 = District

 07 = School

 09 = Direct Funded Charter School

 10 = Locally Funded Charter School)

ZN 2 23 24
County Name AS 50 25 74
District Name AS 50 75 124
School Name AS 50 125 174
Zip Code ZN 5 175 179

The file created is comprised of state, all tested counties, districts, and schools in California

Research File Layout

Data/Column Heading Type Length Start Position End Position
County Code ZA 2 1 2
District Code ZA 5 3 7
School Code ZA 7 8 14
Filler ZA 4 15 18
Test Year 4Y 4 19 22
Student Group ID

(Detailed listing provided below – Table A)

ZN 3 23 25
Test Type

(California Science Test = X)

A 1 26 26
Total Tested at Reporting Level SN 7 27 33
Total Tested with Scores at Reporting Level SN 7 34 40
Grade

(Detailed listing provided below – Table B)

ZN 2 41 42
Test ID

(California Science Test = 17)

ZN 2 43 44
Students Enrolled SN 7 45 51
Students Tested SN 7 52 58
Mean Scale Score SN 6 59 64
Percentage Standard Exceeded SN 6 65 70
Percentage Standard Met SN 6 71 76
Percentage Standard Met and Above SN 6 77 82
Percentage Standard Nearly Met SN 6 83 88
Percentage Standard Not Met SN 6 89 94
Students with Scores SN 7 95 101
Life Sciences Domain Percent Below Standard SN 6 102 107
Life Sciences Domain Percent Near Standard SN 6 108 113
Life Sciences Domain Percent Above Standard SN 6 114 119
Physical Sciences Domain Percent Below Standard SN 6 120 125
Physical Sciences Domain Percent Near Standard SN 6 126 131
Physical Sciences Domain Percent Above Standard SN 6 132 137
Earth and Space Sciences Domain Percent Below Standard SN 6 138 143
Earth and Space Sciences Domain Percent Near Standard SN 6 144 149
Earth and Space Sciences Domain Percent Above Standard SN 6 150 155
Type ID

(04 = State

 05 = County

 06 = District

 07 = School

 09 = Direct Funded Charter School

 10 = Locally Funded Charter School)

ZN 2 156 157

Table A — Student Groups

Student Group Student Group Name Student Group ID
All Students All Students 001
Disability Status Reported disabilities 128
Disability Status No reported disabilities 099
Economic Status Economically disadvantaged 031
Economic Status Not economically disadvantaged 111
English-Language Fluency IFEP and EO (Initial fluent English proficient and English only) 006
English-Language Fluency IFEP (Initial fluent English proficient) 007
English-Language Fluency RFEP (Reclassified fluent English proficient) 008
English-Language Fluency ELs enrolled less than 12 months 120
English-Language Fluency ELs enrolled 12 months or more 142
English-Language Fluency EL (English learner) 160
English-Language Fluency ADEL (Adult English learner) 243
English-Language Fluency EO (English only) 180
English-Language Fluency Ever-EL 170
English-Language Fluency TBD (To be determined) 190
Race and Ethnicity American Indian or Alaska Native 075
Race and Ethnicity Asian 076
Race and Ethnicity Black or African American 074
Race and Ethnicity Filipino 077
Race and Ethnicity Hispanic or Latino 078
Race and Ethnicity Native Hawaiian or Pacific Islander 079
Race and Ethnicity White 080
Race and Ethnicity Two or more races 144
Ethnicity for Economically Disadvantaged American Indian or Alaska Native 201
Ethnicity for Economically Disadvantaged Asian 202
Ethnicity for Economically Disadvantaged Black or African American 200
Ethnicity for Economically Disadvantaged Filipino 203
Ethnicity for Economically Disadvantaged Hispanic or Latino 204
Ethnicity for Economically Disadvantaged Native Hawaiian or Pacific Islander 205
Ethnicity for Economically Disadvantaged White 206
Ethnicity for Economically Disadvantaged Two or more races 207
Ethnicity for Not Economically Disadvantaged American Indian or Alaska Native 221
Ethnicity for Not Economically Disadvantaged Asian 222
Ethnicity for Not Economically Disadvantaged Black or African American 220
Ethnicity for Not Economically Disadvantaged Filipino 223
Ethnicity for Not Economically Disadvantaged Hispanic or Latino 224
Ethnicity for Not Economically Disadvantaged Native Hawaiian or Pacific Islander 225
Ethnicity for Not Economically Disadvantaged White 226
Ethnicity for Not Economically Disadvantaged Two or more races 227
Gender Female 004
Gender Male 003
Migrant Migrant education 028
Migrant Not migrant education 029
Parent Education Not a high school graduate 090
Parent Education High school graduate 091
Parent Education Some college (includes AA degree) 092
Parent Education College graduate 093
Parent Education Graduate school/Postgraduate 094
Parent Education Declined to state 121
Military Status Armed forces family member 050
Military Status Not armed forces family member 051
Homeless Status Homeless 052
Homeless Status Not homeless 053
Foster Status Foster youth 240
Foster Status Not foster youth 241

Table B — Grades

Grade Description
05 Grade 5
08 Grade 8
10 Grade 10
11 Grade 11
12 Grade 12
14 All High School

(Includes Grades 10, 11 and 12)

13 All Grades

Table C — Test IDs and Names

Test ID Test Name
17 CAST - Science

* - Some filler fields are omitted from the .CSV versions of these files.

California Department of Education 1430 N Street Sacramento, CA 95814