Data Management with FHIR
0.1.0 - ci-build France flag

Data Management with FHIR - Local Development build (v0.1.0) built by the FHIR (HL7® FHIR® Standard) Build Tools. See the Directory of published versions

Logical Model: Episode OMOP Table

Official URL: https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPEpisode Version: 0.1.0
Draft as of 2025-10-23 Computable Name: OMOPEpisode

The EPISODE table aggregates lower-level clinical events (VISIT_OCCURRENCE, DRUG_EXPOSURE, PROCEDURE_OCCURRENCE, DEVICE_EXPOSURE) into a higher-level abstraction representing clinically and analytically relevant disease phases,outcomes and treatments. The EPISODE_EVENT table connects qualifying clinical events (VISIT_OCCURRENCE, DRUG_EXPOSURE, PROCEDURE_OCCURRENCE, DEVICE_EXPOSURE) to the appropriate EPISODE entry. For example cancers including their development over time, their treatment, and final resolution.

Usages:

You can also check for usages in the FHIR IG Statistics

Formal Views of Profile Content

Description of Profiles, Differentials, Snapshots and how the different presentations work.

NomDrapeauxCard.TypeDescription et contraintes    Filter: Filtersdoco
.. OMOPEpisode 0..* Base Episode OMOP Table
Instances of this logical model can be the target of a Reference
... episode_id 1..1 integer Episode Identifier
... person_id 1..1 Reference(Person OMOP Table) Person
... episode_concept_id 1..1 Reference(Concept OMOP Table) Episode
... episode_start_datetime 0..1 dateTime Episode Start Datetime
... episode_end_date 0..1 date Episode End Date
... episode_end_datetime 0..1 dateTime Epsisode End Datetime
... episode_parent_id 0..1 Reference(Episode OMOP Table) Episode Parent
... episode_number 0..1 integer Episode Number
... episode_object_concept_id 1..1 Reference(Concept OMOP Table) Episode Object
... episode_type_concept_id 1..1 Reference(Concept OMOP Table) Episode Type
... episode_source_value 0..1 string Episode Source Value
... episode_source_concept_id 0..1 Reference(Concept OMOP Table) Episode Source

doco Documentation for this format

This structure is derived from Base

NomDrapeauxCard.TypeDescription et contraintes    Filter: Filtersdoco
.. OMOPEpisode 0..* Base Episode OMOP Table
Instances of this logical model can be the target of a Reference
... episode_id 1..1 integer Episode Identifier
... person_id 1..1 Reference(Person OMOP Table) Person
... episode_concept_id 1..1 Reference(Concept OMOP Table) Episode
... episode_start_datetime 0..1 dateTime Episode Start Datetime
... episode_end_date 0..1 date Episode End Date
... episode_end_datetime 0..1 dateTime Epsisode End Datetime
... episode_parent_id 0..1 Reference(Episode OMOP Table) Episode Parent
... episode_number 0..1 integer Episode Number
... episode_object_concept_id 1..1 Reference(Concept OMOP Table) Episode Object
... episode_type_concept_id 1..1 Reference(Concept OMOP Table) Episode Type
... episode_source_value 0..1 string Episode Source Value
... episode_source_concept_id 0..1 Reference(Concept OMOP Table) Episode Source

doco Documentation for this format
NomDrapeauxCard.TypeDescription et contraintes    Filter: Filtersdoco
.. OMOPEpisode 0..* Base Episode OMOP Table
Instances of this logical model can be the target of a Reference
... episode_id 1..1 integer Episode Identifier
... person_id 1..1 Reference(Person OMOP Table) Person
... episode_concept_id 1..1 Reference(Concept OMOP Table) Episode
... episode_start_datetime 0..1 dateTime Episode Start Datetime
... episode_end_date 0..1 date Episode End Date
... episode_end_datetime 0..1 dateTime Epsisode End Datetime
... episode_parent_id 0..1 Reference(Episode OMOP Table) Episode Parent
... episode_number 0..1 integer Episode Number
... episode_object_concept_id 1..1 Reference(Concept OMOP Table) Episode Object
... episode_type_concept_id 1..1 Reference(Concept OMOP Table) Episode Type
... episode_source_value 0..1 string Episode Source Value
... episode_source_concept_id 0..1 Reference(Concept OMOP Table) Episode Source

doco Documentation for this format

Key Elements View

NomDrapeauxCard.TypeDescription et contraintes    Filter: Filtersdoco
.. OMOPEpisode 0..* Base Episode OMOP Table
Instances of this logical model can be the target of a Reference
... episode_id 1..1 integer Episode Identifier
... person_id 1..1 Reference(Person OMOP Table) Person
... episode_concept_id 1..1 Reference(Concept OMOP Table) Episode
... episode_start_datetime 0..1 dateTime Episode Start Datetime
... episode_end_date 0..1 date Episode End Date
... episode_end_datetime 0..1 dateTime Epsisode End Datetime
... episode_parent_id 0..1 Reference(Episode OMOP Table) Episode Parent
... episode_number 0..1 integer Episode Number
... episode_object_concept_id 1..1 Reference(Concept OMOP Table) Episode Object
... episode_type_concept_id 1..1 Reference(Concept OMOP Table) Episode Type
... episode_source_value 0..1 string Episode Source Value
... episode_source_concept_id 0..1 Reference(Concept OMOP Table) Episode Source

doco Documentation for this format

Differential View

This structure is derived from Base

NomDrapeauxCard.TypeDescription et contraintes    Filter: Filtersdoco
.. OMOPEpisode 0..* Base Episode OMOP Table
Instances of this logical model can be the target of a Reference
... episode_id 1..1 integer Episode Identifier
... person_id 1..1 Reference(Person OMOP Table) Person
... episode_concept_id 1..1 Reference(Concept OMOP Table) Episode
... episode_start_datetime 0..1 dateTime Episode Start Datetime
... episode_end_date 0..1 date Episode End Date
... episode_end_datetime 0..1 dateTime Epsisode End Datetime
... episode_parent_id 0..1 Reference(Episode OMOP Table) Episode Parent
... episode_number 0..1 integer Episode Number
... episode_object_concept_id 1..1 Reference(Concept OMOP Table) Episode Object
... episode_type_concept_id 1..1 Reference(Concept OMOP Table) Episode Type
... episode_source_value 0..1 string Episode Source Value
... episode_source_concept_id 0..1 Reference(Concept OMOP Table) Episode Source

doco Documentation for this format

Snapshot View

NomDrapeauxCard.TypeDescription et contraintes    Filter: Filtersdoco
.. OMOPEpisode 0..* Base Episode OMOP Table
Instances of this logical model can be the target of a Reference
... episode_id 1..1 integer Episode Identifier
... person_id 1..1 Reference(Person OMOP Table) Person
... episode_concept_id 1..1 Reference(Concept OMOP Table) Episode
... episode_start_datetime 0..1 dateTime Episode Start Datetime
... episode_end_date 0..1 date Episode End Date
... episode_end_datetime 0..1 dateTime Epsisode End Datetime
... episode_parent_id 0..1 Reference(Episode OMOP Table) Episode Parent
... episode_number 0..1 integer Episode Number
... episode_object_concept_id 1..1 Reference(Concept OMOP Table) Episode Object
... episode_type_concept_id 1..1 Reference(Concept OMOP Table) Episode Type
... episode_source_value 0..1 string Episode Source Value
... episode_source_concept_id 0..1 Reference(Concept OMOP Table) Episode Source

doco Documentation for this format

 

Other representations of profile: CSV, Excel