Claude

IntuitionLabs is now a member of the Claude Partner Network – AI training and upskilling with Claude for pharma and biotech. Book a call.

IntuitionLabs
Back to Articles
IntuitionLabs

fhir to omop mapping · fhir to omop crosswalk

FHIR to OMOP Mapping: Loss-Aware Crosswalk and Validation

October 13, 2026
22 min read

A 2026 implementation reference for FHIR to OMOP mapping: resource and field crosswalks, terminology and time-precision loss, reconciliation metrics, and an analysis-specific validation and acceptance protocol.

FHIR to OMOP Mapping: Loss-Aware Crosswalk and Validation
Summary
  1. 01Approve FHIR-to-OMOP mapping for a defined cohort, exposure, outcome, and time window, with a documented loss register and study-specific acceptance tests.
  2. 02Pin the mapping publication, actual source FHIR release and profiles, target CDM schema, and vocabulary release as a tested combination.
  3. 03Validate clinical meaning separately from destination placement, including medication evidence type, observation components, units, status, identity linkage, and temporal precision.
  4. 04Retain source identity and transformation history externally where needed. Sidecars improve traceability but do not make analytical records inherently reversible.
  5. 05Reported forward and reverse coverage concern selected mapped structures and synthetic examples. They do not establish clinical correctness or a universal success threshold.
  6. 06Review vocabulary permissions independently, including deployment territories, redistribution, and restrictions on included source content.
01

Executive Summary

FHIR to OMOP mapping is a controlled transformation from exchange-oriented clinical resources into analysis-oriented tables and standardized concepts. Fast Healthcare Interoperability Resources (FHIR) and the Observational Medical Outcomes Partnership Common Data Model (OMOP CDM) serve different purposes: interoperability and exchange versus research analytics. A useful crosswalk therefore specifies which meaning an observational analysis needs, where that meaning lands, and what remains outside the target representation. ([1]) A mapping should be accepted for a defined cohort, exposure, outcome, and time window, with a documented loss register, rather than certified as generically lossless. European Medicines Agency (EMA) guidance explicitly recognizes that transformation to a common data model can introduce information loss. ([2])

The version baseline matters. Reviewed on October 13, 2026, the permanent HL7 mapping publication identifies 1.0.0, INFORMATIVE 1, while the continuous build identifies 2.0.0-ballot and states that it is not an authorized publication. ([3]) ([4]) ([5]) The build describes output conforming to CDM 5.4, although OHDSI now identifies 5.5 as current. ([6]) ([7]) These facts require a version manifest, not an assumption that the newest source page, schema, and vocabulary form one tested combination. The manifest should include the declared source profiles and actual FHIR resource release.

The strongest quantitative example reviewed here reports 74% forward mapping coverage and approximately 23% reverse coverage. Those are implementation-specific mapping measures, not clinical accuracy, production yield, or evidence that arbitrary records can be reconstructed. ([8]) ([9]) This report supplies a resource-to-field crosswalk, accountable owners, reconciliation formulas, and an acceptance matrix. The proposed controls are editorial implementation choices; their thresholds must come from the study’s needs and source expectations.

The practical decision is whether critical information survives with its clinical meaning. Identity linkage, encounter context, medication evidence type, component observations, units, event status, and temporal precision require separate tests. Unknown modifier extensions need rejection or quarantine because they can change meaning. ([10]) Vocabulary permissions also require an independent review: inclusion in a terminology distribution does not automatically authorize all third-party content. ([11]) A release is fit for its proposed use only when required mappings are verified, unresolved ambiguities have explicit dispositions, and the study owner accepts the remaining loss.

74%

TermX FHIR-to-OMOP mapping coverage, based on an implementation and synthetic examples

23%

Approximate TermX reverse mapping coverage, based on an implementation and synthetic examples

02

Introduction and Background

Real-world evidence (RWE) platforms often need both clinical exchange and reproducible observational analysis. FHIR supplies resource-based clinical information; OMOP supplies a common analytical representation. Vulcan describes its FHIR-to-OMOP project as a collaboration between HL7 and Observational Health Data Sciences and Informatics (OHDSI). ([12]) The distinction between their roles explains why a successful exchange interface does not, by itself, establish that the resulting research database is suitable for a particular study. ([1])

