FHIR to OMOP FHIR IG
0.1.0 - ci-build International flag

FHIR to OMOP FHIR IG, published by HL7 International / Biomedical Research and Regulation. This guide is not an authorized publication; it is the continuous build for version 0.1.0 built by the FHIR (HL7® FHIR® Standard) CI Build. This version is based on the current content of https://github.com/HL7/fhir-omop-ig/ and changes regularly. See the Directory of published versions

Logical Model: Visit Detail OMOP Table

Official URL: http://hl7.org/fhir/uv/omop/StructureDefinition/VisitDetail Version: 0.1.0
Standards status: Draft Maturity Level: 1 Computable Name: VisitDetail

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
.. VisitDetail 0..*BaseVisit Detail OMOP Table
Instances of this logical model can be the target of a Reference
... visit_detail_id 1..1integerVisit Detail Identifier
... person_id 1..1Reference(Person OMOP Table)Person
... visit_detail_concept_id 1..1codeVisit Detail
... visit_detail_start_datetime 0..1dateTimeVisit Detail Start Datetime
... visit_detail_end_date 1..1dateVisit Detail End Date
... visit_detail_end_datetime 0..1dateTimeVisit Detail End Datetime
... visit_detail_type_concept_id 1..1codeVisit Detail Type
... provider_id 0..1Reference(Provider OMOP Table)Provider
... care_site_id 0..1Reference(CareSite OMOP Table)Care Site
... visit_detail_source_value 0..1stringVisit Detail Source Value
... visit_detail_source_concept_id 0..1codeVisit Detail Source Concept
... admitted_from_concept_id 0..1codeAdmitted From
... admitted_from_source_value 0..1stringAdmitted From Source Value
... discharged_to_source_value 0..1stringDischarged To Source Value
... discharged_to_concept_id 0..1codeDischarged To
... preceding_visit_detail_id 0..1Reference(Visit Detail OMOP Table)Preceding Visit
... parent_visit_detail_id 0..1Reference(Visit Detail OMOP Table)Parent Visit
... visit_occurrence_id 1..1Reference(Visit Occurrence OMOP Table)Visit Occurrence

doco Documentation for this format
NameFlagsCard.TypeDescription & Constraintsdoco
.. VisitDetail 0..*BaseVisit Detail OMOP Table
Instances of this logical model can be the target of a Reference
... visit_detail_id 1..1integerVisit Detail Identifier
... person_id 1..1Reference(Person OMOP Table)Person
... visit_detail_concept_id 1..1codeVisit Detail
... visit_detail_start_datetime 0..1dateTimeVisit Detail Start Datetime
... visit_detail_end_date 1..1dateVisit Detail End Date
... visit_detail_end_datetime 0..1dateTimeVisit Detail End Datetime
... visit_detail_type_concept_id 1..1codeVisit Detail Type
... provider_id 0..1Reference(Provider OMOP Table)Provider
... care_site_id 0..1Reference(CareSite OMOP Table)Care Site
... visit_detail_source_value 0..1stringVisit Detail Source Value
... visit_detail_source_concept_id 0..1codeVisit Detail Source Concept
... admitted_from_concept_id 0..1codeAdmitted From
... admitted_from_source_value 0..1stringAdmitted From Source Value
... discharged_to_source_value 0..1stringDischarged To Source Value
... discharged_to_concept_id 0..1codeDischarged To
... preceding_visit_detail_id 0..1Reference(Visit Detail OMOP Table)Preceding Visit
... parent_visit_detail_id 0..1Reference(Visit Detail OMOP Table)Parent Visit
... visit_occurrence_id 1..1Reference(Visit Occurrence OMOP Table)Visit Occurrence

doco Documentation for this format
NameFlagsCard.TypeDescription & Constraintsdoco
.. VisitDetail 0..*BaseVisit Detail OMOP Table
Instances of this logical model can be the target of a Reference
... visit_detail_id 1..1integerVisit Detail Identifier
... person_id 1..1Reference(Person OMOP Table)Person
... visit_detail_concept_id 1..1codeVisit Detail
... visit_detail_start_datetime 0..1dateTimeVisit Detail Start Datetime
... visit_detail_end_date 1..1dateVisit Detail End Date
... visit_detail_end_datetime 0..1dateTimeVisit Detail End Datetime
... visit_detail_type_concept_id 1..1codeVisit Detail Type
... provider_id 0..1Reference(Provider OMOP Table)Provider
... care_site_id 0..1Reference(CareSite OMOP Table)Care Site
... visit_detail_source_value 0..1stringVisit Detail Source Value
... visit_detail_source_concept_id 0..1codeVisit Detail Source Concept
... admitted_from_concept_id 0..1codeAdmitted From
... admitted_from_source_value 0..1stringAdmitted From Source Value
... discharged_to_source_value 0..1stringDischarged To Source Value
... discharged_to_concept_id 0..1codeDischarged To
... preceding_visit_detail_id 0..1Reference(Visit Detail OMOP Table)Preceding Visit
... parent_visit_detail_id 0..1Reference(Visit Detail OMOP Table)Parent Visit
... visit_occurrence_id 1..1Reference(Visit Occurrence OMOP Table)Visit Occurrence

