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

English Language Arts/Literacy and Mathematics Smarter Balanced Summative Assessments

View Test Results
Search / Compare Results
Understanding Results
Research Files

2025–26 Fixed-Length* Research Files Record Definitions

The Fixed-Length* 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
  • Composite Areas — areas and composite areas descriptions
  • Table A — Student Groups
  • Table B — Grades
  • Table C — Test IDs and Names

PLEASE NOTE:

  • Statewide research files for test administration years 2019–20 and later are available in two formats: fixed-width and caret-delimited. For 2018–19 and prior years, statewide research files are available in fixed-width and comma-delimited formats.
  • Countywide and districtwide research files for test administration years 2023–24 and later are available in two formats: fixed-width and caret-delimited. File formats for previous-year test administrations are either caret-delimited (2020–21 to 2022–23) or comma-delimited (2018–19 and prior years).
  • All research files contain the data for entities composing the level of that file.
  • The research file layouts in Excel format are only available beginning with 2023–24 administration year.

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
NS Numeric with right-filled spaces
4Y 4-digit year

Entities File Layout

Field # Data Element Type Legend Length Start Position End Position Column Header for Caret-Delimited (CSV) Research file
1 County Code ZN 2 1 2 County Code
2 District Code ZN 5 3 7 District Code
3 School Code ZN 7 8 14 School Code
4 Type ID

(04 = State

 05 = County

 06 = District

 07 = School

 09 = Direct Funded Charter School

 10 = Locally Funded Charter School)

 ZN 2 15 16 Type ID
5 Filler AS 4 17 20 Filler
6 Test Year 4Y 4 21 24 Test Year
7 County Name AS 25 25 49 County Name
8 District Name AS 40 50 89 District Name
9 School Name AS 60 90 149 School Name
10 School Zip Code AS 9 150 158 Zip Code

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

Research File Layout

Field # Data Element Type Legend Length Start Position End Position Column Header for Caret-Delimited (CSV) Research file
1 County Code ZN 2 1 2 County Code
2 District Code ZN 5 3 7 District Code
3 District Name AS 40 8 47 District Name
4 School Code ZN 7 48 54 School Code
5 School Name AS 60 55 114 School Name
6 Type ID

(04 = State

 05 = County

 06 = District

 07 = School

 09 = Direct Funded Charter School

 10 = Locally Funded Charter School)

 ZN 2 115 116 Type ID
