Data Dictionary

Data available for request at the Utah Data Research Center include those related to K-12 education, postsecondary education, and workforce participation of Utahns. Health data will also be available soon. This data dictionary provides high-level details on the various data elements available for request, including the field values, years available, limitations, and other notes. Any variables with 10 or fewer records are never disclosed to protect personal information. Data are updated on a quarterly basis. For further questions, contact udrc@ushe.edu.

A PDF file version with more information is also available here: UDRC Data Dictionary PDF

Quick Links to the data and associated agencies:

Utah Department of Workforce Services

Data available for 2001-2019. Limitations: Variables not available include occupation, hours worked, employment location, and full-time status. UDRC does not have a reliable source for this information.

Employment Status

Description
Employment indicator if a person was employed at any time in the quarter.
Field Values
Binary — (0/1 by quarter or year)
Limitations
n/a
Other Notes
Full-time status is not available. UDRC has defined "working" as a person flagged in all four quarters. Those with no record in any quarter are considered "not working". May also use the phrase "worked in at least one quarter" to define partial employment.

Wages

Description
Wage amounts of Utah employees reported to the Unemployment Insurance program. Majority of Utah employers are required by law to report their employees and wages to this program.
Field Values
Numeric — ($/quarter or $/year)
Limitations
Hourly wages are not available. Does not include individuals who are self-employed, federal employees, or military personnel. Does not include wage payments suck as stocks, tips, in-kind or bonuses.
Other Notes
n/a

Employer

Description
Name of employer.
Field Values
Varchar
Limitations
Those employed by the Church of Jesus Christ of Latter-Day Saints are not available.
Other Notes
n/a

Industry

Description
Industry the employee works in, according to the North American Industry Classification System (NAICS).
Field Values
Numeric Code — (NAICS 3-6 digit)
Limitations
n/a
Other Notes
Typically, if there are two different NAICS in the quarter, the one with the highest wage is provided.

Utah State Board of Education (K-12)

Data available for 2011-2017.

Courses

School Class Year

Description
The year a given class was taken by a given student.
Field Values
Varchar
Limitations
n/a
Other Notes
Available for 2011-2017

Class period

Description
The dderiod, of the school day, which a given class was offered.
Field Values
Character
Limitations
n/a
Other Notes
Codes for 91 class dderiods.

College Granting Credit

Description
Indicator for whether or not a class grants college credit.
Field Values
Character
Limitations
n/a
Other Notes
[49, 50, 52-54,56-59, null]
An indicator of college readiness.

Concurrent Enrollment

Description
Indicator for a class being classified as concurrent enrollment, and therefore college credit granting.
Field Values
Character
Limitations
n/a
Other Notes
Y/N
An indicator of college readiness.

Course Entry Date

Description
Date a student entered the course.
Field Values
Date
Limitations
n/a
Other Notes
##/##/####

Credits Attempted

Description
The number of credits Attempted for a given class.
Field Values
Number
Limitations
n/a
Other Notes
Range: 0 - 8

Credits Earned

Description
The number of credits earned for a given class.
Field Values
Number
Limitations
n/a
Other Notes
Range: 0 - 7

Entry Date

Description
Date of class entrance.
Field Values
Date
Limitations
n/a
Other Notes
##/##/####

Exit Date

Description
Date of class exit.
Field Values
Date
Limitations
n/a
Other Notes
##/##/####

Grade

Description
Grade earned.
Field Values
Character
Limitations
Required only for 9-12 grade
Other Notes
[0-4, F, NG, dd]

Institutional Setting

Description
Setting or mode by which instruction is delivered.
Field Values
Character
Limitations
n/a
Other Notes
[AV, IS, Odd, CC, ON, FF, BC, EC]

School Course Title

Description
Course title as assigned by local education agency (LEA).
Field Values
Character
Limitations
Driven by LEA choice
Other Notes
17,070 unique course titles

Subject Matter of Class

Description
Code related to the subject matter of a given class.
Field Values
Character
Limitations
Driven by LEA choice
Other Notes
951 unique subjects

Class Term

Description
The term a given class is offered.
Field Values
Character
Limitations
n/a
Other Notes
[Q1-4, Q1Q2, Q3Q4, S1, S2, SU, T1-6, YR]

Demographics

Data available for 2011-2017.

English Language Learner (ELL)

Description
What type of ELL status a given student is classified.
Field Values
Character
Limitations
n/a
Other Notes
[Y, M, N, O, P]

Gender

