CEHI logo
Children’s Environmental Health Initiative
University of Illinois Chicago
2705 University Hall
Chicago, IL 60607
https://cehi.uic.edu/
Key Information

mastid

Master ID - Unique ID per Student

integer

Raw Value

Position in File: 1

Year

School Year

integer

Calculated Value

Position in File: 2

School year. The year recorded is always the one that corresponds to the end of the year. For example, '2015' (or '15') is used when referring to the 2014-2015 academic year.

bdate

Birth Date with Day set to 15th

date (MM/DD/YYYY)

Raw Value

Position in File: 3


Demographics
Demography

RaceGroup

Race/Ethnicity Group

integer

Calculated Value

Position in File: 5

Value Description
1 Non-Hispanic White
2 Non-Hispanic Black
3 Hispanic
4 Non-Hispanic Asian/Hawaiian/Pacific Islander
5 Non-Hispanic Other (includes multi-racial)

sex

Student Gender

character (1)

Raw Value

Position in File: 4

Value Description
M Male
F Female
MeSH: Sex

transfer

Transfer Student

character (1)

Raw Value

Position in File: 80

Migrant

Migrant Student

integer

Calculated Value

Position in File: 10

Value Description
0 No
1 Yes

EducGroup

Parent Education Group

integer

Calculated Value

Position in File: 11

Value Description
2 Less than high school
3 High school
4 Some college/some education after high school
5 College or above
This variable is completely unreliable due to how its source field was collected, do not use.

Applicable Years: 2008



Sociological Factors
Sociological Factors

Days_in_Susp

Number of Days ISS (In-school Suspension)

integer (days)

Raw Value

Position in File: 16

Applicable Years: 2008, 2009

Days_out_Susp

Number of Days OSS (Out of School Suspension)

integer (days)

Raw Value

Position in File: 17

Applicable Years: 2008, 2009

DaysAbs

Number of Days Absent

integer (days)

Raw Value

Position in File: 12

DaysAbsGroup

Number of Days Absent Group

integer

Calculated Value

Position in File: 13

Value Description
1 0-7 days
2 8-14 days
3 15-21 days
4 22+ days
Related Attributes:
Was Derived From DaysAbs

Exc_Abs

Excused Absences

decimal

Raw Value

Position in File: 14

Times_in_Susp

Number of In-School Suspensions

integer

Raw Value

Position in File: 18

Applicable Years: 2008, 2009

Times_out_Susp

Number of Out-of-School Suspensions

integer

Raw Value

Position in File: 19

Applicable Years: 2008, 2009

Times_Tardy

Times Tardy

integer

Raw Value

Position in File: 20

Unexc_Abs

Unexcused Absences

decimal

Raw Value

Position in File: 15

FRLunch

Receives Free or Reduced Price Lunch

integer

Calculated Value

Position in File: 9

Value Description
0 No
1 Yes

ComputerUse

Use of Computer at Home

integer

Calculated Value

Position in File: 8

Value Description
0 There is no computer at home
1 Never, even though there is a computer at home
2 Hardly ever
3 Once or twice a month
4 Once or twice a week
5 I use a computer at home for school work almost every day
Applicable Years: 2008, 2009, 2010, 2011

LEPcurrent

Currently LEP (Limited English Proficiency)

integer

Calculated Value

Position in File: 58

Value Description
0 No
1 Yes

LEPever

Currently or Ever LEP (Limited English Proficiency)

integer

Calculated Value

Position in File: 59

Value Description
0 No
1 Yes

Academic Performance
Academic Performance

FDS_TestDt

Date for the First Day of Spring Testing

date (mm/dd/yyyy)

Raw Value

Position in File: 37

Applicable Years: 2012


grade

Assigned Grade Level (Highest Test Score)

character (2)

Raw Value

Position in File: 7

Grade1

Assigned Grade Level (First Test Score)

character (2)

Raw Value

Position in File: 6

mathach

Math Achievement Level (Highest Test Score)

character (1)

Raw Value

Position in File: 24

Year(s) Achievement Levels Scaled Scores
2008-2012 1 = Insufficient Mastery
2 = Inconsistent Mastery
3 = Consistent Mastery
4 = Superior Performance		 300s
2013 1 = Insufficient Mastery
2 = Inconsistent Mastery
3 = Consistent Mastery
4 = Superior Performance		 400s
2014-2016 1 = Limited Command
2 = Partial Command
3 = Sufficient Command
4 = Solid Command
5 = Superior Command		 400s

