This shows you the differences between two versions of the page.
Both sides previous 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 3: | Line 3: | ||
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 ==== |