Mapping, in this report, includes structural placement, terminology translation, value normalization, event selection, and preservation of context. Extract, transform, load (ETL) includes those decisions plus ingestion, identity resolution, incremental processing, and loading. The HL7 guide supplies logical models and StructureMaps for transformations, offering a shared technical baseline. ([13]) This report adds an explicit analysis-purpose acceptance method around that baseline. It does not claim that every local extension or clinical workflow already has an agreed community mapping.

For pharmaceutical teams, the useful question is whether transformations preserve the evidence needed to identify eligible people, distinguish exposure from ordering, and locate outcomes in time. The US Food and Drug Administration (FDA) discusses data reliability through accuracy, completeness, and traceability in its electronic-health-record and claims guidance. ([14]) EMA similarly frames dataset quality assessment as guidance and recommendations. ([15]) Neither observation establishes that a particular converter or draft mapping artifact is regulator-endorsed.

IntuitionLabs’ relevant perspective is that of an adjacent data-engineering and implementation consultancy. Its service description covers pipelines, integration, warehousing, and business intelligence. ([16]) Its stated information-foundation approach includes identity, permissions, evaluation, and accountable operation. ([17]) Here, that perspective informs the proposed ownership and evidence controls. It supplies no proprietary conversion benchmark, private deployment result, or competing software product. Readers should use the crosswalk to define a reviewable transformation contract and then test that contract against their own source profiles and analysis requirements.

03

Key Changes: From Conversion Rules to an Analysis Contract

Pin the publication, resource release, and target schema

The most consequential change in implementation practice is to treat the mapping baseline as a versioned dependency. The published informative artifact and the changing ballot build must be distinguished. ([3]) ([5]) The reviewed guide package identifies a FHIR release, but that does not establish the release of incoming clinical resources. Official US Core ecosystem documentation describes US Core as built on FHIR R4, with versions corresponding to particular US Core Data for Interoperability (USCDI) releases. ([18]) ([19]) A pipeline cannot infer source field names or validation rules solely from the guide’s publication package.

The target deserves the same treatment. CDM 5.5 adds seven optional fields and three vocabulary-metadata tables, with no fields or tables removed or renamed in the documented release. ([20]) ([21]) ([22]) Compatibility still needs to be demonstrated for the selected loader, mappings, quality checks, and study code. The guide’s declared 5.4 output is a separate version statement. ([6])

Define the minimum retained meaning

Before implementation, the proposed transformation contract should contain:

  • Analysis: cohort definition, exposure interpretation, outcome definitions, and exclusions.
  • Source: FHIR release, profile canonical URLs and versions, extension definitions, and reference-resolution rules.
  • Target: CDM schema, vocabulary distribution, terminology services, and mapping package identifiers.
  • Identity: person-linkage scope, encounter identifiers, duplicate resolution, and update behavior.
  • Time: event-date hierarchy, precision requirements, timezone policy, and permitted derivations.
  • Loss: retained fields, sidecar fields, excluded records, and unresolved meanings.
  • Acceptance: study-specific tests, named approvers, and conditions requiring a blocked release.

These are proposed implementation controls. The reviewed continuous build starts with International Patient Access (IPA) profiles plus Encounter and Procedure profiles from US Core STU7, and says implementers must declare accepted inputs. ([23]) A critical consequence is that an unrecognized source profile cannot silently inherit a mapping validated for a different profile.

Identity provides a concrete example. The published Encounter map recommends independent integer keys and an external linkage table connecting them to original FHIR identifiers. ([24]) The analytical identifier is therefore not a replacement for the original source identity. The OMOP specification also requires an available birth year for PERSON. ([25]) The contract must state the disposition of a source patient without that information, rather than invent a birth year to satisfy a load constraint.

“

A clean destination row can still carry the wrong evidence type or date.

04

Resource-to-Table Crosswalk

The following crosswalk is an implementation design reference, not a claim that every listed resource has a complete executable mapping in the current guide. The guide demonstrates component-observation expansion. ([26]) Some routes below require local rules, especially medication evidence and document processing.