MathAch1

Math Achievement Level (First Test Score)

character (1)

Raw Value

Position in File: 21

Year(s) Achievement Levels Scaled Scores
2008-2012 1 = Insufficient Mastery
2 = Inconsistent Mastery
3 = Consistent Mastery
4 = Superior Performance		 300s
2013 1 = Insufficient Mastery
2 = Inconsistent Mastery
3 = Consistent Mastery
4 = Superior Performance		 400s
2014-2016 1 = Limited Command
2 = Partial Command
3 = Sufficient Command
4 = Solid Command
5 = Superior Command		 400s

MathcScore

Math Change Scale Score

integer

Raw Value

Position in File: 26

Applicable Years: 2009, 2010, 2011, 2012


MathRetest

Re-tested in Math

integer

Calculated Value

Position in File: 27

Value Description
0 No
1 Yes
Starting with school year 2008-2009, re-tests were mandated for students who scored achievement level II on the initial test. Moreover, the state paid for the retesting. Thus, re-testing soared, with ~40% of students being re-tested through 2012. In 2013, the state reversed their policy, and no longer provided or supported any re-tests. In 2013, there was virtually no re-testing. From 2014 through 2016, a small percentage of students are re-tested. Variable is constructed from Math test scores.

Applicable Years: 2009, 2010, 2011, 2012


Related Attributes:
Was Derived From mathscal

MathTestDt1

Math Test Date (First Test Score)

date (mm/dd/yyyy)

Raw Value

Position in File: 28

Applicable Years: 2008


mathscal

Math Scale Score (Highest Test Score)

integer

Raw Value

Position in File: 25

Achievement
Level		 2000 2001-2005 2006-2007 2008-2012
Grade 3 1
2
3
4		 98-124
125-137
138-149
150-173		 218-237
238-245
246-254
255-276		 311-328
329-338
339-351
352-370		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 4 1
2
3
4		 111-131
132-142
143-155
156-182		 221-239
240-246
247-259
260-285		 319-335
336-344
345-357
358-374		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 5 1
2
3
4		 117-140
141-149
150-160
161-188		 221-242
243-249
250-259
260-295		 326-340
341-350
351-362
363-378


363-379		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 6 1
2
3
4		 130-145
146-154
155-167
168-196		 228-246
247-253
254-264
265-296		 328-341
342-351
352-363
364-381		 327-341


364-382		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 7 1
2
3
4		 134-151
152-160
161-172
173-203		 231-249
250-257
258-266
267-307		 332-345
346-354
355-366
367-383		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 8 1
2
3
4		 137-154
155-164
165-177
178-208		 235-253
254-260
261-271
272-310		 332-348
349-356
357-367
368-384


363-386		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance

MathScal1

Math Scale Score (First Test Score)

integer

Raw Value

Position in File: 22

Achievement
Level		 2000 2001-2005 2006-2007 2008-2012
Grade 3 1
2
3
4		 98-124
125-137
138-149
150-173		 218-237
238-245
246-254
255-276		 311-328
329-338
339-351
352-370		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 4 1
2
3
4		 111-131
132-142
143-155
156-182		 221-239
240-246
247-259
260-285		 319-335
336-344
345-357
358-374		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 5 1
2
3
4		 117-140
141-149
150-160
161-188		 221-242
243-249
250-259
260-295		 326-340
341-350
351-362
363-378


363-379		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 6 1
2
3
4		 130-145
146-154
155-167
168-196		 228-246
247-253
254-264
265-296		 328-341
342-351
352-363
364-381		 327-341


364-382		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 7 1
2
3
4		 134-151
152-160
161-172
173-203		 231-249
250-257
258-266
267-307		 332-345
346-354
355-366
367-383		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 8 1
2
3
4		 137-154
155-164
165-177
178-208		 235-253
254-260
261-271
272-310		 332-348
349-356
357-367
368-384


363-386		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance

MathcScore1

Math Change Scale Score (First Test Score)

integer

Raw Value

Position in File: 23

Applicable Years: 2009, 2010, 2011, 2012


nccmath

EOG Reading and NCCLAS Math Alternate Assessment

character (1)

Raw Value

Position in File: 38

Applicable Years: 2008, 2009


nccread

EOG Reading and NCCLAS Reading Alternate Assessment

character (1)

Raw Value

Position in File: 40

Applicable Years: 2008, 2009


ncemath

EOG Reading and NCEXTEND2 Math Alternate Assessment

character (1)

Raw Value

Position in File: 39

