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
Next revision
Previous revision
documentation:cdm:visit_cost [2016/04/12 03:23]
cgreich
documentation:cdm:visit_cost [2016/05/03 19:43] (current)
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. 
 +---- 
 +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.1460431403.txt.gz · Last modified: 2016/04/12 03:23 by cgreich