| # | Column | Type | Notes |
|---|
| 1 | eid | integer | A foreign key identifier to the Person who is subjected to the Procedure. |
| 2 | modifier_concept_id | integer | A foreign key to a Standard Concept identifier for a modifier to the Procedure (e.g. bilateral) |
| 3 | modifier_source_value | integer | The source code for the qualifier as it appears in the source data. |
| 4 | procedure_concept_id | integer | A foreign key that refers to a standard procedure Concept identifier in the Standardized Vocabularies. |
| 5 | procedure_date | date | The date on which the Procedure was performed. |
| 6 | procedure_datetime | timestamp | The date and time on which the Procedure was performed. |
| 7 | procedure_occurrence_id | integer | A system-generated unique identifier for each Procedure Occurrence. |
| 8 | procedure_source_concept_id | integer | A foreign key to a Procedure Concept that refers to the code used in the source. |
| 9 | procedure_source_value | string | 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. |
| 10 | procedure_type_concept_id | 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. |
| 11 | provider_id | integer | A foreign key to the provider in the provider table who was responsible for carrying out the procedure. |
| 12 | quantity | integer | The quantity of procedures ordered or administered. |
| 13 | visit_detail_id | integer | |
| 14 | visit_occurrence_id | integer | A foreign key to the visit in the visit table during which the Procedure was carried out. |
