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

Official URL: https://interop.esante.gouv.fr/ig/fhir/eds/StructureDefinition/OMOPVisitDetail Version: 0.1.0
Draft as of 2024-09-10 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.

Usage:

Formal Views of Profile Content

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

This structure is derived from Base

NameFlagsCard.TypeDescription & Constraintsdoco
.. OMOPVisitDetail 0..* Base Visit Detail OMOP Table
Instances of this logical model are not marked to 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_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

doco Documentation for this format
NameFlagsCard.TypeDescription & Constraintsdoco
.. OMOPVisitDetail 0..* Base Visit Detail OMOP Table
Instances of this logical model are not marked to 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_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

doco Documentation for this format
NameFlagsCard.TypeDescription & Constraintsdoco
.. OMOPVisitDetail 0..* Base Visit Detail OMOP Table
Instances of this logical model are not marked to 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_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

doco Documentation for this format

Differential View

This structure is derived from Base

NameFlagsCard.TypeDescription & Constraintsdoco
.. OMOPVisitDetail 0..* Base Visit Detail OMOP Table
Instances of this logical model are not marked to 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_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

doco Documentation for this format

Key Elements View

NameFlagsCard.TypeDescription & Constraintsdoco
.. OMOPVisitDetail 0..* Base Visit Detail OMOP Table
Instances of this logical model are not marked to 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_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

doco Documentation for this format

Snapshot View

NameFlagsCard.TypeDescription & Constraintsdoco
.. OMOPVisitDetail 0..* Base Visit Detail OMOP Table
Instances of this logical model are not marked to 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_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

doco Documentation for this format

 

Other representations of profile: CSV, Excel