Description
The specified sex of a given student.
Field Values
Character
Limitations
n/a
Other Notes
n/a

Homeless

Description
Indicator for the homeless status of a given student.
Field Values
Character
Limitations
n/a
Other Notes
0/1

Immigrant

Description
Indicator for the immigrant status of a given student.
Field Values
Character
Limitations
n/a
Other Notes
True/False

Low Income

Description
The eligibility of a given student for receipt of reduced price school lunch.
Field Values
Number
Limitations
Based on eligibility to free and reduced-price school lunch.
Other Notes
0/1

Native Language

Description
Populated when studen it "ELL." the native language of a given student.
Field Values
Number
Limitations
Self reported
Other Notes
Codes available for 161 languages

Race

Description
Indicator for the race of a given student.
Field Values
Character
Limitations
n/a
Other Notes
[H, P, I, M, C, B, A]

Refugee

Description
Indicator for refugee status of a student.
Field Values
Character
Limitations
n/a
Other Notes
True/False

Resident Status

Description
Indicator for the residence status of a given student.
Field Values
Character
Limitations
n/a
Other Notes
[U, B, J, A, C, F]

Tribal Affiliation

Description
Indicator for the tribal affiliation of a given student.
Field Values
Character
Limitations
n/a
Other Notes
[U, P, O, N, G, S, Null]

Enrollment

Data available for 2011-2017.

Attendance

Description
Days the student was counted in attendance.
Field Values
Number
Limitations
n/a
Other Notes
Range: 0-180

Chronically Absent

Description
Student who is enrolled over 60 calendar days, and was absent greater than or equal to 10% of their membership days.
Field Values
Character
Limitations
n/a
Other Notes
True/False/Null

Total Membership

Description
Days enrolled (not a measure of attendance).
Field Values
Number
Limitations
n/a
Other Notes
Range: 0-360

School District

Description
The school district.
Field Values
Number
Limitations
n/a
Other Notes
153 current districts. Joinable to a reference table for school district name.

Entry Date

Description
Demarks the beginning of a given school membership.
Field Values
Date
Limitations
n/a
Other Notes
##/##/####

Exit Date

Description
Demarks the end of a given school membership.
Field Values
Date
Limitations
n/a
Other Notes
##/##/####

Cumulative GPA

Description
The cumalative GPA of a given student in a given school year.
Field Values
Number
Limitations
n/a
Other Notes
Range: 0-4

Grade Level

Description
The grade level of a student.
Field Values
Character
Limitations
n/a
Other Notes
(1) - 12

Limited English Proficiency

Description
Populated when a student is "limited English proficiency," this is the type of English Language Learner (ELL) intervention.
Field Values
Character
Limitations
n/a
Other Notes
[DUL, BIH, SEI, IMT, BIN, BIW, BIT, ESL, IMP, IMS, & Null]

Native Language

Description
Populated when student is "ELL". The native language of a given student.
Field Values
Character
Limitations
n/a
Other Notes
[DUL, BIH, SEI, IMT, BIN, BIW, BIT, ESL, IMP, IMS, & Null]

Migrant Education Program

Description
Indicator for participation in the migrant education program.
Field Values
Character
Limitations
n/a
Other Notes
True/False

Mobile (moved during school year)

Description
Indicator of enrollment as less than 160 days in a given school.
Field Values
Number
Limitations
n/a
Other Notes
0/1

Student Enrolled on Dec. 1

Description
Indicator for enrollment on 12/1 of a given year in a given school.
Field Values
Number
Limitations
n/a
Other Notes
0/1

Student Enrolled on Oct. 1

Description
Indicator for enrollment on 10/1 of a given year in a given school.
Field Values
Number
Limitations
n/a
Other Notes
0/1

Reading Intervention

Description
Indicator for receipt of reading intervention in a given year.
Field Values
Character
Limitations
n/a
Other Notes
True/False

School

Description
The school that a given student is attending.
Field Values
Number
Limitations
n/a
Other Notes
1,084 current schools. Joinable to a reference table for school name.

School Year

Description
The school year of the enrollment record of a given student.
Field Values
Character
Limitations
n/a
Other Notes
Available for 2011-2017

Special Education Services

Description
Indicator for receipt of special education services.
Field Values
Character
Limitations
n/a
Other Notes
Y/N

Super Senior

Description
Indicator for a student remaining enrolled beyond expected graduation year.
Field Values
Character
Limitations
n/a
Other Notes
True/False

Youth-In-Custody

