documentation:cdm:cost
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
documentation:cdm:cost [2016/05/04 01:42] cgreich |
documentation:cdm:cost [2017/01/08 19:04] cgreich |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| This table was added with version 5.0.1 (5-Apr-2016) of the OMOP CDM. It replaces the [[documentation:cdm:visit_cost|VISIT_COST]], [[documentation:cdm:procedure_cost|PROCEDURE_COST]], [[documentation:cdm:drug_cost|DRUG_COST]] and [[documentation:cdm:device_cost|DEVICE_COST]] tables. | This table was added with version 5.0.1 (5-Apr-2016) of the OMOP CDM. It replaces the [[documentation:cdm:visit_cost|VISIT_COST]], [[documentation:cdm:procedure_cost|PROCEDURE_COST]], [[documentation:cdm:drug_cost|DRUG_COST]] and [[documentation:cdm:device_cost|DEVICE_COST]] tables. | ||
| + | ---- | ||
| + | |||
| + | This table changed in version 5.X of the OMOP CDM. The fields DRG_concept_id and DRG_source_value were added. | ||
| + | ---- | ||
| The COST table captures records containing the cost of any medical entity recorded in one of the DRUG_EXPOSURE, PROCEDURE_OCCURRENCE, VISIT_OCCURRENCE or DEVICE_OCCURRENCE tables. It replaces the corresponding DRUG_COST, PROCEDURE_COST, VISIT_COST or DEVICE_COST tables that were initially defined for the OMOP CDM V5. However, it also allows to capture cost information for records of the OBSERVATION and MEASUREMENT tables. | The COST table captures records containing the cost of any medical entity recorded in one of the DRUG_EXPOSURE, PROCEDURE_OCCURRENCE, VISIT_OCCURRENCE or DEVICE_OCCURRENCE tables. It replaces the corresponding DRUG_COST, PROCEDURE_COST, VISIT_COST or DEVICE_COST tables that were initially defined for the OMOP CDM V5. However, it also allows to capture cost information for records of the OBSERVATION and MEASUREMENT tables. | ||
| Line 27: | Line 31: | ||
| |amount_allowed|No|float|The contracted amount agreed between the payer and provider.| | |amount_allowed|No|float|The contracted amount agreed between the payer and provider.| | ||
| |revenue_code_concept_id|No|integer|A foreign key referring to a Standard Concept ID in the Standardized Vocabularies for Revenue codes.| | |revenue_code_concept_id|No|integer|A foreign key referring to a Standard Concept ID in the Standardized Vocabularies for Revenue codes.| | ||
| + | |drg_concept_id|No|integer|A foreign key referring to a Standard Concept ID in the Standardized Vocabularies for DRG codes.| | ||
| |revenue_code_source_value|No|string(50)|The source code for the Revenue code as it appears in the source data, stored here for reference.| | |revenue_code_source_value|No|string(50)|The source code for the Revenue code as it appears in the source data, stored here for reference.| | ||
| + | |drg_source_value|No|string(50)|The source code for the 3-digit DRG source code as it appears in the source data, stored here for reference.| | ||
| ==== Conventions ==== | ==== Conventions ==== | ||
documentation/cdm/cost.txt ยท Last modified: 2017/09/25 15:08 by clairblacketer
Page Tools
