The v1.1.0 release of the Fred Hutch OMOP CDM builds on the first full build of the core OMOP tables by adding new tables (care_site, provider, note, and fact_relationship), updating vocabulary and improving visit mapping and vocabulary management, and syncing data refreshes with the Data Quality Dashboard (DQD).

User Impacts

  • Users may now query information about care sites and see care sites/locations for each visit.
  • Clinical data tables can now be joined on the provider table.
  • Unstructured text from clinical notes is now available.
  • Mapping to the visit_type_concept_id more accurately reflects the type of visit that took place.
  • Data quality monitoring is automatically refreshed and summarized in a dashboard.

Details

  • The care_site table was added. Departments and places of service are now available in this table.
    • Care sites were added to the location table
    • The care_site_id column is now populated in the visit_occurrence table
    • The location_id column is now populated in the person table, representing a person’s main care site location
  • The fact_relationship table was added to map relationships between departments and places of service.
  • The provider table was added. Provider information (physicians, nurses, and other clinical staff) is in this table.
    • The provider_id column is now populated in the condition_occurrence, drug_exposure, measurement, note, procedure_occurrence, and visit_occurrence tables.
    • The provider_id column is now populated in the person table, representing a patient’s primary care doctor
  • The note table was added. Clinical notes from Clarity’s HNO_NOTE_TEXT table are available in this table.
  • Visit mapping was improved by adding more detailed visit mapping rules for emergency departments, lab departments, home health, and non-hospital institution visits.
  • The vocabulary was updated to v20260829, now utilizing drug_stength vocabulary from Athena
  • New custom vocabulary mappings were added for Epic provider type to standard provider concepts; Epic note types to standard LOINC note concepts; and from Epic places of service to standard place of service concepts.
  • TakePART-NW consent data was updated and the pipeline was updated to reflect changes in research workspace catalog naming conventions.
  • Job and refresh orchestration improvements were made, including adding a task to update DQD when data is refreshed in curated_omop.

Current Limitations

provider table: Information about a provider’s speciality (specialty_concept_id) is not currently available. This will be incorporated when source data from Clarity is ingested on CARDS.

procedure_occurrence table: Radiation oncology records are underrepresented due limitations in how source data is mapped to standard concepts. This will be addressed in the next release by integrating records from hospital account data.