Table 1 summarizes candidate destinations, vocabulary decisions, expected expansion, reversibility, checks, and ownership. Cardinality describes the proposed transformation’s output relationship, not a universal count for every FHIR resource. “Conditional” reversibility requires original source data and lineage. The abbreviated SQL predicates are review checks to adapt to the deployed schema and staging tables.

T.01
Resource and target fieldsTransform and vocabularyCardinality and loss classReversibilityValidation query or assertionAccountable owner
Patient → PERSON.person_id, year_of_birthResolve people before allocating stable keys; keep identifiers externally. Patient-to-Person is documented. ([27])Many source identities may resolve to a person; identity ambiguity is conditional loss.Conditional, with linkage and original demographics.SELECT person_id, COUNT(*) FROM person GROUP BY person_id HAVING COUNT(*)>1 plus independent linkage review.Identity lead
Encounter → VISIT_OCCURRENCE.visit_occurrence_id, person_id, dates; VISIT_DETAIL when justifiedDefine encounter grouping and preserve the source-to-target key relationship externally. ([24])Source encounters may be split or grouped by declared local rules; encounter-context loss.Conditional; grouping alone does not reconstruct source encounters.Anti-join visits against PERSON; compare expected encounter dispositions with loaded visits.Clinical ETL lead
Condition → CONDITION_OCCURRENCE.condition_concept_id, start date, source fieldsResolve vocabulary domain and distinguish clinical onset from documentation time. ([28]) Rule-out diagnoses should not populate this table. ([29])Exclusion or domain-dependent output; status and onset ambiguity.Conditional; original verification and date evidence required.WHERE condition_end_date < condition_start_date; audit the fallback-date flag.Clinical informatician
MedicationStatement and other medication evidence → DRUG_EXPOSURE.drug_concept_id, dates, drug_type_concept_idSeparate reported use, prescriptions, dispensing, and administrations. The reviewed executable map excludes MedicationRequest. ([30])Potential exclusion or vocabulary expansion; evidence-type loss if merged.Conditional; ordering cannot reconstruct administration.Group staging evidence by resource type and disposition; reconcile resulting exposures separately.Pharmacoepidemiologist
Procedure → PROCEDURE_OCCURRENCE.procedure_concept_id or domain-appropriate MEASUREMENT/OBSERVATIONRoute by the target standard concept’s domain. ([31])Domain-dependent output; planned or absent events require explicit handling.Conditional; clinical event state must survive externally if omitted.Compare resolved concept domain with destination table; audit excluded event states.Procedure-domain owner
Observation → MEASUREMENT.measurement_concept_id, value_as_number, value_as_concept_id, unit fields, rangesPreserve code, value semantics, components, and units; review the target standard concept domain. ([32])Component observations can expand into multiple measurements. ([26]) Numeric and context loss remain possible.Conditional; a component row does not reconstruct its parent resource.Anti-join component lineage against measurements; compare value and unit pairs before and after transformation.Laboratory informatician
Other Observation → OBSERVATION.observation_concept_id, value fields, datesSelect the destination from clinical meaning and vocabulary domain rather than resource name alone. Standard concepts have a single domain. ([32])Domain-dependent; coded-value and contextual ambiguity.Conditional; retain original codings and value type.Audit concept-domain mismatches and contradictory source codings.Terminology lead
Specimen → SPECIMEN.specimen_concept_id, specimen_date, source fieldsRetain sample identity and collection evidence. OMOP describes biological samples; FHIR collection time is optional. ([33]) ([34])Policy-dependent admission when collection time is missing; sample-context loss.Conditional; handling and collection details may need a sidecar.WHERE specimen_date IS NULL; reconcile exclusions against staged samples.Specimen-data owner
DocumentReference or clinical text → NOTE.note_text, date, type; NOTE_NLP only after extractionResolve attachment access and preserve reference/document provenance separately. ([35]) ([36])Attachment- and extraction-dependent; document structure and provenance loss.Conditional; extracted terms do not recreate the document.Compare attachment dispositions with loaded note hashes; separately validate extracted assertions.Document-processing lead