nceread

EOG Math and NCEXTEND2 Reading Alternate Assessment

character (1)

Raw Value

Position in File: 41

ncextend

NC EXTEND 1 Alternate Assessment

character (1)

Raw Value

Position in File: 42

readach

Reading Achievement Level (Highest Test Score)

character (1)

Raw Value

Position in File: 32

Year(s) Achievement Levels Scaled Scores
2008-2012 1 = Insufficient Mastery
2 = Inconsistent Mastery
3 = Consistent Mastery
4 = Superior Performance		 300s
2013 1 = Insufficient Mastery
2 = Inconsistent Mastery
3 = Consistent Mastery
4 = Superior Performance		 400s
2014-2016 1 = Limited Command
2 = Partial Command
3 = Sufficient Command
4 = Solid Command
5 = Superior Command		 400s

ReadAch1

Reading Achievement Level (First Test Score)

character (1)

Raw Value

Position in File: 29

Year(s) Achievement Levels Scaled Scores
2008-2012 1 = Insufficient Mastery
2 = Inconsistent Mastery
3 = Consistent Mastery
4 = Superior Performance		 300s
2013 1 = Insufficient Mastery
2 = Inconsistent Mastery
3 = Consistent Mastery
4 = Superior Performance		 400s
2014-2016 1 = Limited Command
2 = Partial Command
3 = Sufficient Command
4 = Solid Command
5 = Superior Command		 400s

ReadcScore

Reading Change Scale Score (Highest Test Score)

decimal

Raw Value

Position in File: 34

Applicable Years: 2009, 2010, 2011, 2012


ReadcScore1

Reading Change Scale Score (First Test Score)

decimal

Raw Value

Position in File: 31

Applicable Years: 2009, 2010, 2011, 2012


ReadRetest

Re-tested in Reading

integer

Calculated Value

Position in File: 35

Value Description
0 No
1 Yes
Applicable Years: 2009, 2010, 2011, 2012


Related Attributes:
Was Derived From readscal

readscal

Reading Scale Score (Highest Test Score)

integer

Raw Value

Position in File: 33

Achievement
Level		 2000-2002 2003-2007 2008-2012
Grade 3 1
2
3
4		 114-130
131-140
141-150
151-172		 216-229
230-239
240-249
250-272		 302-330
331-337
338-349
350-367		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 4 1
2
3
4		 118-134
135-144
145-155
156-179		 223-235
236-243
244-254
255-275		 313-334
335-342
343-353
354-370		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 5 1
2
3
4		 124-138
139-148
149-158
159-182		 228-238
239-246
247-258
259-277		 319-340
341-348
349-360
361-375		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 6 1
2
3
4		 124-140
141-151
152-161
162-183		 228-241
242-251
252-263
264-283		 332-344
345-350
351-361
362-377		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 7 1
2
3
4		 126-144
145-154
155-163
164-183		 231-243
244-253
254-263
264-287		 325-347
348-355
356-362
363-379		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 8 1
2
3
4		 132-144
145-155
156-165
166-187		 231-243
244-253
254-265
266-290		 327-349
350-357
358-369
370-384		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance

ReadScal1

Reading Scale Score (First Test Score)

integer

Raw Value

Position in File: 30

Achievement
Level		 2000-2002 2003-2007 2008-2012
Grade 3 1
2
3
4		 114-130
131-140
141-150
151-172		 216-229
230-239
240-249
250-272		 302-330
331-337
338-349
350-367		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 4 1
2
3
4		 118-134
135-144
145-155
156-179		 223-235
236-243
244-254
255-275		 313-334
335-342
343-353
354-370		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 5 1
2
3
4		 124-138
139-148
149-158
159-182		 228-238
239-246
247-258
259-277		 319-340
341-348
349-360
361-375		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 6 1
2
3
4		 124-140
141-151
152-161
162-183		 228-241
242-251
252-263
264-283		 332-344
345-350
351-361
362-377		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 7 1
2
3
4		 126-144
145-154
155-163
164-183		 231-243
244-253
254-263
264-287		 325-347
348-355
356-362
363-379		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance
Grade 8 1
2
3
4		 132-144
145-155
156-165
166-187		 231-243
244-253
254-265
266-290		 327-349
350-357
358-369
370-384		 Insufficient Mastery
Inconsistent Mastery
Consistent Mastery
Superior Performance

ReadTestDt1

Date of Reading Test (First Test Score)

date (mm/dd/yyyy)

Raw Value

Position in File: 36

