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

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
  • 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
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 CountyCode
2 District Code ZN 5 3 7 DistrictCode
3 School Code ZN 7 8 14 SchoolCode
4 Record Type

(01 = School

 02 = District

 03 = County

 04 = State

 09 = Direct Funded Charter School

 10 = Locally Funded Charter School)

ZN 2 15 16 TypeID
5 Filler AS 4 17 20 Filler
6 Test Year(Year = 2024) 4Y 4 21 24 TestYear
7 County Name AS 25 25 49 CountyName
8 District Name AS 40 50 89 DistrictName
9 School Name AS 60 90 149 SchoolName
10 School Zip Code AS 9 150 158 ZipCode

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 CountyCode
2 District Code ZN 5 3 7 DistrictCode
3 District Name AS 40 8 47 DistrictName
4 School Code ZN 7 48 54 SchoolCode
5 School Name AS 60 55 114 SchoolName
6 Record Type

(01 = School

 02 = District

 03 = County

 04 = State

 09 = Direct Funded Charter School

 10 = Locally Funded Charter School)

ZN 2 115 116 TypeID
7 Filler AS 4 117 120 Filler
8 Test Year(Year = 2024) 4Y 4 121 124 TestYear
9 Assessment Type (Detailed listing provided below – Table C) ZN 2 125 126 TestID
10 Student Group ID (Detailed listing provided below – Table A) ZN 3 127 129 StudentGroupID
11 Grade (Detailed listing provided below – Table B) ZN 2 130 131 Grade
12 Total Number Enrolled SA 9 132 140 TotalStudentsEnrolled
13 Total Number Tested SA 9 141 149 TotalStudentsTested
14 Total Number Tested with Scores SA 9 150 158 TotalStudentsTestedWithScores
15 Overall Mean Scale Score SA 6 159 164 OverallMeanSclScr
16 Percent of Students for Novice English Learner Performance Level SA 6 165 170 NoviceELPerfLvlPcnt
17 Count of Students for Novice English Learner Performance Level SA 9 171 179 NoviceELPerfLvlCount
18 Percent of Students for Intermediate English Learner Performance Level SA 6 180 185 IntermediateELPerfLvlPcnt
19 Count of Students for Intermediate English Learner Performance Level SA 9 186 194 IntermediateELPerfLvlCount
20 Percent of Students for Initial Fluent English Proficient (IFEP) Performance Level SA 6 195 200 IFEPPerfLvlPcnt
21 Count of Students for Initial Fluent English Proficient (IFEP) Performance Level SA 9 201 209 IFEPPerfLvlCount
22 Total Number of Students at All Levels—Overall Performance Level SA 9 210 218 OverallTotal
23 Percent Minimally Developed Performance Level—Oral Language SA 6 219 224 OralLangMinimallyDevelopedPerfLvlPcnt
24 Count Minimally Developed Performance Level—Oral Language SA 9 225 233 OralLangMinimallyDevelopedPerfLvlCount
25 Percent Somewhat to Moderately Developed Performance Level—Oral Language SA 6 234 239 OralLangModeratelyDevelopedPerfLvlPcnt
26 Count Somewhat to Moderately Developed Performance Level—Oral Language SA 9 240 248 OralLangModeratelyDevelopedPerfLvlCount
27 Percent Well Developed Performance Level—Oral Language SA 6 249 254 OralLangWellDevelopedPerfLvlPcnt
28 Count Well Developed Performance Level—Oral Language SA 9 255 263 OralLangWellDevelopedPerfLvlCount
29 Total Number of Students for All Levels—Oral Language SA 9 264 272 OralLangTotal
30 Percent Minimally Developed Performance Level—Written Language SA 6 273 278 WritLangMinimallyDevelopedPerfLvlPcnt
31 Count Minimally Developed Performance Level—Written Language SA 9 279 287 WritLangMinimallyDevelopedPerfLvlCount
32 Percent Somewhat to Moderately Developed Performance Level—Written Language SA 6 288 293 WritLangModeratelyDevelopedPerfLvlPcnt
33 Count Somewhat to Moderately Developed Performance Level—Written Language SA 9 294 302 WritLangModeratelyDevelopedPerfLvlCount
34 Percent Well Developed Performance Level—Written Language SA 6 303 308 WritLangWellDevelopedPerfLvlPcnt
35 Count Well Developed Performance Level—Written Language SA 9 309 317 WritLangWellDevelopedPerfLvlCount
36 Total Number of Students for All Levels—Written Language SA 9 318 326 WritLangTotal

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 Reported disabilities 128
Disability Status No reported disabilities 099
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
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 (Includes Grades KN–12)

Table C - Test IDs and Names

Test ID Test Name
22 Initial ELPAC
California Department of Education 1430 N Street Sacramento, CA 95814