This table makes destination selection and meaning preservation separate review tasks. A clean destination row can still carry the wrong evidence type or date. FHIR distinguishes administration from ordering and dispensing; those distinctions must inform local exposure rules. ([37]) Likewise, a lab result’s identity includes more than a display name: LOINC distinguishes properties such as sample, scale, and method. ([38]) The table’s owners should approve both the clinical interpretation and the corresponding validation evidence.

05

Terminology, Values, and Vocabulary Permissions

Keep source codes and analytical concepts distinct

Standard-concept coverage measures successful translation into the selected OMOP analytical vocabulary. It is different from preserving the source’s original coding. OMOP source-concept fields describe the terminology and concept used in the original data; standard concepts carry domain assignments that inform target placement. ([39]) ([32]) The proposed mapping record should retain original coding system, code, display, version, all competing codings, chosen concept, relationship used, and the reason for any rejection.

A single CodeableConcept can contain alternative representations. The pipeline should not count every coding as an independent clinical event. As an implementation choice, it should select a documented preferred representation and record unresolved disagreement. Vocabulary release changes can alter mappings and standard-concept properties, so the release belongs in lineage rather than being treated as a background service detail. ([40]) Review should focus on study-relevant concepts as well as aggregate coverage. ([41])

Normalize values with their clinical identity

Logical Observation Identifiers Names and Codes (LOINC) expresses observation names through component, property, time, sample or system, scale, and method where relevant. ([38]) The method axis helps distinguish measurements that other axes do not distinguish sufficiently. ([42]) Consequently, matching test display text alone is an inadequate proposed normalization rule.

The Unified Code for Units of Measure (UCUM) supports unambiguous exchange of quantities and units. ([43]) Dimensional compatibility does not establish that unit expressions are equal, and arbitrary units can depend on the measurement procedure. ([44]) ([45]) The proposed value rules should therefore include:

  • Quantity: transform the number and unit together, keeping the original pair.
  • Comparator: preserve less-than or greater-than meaning instead of turning a bound into an exact value.
  • Reference interval: apply any verified conversion to the interval as well as the result.
  • Assay context: block unsupported conversions when comparability depends on method.
  • Coded result: retain the chosen coded value and the original alternatives.
  • Missing result: distinguish absent information from an explicit clinical negative.

These are implementation recommendations, not a universal conversion catalog. Unit preservation should be verified with the selected assay and transformation rules; the implementation should not assume that similarly named tests are interchangeable.

Review vocabulary permissions separately

LOINC permits commercial and noncommercial use under its terms, while inclusion of third-party material does not automatically grant permission for that material. ([46]) ([11]) UCUM likewise provides a conditional no-charge license. ([47]) SNOMED International describes no-charge licensed use in Member territories and possible charges in non-Member territories; its vendor guidance requires Affiliate or sublicense status and notes additional Member requirements. ([48]) ([49]) ([50]) ([51])

The US National Library of Medicine (NLM) does not charge for RxNorm licensing, but source-provider content may require additional permissions. ([52]) ([53]) Unified Medical Language System (UMLS) terms also recognize additional source restrictions. ([54]) The proposed control is a vocabulary-permission inventory covering deployment territories, redistribution, and included source content. Mapping a code into OMOP does not, by itself, settle those underlying permissions.

06

Status, Time, and Provenance: Maintain a Loss Register

Treat clinical state as part of the event

The loss register should treat recognized modifier extensions as potentially consequential to event meaning. The guide says data containing unrecognized modifier extensions must not be processed. ([10]) The proposed loss register should identify whether each recognized modifier changes event selection, value interpretation, or destination placement. Non-modifier extensions should also have an explicit disposition when the analysis depends on their content.

Status policies need resource-specific review. A procedure marked not-done must not become a procedure occurrence under the reviewed guidance. ([55]) Medication-state filters therefore need a pinned acceptance matrix and resource-specific test cases. A prescribing timestamp describes a prescriptive event rather than actual medication initiation. ([56]) Implementers should resolve the build’s inconsistent medication-status instructions against a pinned rule set and explicit test cases before accepting that branch.