Description
Student who is in full time care of the state.
Field Values
Integer
Limitations
n/a
Other Notes
0/1. Additional data available (facility)

Zip Code of Residence

Description
Postal code of a given student's residence.
Field Values
Character
Limitations
n/a
Other Notes
538 zip codes available

504 Services

Description
Indicator for receipt of 504 services.
Field Values
Character
Limitations
n/a
Other Notes
Y/Null

Graduation

Data available for 2007-2016 unless otherwise noted.

College Ready ACT Composite (18+)

Description
Indicator of highest ACT composite score greater than or equal to 18.
Field Values
Character
Limitations
n/a
Other Notes
True/False
An indicator of college readiness.

College Ready ACT Subscores (18+)

Description
Indicator of whether a given student's highest score on the four subtests met the corresponding ACT Colllege Readiness banchmark.
Field Values
Character
Limitations
n/a
Other Notes
True/False
An indicator of college readiness.

Max Composite ACT Scores

Description
The highest composite ACT score for a given student.
Field Values
Number
Limitations
n/a
Other Notes
Range: 1-36
An indicator of college readiness.

Max ACT Subscores

Description
The highest ACT subscores in English, math, reading, or science for a given student.
Field Values
Number
Limitations
n/a
Other Notes
Range: 1-36
An indicator of college readiness.

Graduation Cohort Year

Description
Expected year of graduation for a given student.
Field Values
Number
Limitations
n/a
Other Notes
Available for 2007-2016
An indicator of college readiness.

High School Completion Status

Description
Final high school outcome for a given student.
Field Values
Character
Limitations
n/a
Other Notes
Data available for 2007-2016. 30 unique completion statuses.
An indicator of college readiness.

School Characteristics

Data available for 2004-2017 unless otherwise noted.

Institution Name

Description
Name of institution/school.
Field Values
Character
Limitations
n/a
Other Notes
Most recent year available is 2017 with 1,734 unique institutions.

Latitude & Longitude

Description
Latitude and longitude of institution/school.
Field Values
Character
Limitations
n/a
Other Notes
Most recent year available is 2017.

Address

Description
Address of institution/school.
Field Values
Character
Limitations
n/a
Other Notes
Most recent year available is 2017.

City

Description
City of institution/school.
Field Values
Character
Limitations
n/a
Other Notes
Most recent year available is 2017 with 268 unique cities.

County

Description
County of institution/school.
Field Values
Character
Limitations
n/a
Other Notes
Most recent year available is 2017 with 29 unique counties.

State

Description
County of institution/school.
Field Values
Character
Limitations
n/a
Other Notes
Most recent year available is 2017.

Zip Code

Description
Zip code of institution/school.
Field Values
Character
Limitations
n/a
Other Notes
Most recent year available is 2017 with 219 unique zip codes.

District

Description
District of institution/school.
Field Values
Character
Limitations
n/a
Other Notes
Most recent year available is 2018 with 153 unique districts.

Highest & Lowest Grades Served

Description
The highest and lowest grades a given school serves.
Field Values
Character
Limitations
n/a
Other Notes
Range: -1 - 12

Necessarily Existent Small School

Description
Indicator as to whether the school participates in the "Necessarily Existent Small Schools" program.
Field Values
Character
Limitations
n/a
Other Notes
Y/N

Rurality

Description
The rurality of a given school.
Field Values
Character
Limitations
n/a
Other Notes
[Urban, Rural, Frontier]

Title I Program

Description
Indicator for participation in Title I program.
Field Values
Number
Limitations
n/a
Other Notes
0-3

Title III Program

