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

2022–23 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
  • 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

Field # Field Name Start Position End Position Length Header Title for Caret Delimited (TXT) File
1 County Code 1 2 2 CountyCode
2 District Code 3 7 5 DistrictCode
3 School Code 8 14 7 SchoolCode
4 Record Type

(01 = School

 02 = District

 03 = County

 04 = State

 09 = Direct Funded Charter School

 10 = Locally Funded Charter School)

15 16 2 RecordType
5 Charter School Number (populated for all charters) 17 20 4 CharterNumber
6 Test Year 21 24 4 TestYear
7 County Name 25 49 25 CountyName
8 District Name 50 89 40 DistrictName
9 School Name 90 149 60 SchoolName
10 School Zip Code 150 158 9 ZipCode

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

Research File Layout

Field # Field Name Start Position End Position Length Header Title for Caret Delimited (TXT) File
1 County Code 1 2 2 CountyCode
2 District Code 3 7 5 DistrictCode
3 School Code 8 14 7 SchoolCode
4 Record Type

(01 = School

 02 = District

 03 = County

 04 = State

 09 = Direct Funded Charter School

 10 = Locally Funded Charter School)

15 16 2 RecordType
5 Charter School Number(Populated for all charter schools) 17 20 4 CharterNumber
6 Test Year(Year = 2023) 21 24 4 TestYear
7 Student Group ID(Detailed listing provided below – Table A) 25 27 3 StudentGroupID
8 Assessment Type(Detailed listing provided below – Table C) 28 29 2 AssessmentType
9 Total Number Enrolled 30 38 9 TotalEnrolled
10 Total Number Tested 39 47 9 TotalTested
11 Total Number Tested with Scores 48 56 9 TotalTestedWithScores
12 Grade(Detailed listing provided Below – Table B) 57 58 2 Grade
13 Overall Mean Scale Score 59 64 6 OverallMeanSclScr
14 Percentage Overall Performance Level 1 65 70 6 OverallPerfLvl1Pcnt
15 Count Overall Performance Level 1 71 79 9 OverallPerfLvl1Count
16 Percentage Overall Performance Level 2 80 85 6 OverallPerfLvl2Pcnt
17 Count Overall Performance Level 2 86 94 9 OverallPerfLvl2Count
18 Percentage Overall Performance Level 3 95 100 6 OverallPerfLvl3Pcnt
19 Count Overall Performance Level 3 101 109 9 OverallPerfLvl3Count
20 Percentage Overall Performance Level 4 110 115 6 OverallPerfLvl4Pcnt
21 Count Overall Performance Level 4 116 124 9 OverallPerfLvl4Count
22 Total number of students for all levels—Overall 125 133 9 OverallTotal
23 Oral Language Mean Scale Score 134 139 6 OralLangMeanSclScr
24 Percentage Oral Language Performance Level 1 140 145 6 OralLangPerfLvl1Pcnt
25 Count Oral Language Performance Level 1 146 154 9 OralLangPerfLvl1Count
26 Percentage Oral Language Performance Level 2 155 160 6 OralLangPerfLvl2Pcnt
27 Count Oral Language Performance Level 2 161 169 9 OralLangPerfLvl2Count
28 Percentage Oral Language Performance Level 3 170 175 6 OralLangPerfLvl3Pcnt
29 Count Oral Language Performance Level 3 176 184 9 OralLangPerfLvl3Count
30 Percentage Oral Language Performance Level 4 185 190 6 OralLangPerfLvl4Pcnt
31 Count Oral Language Performance Level 4 191 199 9 OralLangPerfLvl4Count
32 Total number of students for all levels—Oral Language 200 208 9 OralLangTotal
33 Written Language Mean Scale Score 209 214 6 WritLangMeanSclScr
34 Percentage Written Language Performance Level 1 215 220 6 WritLangPerfLvl1Pcnt
35 Count Written Language Performance Level 1 221 229 9 WritLangPerfLvl1Count
36 Percentage Written Language Performance Level 2 230 235 6 WritLangPerfLvl2Pcnt
37 Count Written Language Performance Level 2 236 244 9 WritLangPerfLvl2Count
38 Percentage Written Language Performance Level 3 245 250 6 WritLangPerfLvl3Pcnt
39 Count Written Language Performance Level 3 251 259 9 WritLangPerfLvl3Count
40 Percentage Written Language Performance Level 4 260 265 6 WritLangPerfLvl4Pcnt
41 Count Written Language Performance Level 4 266 274 9 WritLangPerfLvl4Count
42 Total number of students for all levels—Written Language 275 283 9 WritLangTotal
43 Percentage Beginning—Listening Domain 284 289 6 ListeningDomainBeginPcnt
44 Count Beginning—Listening Domain 290 298 9 ListeningDomainBeginCount
45 Percentage Somewhat/Moderately—Listening Domain 299 304 6 ListeningDomainModeratePcnt
46 Count Somewhat/Moderately—Listening Domain 305 313 9 ListeningDomainModerateCount
47 Percentage Well Developed—Listening Domain 314 319 6 ListeningDomainDevelopedPcnt
48 Count Well Developed—Listening Domain 320 328 9 ListeningDomainDevelopedCount
49 Total number of students for all levels—Listening Domain 329 337 9 ListeningDomainTotal
50 Percentage Beginning—Speaking Domain 338 343 6 SpeakingDomainBeginPcnt
51 Count Beginning—Speaking Domain 344 352 9 SpeakingDomainBeginCount
52 Percentage Somewhat/Moderately—Speaking Domain 353 358 6 SpeakingDomainModeratePcnt
53 Count Somewhat/Moderately—Speaking Domain 359 367 9 SpeakingDomainModerateCount
54 Percentage Well Developed—Speaking Domain 368 373 6 SpeakingDomainDevelopedPcnt
55 Count Well Developed—Speaking Domain 374 382 9 SpeakingDomainDevelopedCount
56 Total number of students for all levels—Speaking Domain 383 391 9 SpeakingDomainTotal
57 Percentage Beginning—Reading Domain 392 397 6 ReadingDomainBeginPcnt
58 Count Beginning—Reading Domain 398 406 9 ReadingDomainBeginCount
59 Percentage Somewhat/Moderately—Reading Domain 407 412 6 ReadingDomainModeratePcnt
60 Count Somewhat/Moderately—Reading Domain 413 421 9 ReadingDomainModerateCount
61 Percentage Well Developed—Reading Domain 422 427 6 ReadingDomainDevelopedPcnt
62 Count Well Developed—Reading Domain 428 436 9 ReadingDomainDevelopedCount
63 Total number of students for all levels—Reading Domain 437 445 9 ReadingDomainTotal
64 Percentage Beginning—Writing Domain 446 451 6 WritingDomainBeginPcnt
65 Count Beginning—Writing Domain 452 460 9 WritingDomainBeginCount
66 Percentage Somewhat/Moderately—Writing Domain 461 466 6 WritingDomainModeratePcnt
67 Count Somewhat/Moderately—Writing Domain 467 475 9 WritingDomainModerateCount
68 Percentage Well Developed—Writing Domain 476 481 6 WritingDomainDevelopedPcnt
69 Count Well Developed—Writing Domain 482 490 9 WritingDomainDevelopedCount
70 Total number of students for all levels—Writing Domain 491 499 9 WritingDomainTotal

