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

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)
Source values were mapped to standard CEHI race groups.



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: 62


Migrant

Migrant Student

integer

Raw Value

Position in File: 9

Value Description
0 No
1 Yes
The child must engage in or have parents or guardians who engage in migrant agricultural work. The child also must have moved within the preceding 36 months to accommodate temporary or seasonal agricultural work.

Applicable Years: 2006, 2007



EducGroup

Parent Education Group

integer

Calculated Value

Position in File: 10

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.



Source_Demo

Source Provided Race Group in Demographics

integer

Calculated Value

Position in File: 65

Value Description
0 No
1 Yes
Source value indicating race group was provided. Primary source for race group.

Applicable Years: 2006, 2007


Source_MB

Source Provided Race Group in MasterBuild

integer

Calculated Value

Position in File: 64

Value Description
0 No
1 Yes
Secondary source for race group.


Sociological Factors

Days_in_Susp

Number of Days ISS (In-school Suspension)

integer (days)

Raw Value

Position in File: 15

Applicable Years: 2006, 2007


Days_out_Susp

Number of Days OSS (Out of School Suspension)

integer (days)

Raw Value

Position in File: 16

Applicable Years: 2006, 2007


DaysAbs

Number of Days Absent

integer (days)

Raw Value

Position in File: 11

Applicable Years: 2004, 2005, 2006, 2007


DaysAbsGroup

Number of Days Absent Group

integer

Calculated Value

Position in File: 12

Value Description
1 0-7 days
2 8-14 days
3 15-21 days
4 22+ days
DaysAbsGroup is sometimes missing even though DaysAbs exists. Only 2004 records are affected. It affects 1,464 of the 642,878 unique children kept in the final 2004 EoG dataset (0.2%).

Applicable Years: 2000, 2004, 2005, 2006, 2007

Related Attributes:
Was Derived From DaysAbs


Exc_Abs

Excused Absences

decimal

Raw Value

Position in File: 13

Applicable Years: 2006, 2007


Times_in_Susp

Number of In-School Suspensions

integer

Raw Value

Position in File: 17

Applicable Years: 2006, 2007


Times_out_Susp

Number of Out-of-School Suspensions

integer

Raw Value

Position in File: 18

Applicable Years: 2006, 2007


Times_Tardy

Times Tardy

integer

Raw Value

Position in File: 19

Applicable Years: 2006, 2007


Unexc_Abs

Unexcused Absences

decimal

Raw Value

Position in File: 14

Applicable Years: 2006, 2007


FRLunch

Receives Free or Reduced Price Lunch

integer

Calculated Value

Position in File: 8

Value Description
0 No
1 Yes
Source values included 5 options: 'Free lunch', 'Reducted price lunch', 'Temporary eligibility', 'Full pay; School not participating; Student not eligible', and 'Information NA'. The first two were mapped to 1, the next two values were mapped to 0, and the value is left blank if the information was not available.


ComputerUse

Use of Computer at Home

integer

Calculated Value

Position in File: 7

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

LEPcurrent

Currently LEP (Limited English Proficiency)

integer

Calculated Value

Position in File: 44

Value Description
0 No
1 Yes
Set to 1 if any source variable indicated current LEP. Set to 0 if LEP was not indicatied. no LEP information was available, or if child exited LEP status.



LEPever

Currently or Ever LEP (Limited English Proficiency)

integer

Calculated Value

Position in File: 45

Value Description
0 No
1 Yes
Set to 1 if any source variable indicated LEP at any time. Set to 0 if LEP was not indicatied or no LEP information was available.

Applicable Years: 2003, 2004, 2005, 2006, 2007



Academic Performance

grade

Assigned Grade Level (Highest Test Score)

character (2)

Raw Value

Position in File: 6


mathach

Math Achievement Level (Highest Test Score)

character (1)

Raw Value

Position in File: 20

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

mathscal

Math Scale Score (Highest Test Score)

integer

Raw Value

Position in File: 21

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

MathScal08

2008 Equivalent Math Scale Score

integer

Calculated Value

Position in File: 22

