This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
documentation:cdm:cost [2016/05/04 00:00] cgreich |
documentation:cdm:cost [2017/09/25 15:08] (current) clairblacketer |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== COST table ===== | ===== COST 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 was added with version 5.0.1 (5-Apr-2016) of the OMOP CDM. It is 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 32: | ||
|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 ==== | ||
Line 57: | Line 64: | ||
* paid_by_primary does contribute to the total_paid variable. The paid_by_primary field is only used for reporting a patient's primary insurance payment amount reported on the secondary payer insurance claim. If the source data has actual primary insurance payments (e.g. the primary insurance payment is not a derivative of the payer claim and there is verification another insurance company paid an amount to the provider), then the primary insurance payment should have its own cost record with a payer_plan_id set to the applicable payer, and the actual primary insurance payment should be noted under the paid_by_payer field. | * paid_by_primary does contribute to the total_paid variable. The paid_by_primary field is only used for reporting a patient's primary insurance payment amount reported on the secondary payer insurance claim. If the source data has actual primary insurance payments (e.g. the primary insurance payment is not a derivative of the payer claim and there is verification another insurance company paid an amount to the provider), then the primary insurance payment should have its own cost record with a payer_plan_id set to the applicable payer, and the actual primary insurance payment should be noted under the paid_by_payer field. | ||
* revenue_code_concept_id: Revenue codes are a method to charge for a class of procedures and conditions in the U.S. hospital system. | * revenue_code_concept_id: Revenue codes are a method to charge for a class of procedures and conditions in the U.S. hospital system. | ||
+ | * drg_concept_id: DRG is a system to classify hospital cases into one of approximately 500 groups for reimbursement purposes. They have been used in the United States since 1983. | ||