Table A - Student Groups

Student Group Student Group Name Student Group ID
All Students All Students 001
Gender Female 004
Gender Male 003
Primary Language Spanish 228
Primary Language Vietnamese 229
Primary Language Mandarin (Putonghua) 230
Primary Language Arabic 231
Primary Language Filipino (Pilipino or Tagalog) 232
Primary Language Cantonese 233
Primary Language Korean 234
Primary Language Hmong 235
Primary Language Punjabi 236
Primary Language Russian 237
Primary Language All remaining languages 238
Migrant Migrant education 028
Migrant Not migrant education 029
Disability Status No reported disabilities 099
Disability Status Reported disabilities 128
Economic Status Socioeconomically disadvantaged 031
Economic Status Not socioeconomically disadvantaged 111
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 Other Pacific Islander 079
Race and Ethnicity White 080
Race and Ethnicity Two or more races 144
English Learners ELs enrolled less than 12 months 120
English Learners ELs enrolled 12 months or more 142
English Learners All English learners – (All ELs) 160
English Learners LTEL (Long-Term English learner) 250
English Learners AR–LTEL (At-Risk of becoming LTEL) 251
English Learners Time in Program EL – less than 1 year in program 248
English Learners Time in Program EL – 1 year in program 242
English Learners Time in Program EL – 2 years in program 243
English Learners Time in Program EL – 3 years in program 244
English Learners Time in Program EL – 4 years in program 245
English Learners Time in Program EL – 5 years in program 246
English Learners Time in Program EL – 6+ years in program 247
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
KN Kindergarten
01 Grade 1
02 Grade 2
03 Grade 3
04 Grade 4
05 Grade 5
06 Grade 6
07 Grade 7
08 Grade 8
09 Grade 9
10 Grade 10
11 Grade 11
12 Grade 12
13 All Grades

Table C - Test IDs and Names

Test ID Test Name
21 Summative ELPAC
California Department of Education 1430 N Street Sacramento, CA 95814