Fixed-Length* ASCII Files Record Definitions

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

  • Type Legend–data format of individual data fields
  • Entities File–layout of entity file data fields
  • Test Data File–layout of test data file data fields
  • Table A–demographic student group listing
  • Table B–grade listing
  • Table C–test name listing
  • Test ID/Name Lookup Table–identifies the subject test name and ID for the two Smarter Balanced Assessments, ELA and mathematics.
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

Data Type Length Start Position End Position
County Code ZN 2 1 2
District Code ZN 5 3 7
School Code ZN 7 8 14
Filler ZN 4 15 18
Test Year ZN 4 19 22
Type ID
(‘04’ = State
‘05’ = County
‘06’ = District
‘07’ = School
‘09’ = Direct Funded Charter School
‘10’ = Locally Funded Charter School) 
ZN 2 23 24
County Name AS 50 25 74
District Name AS 50 75 124
School Name AS 50 125 174
Zip Code ZN 5 175 179

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


Test Data File

Data/Column Heading Type Length Start Position End Position
County Code ZA 2 1 2
District Code ZA 5 3 7
School Code ZA 7 8 14
Filler ZA 4 15 18
Test Year 4Y 4 19 22
Subgroup ID
(Detailed listing provided Below – Table A)
ZN 3 23 25
Test Type
(Smarter Balanced English Language Arts/Literacy and Mathematics = 'B')
A 1 26 26
Total Tested at Entity Level SN 7 27 33
Total Tested with Scores
(this field is same as 'Total Tested with Scores at Entity Level')
SN 7 34 40
Grade
(Detailed listing provided below – Table B)
ZN 2 41 42
Test ID
(Detailed listing provided below – Table C)
ZN 2 43 44
CAASPP Reported Enrollment SN 7 45 51
Students Tested SN 7 52 58
Mean Scale Score SN 6(9999.9) 59 64
Percentage Standard Exceeded SN 6 65 70
Percentage Standard Met SN 6 71 76
Percentage Standard Met and Above SN 6 77 82
Percentage Standard Nearly Met SN 6 83 88
Percentage Standard Not Met SN 6 89 94
Students with Scores in Grade SN 7 95 101
Area 1 Percentage Above Standard SN 6 102 107
Area 1 Percentage Near Standard SN 6 108 113
Area 1 Percentage Below Standard SN 6 114 119
Area 2 Percentage Above Standard SN 6 120 125
Area 2 Percentage Near Standard SN 6 126 131
Area 2 Percentage Below Standard SN 6 132 137
Area 3 Percentage Above Standard SN 6 138 143
Area 3 Percentage Near Standard SN 6 144 149
Area 3 Percentage Below Standard SN 6 150 155
Area 4 Percentage Above Standard SN 6 156 161
Area 4 Percentage Near Standard SN 6 162 167
Area 4 Percentage Below Standard SN 6 168 173

Table A

Student Groups Student Group ID
All Students 1

Gender

Student Groups Student Group ID
Male 3
Female 4

English-Language Fluency

Student Groups Student Group ID
Fluent English proficient and English only 6
Initial fluent English proficient (IFEP) 7
Reclassified fluent English proficient (RFEP)  8
English only 180
English learner 160
English learners (ELs) enrolled in school in the U.S. fewer than 12 months 120
English learners enrolled in school in the U.S. 12 months or more 142
Ever-ELs 170
To be determined (TBD) 190

Economic Status

Student Groups Student Group ID
Economically disadvantaged 31
Not economically disadvantaged 111

Ethnicity for Economically Disadvantaged

Student Groups Student Group ID
Black or African American 200
American Indian or Alaska Native 201
Asian 202
Filipino 203
Hispanic or Latino 204
Native Hawaiian or Pacific Islander 205
White 206
Two or more races 207

Ethnicity for Not Economically Disadvantaged

Student Groups Student Group ID
Black or African American 220
American Indian or Alaska Native 221
Asian 222
Filipino 223
Hispanic or Latino 224
Native Hawaiian or Pacific Islander 225
White 226
Two or more races 227

Disability Status

Student Groups Student Group ID
Students with disability 128
Students with no reported disability 99

Ethnicity

Student Groups Student Group ID
Black or African American 74
American Indian or Alaska Native 75
Filipino 77
Hispanic or Latino 78
White 80
Asian 76
Native Hawaiian or Pacific Islander 79
Two or more races 144

Parent Education

Student Groups Student Group ID
Not a high school graduate 90
High school graduate 91
Some college (includes AA degree) 92
College graduate 93
Graduate school/Post graduate 94
Declined to state 121

Migrant

Student Groups Student Group ID
Migrant education 28

Table B - Grade

Grade Description
03 3rd Grade
04 4th Grade
05 5th Grade
06 6th Grade
07 7th Grade
08 8th Grade
11 11th Grade
13 All Grades

Table C - Test

Test ID Test Name
1 SB - English Language Arts/Literacy
2 SB - Mathematics

* - Some filler fields are omitted from the .CSV versions of these files.