The loss register proposed here uses these classes:

  • Preserved: clinical meaning survives in declared target fields and verified mappings.
  • Normalized: meaning survives through a documented code, unit, or value transformation.
  • Externally retained: meaning needs source storage or a linked sidecar for reconstruction.
  • Derived: a target value is inferred under a named, approved rule.
  • Ambiguous: competing interpretations remain unresolved and affect acceptance.
  • Excluded: a resource or element is intentionally omitted with an accountable disposition.

For every entry, record the source path, target path, rule version, affected analysis variable, reversibility, owner, and acceptance decision. These classes are editorial controls rather than official OMOP categories.

Preserve the distinction between event time and available precision

The guide identifies that OMOP lacks a standard mechanism for original temporal-precision metadata. ([57]) The target specification recommends leaving missing datetimes null. ([58]) Consequently, a year-only birth date or date-only event must not silently acquire the same evidentiary precision as a timestamp. A timezone-normalization policy should retain the original offset and lexical value outside the core representation when needed for reconstruction.

Repeated observations need equally explicit rules: distinguish separate clinical events from successive versions of the same resource. The proposed event identity combines source namespace, resource identity, version or update evidence, and component identity. World Wide Web Consortium (W3C) PROV represents revisions as new entities related to earlier revisions, providing a useful lineage pattern. ([59]) Reprocessing, correction, and replacement should have declared effects on active analytical rows.

Preserve production history, not just resource identifiers

PROV describes provenance through entities, activities, and people, including transformation activities that create entities. ([60]) ([61]) USCDI provenance separately describes who created data and when. ([62]) FHIR DocumentReference also distinguishes provenance of the reference from provenance of the referenced document. ([36]) A proposed sidecar should therefore retain authorship, source version, transformation run, rule and vocabulary versions, disposition, and target keys. That sidecar improves traceability; it does not make a transformed analytical record inherently reversible.

07

Implementation Considerations and Process Changes

The pipeline should produce evidence at structural, semantic, and analysis levels. EHDEN describes the Data Quality Dashboard (DQD) as evaluating and communicating OMOP instance quality, organized around conformance, completeness, and plausibility. ([63]) ([64]) These dimensions complement source-level validation and sponsor-specific interpretation checks.

The following proposed process gives each release a reviewable record:

  • Ingest: retain source Bundles or equivalent immutable snapshots and their manifests.
  • Validate source: test declared release and profile constraints, extensions, and reference resolution.
  • Resolve identity: separate person linkage from target-key allocation and keep linkage evidence.
  • Resolve terminology: record accepted, unmapped, ambiguous, and invalid mappings by study variable.
  • Transform: apply versioned status, date, domain, component, and value rules.
  • Reconcile: assign each source resource a disposition and an expected target-row expansion.
  • Validate target: run the matching CDM structural and terminology checks.
  • Validate analysis: compare cohort membership, exposure interpretation, and outcome timing with source evidence.

The guide allows explicit rejection or quarantine for profile-invalid inputs. ([65]) In related transformation research, a pipeline reads destination capabilities and validates generated records before writing them. ([66]) ([67]) Those practices support a proposed boundary between accepted inputs and clinically interpretable outputs, although that study is not a benchmark for this FHIR-to-OMOP pipeline.

DQD’s current index describes over 20 parameterized check types that generate individual checks, rather than a fixed universal checklist. ([68]) Run the configured version against the actual target CDM version. ([69]) Domain validation and missing-concept validation answer different questions: a domain check can exclude concept zero from its numerator, so passing it does not demonstrate successful terminology mapping. ([70]) Source-linked optional concept fields may still count as incomplete when their source value exists. ([71])

Table 2 proposes an acceptance matrix. Its decisions depend on the named analysis and documented evidence; it supplies no universal numerical tolerance.

