This is an old revision of the document!
This table changed in version 5.1 of the OMOP CDM. The field procedure_datetime was added.
The PROCEDURE_OCCURRENCE tabe contains records of activities or processes ordered by, or carried out by, a healthcare provider on the patient to have a diagnostic or therapeutic purpose. Procedures are present in various data sources in different forms with varying levels of standardization. For example:
Field | Required | Type | Description |
---|---|---|---|
procedure_occurrence_id | Yes | integer | A system-generated unique identifier for each Procedure Occurrence. |
person_id | Yes | integer | 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_concept_id | Yes | integer | A foreign key that refers to a standard procedure Concept identifier in the Standardized Vocabularies. |
procedure_date | Yes | date | The date on which the Procedure was performed. |
procedure_datetime | No | datetime | The date and time on which the Procedure was performed. |
procedure_type_concept_id | Yes | integer | A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of source data from which the procedure record is derived. |
modifier_concept_id | No | integer | A foreign key to a Standard Concept identifier for a modifier to the Procedure (e.g. bilateral) |
quantity | No | integer | The quantity of procedures ordered or administered. |
provider_id | No | integer | A foreign key to the provider in the provider table who was responsible for carrying out the procedure. |
visit_occurrence_id | No | integer | A foreign key to the visit in the visit table during which the Procedure was carried out. |
procedure_source_value | No | varchar(50) | The source code for the Procedure as it appears in the source data. This code is mapped to a standard procedure Concept in the Standardized Vocabularies and the original code is, stored here for reference. Procedure source codes are typically ICD-9-Proc, CPT-4, HCPCS or OPCS-4 codes. |
procedure_source_concept_id | No | integer | A foreign key to a Procedure Concept that refers to the code used in the source. |
qualifier_source_value | No | varchar(50) | The source code for the qualifier as it appears in the source data. |