7 Filler AS 4 117 120 Filler
8 Test Year 4Y 4 121 124 Test Year
9 Test Type(B = SB English Language Arts/Literacy and Mathematics) AS 1 125 125 Test Type
10 Test ID(Detailed listing provided below – Table C) ZN 2 126 127 Test ID
11 Student Group ID(Detailed listing provided below – Table A) ZN 3 128 130 Student Group ID
12 Grade(Detailed listing provided below – Table B) ZN 2 131 132 Grade
13 Total Students Enrolled SA 9 133 141 Total Students Enrolled
14 Total Students Tested SA 9 142 150 Total Students Tested
15 Total Students Tested with Scores SA 9 151 159 Total Students Tested with Scores
16 Mean Scale Score SA 6 160 165 Mean Scale Score
17 Percentage Advanced SA 6 166 171 Percentage Advanced
18 Count Advanced SA 9 172 180 Count Advanced
19 Percentage Proficient SA 6 181 186 Percentage Proficient
20 Count Proficient SA 9 187 195 Count Proficient
21 Percentage Proficient and Advanced SA 6 196 201 Percentage Proficient and Advanced
22 Count Proficient and Advanced SA 9 202 210 Count Proficient and Advanced
23 Percentage Developing SA 6 211 216 Percentage Developing
24 Count Developing SA 9 217 225 Count Developing
25 Percentage Minimal SA 6 226 231 Percentage Minimal
26 Count Minimal SA 9 232 240 Count Minimal
27 Overall Total SA 9 241 249 Overall Total
28 Area 1 Percentage Above Proficient SA 6 250 255 Area 1 Percentage Above Proficient
29 Area 1 Count Above Proficient SA 9 256 264 Area 1 Count Above Proficient
30 Area 1 Percentage At or Near Proficient SA 6 265 270 Area 1 Percentage At or Near Proficient
31 Area 1 Count At or Near Proficient SA 9 271 279 Area 1 Count At or Near Proficient
32 Area 1 Percentage Below Proficient SA 6 280 285 Area 1 Percentage Below Proficient
33 Area 1 Count Below Proficient SA 9 286 294 Area 1 Count Below Proficient
34 Area 1 Total SA 9 295 303 Area 1 Total
35 Area 2 Percentage Above Proficient SA 6 304 309 Area 2 Percentage Above Proficient
36 Area 2 Count Above Proficient SA 9 310 318 Area 2 Count Above Proficient
37 Area 2 Percentage At or Near Proficient SA 6 319 324 Area 2 Percentage At or Near Proficient
38 Area 2 Count At or Near Proficient SA 9 325 333 Area 2 Count At or Near Proficient
39 Area 2 Percentage Below Proficient SA 6 334 339 Area 2 Percentage Below Proficient
40 Area 2 Count Below Proficient SA 9 340 348 Area 2 Count Below Proficient
41 Area 2 Total SA 9 349 357 Area 2 Total
42 Area 3 Percentage Above Proficient SA 6 358 363 Area 3 Percentage Above Proficient
43 Area 3 Count Above Proficient SA 9 364 372 Area 3 Count Above Proficient
44 Area 3 Percentage At or Near Proficient SA 6 373 378 Area 3 Percentage At or Near Proficient
45 Area 3 Count At or Near Proficient SA 9 379 387 Area 3 Count At or Near Proficient
46 Area 3 Percentage Below Proficient SA 6 388 393 Area 3 Percentage Below Proficient
47 Area 3 Count Below Proficient SA 9 394 402 Area 3 Count Below Proficient
48 Area 3 Total SA 9 403 411 Area 3 Total
49 Area 4 Percentage Above Proficient SA 6 412 417 Area 4 Percentage Above Proficient
50 Area 4 Count Above Proficient SA 9 418 426 Area 4 Count Above Proficient
51 Area 4 Percentage At or Near Proficient SA 6 427 432 Area 4 Percentage At or Near Proficient
52 Area 4 Count At or Near Proficient SA 9 433 441 Area 4 Count At or Near Proficient
53 Area 4 Percentage Below Proficient SA 6 442 447 Area 4 Percentage Below Proficient
54 Area 4 Count Below Proficient SA 9 448 456 Area 4 Count Below Proficient
55 Area 4 Total SA 9 457 465 Area 4 Total
56 Composite Area 1 Percentage Above Proficient SA 6 466 471 Composite Area 1 Percentage Above Proficient
57 Composite Area 1 Count Above Proficient SA 9 472 480 Composite Area 1 Count Above Proficient
58 Composite Area 1 Percentage At or Near Proficient SA 6 481 486 Composite Area 1 Percentage At or Near Proficient
59 Composite Area 1 Count At or Near Proficient SA 9 487 495 Composite Area 1 Count At or Near Proficient
60 Composite Area 1 Percentage Below Proficient SA 6 496 501 Composite Area 1 Percentage Below Proficient
61 Composite Area 1 Count Below Proficient SA 9 502 510 Composite Area 1 Count Below Proficient
62 Composite Area 1 Total SA 9 511 519 Composite Area 1 Total
63 Composite Area 2 Percentage Above Proficient SA 6 520 525 Composite Area 2 Percentage Above Proficient
64 Composite Area 2 Count Above Proficient SA 9 526 534 Composite Area 2 Count Above Proficient
65 Composite Area 2 Percentage At or Near Proficient SA 6 535 540 Composite Area 2 Percentage At or Near Proficient
66 Composite Area 2 Count At or Near Proficient SA 9 541 549 Composite Area 2 Count At or Near Proficient
67 Composite Area 2 Percentage Below Proficient SA 6 550 555 Composite Area 2 Percentage Below Proficient
68 Composite Area 2 Count Below Proficient SA 9 556 564 Composite Area 2 Count Below Proficient
69 Composite Area 2 Total SA 9 565 573 Composite Area 2 Total

Composite Areas

Area/Composite Area ELA Mathematics
Composite Area 1 Reading and Listening Concepts and Procedures
Composite Area 2 Writing and Research Mathematical Practices
Area 1 Reading Concepts and Procedures
Area 2 Writing Problem Solving
Area 3 Speaking/Listening Communicating Reasoning
Area 4 Research N/A

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 Socioeconomically disadvantaged 031
Economic Status Not socioeconomically disadvantaged 111
English-Language Fluency IFEP, RFEP, and EO (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, excluding RFEP) 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 LTEL (Long-Term English learner) 250
English-Language Fluency AR–LTEL (At-Risk of becoming LTEL) 251
English-Language Fluency Never–EL 252
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 Socioeconomically Disadvantaged American Indian or Alaska Native 201
Ethnicity for Socioeconomically Disadvantaged Asian 202
Ethnicity for Socioeconomically Disadvantaged Black or African American 200
Ethnicity for Socioeconomically Disadvantaged Filipino 203
Ethnicity for Socioeconomically Disadvantaged Hispanic or Latino 204
Ethnicity for Socioeconomically Disadvantaged Native Hawaiian or Pacific Islander 205
Ethnicity for Socioeconomically Disadvantaged White 206
Ethnicity for Socioeconomically Disadvantaged Two or more races 207
Ethnicity for Not Socioeconomically Disadvantaged American Indian or Alaska Native 221
Ethnicity for Not Socioeconomically Disadvantaged Asian 222
Ethnicity for Not Socioeconomically Disadvantaged Black or African American 220
Ethnicity for Not Socioeconomically Disadvantaged Filipino 223
Ethnicity for Not Socioeconomically Disadvantaged Hispanic or Latino 224
Ethnicity for Not Socioeconomically Disadvantaged Native Hawaiian or Pacific Islander 225
Ethnicity for Not Socioeconomically Disadvantaged White 226
Ethnicity for Not Socioeconomically 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
03 Grade 3
04 Grade 4
05 Grade 5
06 Grade 6
07 Grade 7
08 Grade 8
11 Grade 11
13 All Grades (Includes Grades 3–8 and 11)

Table C — Test IDs and Names

Test ID Test Name
1 SB - English Language Arts/Literacy
2 SB - Mathematics

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

California Department of Education 1430 N Street Sacramento, CA 95814