T.02
DecisionEvidence requiredAccountable acceptance
GoCritical variables retain defined meaning; dispositions reconcile; study-level comparisons support the intended analysis.Study lead and data owner approve the release.
Go with mitigationA limitation is bounded, externally retained, or handled through an approved restriction or sensitivity analysis.Clinical owner approves the mitigation and affected analyses.
HoldA critical terminology mapping, date rule, or identity ambiguity remains unresolved.Domain owner supplies evidence before release.
Block for this purposeUnknown meaning or unavailable essential evidence prevents interpretation of a required study variable.Study lead records the reason and any narrower permitted use.

The matrix separates loading success from study readiness. OHDSI recommends study-specific quality assessments and reviewing concepts most relevant to the study. ([72]) ([41]) EMA notes that plausibility checks cannot fully replace validation against primary source records. ([73]) A release should therefore include source review or adjudication appropriate to the critical variables, rather than equating a clean dashboard with clinical fidelity.

F.01
Proposed process for a reviewable release record
01Retain and validate source

Retain immutable source snapshots and manifests; test declared release and profile constraints, extensions, and reference resolution.

02Resolve identity and terminology

Separate person linkage from target-key allocation. Keep linkage evidence and record accepted, unmapped, ambiguous, and invalid mappings by study variable.

03Transform

Apply versioned status, date, domain, component, and value rules.

04Reconcile

Assign each source resource a disposition and an expected target-row expansion.

05Validate target

Run the matching CDM structural and terminology checks.

06Validate analysis

Compare cohort membership, exposure interpretation, and outcome timing with source evidence.

F.02
Proposed acceptance decisions for a defined analysis
Go or go with mitigation
  • Go: critical variables retain defined meaning, dispositions reconcile, and study-level comparisons support the intended analysis.
  • Go with mitigation: a limitation is bounded, externally retained, or handled through an approved restriction or sensitivity analysis.
Hold or block for this purpose
  • Hold: a critical terminology mapping, date rule, or identity ambiguity remains unresolved.
  • Block for this purpose: unknown meaning or unavailable essential evidence prevents interpretation of a required study variable.

Decisions depend on the named analysis and documented evidence. The matrix supplies no universal numerical tolerance.

“

Consequently, a year-only birth date or date-only event must not silently acquire the same evidentiary precision as a timestamp.

08

Data Analysis and Evidence

Interpret published coverage with its denominator

The reviewed TermX paper reports 74% FHIR-to-OMOP coverage and approximately 23% reverse coverage, based on a mapping implementation and synthetic examples. ([8]) ([9]) These figures concern selected mapped structures, not a representative patient population. The authors acknowledge incomplete concept-based semantic testing. ([74])

These results support a cautious conclusion: forward coverage cannot be interpreted as reverse reconstruction or clinical correctness. They do not supply a universal success threshold. A separate study using data from two institutions evaluates legacy-data-to-FHIR transformation; it supports provenance and validation practices, but it is not a FHIR-to-OMOP performance estimate. ([75]) ([76])

Use explicit denominators for local measurements

Table 3 defines proposed metrics. The eligible population and required fields must be declared before measurement. Every percentage is calculated within that declaration, with exclusions reported alongside it.

T.03
MetricCalculationInterpretation and owner
Mapped-field coverageRequired source-field instances with approved target or sidecar representation ÷ eligible required source-field instances × 100Excludes optional fields only by prior declaration. Clinical mapping owner reviews critical-field failures.
Unmapped-extension countCount extension instances with no approved interpretation or disposition; also report distinct canonical URLsSeparate unknown modifiers from non-modifier extensions. Profile owner approves dispositions.
Standard-concept coverageEligible coded events assigned valid standard concepts in the expected domain ÷ eligible coded events × 100Publish domain, source-system, and study-variable strata. Terminology owner checks unmapped and ambiguous events.
Row-count reconciliationLoaded rows minus the sum of expected output rows across admitted source resourcesExpected expansion includes components and declared vocabulary routing. ETL owner investigates each unexplained difference.
Temporal-precision downgradeRetained events whose target representation has lower time precision ÷ eligible retained events × 100Record original precision and affected study windows. Study lead assesses consequence.
Round-trip non-reversibilityAudited source elements that cannot be reconstructed equivalently ÷ audited source elements × 100Distinguish reconstruction from core tables alone versus core plus retained source. Lineage owner defines equivalence.

