documentation:cdm:procedure_occurrence
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
documentation:cdm:procedure_occurrence [2014/12/06 17:42] cgreich |
documentation:cdm:procedure_occurrence [2017/09/25 15:01] clairblacketer |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== PROCEDURE_OCCURRENCE table ===== | ===== PROCEDURE_OCCURRENCE table ===== | ||
| + | **THIS IS OUTDATED. All documentation is now on the [[https://github.com/OHDSI/CommonDataModel/wiki|github wiki]]. Please refer there or to the [[projects:workgroups:cdm-wg|CDM working group]] for more information** | ||
| + | |||
| + | 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: | 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: | ||
| Line 10: | Line 15: | ||
| |procedure_concept_id|Yes|integer|A foreign key that refers to a standard procedure Concept identifier in the Standardized Vocabularies.| | |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_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.| | |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)| | |modifier_concept_id|No|integer|A foreign key to a Standard Concept identifier for a modifier to the Procedure (e.g. bilateral)| | ||
| Line 28: | Line 34: | ||
| * The Visit during which the procedure was performed is recorded through a reference to the VISIT_OCCURRENCE table. This information is not always available. | * The Visit during which the procedure was performed is recorded through a reference to the VISIT_OCCURRENCE table. This information is not always available. | ||
| * The Provider carrying out the procedure is recorded through a reference to the PROVIDER table. This information is not always available. | * The Provider carrying out the procedure is recorded through a reference to the PROVIDER table. This information is not always available. | ||
| - | |||
documentation/cdm/procedure_occurrence.txt ยท Last modified: 2017/09/25 15:01 by clairblacketer
Page Tools
