# Episode OMOP Table - Data Management with FHIR v0.1.0

* [**Table of Contents**](toc.md)
* [**Artifacts Summary**](artifacts.md)
* **Episode OMOP Table**

## 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](StructureDefinition-OMOPEpisode.md) and [Episode Event OMOP Table](StructureDefinition-OMOPEpisodeEvent.md)

You can also check for [usages in the FHIR IG Statistics](https://packages2.fhir.org/xig/aphp.fhir.fr.dm|current/StructureDefinition/OMOPEpisode)

### Formal Views of Profile Content

 [Description of Profiles, Differentials, Snapshots and how the different presentations work](http://build.fhir.org/ig/FHIR/ig-guidance/readingIgs.html#structure-definitions). 

 

Other representations of profile: [CSV](StructureDefinition-OMOPEpisode.csv), [Excel](StructureDefinition-OMOPEpisode.xlsx) 



## Resource Content

```json
{
  "resourceType" : "StructureDefinition",
  "id" : "OMOPEpisode",
  "extension" : [
    {
      "url" : "http://hl7.org/fhir/StructureDefinition/structuredefinition-type-characteristics",
      "valueCode" : "can-be-target"
    }
  ],
  "url" : "https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPEpisode",
  "version" : "0.1.0",
  "name" : "OMOPEpisode",
  "title" : "Episode OMOP Table",
  "status" : "draft",
  "date" : "2025-10-23T20:49:03+00:00",
  "publisher" : "AP-HP",
  "contact" : [
    {
      "name" : "AP-HP",
      "telecom" : [
        {
          "system" : "url",
          "value" : "https://aphp.fr"
        }
      ]
    }
  ],
  "description" : "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.",
  "jurisdiction" : [
    {
      "coding" : [
        {
          "system" : "urn:iso:std:iso:3166",
          "code" : "FR",
          "display" : "France"
        }
      ]
    }
  ],
  "fhirVersion" : "4.0.1",
  "kind" : "logical",
  "abstract" : false,
  "type" : "https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPEpisode",
  "baseDefinition" : "http://hl7.org/fhir/StructureDefinition/Base",
  "derivation" : "specialization",
  "differential" : {
    "element" : [
      {
        "id" : "OMOPEpisode",
        "path" : "OMOPEpisode",
        "short" : "Episode OMOP Table",
        "definition" : "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."
      },
      {
        "id" : "OMOPEpisode.episode-id",
        "path" : "OMOPEpisode.episode_id",
        "short" : "Episode Identifier",
        "definition" : "Episode Identifier",
        "min" : 1,
        "max" : "1",
        "type" : [
          {
            "code" : "integer"
          }
        ]
      },
      {
        "id" : "OMOPEpisode.person-id",
        "path" : "OMOPEpisode.person_id",
        "short" : "Person",
        "definition" : "The PERSON_ID of the PERSON for whom the episode is recorded.",
        "min" : 1,
        "max" : "1",
        "type" : [
          {
            "code" : "Reference",
            "targetProfile" : [
              "https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPPerson"
            ]
          }
        ]
      },
      {
        "id" : "OMOPEpisode.episode-concept-id",
        "path" : "OMOPEpisode.episode_concept_id",
        "short" : "Episode",
        "definition" : "The EPISODE_CONCEPT_ID represents the kind abstraction related to the disease phase, outcome or treatment.",
        "min" : 1,
        "max" : "1",
        "type" : [
          {
            "code" : "Reference",
            "targetProfile" : [
              "https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPConcept"
            ]
          }
        ]
      },
      {
        "id" : "OMOPEpisode.episode-start-date",
        "path" : "OMOPEpisode.episode_start_date",
        "short" : "Episode Start Date",
        "definition" : "The date when the Episode beings.",
        "min" : 1,
        "max" : "1",
        "type" : [
          {
            "code" : "date"
          }
        ]
      },
      {
        "id" : "OMOPEpisode.episode-start-datetime",
        "path" : "OMOPEpisode.episode_start_datetime",
        "short" : "Episode Start Datetime",
        "definition" : "The date and time when the Episode beings.",
        "min" : 0,
        "max" : "1",
        "type" : [
          {
            "code" : "dateTime"
          }
        ]
      },
      {
        "id" : "OMOPEpisode.episode-end-date",
        "path" : "OMOPEpisode.episode_end_date",
        "short" : "Episode End Date",
        "definition" : "The date when the instance of the Episode is considered to have ended.",
        "min" : 0,
        "max" : "1",
        "type" : [
          {
            "code" : "date"
          }
        ]
      },
      {
        "id" : "OMOPEpisode.episode-end-datetime",
        "path" : "OMOPEpisode.episode_end_datetime",
        "short" : "Epsisode End Datetime",
        "definition" : "The date when the instance of the Episode is considered to have ended.",
        "min" : 0,
        "max" : "1",
        "type" : [
          {
            "code" : "dateTime"
          }
        ]
      },
      {
        "id" : "OMOPEpisode.episode-parent-id",
        "path" : "OMOPEpisode.episode_parent_id",
        "short" : "Episode Parent",
        "definition" : "Use this field to find the Episode that subsumes the given Episode record. This is used in the case that an Episode are nested into each other.",
        "min" : 0,
        "max" : "1",
        "type" : [
          {
            "code" : "Reference",
            "targetProfile" : [
              "https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPEpisode"
            ]
          }
        ]
      },
      {
        "id" : "OMOPEpisode.episode-number",
        "path" : "OMOPEpisode.episode_number",
        "short" : "Episode Number",
        "definition" : "For sequences of episodes, this is used to indicate the order the episodes occurred. For example, lines of treatment could be indicated here.",
        "min" : 0,
        "max" : "1",
        "type" : [
          {
            "code" : "integer"
          }
        ]
      },
      {
        "id" : "OMOPEpisode.episode-object-concept-id",
        "path" : "OMOPEpisode.episode_object_concept_id",
        "short" : "Episode Object",
        "definition" : "A Standard Concept representing the disease phase, outcome, or other abstraction of which the episode consists.  For example, if the EPISODE_CONCEPT_ID is [treatment regimen](https://athena.ohdsi.org/search-terms/terms/32531) then the EPISODE_OBJECT_CONCEPT_ID should contain the chemotherapy regimen concept, like [Afatinib monotherapy](https://athena.ohdsi.org/search-terms/terms/35804392).",
        "min" : 1,
        "max" : "1",
        "type" : [
          {
            "code" : "Reference",
            "targetProfile" : [
              "https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPConcept"
            ]
          }
        ]
      },
      {
        "id" : "OMOPEpisode.episode-type-concept-id",
        "path" : "OMOPEpisode.episode_type_concept_id",
        "short" : "Episode Type",
        "definition" : "This field can be used to determine the provenance of the Episode record, as in whether the episode was from an EHR system, insurance claim, registry, or other sources.",
        "min" : 1,
        "max" : "1",
        "type" : [
          {
            "code" : "Reference",
            "targetProfile" : [
              "https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPConcept"
            ]
          }
        ]
      },
      {
        "id" : "OMOPEpisode.episode-source-value",
        "path" : "OMOPEpisode.episode_source_value",
        "short" : "Episode Source Value",
        "definition" : "The source code for the Episdoe as it appears in the source data. This code is mapped to a Standard Condition Concept in the Standardized Vocabularies and the original code is stored here for reference.",
        "min" : 0,
        "max" : "1",
        "type" : [
          {
            "code" : "string"
          }
        ]
      },
      {
        "id" : "OMOPEpisode.episode-source-concept-id",
        "path" : "OMOPEpisode.episode_source_concept_id",
        "short" : "Episode Source",
        "definition" : "A foreign key to a Episode Concept that refers to the code used in the source.",
        "min" : 0,
        "max" : "1",
        "type" : [
          {
            "code" : "Reference",
            "targetProfile" : [
              "https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPConcept"
            ]
          }
        ]
      }
    ]
  }
}

```