1. Years are grouped according to whether they have the same score ranges for each grade and achievement level. For example, the reading achievement ranges are the same for years 2000-2002, so they form a year group. 2. A table was created by hand from the 2000-2008 NCERDC documentation files. It contains a row for each grade and achievement level. The columns indicate the minimum and maximum values for each year group. 3. For each year group, grade and achievement level, calculate the difference between the min and max values. This tells us how many possible score values there are per year, grade and achievement level. Similarly, calculate the min/max range for 2008 scores. Example: 2000 min/max difference is 16 (130-114); 2008 min/max difference is 28 (330-302); 4. Calculate the increment to be used when adjusting an original score to a 2008 score. The increment is the ratio of the min/max difference in a year group to the min/max difference in the base year (2008). In other words, for every increase of 1 in the score of an earlier year, what is the equivalent increment in 2008? Example: Ratio (increment) = 28/16 = 1.75; 5. For every score value in the earlier year, calculate the 2008 equivalent. The original min value’s equivalent is the min value in 2008 for the same grade and achievement level. Same for the max values. All values in between the min and max are converted by starting with the 2008 min value, and applying the increment as shown in the table below. The values were rounded to the nearest integer.


Related Attributes:
Was Derived From mathscal


nccmath

EOG Reading and NCCLAS Math Alternate Assessment

character (1)

Raw Value

Position in File: 26

Applicable Years: 2006, 2007



nccread

EOG Reading and NCCLAS Reading Alternate Assessment

character (1)

Raw Value

Position in File: 28

Applicable Years: 2006, 2007



ncemath

EOG Reading and NCEXTEND2 Math Alternate Assessment

character (1)

Raw Value

Position in File: 27

Applicable Years: 2006, 2007



nceread

EOG Math and NCEXTEND2 Reading Alternate Assessment

character (1)

Raw Value

Position in File: 29

Applicable Years: 2006, 2007



ncextend

NC EXTEND 1 Alternate Assessment

character (1)

Raw Value

Position in File: 30

Applicable Years: 2007



readach

Reading Achievement Level (Highest Test Score)

character (1)

Raw Value

Position in File: 23

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

readscal

Reading Scale Score (Highest Test Score)

integer

Raw Value

Position in File: 24

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

ReadScal08

2008 Equivalent Reading Scale Score

integer

Calculated Value

Position in File: 25

1. Years are grouped according to whether they have the same score ranges for each grade and achievement level. For example, the reading achievement ranges are the same for years 2000-2002, so they form a year group. 2. A table was created by hand from the 2000-2008 NCERDC documentation files. It contains a row for each grade and achievement level. The columns indicate the minimum and maximum values for each year group. 3. For each year group, grade and achievement level, calculate the difference between the min and max values. This tells us how many possible score values there are per year, grade and achievement level. Similarly, calculate the min/max range for 2008 scores. Example: 2000 min/max difference is 16 (130-114); 2008 min/max difference is 28 (330-302); 4. Calculate the increment to be used when adjusting an original score to a 2008 score. The increment is the ratio of the min/max difference in a year group to the min/max difference in the base year (2008). In other words, for every increase of 1 in the score of an earlier year, what is the equivalent increment in 2008? Example: Ratio (increment) = 28/16 = 1.75; 5. For every score value in the earlier year, calculate the 2008 equivalent. The original min value’s equivalent is the min value in 2008 for the same grade and achievement level. Same for the max values. All values in between the min and max are converted by starting with the 2008 min value, and applying the increment as shown in the table below. The values were rounded to the nearest integer.


Related Attributes:
Was Derived From readscal


teachid

Encrypted Teacher ID

integer

Raw Value

Position in File: 63


testdt

Test Date

character (5)

Raw Value

Position in File: 59


testform

Test Form

character (4)

Raw Value

Position in File: 60


testname

Test Name

character (6)

Raw Value

Position in File: 61


Exceptionality

EC_AIG

Exceptionallity-Academically/Intellectually Gifted

integer

Calculated Value

Position in File: 31

Value Description
0 No
1 Yes
Set to 1 if any of the fields is set to 'Academically/Intellectually Gifted (AIG)'


Related Attributes:
Was Derived From Except1, Except2, Except3


EC_MentEmo

Exceptionality-Mental/Emotional

integer

Calculated Value

Position in File: 32

Value Description
0 No
1 Yes
Set to 1 if any of the fields is set to 'Educable Mentally Handicapped OR Intellectual Disability – Mild', 'Traumatic Brain Injured', 'Severe/Profound Mentally Disabled OR Intellectual Disability – Severe', 'Multihandicapped OR Multiple Disabilities', 'Trainable Mentally Handicapped OR Intellectual Disability – Moderate', 'Specific Leaning Disabled', or 'Autistic'


Related Attributes:
Was Derived From Except1, Except2, Except3


EC_Physical

Exceptionality-Physical

integer

Calculated Value

Position in File: 33

Value Description
0 No
1 Yes
Set to 1 if any of the fields is set to 'Hearing Impaired OR Deafness', 'Deaf-Blind', 'Visually Impaired', 'Other Health Impaired', 'Orthopedically Impaired', 'Multihandicapped OR Multiple Disabilities', or 'Other Exceptional Classifications'


Related Attributes:
Was Derived From Except1, Except2, Except3


Except1

Exceptionality (1)

character (2)

Calculated Value

Position in File: 34

Value Description
01 Not identified as an Exceptional Student
02 Academically/Intellectually Gifted (AIG)
03 Emotionally Disabled
03 Behaviorally 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/Profound Mentally Disabled
12 Multi-Handicapped
13 Speech-Language Impaired
14 Trainable Mentally Disabled
14 Intellectual Disability – Moderate
15 Specific Leaning Disabled
16 Autistic
99 Developmentally Delayed

Except2

Exceptionality (2)

character (2)

Calculated Value

Position in File: 35

Value Description
01 Not identified as an Exceptional Student
02 Academically/Intellectually Gifted (AIG)
03 Emotionally Disabled
03 Behaviorally 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/Profound Mentally Disabled
12 Multi-Handicapped
13 Speech-Language Impaired
14 Trainable Mentally Disabled
14 Intellectual Disability – Moderate
15 Specific Leaning Disabled
16 Autistic
99 Developmentally Delayed

Except3

Exceptionality (3)

character (2)

Calculated Value

Position in File: 36

Value Description
01 Not identified as an Exceptional Student
02 Academically/Intellectually Gifted (AIG)
03 Emotionally Disabled
03 Behaviorally 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/Profound Mentally Disabled
12 Multi-Handicapped
13 Speech-Language Impaired
14 Trainable Mentally Disabled
14 Intellectual Disability – Moderate
15 Specific Leaning Disabled
16 Autistic
99 Developmentally Delayed

iepinvm

North Carolina Alternate Assessment - Academic Inventory-Math

integer

Raw Value

Position in File: 39

Value Description
0 No
1 Yes
Applicable Years: 2004, 2005



iepinvr

North Carolina Alternate Assessment - Academic Inventory-Reading

integer

Raw Value

Position in File: 38

Value Description
0 No
1 Yes
Applicable Years: 2004, 2005



ieppo

North Carolina Alternate Assessment - Portfolio

integer

Raw Value

Position in File: 37

Value Description
0 No
1 Yes
Applicable Years: 2004, 2005



LDmath

Learning Disabled - Math

integer

Raw Value

Position in File: 40

Value Description
0 No
1 Yes

LDoth

Learning Disabled - Other

integer

Raw Value

Position in File: 41

Value Description
0 No
1 Yes

LDread

Learning Disabled - Reading

integer

Raw Value

Position in File: 42

Value Description
0 No
1 Yes

LDwrite

Learning Disabled - Written Expression

integer

Raw Value

Position in File: 43

Value Description
0 No
1 Yes

Geography

AddrCnt

Number of Addresses

integer

Calculated Value

Position in File: 46

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

BlkGrp1

Census 2000 Block Group for Child Address (1)

character (12)

Calculated Value

Position in File: 47

Census 2000 Block Group for Child Address (1). 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.

Applicable Years: 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007

Geographic Resolution: Block



BlkGrp2

Census 2000 Block Group for Child Address (2)

character (12)

Calculated Value

Position in File: 48

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.

Applicable Years: 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007

Geographic Resolution: Block



School Information

schlcode

School Code (Highest Test Score)

character (3)

Raw Value

Position in File: 56

Geographic Resolution: School

MeSH: Schools


schlname

School Name

character (25)

Raw Value

Position in File: 57

MeSH: Schools


schtype

Type of School

character (1)

Raw Value

Position in File: 58

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: 2004, 2005, 2006, 2007

MeSH: Schools


lea

Local Education Agency (LEA) Code (School District)

character (3)

Raw Value

Position in File: 51

Where highest test score was recoreded

Geographic Resolution: School

MeSH: Schools


leaCoFIPS

Federal Information Processing Standards (FIPS) County Code equivalent for Local Education Agency (LEA)

character (5)

Calculated Value

Position in File: 52

Where highest test score was recoreded

Geographic Resolution: County


Related Attributes:
Was Derived From lea


leaCoName

County Name Equivalent for Local Education Agency (LEA)

character (25)

Calculated Value

Position in File: 53

Where highest test score was recoreded

Geographic Resolution: County

MeSH: Schools

Related Attributes:
Was Derived From lea


leaGeo1

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

character (3)

Raw Value

Position in File: 54


leaGeo2

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

character (3)

Raw Value

Position in File: 55


Zip1

Zip Code for Address (1)

character (5)

Raw Value

Position in File: 49

Geographic Resolution: Zip code



Zip2

Zip Code for Address (2)

character (5)

Raw Value

Position in File: 50

Geographic Resolution: Zip code