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

2023–24 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(Smarter Balanced English Language Arts/Literacy and Mathematics = 'B') 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 Standard Exceeded SA 6 166 171 Percentage Standard Exceeded
18 Count Standard Exceeded SA 9 172 180 Count Standard Exceeded
19 Percentage Standard Met SA 6 181 186 Percentage Standard Met
20 Count Standard Met SA 9 187 195 Count Standard Met
21 Percentage Standard Met and Above SA 6 196 201 Percentage Standard Met and Above
22 Count Standard Met and Above SA 9 202 210 Count Standard Met and Above
23 Percentage Standard Nearly Met SA 6 211 216 Percentage Standard Nearly Met
24 Count Standard Nearly Met SA 9 217 225 Count Standard Nearly Met
25 Percentage Standard Not Met SA 6 226 231 Percentage Standard Not Met
26 Count Standard Not Met SA 9 232 240 Count Standard Not Met
27 Overall Total SA 9 241 249 Overall Total
28 Area 1 Percentage Above Standard SA 6 250 255 Area 1 Percentage Above Standard
29 Area 1 Count Above Standard SA 9 256 264 Area 1 Count Above Standard
30 Area 1 Percentage Near Standard SA 6 265 270 Area 1 Percentage Near Standard
31 Area 1 Count Near Standard SA 9 271 279 Area 1 Count Near Standard
32 Area 1 Percentage Below Standard SA 6 280 285 Area 1 Percentage Below Standard
33 Area 1 Count Below Standard SA 9 286 294 Area 1 Count Below Standard
34 Area 1 Total SA 9 295 303 Area 1 Total
35 Area 2 Percentage Above Standard SA 6 304 309 Area 2 Percentage Above Standard
36 Area 2 Count Above Standard SA 9 310 318 Area 2 Count Above Standard
37 Area 2 Percentage Near Standard SA 6 319 324 Area 2 Percentage Near Standard
38 Area 2 Count Near Standard SA 9 325 333 Area 2 Count Near Standard
39 Area 2 Percentage Below Standard SA 6 334 339 Area 2 Percentage Below Standard
40 Area 2 Count Below Standard SA 9 340 348 Area 2 Count Below Standard
41 Area 2 Total SA 9 349 357 Area 2 Total
42 Area 3 Percentage Above Standard SA 6 358 363 Area 3 Percentage Above Standard
43 Area 3 Count Above Standard SA 9 364 372 Area 3 Count Above Standard
44 Area 3 Percentage Near Standard SA 6 373 378 Area 3 Percentage Near Standard
45 Area 3 Count Near Standard SA 9 379 387 Area 3 Count Near Standard
46 Area 3 Percentage Below Standard SA 6 388 393 Area 3 Percentage Below Standard
47 Area 3 Count Below Standard SA 9 394 402 Area 3 Count Below Standard
48 Area 3 Total SA 9 403 411 Area 3 Total
49 Area 4 Percentage Above Standard SA 6 412 417 Area 4 Percentage Above Standard
50 Area 4 Count Above Standard SA 9 418 426 Area 4 Count Above Standard
51 Area 4 Percentage Near Standard SA 6 427 432 Area 4 Percentage Near Standard
52 Area 4 Count Near Standard SA 9 433 441 Area 4 Count Near Standard
53 Area 4 Percentage Below Standard SA 6 442 447 Area 4 Percentage Below Standard
54 Area 4 Count Below Standard SA 9 448 456 Area 4 Count Below Standard
55 Area 4 Total SA 9 457 465 Area 4 Total
56 Composite Area 1 Percentage Above Standard SA 6 466 471 Composite Area 1 Percentage Above Standard
57 Composite Area 1 Count Above Standard SA 9 472 480 Composite Area 1 Count Above Standard
58 Composite Area 1 Percentage Near Standard SA 6 481 486 Composite Area 1 Percentage Near Standard
59 Composite Area 1 Count Near Standard SA 9 487 495 Composite Area 1 Count Near Standard
60 Composite Area 1 Percentage Below Standard SA 6 496 501 Composite Area 1 Percentage Below Standard
61 Composite Area 1 Count Below Standard SA 9 502 510 Composite Area 1 Count Below Standard
62 Composite Area 1 Total SA 9 511 519 Composite Area 1 Total
63 Composite Area 2 Percentage Above Standard SA 6 520 525 Composite Area 2 Percentage Above Standard
64 Composite Area 2 Count Above Standard SA 9 526 534 Composite Area 2 Count Above Standard
65 Composite Area 2 Percentage Near Standard SA 6 535 540 Composite Area 2 Percentage Near Standard
66 Composite Area 2 Count Near Standard SA 9 541 549 Composite Area 2 Count Near Standard
67 Composite Area 2 Percentage Below Standard SA 6 550 555 Composite Area 2 Percentage Below Standard
68 Composite Area 2 Count Below Standard SA 9 556 564 Composite Area 2 Count Below Standard
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