Observational Health Data Sciences and Informatics

User Tools

Site Tools

Trace: • concept_synonym • cohorts • focusgroup3 • wg_meeting_aug_10_2022 • data_etl • my_great_study • time • specimen • concept_sets • next_cdm
documentation:cdm:cost

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
documentation:cdm:cost [2016/04/12 03:15] – cgreichdocumentation: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 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 18:
 |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 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 41: Line 50:
 |Measurement|MEASUREMENT| |Measurement|MEASUREMENT|
 |Observation|OBSERVATION| |Observation|OBSERVATION|
-|Specimen|SPECIMENT|+|Specimen|SPECIMEN|
  
-  * cost_type_concept_id: The concept referenced in this field defines the source of the cost information, and therefore the perspective. It could be from the perspective of the payer, or the perspective of the provider. Therefore, "cost" really means either cost or revenue, and the direction of funds (incoming and outgoing) as well as the modus of it's calculation is defined by this field.+  * cost_type_concept_id: The concept referenced in this field defines the source of the cost information, and therefore the perspective. It could be from the perspective of the payer, or the perspective of the provider. Therefore, "cost" really means either cost or revenue, and the direction of funds (incoming and outgoing) as well as the modus of its calculation is defined by this field.
   * total_charged and total_cost: The cost of the goods or services the provider provides is often not known directly, but derived from the hospital charges multiplied by an average cost-to-charge ratio. This data is currently available for [[https://www.hcup-us.ahrq.gov/db/nation/nis/nisdbdocumentation.jsp|NIS]] datasets, or any other [[https://www.hcup-us.ahrq.gov/databases.jsp|HCUP]] datasets. See also cost calculation explanation from AHRQ [[https://www.hcup-us.ahrq.gov/db/state/costtocharge.jsp|here]].   * total_charged and total_cost: The cost of the goods or services the provider provides is often not known directly, but derived from the hospital charges multiplied by an average cost-to-charge ratio. This data is currently available for [[https://www.hcup-us.ahrq.gov/db/nation/nis/nisdbdocumentation.jsp|NIS]] datasets, or any other [[https://www.hcup-us.ahrq.gov/databases.jsp|HCUP]] datasets. See also cost calculation explanation from AHRQ [[https://www.hcup-us.ahrq.gov/db/state/costtocharge.jsp|here]].
   * total_paid: This field is calculated using the following formula: paid_by_payer + paid_by_patient + paid_by_primary. In claims data, this field is considered the calculated field the payer expects the provider to get reimbursed for goods and services, based on the payer's contractual obligations.   * total_paid: This field is calculated using the following formula: paid_by_payer + paid_by_patient + paid_by_primary. In claims data, this field is considered the calculated field the payer expects the provider to get reimbursed for goods and services, based on the payer's contractual obligations.
Line 54: Line 63:
   * amount_allowed: This information is generally available in claims data.  This is similar to the total_paid amount in that it shows what the payer expects the provider to be reimbursed after the payer and patient pay.  This differs from the total_paid amount in that it is not a calculated field, but a field available directly in claims data. The field is payer-specific and the payer should be indicated by the payer_plan_id field.   * amount_allowed: This information is generally available in claims data.  This is similar to the total_paid amount in that it shows what the payer expects the provider to be reimbursed after the payer and patient pay.  This differs from the total_paid amount in that it is not a calculated field, but a field available directly in claims data. The field is payer-specific and the payer should be indicated by the payer_plan_id 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.   * 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|No|integer|A foreign key referring to a Standard Concept ID in the Standardized Vocabularies for Revenue codes.| +  * 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_source_value|No|string(50)|The source code for the Revenue code as it appears in the source data, stored here for reference.|+  * 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.
  
documentation/cdm/cost.1460430928.txt.gz · Last modified: by cgreich
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki