Ohio Data Sources

Data steward(s):

  • Lisa Neilson (lisa.neilson@chrr.osu.edu)

Data provider:

  • Jeremy Alexander (jeremy.alexander@chrr.osu.edu)

Coleridge Project Manager

  • Contact information to be updated
Schema Table Last Updated Frequency Notes
ds_oh_dhe cofs_app Certificate of Free Sale application data |
ds_oh_dhe dim_academic_program Academic program dimension table
ds_oh_dhe dim_campus Campus dimension table
ds_oh_dhe dim_course Course dimension table
ds_oh_dhe dim_institution Institution dimension table
ds_oh_dhe dim_ipeds_cip IPEDS CIP code dimension table
ds_oh_dhe dim_person Person dimension table
ds_oh_dhe dim_stud_person_xref Student-person crossreference table |
ds_oh_dhe fact_alt_credits Alternative credit fact table
ds_oh_dhe fact_cn_sn Course number and section number fact table |
ds_oh_dhe fact_course_enrollments Course enrollment fact table
ds_oh_dhe fact_degrees Degree completion fact table
ds_oh_dhe fact_enrollment Student enrollment fact table
ds_oh_dhe fact_sections_taught Sections taught fact table
ds_oh_dhe he_pers_locater Higher education person locator data
ds_oh_dhe nsc National Student Clearinghouse data |
ds_oh_dhe t_credential Credential tracking table
ds_oh_dhe t_credential_status Credential status tracking
ds_oh_dhe t_credential_type Credential type classifications
ds_oh_dhe t_enrollment Student enrollment tracking table
ds_oh_dhe t_enrollment_credential Enrollment-credential linkage table |
ds_oh_dhe t_student Student information table
ds_oh_djfs ladt 27 March 2024 Weekly Liable/Agent Data Transfer. UI claims filed in Ohio but other states liable to pay |
ds_oh_djfs qcew 1 April 2024 Quarterly Quarterly Census of Employment and Wages. Use this table (3 qcew tables exist in schema) |
ds_oh_djfs qcew_employers Quarterly QCEW employer-level data
ds_oh_djfs qcew_employers_olda QCEW employers OLDA (Ohio Labor Data Analytics) format |
ds_oh_djfs ras 27 March 2024 Weekly Residency Assignment System. Claims Ohio pays for. Similar to Illinois PROMIS data |
ds_oh_djfs ui_wage_by_employer_olda UI wages by employer in OLDA format |
ds_oh_djfs ui_wage_olda UI wages in OLDA format |
ds_oh_djfs vw_ui_wage_by_employer_olda_2013_2018 UI wage by employer view 2013-2018 |
ds_oh_djfs vw_ui_wage_olda_2013_2018 UI wage view 2013-2018 |
ds_oh_djfs vw_ui_wage_record_2013_present UI wage record view 2013-present |
ds_oh_djfs wage_record 1 April 2024 Quarterly Quarterly wage records. Latest version includes late-filing employers and is most accurate |
ds_oh_hei able Adult Basic and Literacy Education data |
ds_oh_hei act_high_school_lkp ACT high school lookup table |
ds_oh_hei campus_county_lkp Campus to county lookup table |
ds_oh_hei cip_to_soc_crosswalk CIP to SOC occupation crosswalk |
ds_oh_hei course_credits Course credit information
ds_oh_hei degcert_level_lkp Degree and certificate level lookup |
ds_oh_hei demo Demographic data
ds_oh_hei hei_long Higher Education Information longitudinal data
ds_oh_hei hei_state HEI state-level data
ds_oh_hei in_demand_occupations_lkp In-demand occupations lookup table |
ds_oh_hei institution_lkp Institution lookup table
ds_oh_hei naics2_codes_lkp 2-digit NAICS codes lookup |
ds_oh_hei naics3_codes_lkp 3-digit NAICS codes lookup |
ds_oh_hei otc Ohio Technical Center data
ds_oh_hei otc_county_lkp OTC county lookup table |
ds_oh_hei person Person-level data
ds_oh_hei rank_code_lkp Rank code lookup table |
ds_oh_hei rapids Registered Apprenticeship Partners Information Data System |
ds_oh_hei rapids_occ_titles RAPIDS occupation titles
ds_oh_hei rapids_suppl RAPIDS supplemental data
ds_oh_hei region_county_lkp Region to county lookup table |
ds_oh_hei region_lkp Region lookup table |
ds_oh_hei subject_codes_lkp Academic subject codes lookup |
ds_oh_hei tenants Tenant information data
ds_oh_hei vr Vocational Rehabilitation data
ds_oh_hei vr_appl Vocational Rehabilitation applications
ds_oh_lccc academic_programs Lorain County Community College academic programs |
ds_oh_lccc leap_credentials LEAP (Learning Earns Achievement Program) credentials |
ds_oh_lccc pdp_cohort Professional Development Program cohort data
ds_oh_lccc pdp_course Professional Development Program course data
ds_oh_mtc academic_programs Marion Technical College academic programs |
ds_oh_mtc cohort Student cohort tracking data
ds_oh_mtc credential Credential and certification data
ds_oh_mtc graduates Graduate tracking and outcomes data
ds_oh_mtc pdp_course Professional Development Program course information