has_procedure_occurrence
Go to external page http://www.lesfleursdunormal.fr/static/_downloads/omop_cdm_v6.owl#has_procedure_occurrence
Property information
(reversed relation, for ProcedureOccurrence:) A foreign key to the Visit Detail in the VISIT_DETAIL table during which the Procedure was carried out.
(reversed relation, for ProcedureOccurrence:) A foreign key to the Visit in the VISIT_OCCURRENCE table during which the Procedure was carried out.
(reversed relation, for ProcedureOccurrence:) A foreign key identifier to the Person who is subjected to the Procedure. The demographic details of that Person are stored in the PERSON table.
procedure_occurrence.person_id#167 AS Person
procedure_occurrence.visit_detail_id#176 AS VisitDetail
procedure_occurrence.visit_occurrence_id#175 AS VisitOccurrence