Applicable Years: 2008


Administ1

Test Administration (First Test Score)

character (1)

Raw Value

Position in File: 79

teachid

Encrypted Teacher ID

integer

Raw Value

Position in File: 81

Applicable Years: 2008, 2009, 2010, 2011



Exceptionality
Child, Exceptional

EC_AIG

Exceptionallity-Academically/Intellectually Gifted

integer

Calculated Value

Position in File: 43

Value Description
0 No
1 Yes

EC_MentEmo

Exceptionality-Mental/Emotional

integer

Calculated Value

Position in File: 44

Value Description
0 No
1 Yes

Related Attributes:
Was Derived From Except1, Except2, Except3

EC_Physical

Exceptionality-Physical

integer

Calculated Value

Position in File: 45

Value Description
0 No
1 Yes

Related Attributes:
Was Derived From Except1, Except2, Except3

Except1

Exceptionality (1)

character (2)

Calculated Value

Position in File: 46

Value Description
02 Academically/Intellectually Gifted (AIG)
03 Behaviorally Disabled
03 Emotionally Disabled
04 Deafness
04 Hearing Impaired
05 Educable Mentally Disabled
05 Intellectual Disability – Mild
06 Deaf-Blind
07 Visually Impaired
08 Other Health Impaired
09 Orthopedically Impaired
10 Traumatic Brain Injured
11 Intellectual Disability – Severe
11 Severely/Profoundly Mentally Disabled
13 Speech-Language Impaired
12 Multi-Handicapped / Multiple Disabilities
14 Intellectual Disability – Moderate
14 Trainable Mentally Disabled
15 Specific Leaning Disabled
16 Autistic
99 Developmentally Delayed

Except2

Exceptionality (2)

character (2)

Calculated Value

Position in File: 47

Value Description
02 Academically/Intellectually Gifted (AIG)
03 Behaviorally Disabled
03 Emotionally Disabled
04 Deafness
04 Hearing Impaired
05 Educable Mentally Disabled
05 Intellectual Disability – Mild
06 Deaf-Blind
07 Visually Impaired
08 Other Health Impaired
09 Orthopedically Impaired
10 Traumatic Brain Injured
11 Intellectual Disability – Severe
11 Severely/Profoundly Mentally Disabled
13 Speech-Language Impaired
12 Multi-Handicapped / Multiple Disabilities
14 Intellectual Disability – Moderate
14 Trainable Mentally Disabled
15 Specific Leaning Disabled
16 Autistic
99 Developmentally Delayed

Except3

Exceptionality (3)

character (2)

Calculated Value

Position in File: 48

Value Description
02 Academically/Intellectually Gifted (AIG)
03 Behaviorally Disabled
03 Emotionally Disabled
04 Deafness
04 Hearing Impaired
05 Educable Mentally Disabled
05 Intellectual Disability – Mild
06 Deaf-Blind
07 Visually Impaired
08 Other Health Impaired
09 Orthopedically Impaired
10 Traumatic Brain Injured
11 Intellectual Disability – Severe
11 Severely/Profoundly Mentally Disabled
13 Speech-Language Impaired
12 Multi-Handicapped / Multiple Disabilities
14 Intellectual Disability – Moderate
14 Trainable Mentally Disabled
15 Specific Leaning Disabled
16 Autistic
99 Developmentally Delayed
Applicable Years: 2008


LDcalc

Learn Disable - Math Calculations

integer

Raw Value

Position in File: 49

Value Description
0 No
1 Yes
Applicable Years: 2009, 2010, 2011


LDcomp

Learn Disable - Reading Comprehension

integer

Raw Value

Position in File: 50

Value Description
0 No
1 Yes
Applicable Years: 2009, 2010, 2011


LDfluent

Learn Disable - Reading Fluency Skills

integer

Raw Value

Position in File: 51

Value Description
0 No
1 Yes
Applicable Years: 2009, 2010, 2011


LDlisten

Learn Disable - Listening Comprehension

integer

Raw Value

Position in File: 52

Value Description
0 No
1 Yes
Applicable Years: 2009, 2010, 2011


LDmath

Learn Disable - Math

integer

Raw Value

Position in File: 53

Value Description
0 No
1 Yes
Applicable Years: 2008, 2009, 2010, 2011


LDoral

Learn Disable - Oral Expression

integer

Raw Value

Position in File: 54

Value Description
0 No
1 Yes
Applicable Years: 2009, 2010, 2011


LDoth

Learn Disable - Other

integer

