has_condition_occurrence
Go to external page http://www.lesfleursdunormal.fr/static/_downloads/omop_cdm_v6.owl#has_condition_occurrence
Property information
(reversed relation, for ConditionOccurrence:) A foreign key to the visit in the VISIT_OCCURRENCE table during which the Condition was determined (diagnosed).
(reversed relation, for ConditionOccurrence:) A foreign key to the visit in the VISIT_DETAIL table during which the Condition was determined (diagnosed).
(reversed relation, for ConditionOccurrence:) A foreign key identifier to the Person who is experiencing the condition. The demographic details of that Person are stored in the PERSON table.
condition_occurrence.person_id#13 AS Person
condition_occurrence.visit_occurrence_id#23 AS VisitOccurrence
condition_occurrence.visit_detail_id#24 AS VisitDetail