User Tools

Site Tools


documentation:cdm:visit_cost

VISIT_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 VISIT_COST table captures the cost of a Visit of a Person not itemized to specific procedures, drugs, or devices used during the Visit.

FieldRequiredTypeDescription
visit_cost_idYesintegerA unique identifier for each procedure cost record.
visit_occurrence_idYesintegerA foreign key identifier to the procedure 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 Health benefit 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 health benefit Plan.
paid_by_payerNofloatThe amount paid by the Payer (insurer). If there is more than one Payer, several VISIT_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, excluding the copay.
total_paidNofloatThe total amount paid for the expenses of the procedure.
payer_plan_period_idNointegerA foreign key to the PAYER_PLAN_PERIOD table, where the details of the Payer, Plan and Family are stored.

Conventions

  • The cost of the Visit may contain just board and food, but could also include the entire cost of everything that was happening to the patient during the Visit.
  • All other conventions apply as in the PROCEDURE_COST table.
documentation/cdm/visit_cost.txt · Last modified: 2016/05/03 19:43 by cgreich