Guide d'implémentation du GT Standards et Interopérabilité pour les EDS
0.1.0 - ci-build France flag

Guide d'implémentation du GT Standards et Interopérabilité pour les EDS - 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.esante.gouv.fr/ig/fhir/eds/StructureDefinition/OMOPEpisode Version: 0.1.0
Draft as of 2025-02-02 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.

Usage:

Formal Views of Profile Content

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

NameFlagsCard.TypeDescription & Constraintsdoco
.. 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

NameFlagsCard.TypeDescription & Constraintsdoco
.. 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
NameFlagsCard.TypeDescription & Constraintsdoco
.. 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

NameFlagsCard.TypeDescription & Constraintsdoco
.. 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

NameFlagsCard.TypeDescription & Constraintsdoco
.. 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

NameFlagsCard.TypeDescription & Constraintsdoco
.. 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