2019–20 Fixed-Length Research Files Record Definitions

The Fixed-Length Research Files Record Definitions page provides the following information:

  • Entities File—layout of entity file data fields
  • Research File—layout of research file data fields
  • Table A—demographic student group listing
  • Table B—grade listing
  • Table C—test name listing
Report Options

Entities File Layout

Field # Field Name Start Position End Position Length Header Title for Comma-Separated-Value (CSV) 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 = Independent Charter      10 = Dependent Charter) 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 Comma-Separated-Values (CSV) 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 = Independent Charter      10 = Dependent Charter) 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 Demographic ID (Detailed listing provided Below – Table A) 25 27 3 StudentGroupId
8 Assessment Type (Detailed listing provided below – Table C) 28 28 1 AssessmentType
9 Total Number Enrolled 29 37 9 TotalEnrolled
10 Total Number Tested 38 46 9 TotalTested
11 Total Number Tested with Scores 47 55 9 TotalTestedWithScores
12 Grade (Detailed listing provided Below – Table B) 56 57 2 Grade
13 Overall Mean Scale Score 58 63 6 OverallMeanSclScr
14 Percent of Students for Novice English Learner Performance Level 64 69 6 NoviceELPerfLvlPcnt
15 Count of Students for Novice English Learner Performance Level 70 78 9 NoviceELPerfLvlCount
16 Percent of Students for Intermediate English Learner Performance Level 79 84 6 IntermediateELPerfLvlPcnt
17 Count of Students for Intermediate English Learner Performance Level 85 93 9 IntermediateELPerfLvlCount
18 Percent of Students for Initial Fluent English Proficient (IFEP) Performance Level 94 99 6 IFEPPerfLvlPcnt
19 Count of Students for Initial Fluent English Proficient (IFEP) Performance Level 100 108 9 IFEPPerfLvlCount
19 Count of Students for Initial Fluent English Proficient (IFEP) Performance Level 100 108 9 IFEPPerfLvlCount
20 Total Number of Students at All Levels—Overall Performance Level 109 117 9 OverallTotal
21 Percent Minimally Developed Performance Level—Oral Language 118 123 6 OralLangMinimallyDevelopedPerfLvlPcnt
22 Count Minimally Developed Performance Level—Oral Language 124 132 9 OralLangMinimallyDevelopedPerfLvlCount
23 Percent Somewhat to Moderately Developed Performance Level—Oral Language 133 138 6 OralLangModeratelyDevelopedPerfLvlPcnt
24 Count Somewhat to Moderately Developed Performance Level—Oral Language 139 147 9 OralLangModeratelyDevelopedPerfLvlCount
25 Percent Well Developed Performance Level—Oral Language 148 153 6 OralLangWellDevelopedPerfLvlPcnt
26 Count Well Developed Performance Level—Oral Language 154 162 9 OralLangWellDevelopedPerfLvlCount
27 Total Number of Students for All Levels—Oral Language 163 171 9 OralLangTotal
28 Percent Minimally Developed Performance Level—Written Language 172 177 6 WritLangMinimallyDevelopedPerfLvlPcnt
29 Count Minimally Developed Performance Level—Written Language 178 186 9 WritLangMinimallyDevelopedPerfLvlCount
30 Percent Somewhat to Moderately Developed Performance Level—Written Language 187 192 6 WritLangModeratelyDevelopedPerfLvlPcnt
31 Count Somewhat to Moderately Developed Performance Level—Written Language 193 201 9 WritLangModeratelyDevelopedPerfLvlCount
32 Percent Well Developed Performance Level—Written Language 202 207 6 WritLangWellDevelopedPerfLvlPcnt
33 Count Well Developed Performance Level—Written Language 208 216 9 WritLangWellDevelopedPerfLvlCount
34 Total Number of Students for All Levels—Written Language 217 225 9 WritLangTotal

Table A - Student Groups

Student Group Demographic ID
All Students 001
Female 004
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 Education 028
Students not Receiving Special Education Services 099
Students Receiving Special Education Services 128
Students Receiving Special Education Services Tested with Alternate Assessment for any or all Domains 239
Economically Disadvantaged 031
Not Economically Disadvantaged 111
Ethnicity—Black or African American 074
Ethnicity—American Indian or Alaska Native 075
Ethnicity—Asian 076
Ethnicity—Filipino 077
Ethnicity—Hispanic or Latino 078
Ethnicity—White 080
Ethnicity—Native Hawaiian or Other Pacific Islander 079
Ethnicity—Two or More Races 144

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 - Tests

Test ID Test Name
1 Initial ELPAC
2 Summative ELPAC