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: Visit Detail OMOP Table

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

The VISIT_DETAIL table is an optional table used to represents details of each record in the parent VISIT_OCCURRENCE table. A good example of this would be the movement between units in a hospital during an inpatient stay or claim lines associated with a one insurance claim. For every record in the VISIT_OCCURRENCE table there may be 0 or more records in the VISIT_DETAIL table with a 1:n relationship where n may be 0. The VISIT_DETAIL table is structurally very similar to VISIT_OCCURRENCE table and belongs to the visit domain.

Usages:

- Refer to this Logical Model: Condition Occurrence OMOP Table, Device Exposure OMOP Table, Drug Occurrence OMOP Table, Measurement OMOP Table... Show 4 more, Note OMOP Table, Observation OMOP Table, Procedure Occurrence OMOP Table and Visit Detail 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
--- | --- | --- | --- | ---
OMOPVisitDetail |  | 0..* | Base | Visit Detail OMOP Table Instances of this logical model can be the target of a Reference
visit_detail_id |  | 1..1 | integer | Visit Detail Identifier
person_id |  | 1..1 | Reference(Person OMOP Table) | Person
visit_detail_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Visit Detail
visit_detail_start_date |  | 1..1 | date | Visit Detail Start Date
visit_detail_start_datetime |  | 0..1 | dateTime | Visit Detail Start Datetime
visit_detail_end_date |  | 1..1 | date | Visit Detail End Date
visit_detail_end_datetime |  | 0..1 | dateTime | Visit Detail End Datetime
visit_detail_type_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Visit Detail Type
provider_id |  | 0..1 | Reference(Provider OMOP Table) | Provider
care_site_id |  | 0..1 | Reference(CareSite OMOP Table) | Care Site
visit_detail_source_value |  | 0..1 | string | Visit Detail Source Value
visit_detail_source_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Visit Detail Source Concept
admitted_from_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Admitted From
admitted_from_source_value |  | 0..1 | string | Admitted From Source Value
discharged_to_source_value |  | 0..1 | string | Discharged To Source Value
discharged_to_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Discharged To
preceding_visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Preceding Visit
parent_visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Parent Visit
visit_occurrence_id |  | 1..1 | Reference(Visit Occurrence OMOP Table) | Visit Occurrence
Documentation for this format

This structure is derived from Base

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
OMOPVisitDetail |  | 0..* | Base | Visit Detail OMOP Table Instances of this logical model can be the target of a Reference
visit_detail_id |  | 1..1 | integer | Visit Detail Identifier
person_id |  | 1..1 | Reference(Person OMOP Table) | Person
visit_detail_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Visit Detail
visit_detail_start_date |  | 1..1 | date | Visit Detail Start Date
visit_detail_start_datetime |  | 0..1 | dateTime | Visit Detail Start Datetime
visit_detail_end_date |  | 1..1 | date | Visit Detail End Date
visit_detail_end_datetime |  | 0..1 | dateTime | Visit Detail End Datetime
visit_detail_type_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Visit Detail Type
provider_id |  | 0..1 | Reference(Provider OMOP Table) | Provider
care_site_id |  | 0..1 | Reference(CareSite OMOP Table) | Care Site
visit_detail_source_value |  | 0..1 | string | Visit Detail Source Value
visit_detail_source_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Visit Detail Source Concept
admitted_from_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Admitted From
admitted_from_source_value |  | 0..1 | string | Admitted From Source Value
discharged_to_source_value |  | 0..1 | string | Discharged To Source Value
discharged_to_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Discharged To
preceding_visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Preceding Visit
parent_visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Parent Visit
visit_occurrence_id |  | 1..1 | Reference(Visit Occurrence OMOP Table) | Visit Occurrence
Documentation for this format

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
OMOPVisitDetail |  | 0..* | Base | Visit Detail OMOP Table Instances of this logical model can be the target of a Reference
visit_detail_id |  | 1..1 | integer | Visit Detail Identifier
person_id |  | 1..1 | Reference(Person OMOP Table) | Person
visit_detail_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Visit Detail
visit_detail_start_date |  | 1..1 | date | Visit Detail Start Date
visit_detail_start_datetime |  | 0..1 | dateTime | Visit Detail Start Datetime
visit_detail_end_date |  | 1..1 | date | Visit Detail End Date
visit_detail_end_datetime |  | 0..1 | dateTime | Visit Detail End Datetime
visit_detail_type_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Visit Detail Type
provider_id |  | 0..1 | Reference(Provider OMOP Table) | Provider
care_site_id |  | 0..1 | Reference(CareSite OMOP Table) | Care Site
visit_detail_source_value |  | 0..1 | string | Visit Detail Source Value
visit_detail_source_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Visit Detail Source Concept
admitted_from_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Admitted From
admitted_from_source_value |  | 0..1 | string | Admitted From Source Value
discharged_to_source_value |  | 0..1 | string | Discharged To Source Value
discharged_to_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Discharged To
preceding_visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Preceding Visit
parent_visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Parent Visit
visit_occurrence_id |  | 1..1 | Reference(Visit Occurrence OMOP Table) | Visit Occurrence
Documentation for this format