Raw Value

Position in File: 57

Value Description
0 No
1 Yes
Applicable Years: 2008


LDread

Learn Disable - Reading

integer

Raw Value

Position in File: 55

Value Description
0 No
1 Yes
Applicable Years: 2008, 2009, 2010, 2011


LDwrite

Learn Disable - Written Expression

integer

Raw Value

Position in File: 56

Value Description
0 No
1 Yes
Applicable Years: 2008, 2009, 2010, 2011



Geography
Geographic Mapping

AddrCnt

Number of Addresses

integer

Calculated Value

Position in File: 60

Number of addresses at which the student lived during the indicated school year.

GeoID00_bg1

Census 2000 Block Group for Child Address (1)

character (12)

Calculated Value

Position in File: 61

Census 2000 Block Group for Child Address (If a student is associated with more than two different block groups, all block groups are deleted. This affects a negligible number of records, and there is no way to determine which addresses should be used.)

Geographic Resolution: Block


GeoID00_bg2

Census 2000 Block Group for Child Address (2)

character (12)

Calculated Value

Position in File: 62

Census 2000 Block Group for Child Address (2). Populated if the student is associated with more than 1 block group during the school year. If a student is associated with more than two different block groups, all block groups are deleted. This affects a negligible number of records, and there is no way to determine which addresses should be used.

Geographic Resolution: Block


GeoID10_bg1

Census 2010 Block Group for Child Address (1)

character (12)

Calculated Value

Position in File: 63

Applicable Years: 2010, 2011, 2012

Geographic Resolution: Block


GeoID10_bg2

Census 2010 Block Group for Child Address (2)

character (12)

Calculated Value

Position in File: 64

Applicable Years: 2010, 2011, 2012

Geographic Resolution: Block



School Information
Schools

schlcode

School Code (Highest Test Score)

character (3)

Raw Value

Position in File: 74

Geographic Resolution: School

MeSH: Schools

SchlCode1

School Code (First Test Score)

character (3)

Raw Value

Position in File: 70

Geographic Resolution: School

MeSH: Schools

schlname

School Name

character (25)

Raw Value

Position in File: 75

MeSH: Schools

schtype

Type of School

character (1)

Raw Value

Position in File: 76

Value Description
0 Public School: Regular Program
1 Pubilc School: Alternative School
2 Public School: Charter School
3 Private School
4 Federal School
5 Other (e.g. Health and Human Services or Special School)
6 Public School: Extended Day Program
7 Unknown
8 Unknown
9 Unknown
* Unknown
Applicable Years: 2008

MeSH: Schools

lea

Local Education Agency (LEA) Code (School District) (Highest Test Score)

character (3)

Raw Value

Position in File: 71

Geographic Resolution: School

MeSH: Schools

LEA1

Local Education Agency (LEA) Code (School District) (First Test Score)

character (3)

Raw Value

Position in File: 67

Geographic Resolution: School

MeSH: Schools

leaCoFIPS

Federal Information Processing Standards (FIPS) County Code Equivalent for Local Education Agency (LEA) (Highest Test Score)

character (5)

Calculated Value

Position in File: 72

Geographic Resolution: County


Related Attributes:
Was Derived From lea

leaCoFIPS1

Federal Information Processing Standards (FIPS) County Code Equivalent for Local Education Agency (LEA) (First Test Score)

character (5)

Calculated Value

Position in File: 68

Geographic Resolution: County


Related Attributes:
Was Derived From LEA1

leaCoName

County Name Equivalent for Local Education Agency (LEA) (Highest Test Score)

character (25)

Calculated Value

Position in File: 73

Geographic Resolution: County

MeSH: Schools

Related Attributes:
Was Derived From lea

leaCoName1

County name equivalent for Local Education Agency (LEA) (First Test Score)

character (25)

Calculated Value

Position in File: 69

Geographic Resolution: County

MeSH: Schools

Related Attributes:
Was Derived From LEA1

leaGeo1

Local Education Agency (LEA) Code for Address (1)

character (3)

Raw Value

Position in File: 77

Applicable Years: 2008, 2009


leaGeo2

Local Education Agency (LEA) Code for Address (2)

character (3)

Raw Value

Position in File: 78

Applicable Years: 2008, 2009


Zip1

Zip Code for Address (1)

character (5)

Raw Value

Position in File: 65

Geographic Resolution: Zip code


Zip2

Zip Code for Address (2)

character (5)

Raw Value

Position in File: 66

Geographic Resolution: Zip code