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
22 Total number of students for all levels—Overall 125 133 9 OverallTotal

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
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
23 Summative Alternate ELPAC
California Department of Education 1430 N Street Sacramento, CA 95814