doco Documentation for this format

Differential View

This structure is derived from Base

NameFlagsCard.TypeDescription & Constraintsdoco
.. VisitDetail 0..*BaseVisit Detail OMOP Table
Instances of this logical model can be the target of a Reference
... visit_detail_id 1..1integerVisit Detail Identifier
... person_id 1..1Reference(Person OMOP Table)Person
... visit_detail_concept_id 1..1codeVisit Detail
... visit_detail_start_datetime 0..1dateTimeVisit Detail Start Datetime
... visit_detail_end_date 1..1dateVisit Detail End Date
... visit_detail_end_datetime 0..1dateTimeVisit Detail End Datetime
... visit_detail_type_concept_id 1..1codeVisit Detail Type
... provider_id 0..1Reference(Provider OMOP Table)Provider
... care_site_id 0..1Reference(CareSite OMOP Table)Care Site
... visit_detail_source_value 0..1stringVisit Detail Source Value
... visit_detail_source_concept_id 0..1codeVisit Detail Source Concept
... admitted_from_concept_id 0..1codeAdmitted From
... admitted_from_source_value 0..1stringAdmitted From Source Value
... discharged_to_source_value 0..1stringDischarged To Source Value
... discharged_to_concept_id 0..1codeDischarged To
... preceding_visit_detail_id 0..1Reference(Visit Detail OMOP Table)Preceding Visit
... parent_visit_detail_id 0..1Reference(Visit Detail OMOP Table)Parent Visit
... visit_occurrence_id 1..1Reference(Visit Occurrence OMOP Table)Visit Occurrence

doco Documentation for this format

Key Elements View

NameFlagsCard.TypeDescription & Constraintsdoco
.. VisitDetail 0..*BaseVisit Detail OMOP Table
Instances of this logical model can be the target of a Reference
... visit_detail_id 1..1integerVisit Detail Identifier
... person_id 1..1Reference(Person OMOP Table)Person
... visit_detail_concept_id 1..1codeVisit Detail
... visit_detail_start_datetime 0..1dateTimeVisit Detail Start Datetime
... visit_detail_end_date 1..1dateVisit Detail End Date
... visit_detail_end_datetime 0..1dateTimeVisit Detail End Datetime
... visit_detail_type_concept_id 1..1codeVisit Detail Type
... provider_id 0..1Reference(Provider OMOP Table)Provider
... care_site_id 0..1Reference(CareSite OMOP Table)Care Site
... visit_detail_source_value 0..1stringVisit Detail Source Value
... visit_detail_source_concept_id 0..1codeVisit Detail Source Concept
... admitted_from_concept_id 0..1codeAdmitted From
... admitted_from_source_value 0..1stringAdmitted From Source Value
... discharged_to_source_value 0..1stringDischarged To Source Value
... discharged_to_concept_id 0..1codeDischarged To
... preceding_visit_detail_id 0..1Reference(Visit Detail OMOP Table)Preceding Visit
... parent_visit_detail_id 0..1Reference(Visit Detail OMOP Table)Parent Visit
... visit_occurrence_id 1..1Reference(Visit Occurrence OMOP Table)Visit Occurrence

doco Documentation for this format

Snapshot View

NameFlagsCard.TypeDescription & Constraintsdoco
.. VisitDetail 0..*BaseVisit Detail OMOP Table
Instances of this logical model can be the target of a Reference
... visit_detail_id 1..1integerVisit Detail Identifier
... person_id 1..1Reference(Person OMOP Table)Person
... visit_detail_concept_id 1..1codeVisit Detail
... visit_detail_start_datetime 0..1dateTimeVisit Detail Start Datetime
... visit_detail_end_date 1..1dateVisit Detail End Date
... visit_detail_end_datetime 0..1dateTimeVisit Detail End Datetime
... visit_detail_type_concept_id 1..1codeVisit Detail Type
... provider_id 0..1Reference(Provider OMOP Table)Provider
... care_site_id 0..1Reference(CareSite OMOP Table)Care Site
... visit_detail_source_value 0..1stringVisit Detail Source Value
... visit_detail_source_concept_id 0..1codeVisit Detail Source Concept
... admitted_from_concept_id 0..1codeAdmitted From
... admitted_from_source_value 0..1stringAdmitted From Source Value
... discharged_to_source_value 0..1stringDischarged To Source Value
... discharged_to_concept_id 0..1codeDischarged To
... preceding_visit_detail_id 0..1Reference(Visit Detail OMOP Table)Preceding Visit
... parent_visit_detail_id 0..1Reference(Visit Detail OMOP Table)Parent Visit
... visit_occurrence_id 1..1Reference(Visit Occurrence OMOP Table)Visit Occurrence

doco Documentation for this format

 

Other representations of profile: CSV, Excel