This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Last revision Both sides next revision | ||
documentation:cdm:procedure_occurrence [2017/01/02 23:47] cukarthik |
documentation:cdm:procedure_occurrence [2017/02/07 03:37] cukarthik |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== PROCEDURE_OCCURRENCE table ===== | ===== PROCEDURE_OCCURRENCE table ===== | ||
+ | |||
+ | 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 29: | Line 33: | ||
* 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. | ||
- |