User Tools

Site Tools


documentation:cdm:visit_cost

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
documentation:cdm:visit_cost [2016/04/12 03:23]
cgreich
documentation:cdm:visit_cost [2016/05/03 19:43]
cgreich
Line 1: Line 1:
 ===== VISIT_COST table ===== ===== VISIT_COST table =====
-This table is no longer part of the OMOP CDM Version 5, and replaced by the [[documentation:​cdm:​cost|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 [[documentation:​cdm:​cost|COST]] table. 
 + 
 +For prior definition, see below. 
 +---- 
 +===== VISIT_COST table ===== 
 +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. 
 +^Field^Required^Type^Description^ 
 +|visit_cost_id|Yes|integer|A unique identifier for each procedure cost record.| 
 +|visit_occurrence_id|Yes|integer|A foreign key identifier to the procedure record for which cost data are recorded.| 
 +|currency_concept_id|No|integer|A concept representing the 3-letter code used to delineate international currencies, such as USD for US Dollar.| 
 +|paid_copay|No|float|The amount paid by the Person as a fixed contribution to the expenses. Copay does not contribute to the out_of_pocket expenses.| 
 +|paid_coinsurance|No|float|The 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_ deductible|No|float|The amount paid by the Person that is counted toward the deductible defined by the health benefit Plan.| 
 +|paid_by_payer|No|float|The amount paid by the Payer (insurer). If there is more than one Payer, several VISIT_COST records indicate that fact.| 
 +|paid_by_coordination_benefits|No|float|The amount paid by a secondary Payer through the coordination of benefits.| 
 +|total_out_of_pocket|No|float|The total amount paid by the Person as a share of the expenses, excluding the copay.| 
 +|total_paid|No|float|The total amount paid for the expenses of the procedure.| 
 +|payer_plan_period_id|No|integer|A 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