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

Migrant

Migrant Student

integer

Calculated Value

Position in File: 10

Value Description
0 No
1 Yes


Sociological Factors
Sociological Factors

daysmem

Number of Days in School Membership (Year Long)

integer (days)

Raw Value

Position in File: 12

daysabs

Number of Days Absent

integer (days)

Raw Value

Position in File: 11

In the 2015-2016 school year, 0 and unknown number of days absent are both coded as unknown.

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

eds

Economically Disadvantaged Student

character (1)

Calculated Value

Position in File: 9

Value Description
N No
Y Yes

Related Attributes:
Alternate Of FRLunch

FRLunch

Receives Free or Reduced Price Lunch

integer

Calculated Value

Position in File: 8

Value Description
0 No
1 Yes

Related Attributes:
Alternate Of eds

LEPcurrent

Currently LEP (Limited English Proficiency)

integer

Calculated Value

Position in File: 38

Value Description
0 No
1 Yes

LEPever

Currently or Ever LEP (Limited English Proficiency)

integer

Calculated Value

Position in File: 39

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

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

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

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

MathRetest

Re-tested in Math

integer

Calculated Value

Position in File: 19

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.


Related Attributes:
Was Derived From MathScal

MathScal

Math Scale Score (Highest Test Score)

integer

Raw Value

Position in File: 18

Years

2013		 Achievement Level
Grade 1 2 3 4
3 ≤442 443-450 451-459 ≥460
4 ≤443 444-450 451-459 ≥460
5 ≤443 444-450 451-459 ≥460
6 ≤446 447-452 453-460 ≥461
7 ≤446 447-452 453-460 ≥461
8 ≤446 447-453 454-462 ≥463

MathScal1

Math Scale Score (First Test Score)

integer

Raw Value

Position in File: 15

Years

2013		 Achievement Level
Grade 1 2 3 4
3 ≤442 443-450 451-459 ≥460
4 ≤443 444-450 451-459 ≥460
5 ≤443 444-450 451-459 ≥460
6 ≤446 447-452 453-460 ≥461
7 ≤446 447-452 453-460 ≥461
8 ≤446 447-453 454-462 ≥463

MathTestDt

Date of Math Test (Highest Test Score)

date (MM/DD/YYYY)

Raw Value

Position in File: 20

MathTestDt1

Date of Math Test (First Test Score)

date (MM/DD/YYYY)

Raw Value

Position in File: 16

ReadAch

Reading 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

ReadAch1

Reading 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

ReadRetest

Re-tested in Reading

integer

Calculated Value

Position in File: 26

Value Description
0 No
1 Yes

Related Attributes:
Was Derived From ReadScal

ReadScal

Reading Scale Score (Highest Test Score)

integer

Raw Value

Position in File: 25

Years

2013		 Achievement Level
Grade 1 2 3 4
3 ≤431 432-441 442-451 ≥452
4 ≤438 439-447 448-459 ≥460
5 ≤442 443-452 453-463 ≥464
6 ≤441 442-453 454-464 ≥465
7 ≤444 445-456 457-468 ≥469
8 ≤448 449-461 462-472 ≥473

ReadScal1

Reading Scale Score (First Test Score)

integer

Raw Value

Position in File: 22

Years

2013		 Achievement Level
Grade 1 2 3 4
3 ≤431 432-441 442-451 ≥452
4 ≤438 439-447 448-459 ≥460
5 ≤442 443-452 453-463 ≥464
6 ≤441 442-453 454-464 ≥465
7 ≤444 445-456 457-468 ≥469
8 ≤448 449-461 462-472 ≥473

ReadTestDt

Date of Reading Test (Highest Test Score)

date (MM/DD/YYYY)

Raw Value

Position in File: 27

ReadTestDt1

Date of Reading Test (First Test Score)

date (MM/DD/YYYY)

Raw Value

Position in File: 23


Exceptionality
Child, Exceptional

aig

Academically/Intellectually Gifted

character (1)

Raw Value

Position in File: 29

Value Description
B Both
I Intellectually Gifted
M Math Only
N None
R Reading Only

EC_AIG

Exceptionallity-Academically/Intellectually Gifted

integer

Calculated Value

Position in File: 31

Value Description
0 No
1 Yes

Related Attributes:
Was Derived From aig

EC_Code1

Primary Exceptionallity-Classification Code (1)

character (4)

Raw Value

Position in File: 36

Value Description
AU Autistic
DB Deaf-Blind
DD Developmentally Delayed
DF Deafness
ED Emotionally Disabled
EH Behaviorally Disabled
EM Educable Mentally Disabled
HI Hearing Impaired
IDMI Intellectual Disability – Mild
IDMO Intellectual Disability – Moderate
IDSE Intellectual Disability – Severe
LD Specific Leaning Disabled
MU Multi-Handicapped / Multiple Disabilities
OH Other Health Impaired
OI Orthopedically Impaired
SI Speech-Language Impaired
SP Severely/Profoundly Mentally Disabled
TB Traumatic Brain Injured
TM Trainable Mentally Disabled
VI Visually Impaired

Related Attributes:
Alternate Of Except1

EC_Code2

Exceptionallity-Classification Code (2). Populated if the student has more than on exceptionality code.

character (4)

Raw Value

Position in File: 37

Value Description
AU Autistic
DB Deaf-Blind
DD Developmentally Delayed
DF Deafness
ED Emotionally Disabled
EH Behaviorally Disabled
EM Educable Mentally Disabled
HI Hearing Impaired
IDMI Intellectual Disability – Mild
IDMO Intellectual Disability – Moderate
IDSE Intellectual Disability – Severe
LD Specific Leaning Disabled
MU Multi-Handicapped / Multiple Disabilities
OH Other Health Impaired
OI Orthopedically Impaired
SI Speech-Language Impaired
SP Severely/Profoundly Mentally Disabled
TB Traumatic Brain Injured
TM Trainable Mentally Disabled
VI Visually Impaired

Related Attributes:
Alternate Of Except2

EC_MentEmo

Exceptionality-Mental/Emotional

integer

Calculated Value

Position in File: 32

Value Description
0 No
1 Yes

Related Attributes:
Was Derived From EC_Code1, EC_Code2, Except1, Except2

EC_Physical

Exceptionality-Physical

integer

Calculated Value

Position in File: 33

Value Description
0 No
1 Yes

Related Attributes:
Was Derived From EC_Code1, EC_Code2, Except1, Except2

Except1

Exceptionality (1)

character (2)

Calculated Value

Position in File: 34

Value Description
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/Profoundly Mentally Disabled
12 Multi-Handicapped / Multiple Disabilities
13 Speech-Language Impaired
14 Trainable Mentally Disabled
14 Intellectual Disability – Moderate
15 Specific Leaning Disabled
16 Autistic
99 Developmentally Delayed

Related Attributes:
Alternate Of EC_Code1

Except2

Exceptionality (2)

character (2)

Calculated Value

Position in File: 35

Value Description
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/Profoundly Mentally Disabled
12 Multi-Handicapped / Multiple Disabilities
13 Speech-Language Impaired
14 Trainable Mentally Disabled
14 Intellectual Disability – Moderate
15 Specific Leaning Disabled
16 Autistic
99 Developmentally Delayed

Related Attributes:
Alternate Of EC_Code2

swd

Students with Disability

character (1)

Raw Value

Position in File: 30

Value Description
N No
U Exited within 2 years
Y Yes

Geography
Geographic Mapping

AddrCnt

Number of Addresses

integer

Calculated Value

Position in File: 40

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

GeoID10_bg1

Census 2010 Block Group for Child Address (1)

character (12)

Calculated Value

Position in File: 41

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


GeoID10_bg2

Census 2010 Block Group for Child Address (2)

character (12)

Calculated Value

Position in File: 42

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



School Information
Schools

schlcode

School Code (Highest Test score)

character (3)

Raw Value

Position in File: 50

Geographic Resolution: School

MeSH: Schools

SchlCode1

School Code (First test score)

character (3)

Raw Value

Position in File: 46

Geographic Resolution: School

MeSH: Schools

LEA

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

character (3)

Raw Value

Position in File: 47

Geographic Resolution: School

MeSH: Schools

LEA1

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

character (3)

Raw Value

Position in File: 43

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

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

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

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

Geographic Resolution: County

MeSH: Schools

Related Attributes:
Was Derived From LEA1