This structure is derived from Base

Résumé

Mandatory: 0 element(7 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)
- Provider OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPProvider)
- CareSite OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPCareSite)
- Visit Detail OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPVisitDetail)
- Visit Occurrence OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPVisitOccurrence)

Key Elements View

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
OMOPVisitDetail |  | 0..* | Base | Visit Detail OMOP Table Instances of this logical model can be the target of a Reference
visit_detail_id |  | 1..1 | integer | Visit Detail Identifier
person_id |  | 1..1 | Reference(Person OMOP Table) | Person
visit_detail_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Visit Detail
visit_detail_start_date |  | 1..1 | date | Visit Detail Start Date
visit_detail_start_datetime |  | 0..1 | dateTime | Visit Detail Start Datetime
visit_detail_end_date |  | 1..1 | date | Visit Detail End Date
visit_detail_end_datetime |  | 0..1 | dateTime | Visit Detail End Datetime
visit_detail_type_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Visit Detail Type
provider_id |  | 0..1 | Reference(Provider OMOP Table) | Provider
care_site_id |  | 0..1 | Reference(CareSite OMOP Table) | Care Site
visit_detail_source_value |  | 0..1 | string | Visit Detail Source Value
visit_detail_source_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Visit Detail Source Concept
admitted_from_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Admitted From
admitted_from_source_value |  | 0..1 | string | Admitted From Source Value
discharged_to_source_value |  | 0..1 | string | Discharged To Source Value
discharged_to_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Discharged To
preceding_visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Preceding Visit
parent_visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Parent Visit
visit_occurrence_id |  | 1..1 | Reference(Visit Occurrence OMOP Table) | Visit Occurrence
Documentation for this format

Differential View

This structure is derived from Base

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
OMOPVisitDetail |  | 0..* | Base | Visit Detail OMOP Table Instances of this logical model can be the target of a Reference
visit_detail_id |  | 1..1 | integer | Visit Detail Identifier
person_id |  | 1..1 | Reference(Person OMOP Table) | Person
visit_detail_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Visit Detail
visit_detail_start_date |  | 1..1 | date | Visit Detail Start Date
visit_detail_start_datetime |  | 0..1 | dateTime | Visit Detail Start Datetime
visit_detail_end_date |  | 1..1 | date | Visit Detail End Date
visit_detail_end_datetime |  | 0..1 | dateTime | Visit Detail End Datetime
visit_detail_type_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Visit Detail Type
provider_id |  | 0..1 | Reference(Provider OMOP Table) | Provider
care_site_id |  | 0..1 | Reference(CareSite OMOP Table) | Care Site
visit_detail_source_value |  | 0..1 | string | Visit Detail Source Value
visit_detail_source_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Visit Detail Source Concept
admitted_from_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Admitted From
admitted_from_source_value |  | 0..1 | string | Admitted From Source Value
discharged_to_source_value |  | 0..1 | string | Discharged To Source Value
discharged_to_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Discharged To
preceding_visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Preceding Visit
parent_visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Parent Visit
visit_occurrence_id |  | 1..1 | Reference(Visit Occurrence OMOP Table) | Visit Occurrence
Documentation for this format

Snapshot View

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
OMOPVisitDetail |  | 0..* | Base | Visit Detail OMOP Table Instances of this logical model can be the target of a Reference
visit_detail_id |  | 1..1 | integer | Visit Detail Identifier
person_id |  | 1..1 | Reference(Person OMOP Table) | Person
visit_detail_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Visit Detail
visit_detail_start_date |  | 1..1 | date | Visit Detail Start Date
visit_detail_start_datetime |  | 0..1 | dateTime | Visit Detail Start Datetime
visit_detail_end_date |  | 1..1 | date | Visit Detail End Date
visit_detail_end_datetime |  | 0..1 | dateTime | Visit Detail End Datetime
visit_detail_type_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Visit Detail Type
provider_id |  | 0..1 | Reference(Provider OMOP Table) | Provider
care_site_id |  | 0..1 | Reference(CareSite OMOP Table) | Care Site
visit_detail_source_value |  | 0..1 | string | Visit Detail Source Value
visit_detail_source_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Visit Detail Source Concept
admitted_from_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Admitted From
admitted_from_source_value |  | 0..1 | string | Admitted From Source Value
discharged_to_source_value |  | 0..1 | string | Discharged To Source Value
discharged_to_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Discharged To
preceding_visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Preceding Visit
parent_visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Parent Visit
visit_occurrence_id |  | 1..1 | Reference(Visit Occurrence OMOP Table) | Visit Occurrence
Documentation for this format

This structure is derived from Base

Résumé

Mandatory: 0 element(7 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)
- Provider OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPProvider)
- CareSite OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPCareSite)
- Visit Detail OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPVisitDetail)
- Visit Occurrence OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPVisitOccurrence)

Other representations of profile: CSV, Excel