The metrics are proposed reporting definitions, not a published standard. DQD’s completeness checks count missing field values, and its guidance recommends thresholds customized to source expectations. ([77]) ([78]) Standard-concept reporting should likewise distinguish genuine missing units from failed mappings: unitless measurements should have null unit concepts rather than concept zero in the reviewed check guidance. ([79])

Synthetic pipeline check (Hypothetical Example)

An illustrative in-memory test could use a synthetic collection Bundle containing a Patient, an Encounter, a component blood-pressure Observation, and an Observation with an unknown modifier. The proposed setup would use a constrained OMOP-shaped SQLite schema subset to enforce person and visit references. Expected behavior to test would include creation of a person, a visit, and separate systolic and diastolic measurements, quarantine of the unknown modifier, and retention of component lineage. A replay assertion should require that reprocessing the admitted observation adds no rows. This example describes a proposed test design and expected behavior, not reported execution results, production measurements, or full FHIR-profile/CDM validation.

The expansion rule follows the guide’s documented component pattern. ([26]) The quarantine rule follows its unknown-modifier guidance. ([10]) The proposed checks should cover foreign-key linkage, component expansion, replay behavior, and exclusion disposition. A deployment should extend these tests to its actual schema, profiles, source codings, status rules, and date derivations. OHDSI recommends synthetic ETL unit tests alongside wider quality assessment. ([80])

F.03
Reported forward and reverse mapping coveragePercent coverage of selected mapped structures
Source: TermX paper
09

Implications and Future Directions

The chief implication for RWE platform owners is that fitness for purpose belongs to a release and an analysis, not merely to a converter. FDA’s EHR and claims guidance is dated July 2024 and recommends model-conformance checks and documented transformation practices that preserve meaning and context. ([81]) ([82]) ([83]) EMA published the final RWD chapter of its medicines-regulation data-quality framework on March 27, 2026, and recognizes possible loss through common-data-model transformation. ([84]) ([2]) These sources justify attention to transformation evidence; they do not establish a universal FHIR-to-OMOP mapping mandate.

Future implementation work should distinguish community-guide progress from site-specific analytic validation. A version upgrade should trigger a targeted impact review of changed concepts, resource paths, status logic, time derivations, and target schema. The proposed release evidence should include:

  • Manifest: immutable mapping identifiers, source-profile packages, target schema, and vocabulary release.
  • Loss register: critical fields, disposition, reversibility, affected analyses, and accountable owner.
  • Quality results: structural failures, terminology gaps, reconciliation differences, and study-specific comparisons.
  • Change assessment: differences against the previous approved release and required reruns.
  • Acceptance record: approved purposes, mitigations, restrictions, and unresolved items.

Provenance formats such as PROV offer a standards-based way to represent transformation history and revisions. ([85]) ([59]) USCDI authorship metadata can contribute source context, but target row identifiers alone do not capture who created or revised the information. ([86]) The proposed evidence package should preserve both source authorship and pipeline activity.

An OMOP analytical dataset also does not replace every other research representation. Clinical Data Interchange Standards Consortium (CDISC) limits its cited observational-study implementation guidance to Study Data Tabulation Model (SDTM) scope and publishes example LOINC-to-laboratory mappings for that representation. ([87]) ([88]) Those are separate transformation contracts. IntuitionLabs’ stated focus on accountable information operation is consistent with the ownership model proposed here, but this report claims no private validation evidence or proprietary mapping results. ([17])

10

Conclusion

FHIR-to-OMOP mapping should be approved as an analysis-specific transformation with declared loss. The distinction between exchange and analytics explains why an apparently complete set of target tables can still lack context needed for an observational study. ([1]) The useful deliverable is a pinned mapping contract, a field-level crosswalk, a loss register, and evidence that important clinical meaning survives in the selected target representation.

The acceptance decision should address four questions:

  • Identity: can each analytical person and event be linked to the correct source evidence?
  • Meaning: do codes, values, units, statuses, and medication evidence represent the intended clinical facts?
  • Time: do event dates and retained precision support the cohort and outcome windows?
  • Evidence: can the owners explain exclusions, transformations, ambiguities, and limitations for this release?

