: Record Table 936

Record Table 936

Title:	OMOP Procedure Occurrence
Access field:	20142 (Present in OMOP dataset)

Table name

omop_procedure_occurrence

Table group

OMOP

Debut

Feb 2023

Row count

14,000,000+

Parent table

n/a

Version

Sep 2025

Size

1GB

Stability

Complete

Cost Tier

dX o2 s2

This item is regarded as restricted and will be supplied to researchers only when absolutely necessary.

WARNING: the interactive features of this website use CSS3, which your browser does not support. To use the full features of this website, please update your browser.

Notes

The omop_procedure_occurrence table contains records of activities or processes ordered by, or carried out by, a healthcare provider on the patient with a diagnostic or therapeutic purpose.
Further details can be found in the OMOP CDM Clinical Data Tables specifications - https://ohdsi.github.io/CommonDataModel/cdm53.html#PROCEDURE_OCCURRENCE
Due to some data quality issues identified by research groups who have been using the returned OMOP derivation dataset, the record-level tables are now restricted. Please see Field 20142 for more information.

14 Columns

#	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.

15 Related OMOP Record Tables

Table ID	Table	Title
924	omop_condition_era	OMOP Condition Era
925	omop_condition_occurrence	OMOP Condition Occurrence
926	omop_death	OMOP Death
927	omop_device_exposure	OMOP Device Exposure
928	omop_dose_era	OMOP Dose Era
929	omop_drug_era	OMOP Drug Era
930	omop_drug_exposure	OMOP Drug Exposure
931	omop_measurement	OMOP Measurement
932	omop_note	OMOP Note
933	omop_observation	OMOP Observation Period
934	omop_observation_period	OMOP Observation
935	omop_person	OMOP Person
937	omop_specimen	OMOP Specimen
938	omop_visit_detail	OMOP Visit Detail
939	omop_visit_occurrence	OMOP Visit Occurrence

Enabling scientific discoveries that improve human health