Table postgres.omop.procedure_occurrence
[CLINICAL] The PROCEDURE_OCCURRENCE table 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:

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
procedure_occurrence_id int4 10 A system-generated unique identifier for each Procedure Occurrence.
person_id int4 10
person.person_id fpk_procedure_person R
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 int4 10
concept.concept_id fpk_procedure_concept R
A foreign key that refers to a standard procedure Concept identifier in the Standardized Vocabularies.
procedure_date date 13 The date on which the Procedure was performed.
procedure_datetime timestamp 29,6 The date and time on which the Procedure was performed.
procedure_type_concept_id int4 10
concept.concept_id fpk_procedure_type_concept R
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 int4 10  √  null
concept.concept_id fpk_procedure_modifier R
A foreign key to a Standard Concept identifier for a modifier to the Procedure (e.g. bilateral)
quantity int4 10  √  null The quantity of procedures ordered or administered.
provider_id int4 10  √  null
provider.provider_id fpk_procedure_provider R
A foreign key to the provider in the provider table who was responsible for carrying out the procedure.
visit_occurrence_id int4 10  √  null
visit_occurrence.visit_occurrence_id fpk_procedure_visit R
A foreign key to the visit in the visit table during which the Procedure was carried out.
visit_detail_id int4 10  √  null
visit_detail.visit_detail_id fpk_procedure_visit_detail R
A foreign key to the visit in the visit table during which the Procedure was carried out.
procedure_source_value varchar 50  √  null 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 int4 10  √  null
concept.concept_id fpk_procedure_concept_s R
A foreign key to a Procedure Concept that refers to the code used in the source.
qualifier_source_value varchar 50  √  null The source code for the qualifier as it appears in the source data.

Table contained 0 rows at dim. sept. 10 20:08 CEST 2017

Indexes:
Column(s) Type Sort Constraint Name
procedure_occurrence_id Primary key Asc xpk_procedure_occurrence
procedure_concept_id Performance Asc idx_procedure_concept_id
person_id Performance Asc idx_procedure_person_id
visit_detail_id Performance Asc idx_procedure_visit_detail_id
visit_occurrence_id Performance Asc idx_procedure_visit_id

Close relationships  within of separation: