This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
documentation:cdm:cost [2016/05/02 13:22] cgreich |
documentation:cdm:cost [2017/01/08 19:05] cgreich |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== COST table ===== | ===== COST table ===== | ||
+ | |||
+ | 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 11: | Line 17: | ||
|cost_type_concept_id|Yes|integer|A foreign key identifier to a concept in the CONCEPT table for the provenance or the source of the COST data: Calculated from insurance claim information, provider revenue, calculated from cost-to-charge ratio, reported from accounting database, etc.| | |cost_type_concept_id|Yes|integer|A foreign key identifier to a concept in the CONCEPT table for the provenance or the source of the COST data: Calculated from insurance claim information, provider revenue, calculated from cost-to-charge ratio, reported from accounting database, etc.| | ||
|currency_concept_id|No|integer|A foreign key identifier to the concept representing the 3-letter code used to delineate international currencies, such as USD for US Dollar.| | |currency_concept_id|No|integer|A foreign key identifier to the concept representing the 3-letter code used to delineate international currencies, such as USD for US Dollar.| | ||
- | |total_charged|No|float|The total amount charged by some provider of goods or services (e.g. hospital, physician pharmacy, dme provider) to payers (insurance companies, the patient).| | + | |total_charge|No|float|The total amount charged by some provider of goods or services (e.g. hospital, physician pharmacy, dme provider) to payers (insurance companies, the patient).| |
|total_cost|No|float|The cost incurred by the provider of goods or services.| | |total_cost|No|float|The cost incurred by the provider of goods or services.| | ||
|total_paid|No|float|The total amount actually paid from all payers for goods or services of the provider.| | |total_paid|No|float|The total amount actually paid from all payers for goods or services of the provider.| | ||
Line 25: | 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 ==== | ||
Line 55: | Line 63: | ||
* 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. | ||