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(Year = 2023) 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 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 Percent of Students for Novice English Learner Performance Level 65 70 6 NoviceELPerfLvlPcnt
15 Count of Students for Novice English Learner Performance Level 71 79 9 NoviceELPerfLvlCount
16 Percent of Students for Intermediate English Learner Performance Level 80 85 6 IntermediateELPerfLvlPcnt
17 Count of Students for Intermediate English Learner Performance Level 86 94 9 IntermediateELPerfLvlCount
18 Percent of Students for Initial Fluent English Proficient (IFEP) Performance Level 95 100 6 IFEPPerfLvlPcnt
19 Count of Students for Initial Fluent English Proficient (IFEP) Performance Level 101 109 9 IFEPPerfLvlCount
20 Total Number of Students at All Levels—Overall Performance Level 110 118 9 OverallTotal
21 Percent Minimally Developed Performance Level—Oral Language 119 124 6 OralLangMinimallyDevelopedPerfLvlPcnt
22 Count Minimally Developed Performance Level—Oral Language 125 133 9 OralLangMinimallyDevelopedPerfLvlCount
23 Percent Somewhat to Moderately Developed Performance Level—Oral Language 134 139 6 OralLangModeratelyDevelopedPerfLvlPcnt
24 Count Somewhat to Moderately Developed Performance Level—Oral Language 140 148 9 OralLangModeratelyDevelopedPerfLvlCount
25 Percent Well Developed Performance Level—Oral Language 149 154 6 OralLangWellDevelopedPerfLvlPcnt
26 Count Well Developed Performance Level—Oral Language 155 163 9 OralLangWellDevelopedPerfLvlCount
27 Total Number of Students for All Levels—Oral Language 164 172 9 OralLangTotal
28 Percent Minimally Developed Performance Level—Written Language 173 178 6 WritLangMinimallyDevelopedPerfLvlPcnt
29 Count Minimally Developed Performance Level—Written Language 179 187 9 WritLangMinimallyDevelopedPerfLvlCount
30 Percent Somewhat to Moderately Developed Performance Level—Written Language 188 193 6 WritLangModeratelyDevelopedPerfLvlPcnt
31 Count Somewhat to Moderately Developed Performance Level—Written Language 194 202 9 WritLangModeratelyDevelopedPerfLvlCount
32 Percent Well Developed Performance Level—Written Language 203 208 6 WritLangWellDevelopedPerfLvlPcnt
33 Count Well Developed Performance Level—Written Language 209 217 9 WritLangWellDevelopedPerfLvlCount
34 Total Number of Students for All Levels—Written Language 218 226 9 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 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
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
22 Initial ELPAC
California Department of Education 1430 N Street Sacramento, CA 95814