Description
Indicator for participation in Title I program.
Field Values
Number
Limitations
n/a
Other Notes
[0, 1, Null]
  • Other Programs
    • Career Technical Education (CTE)
      • Data available for 2010-2017.
      • Completer

        Description

        Indicator denoting if a student "completed" all required credits for a given CTE career pathway.

        Field Values

        Number

        Limitations

        n/a

        Other Notes

        0/1

      • Concentrator

        Description

        Indicator denoting if a student completed at least half of the required credits and a foundational course in a given CTE pathway.

        Field Values

        Number

        Limitations

        n/a

        Other Notes

        0/1

      • Participant

        Description

        Indicator denoting if a student completed at least one full credit in a given CTE pathway.

        Field Values

        Number

        Limitations

        n/a

        Other Notes

        0/1

    • Special Education (SCRAM)
      • Data available for 2005-2017.
      • Entry Date

        Description

        The date a given student started receiving special education services for a given disability type and time.

        Field Values

        Date

        Limitations

        n/a

        Other Notes

        ##/##/####

      • Exit Date

        Description

        The date, following the last day, the student received special education services for a given disability and time.

        Field Values

        Date

        Limitations

        n/a

        Other Notes

        ##/##/####

      • Setting

        Description

        Setting of special education services provided.

        Field Values

        Character

        Limitations

        n/a

        Other Notes

        [V, U, H, R, P, I, K, Y, M, C, T, J, S, E, F, G, Null]

      • Extended Services

        Description

        Indicator for receipt, or eligibility, of special education services during school break.

        Field Values

        Character

        Limitations

        n/a

        Other Notes

        True/False

      • Membership

        Description

        Total days of membership for a given disability type and time.

        Field Values

        Number

        Limitations

        n/a

        Other Notes

        Range: 0 - 444

      • Regular School Time

        Description

        The amount of time a given student was in regular education classes.

        Field Values

        Character

        Limitations

        n/a

        Other Notes

        [1,2,3, Null]

      • Disability Type

        Description

        The type of disability of a given student.

        Field Values

        Character

        Limitations

        n/a

        Other Notes

        [DD, OI, MD, OH, VI, CD, SL, ID, BD, AU, HI, TB, DB]

      • Exit Disposition

        Description

        The final disposition for a given disability type.

        Field Values

        Character

        Limitations

        n/a

        Other Notes

        [D, X, A, S, Null]

      • Time in Services

        Description

        The amount of services a given student for a given disability receives on a daily basis.

        Field Values

        Character

        Limitations

        n/a

        Other Notes

        [R, P, K, D, M, Q, A, B, C, J, F, E, L]

    • Student in Youth in Custody (YIC)
      • Data available for 2011-2017.
      • Custody Type

        Description

        What department of bureau has custody of a given YIC student.

        Field Values

        Character

        Limitations

        n/a

        Other Notes

        [DCFS, BOIA, DJJS]

      • Facility

        Description

        The facility that a given YIC student receives services.

        Field Values

        Number

        Limitations

        n/a

        Other Notes

        [4-8, 12-14, 18]

      • Entry Date

        Description

        The date of first receipt of YIC services.

        Field Values

        Date

        Limitations

        n/a

        Other Notes

        ##/##/####

      • Setting

        Description

        Indicates the type of setting the YIC service is being provided.

        Field Values

        Character

        Limitations

        n/a

        Other Notes

        [V, R, H, T]

      • Date of Exit

        Description

        School exit date.

        Field Values

        Date

        Limitations

        n/a

        Other Notes

        ##/##/####

      • Reason for Exit

        Description

        Reason of exit.

        Field Values

        Character

        Limitations

        n/a

        Other Notes

        [D, X, A, S, Null]

      • Neglected and Delinquent

        Description

        Indicator for receiving federally funded services under ESEA Title I Part D.

        Field Values

        Character

        Limitations

        n/a

        Other Notes

        [D, N, Null]

      • Time in Services

        Description

        The amount of services a given student receives on a daily basis.

        Field Values

        Character

        Limitations

        n/a

        Other Notes

        A-C

      • Membership Days

        Description

        Total days of service for a given custody and time.

        Field Values

        Number

        Limitations

        n/a

        Other Notes

        Range: 0 - 180

      • Student Tests & Proficiency Levels
        • Reading Grade Level
          • Data available for 2013-2017.
          • Composite Scores

            Description

            The composite score of reading grade level for a given student.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Range: 0 - 899

          • Reading Grade

            Description

            Indicator for the reading grade level.

            Field Values

            Character

            Limitations

            n/a

            Other Notes

            [AN, AY, E, N, O, S, U, Y]

          • Session of Test

            Description

            Time of year the test was administered.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            1-3

        • SAGE Student Tests
          • Data available for 2014-2017.
          • Adequate Growth Percentile (AGP)

            Description

            Performance metrics based on the student growth percentile (SGP).

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Included: Catch up target, keep up target, move up target, stay up target, and prio year proficiency comparison.

          • Course Associated with Test

            Description

            The course associated with a given test.

            Field Values

            Character

            Limitations

            n/a

            Other Notes

            152 unique courses. Included: the date of entry for course, and the section.

          • Grade Level

            Description

            Grade in which a given student in currently enrolled.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Range: 3-12

          • Participation

            Description

            How the student participated in SAGE testing, or reason for non-participation.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            [101-107, 200 - 204, 300, 301, 303, 305]

          • Proficiency Level in Prior Year

            Description

            The proficiency level of the student in the prior year.

            Field Values

            Character

            Limitations

            n/a

            Other Notes

            [1-4, Null]

          • Proficiency Level

            Description

            Indicator of proficiency in test.

            Field Values

            Character

            Limitations

            n/a

            Other Notes

            [1-4, Null]

          • Scaled Score

            Description

            The scaled score of a given student of a given test.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Range: 100 - 985

          • Student Growth Percentile (SGP)

            Description

            The student growth percentile of a given student.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Range: 1-99

          • Subject Area

            Description

            The scholastic subject area of a given test.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            [M, S, L]

          • Test Administrator

            Description

            Teacher of record.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Variable. Currently, 20,837 unique teachers available.

          • Tested Below Grade Level

            Description

            Indicator to the fact that a given student tested below grade level.

            Field Values

            Character

            Limitations

            n/a

            Other Notes

            True/False

        • Student Tests
          • Data available for 2014-2013.
          • District

            Description

            District of a given student of a given test.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            127 unique districts available.

          • Entry Date

            Description

            Date of entrance of a given student in a given school.

            Field Values

            Date

            Limitations

            n/a

            Other Notes

            ##/##/####

          • Proficiency

            Description

            The proficiency level of a given student.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Range: 1-5

          • Scaled Score

            Description

            Scaled score of test.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Range: 130-199

          • School

            Description

            School of administered test.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            1,031 unique schools available.

          • Student Growth Percentile (SGP)

            Description

            The student growth percentile of a given student.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            [1-101, Null]

          • Test Administrator

            Description

            Teacher of record.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            36,865 unique teachers available.

          • Test Medium

            Description

            Medium of test.

            Field Values

            Character

            Limitations

            n/a

            Other Notes

            [C-E, H, HS, L,M, NW, O, OS, P, PS, S, U, W, Z]

          • Non Participation

            Description

            Why student did not participate.

            Field Values

            Character

            Limitations

            n/a

            Other Notes

            [1-9, Z,C]

          • Participation

            Description

            How the student participated.

            Field Values

            Character

            Limitations

            n/a

            Other Notes

            [*, 0-5, 9, Z]

          • Test Program

            Description

            The subject area of a given test.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            531 unique tests available.

        • Utah Academic Language Proficiency Assessment (UALPA)
          • Data available for 2010-2013.
          • Grade Level

            Description

            Grade level of a given student.

            Field Values

            Character

            Limitations

            n/a

            Other Notes

            Range: 00 - 12

          • Proficiency

            Description

            The proficiency level of a given student.

            Field Values

            Character

            Limitations

            n/a

            Other Notes

            [1-5, A, E, I, N, P]

          • Scaled Score

            Description

            Scaled score of test.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Range: 46 - 481

        • WIDA Student Tests
          • Data available for 2014-2017.
          • Composite Overall Proficiency Level

            Description

            Composite of all four modalities: listening, reading, speaking, and writing.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Range: 1 - 6

          • Composite Overall Scale Score

            Description

            Scaled composite of all four modalities: listening, reading, speaking, and writing.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Range: 100 - 500

          • Comprehension Proficiency Level

            Description

            Profenciency level of the composite of listening and speaking.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Range: 1-6

          • Comprehension Score

            Description

            Composite score of listening and speaking.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Range: 100-500

          • Date

            Description

            Date of testing.

            Field Values

            Date

            Limitations

            n/a

            Other Notes

            ##/##/####

          • District

            Description

            District of a given student of a given test.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            121 unique districts available.

          • Entry Date

            Description

            Entry date of test.

            Field Values

            Date

            Limitations

            n/a

            Other Notes

            ##/##/####

          • Grade

            Description

            Grade level of a given student.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            [0-12]

          • Proficiency Level (Listening, Literacy, Oral, Reading, Speaking, or Writing)

            Description

            Level of proficiency in listening, literacy, oral, reading, speaking, or writing of a given student.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Range: 1-6

          • Scaled Score (Listening, Literacy, Oral, Reading, Speaking, or Writing)

            Description

            Scaled score of the level in listening, literacy, oral, reading, speaking, or writing of a given student.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            Range: 100-500

          • School

            Description

            School of administered test.

            Field Values

            Number

            Limitations

            n/a

            Other Notes

            902 unique schools available.

          • School Year

            Description

            School year of test.

            Field Values

            Character

            Limitations

            n/a

            Other Notes

            Available for 2014-2017.

  • Utah System of Higher Education


    Utah System of Technical Colleges