has_visit_detail
Go to external page http://www.lesfleursdunormal.fr/static/_downloads/omop_cdm_v6.owl#has_visit_detail
Property information
comment
(reversed relation, for VisitDetail:) A foreign key that refers to the record in the VISIT_OCCURRENCE table. This is a required field, because for every visit_detail is a child of visit_occurrence and cannot exist without a corresponding parent record in visit_occurrence.
(reversed relation, for VisitDetail:) A foreign key identifier to the Person for whom the visit is recorded. The demographic details of that Person are stored in the PERSON table.
omop cdm name
visit_detail.visit_occurrence_id#237 AS VisitOccurrence
visit_detail.person_id#220 AS Person