User Tools

Site Tools


documentation:cdm:drug_cost

DRUG_COST table

As of version 5.0.1 (5-Apr-2016), this table is no longer part of the OMOP CDM. It is replaced by the COST table.

For prior definition, see below.


The DRUG_COST table captures records containing the cost of a Drug Exposure. The information about the cost is defined by the amount of money paid by the Person and Payer for the Drug, as well as the charged cost of the Drug. In addition, a reference to the health plan information in the PAYER_PLAN_PERIOD table is stored in the record that is responsible for the determination of the cost as well as some of the Payments.

FieldRequiredTypeDescription
drug_cost_idYesintegerA unique identifier for each DRUG_COST record.
drug_exposure_idYesintegerA foreign key identifier to the Drug record for which cost data are recorded.
currency_concept_idNointegerA concept representing the 3-letter code used to delineate international currencies, such as USD for US Dollar.
paid_copayNofloatThe amount paid by the Person as a fixed contribution to the expenses. Copay does not contribute to the out of pocket expenses.
paid_coinsuranceNofloatThe amount paid by the Person as a joint assumption of risk. Typically, this is a percentage of the expenses defined by the Payer Plan after the Person's deductible is exceeded.
paid_toward_deductibleNofloatThe amount paid by the Person that is counted toward the deductible defined by the Payer Plan.
paid_by_payerNofloatThe amount paid by the Payer. If there is more than one Payer, several DRUG_COST records indicate that fact.
paid_by_coordination_benefitsNofloatThe amount paid by a secondary Payer through the coordination of benefits.
total_out_of_pocketNofloatThe total amount paid by the Person as a share of the expenses.
total_paidNofloatThe total amount paid for the expenses of drug exposure.
ingredient_costNofloatThe portion of the drug expenses due to the cost charged by the manufacturer for the drug, typically a percentage of the Average Wholesale Price.
dispensing_feeNofloatThe portion of the drug expenses due to the dispensing fee charged by the pharmacy, typically a fixed amount.
average_wholesale_priceNofloatList price of a Drug set by the manufacturer.
payer_plan_period_idNointegerA foreign key to the PAYER_PLAN_PERIOD table, where the details of the Payer, Plan and Family are stored.

Conventions

  • Each Drug Exposure may have any number of corresponding records in the DRUG_COST table, but usually it is none (no cost data recorded) or one. They are linked directly through the drug_exposure_id field.
  • The amounts paid are:
    • Copay – a fixed amount to be paid by the Person
    • Coinsurance – a relative amount of the total paid by the Person
    • Deductible – an amount of money paid by the Person before the Payer starts contributing
    • Primary Payer – the amount the primary Payer pays towards the total
    • Coordination of Benefits – the amount a secondary Payer or Family Plan pays towards the total
    • Out of Pocket = Copay + Coinsurance + Deductible
    • Total – the total amount paid for the Drug Exposure
  • Drug costs are:
    • Ingredient Cost – the amount charged by the wholesale distributor or manufacturer
    • Dispensing Fee – the amount charged by the pharmacy
    • Sales Tax. This is usually very small and typically not provided by most source data, and therefore not included in the CDM
  • The amount paid should equal the cost, so Copay + Coinsurance + Deductible + Primary Payer + Coordination of Benefits = Total Paid = Ingredient Cost + Dispensing Fee. In reality, this is not always reflected in the source data. It is up to the ETL to determine how to deal with quality problems in the data.
  • The Average Wholesale Price is the list price of the drug, but not the price actually charged or paid.
documentation/cdm/drug_cost.txt · Last modified: 2016/05/03 19:58 by cgreich