Acceptance should include a source-profile declaration; external identifier linkage is a documented part of the mapping approach. ([24]) For interpretation, general quality checks should be supplemented by study-specific assessment. ([72]) Information loss and reverse reconstruction need independent measurement, because a forward coverage result cannot settle either question. ([2])

The proposed decision framework allows acceptance, mitigation, a hold, or blocking for a particular purpose. It deliberately leaves thresholds to the source expectations and study requirements. Vocabulary permissions remain a separate dependency, including additional restrictions associated with some source content. ([54]) The resulting release record should make every consequential choice inspectable: what was preserved, normalized, derived, retained externally, excluded, or left unresolved, and who accepted its effect on the analysis.

The publisher

About IntuitionLabs

Build practical AI for pharma and biotech with IntuitionLabs. We help life-science teams turn complex information and workflows into useful software, governed knowledge systems and AI tools.

IntuitionLabs is an AI consulting, custom software development and data engineering firm serving pharmaceutical, biotechnology, medical-device and other life-science organizations. We work with clinical, regulatory, medical-affairs, commercial, quality and IT teams to connect technology decisions with the work people need to accomplish.

AI consulting and adoption

Our AI enablement services cover readiness assessments, use-case selection, governance and policies, team workshops, adoption measurement and ongoing advisory support. We help organizations structure the information layer behind AI: source material, context, permissions and maintained knowledge that make generated answers useful and reviewable. Private LLM inference and hosted AI options support teams evaluating how to operate AI with appropriate control over their data and infrastructure.

Software, data and life-science workflows

IntuitionLabs develops custom software for pharma and biotech, integrates enterprise systems, and builds data engineering and business intelligence solutions. Areas of focus include AI agents, regulatory research, medical writing, medical affairs, CMC information, competitive intelligence and clinical-document workflows. Our eTMF intelligence work includes cross-system reconciliation and inspection-readiness support.

Enterprise platforms and regulated delivery

We provide Veeva services, application support, managed services, integrations and custom applications, alongside enterprise content work involving platforms such as Egnyte. For regulated workflows, our services include GxP enablement, computer-system validation and software development addressing 21 CFR Part 11 requirements. The applicable controls, validation responsibilities and acceptance criteria are defined for each engagement.

Work with IntuitionLabs

Explore AI enablement, pharma and biotech software development, data engineering and BI, and Veeva services. Contact IntuitionLabs to discuss your workflow, information sources and implementation needs.

IntuitionLabs publishes educational research to help life-science teams make informed technology decisions. Coverage of a product or organization does not imply a client relationship, endorsement or partnership.

Sources / 88
Adrien Laurent

Need Expert Guidance on This Topic?

Let's discuss how IntuitionLabs can help you navigate the challenges covered in this article.

I'm Adrien Laurent, Founder & CEO of IntuitionLabs. With 25+ years of experience in enterprise software development, I specialize in creating custom AI solutions for the pharmaceutical and life science industries.

Disclaimer

The information contained in this document is provided for educational and informational purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability, or availability of the information contained herein. Any reliance you place on such information is strictly at your own risk. In no event will IntuitionLabs.ai or its representatives be liable for any loss or damage including without limitation, indirect or consequential loss or damage, or any loss or damage whatsoever arising from the use of information presented in this document. This document may contain content generated with the assistance of artificial intelligence technologies. AI-generated content may contain errors, omissions, or inaccuracies. Readers are advised to independently verify any critical information before acting upon it. All product names, logos, brands, trademarks, and registered trademarks mentioned in this document are the property of their respective owners. All company, product, and service names used in this document are for identification purposes only. Use of these names, logos, trademarks, and brands does not imply endorsement by the respective trademark holders. IntuitionLabs.ai is an AI software development company specializing in helping life-science companies implement and leverage artificial intelligence solutions. Founded in 2023 by Adrien Laurent and based in San Jose, California. This document does not constitute professional or legal advice. For specific guidance related to your business needs, please consult with appropriate qualified professionals.

Related Articles

Need help with AI?

© 2026 IntuitionLabs. All rights reserved.