Data Management with FHIR
0.1.0 - ci-build

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:

- Refer to this Logical Model: Episode OMOP Table and Episode Event OMOP Table

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.

- Key Elements Table
- Differential Table
- Snapshot Table
- Statistics/References
- All

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
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_date |  | 1..1 | date | Episode Start Date
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
Documentation for this format

This structure is derived from Base

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
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_date |  | 1..1 | date | Episode Start Date
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
Documentation for this format

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
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_date |  | 1..1 | date | Episode Start Date
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
Documentation for this format

This structure is derived from Base

Résumé

Mandatory: 0 element(6 nested mandatory elements)

Structures

This structure refers to these other structures:

- Person OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPPerson)
- Concept OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPConcept)
- Episode OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPEpisode)

Key Elements View

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
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_date |  | 1..1 | date | Episode Start Date
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
Documentation for this format

Differential View

This structure is derived from Base

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
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_date |  | 1..1 | date | Episode Start Date
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
Documentation for this format

Snapshot View

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
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_date |  | 1..1 | date | Episode Start Date
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
Documentation for this format

This structure is derived from Base

Résumé

Mandatory: 0 element(6 nested mandatory elements)

Structures

This structure refers to these other structures:

- Person OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPPerson)
- Concept OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPConcept)
- Episode OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPEpisode)

Other representations of profile: CSV, Excel