Table postgres.omop.cost
[ECONOMIC] 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.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
cost_id int4 10 A unique identifier for each COST record.
cost_event_id int4 10 A foreign key identifier to the event (e.g. Measurement, Procedure, Visit, Drug Exposure, etc) record for which cost data are recorded.
cost_domain_id varchar 20 The concept representing the domain of the cost event, from which the corresponding table can be inferred that contains the entity for which cost information is recorded.
cost_type_concept_id int4 10 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 int4 10  √  null
concept.concept_id fpk_visit_cost_currency R
A foreign key identifier to the concept representing the 3-letter code used to delineate international currencies, such as USD for US Dollar.
total_charge numeric 131089  √  null 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 numeric 131089  √  null The cost incurred by the provider of goods or services.
total_paid numeric 131089  √  null The total amount actually paid from all payers for goods or services of the provider.
paid_by_payer numeric 131089  √  null The amount paid by the Payer for the goods or services.
paid_by_patient numeric 131089  √  null The total amount paid by the Person as a share of the expenses.
paid_patient_copay numeric 131089  √  null The amount paid by the Person as a fixed contribution to the expenses.
paid_patient_coinsurance numeric 131089  √  null The 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_patient_deductible numeric 131089  √  null The amount paid by the Person that is counted toward the deductible defined by the Payer Plan. paid_patient_deductible does contribute to the paid_by_patient variable.
paid_by_primary numeric 131089  √  null The amount paid by a primary Payer through the coordination of benefits.
paid_ingredient_cost numeric 131089  √  null The amount paid by the Payer to a pharmacy for the drug, excluding the amount paid for dispensing the drug. paid_ingredient_cost contributes to the paid_by_payer field if this field is populated with a nonzero value.
paid_dispensing_fee numeric 131089  √  null The amount paid by the Payer to a pharmacy for dispensing a drug, excluding the amount paid for the drug ingredient. paid_dispensing_fee contributes to the paid_by_payer field if this field is populated with a nonzero value.
payer_plan_period_id int4 10  √  null
payer_plan_period.payer_plan_period_id fpk_visit_cost_period R
A foreign key to the PAYER_PLAN_PERIOD table, where the details of the Payer, Plan and Family are stored. Record the payer_plan_id that relates to the payer who contributed to the paid_by_payer field.
amount_allowed numeric 131089  √  null The contracted amount agreed between the payer and provider.
revenue_code_concept_id int4 10  √  null A foreign key referring to a Standard Concept ID in the Standardized Vocabularies for Revenue codes.
revenue_code_source_value varchar 50  √  null The source code for the Revenue code as it appears in the source data, stored here for reference.
drg_concept_id int4 10  √  null
concept.concept_id fpk_drg_concept R
A foreign key to the predefined concept in the DRG Vocabulary reflecting the DRG for a visit.
drg_source_value varchar 3  √  null The 3-digit DRG source code as it appears in the source data.

Table contained 0 rows at dim. sept. 10 20:08 CEST 2017

Indexes:
Column(s) Type Sort Constraint Name
cost_id Primary key Asc xpk_visit_cost

Close relationships  within of separation: