ID

35638

Descrizione

OMOP Common Data Model (CDM) Cost The COST table captures records containing the cost of any medical event recorded in one of the OMOP clinical event tables such as DRUG_EXPOSURE, PROCEDURE_OCCURRENCE, VISIT_OCCURRENCE, VISIT_DETAIL, DEVICE_OCCURRENCE, OBSERVATION or MEASUREMENT. Each record in the cost table account for the amount of money transacted for the clinical event. So, the COST table may be used to represent both receivables (charges) and payments (paid), each transaction type represented by its COST_CONCEPT_ID. The COST_TYPE_CONCEPT_ID field will use concepts in the Standardized Vocabularies to designate the source (provenance) of the cost data. A reference to the health plan information in the PAYER_PLAN_PERIOD table is stored in the record for information used for the adjudication system to determine the persons benefit for the clinical event. OMOP Common Data Model Version 6.0 Specifications 11October2018. The Observational Medical Outcomes Partnership (OMOP) was a public-private partnership established to inform the appropriate use of observational healthcare databases for studying the effects of medical products. © 2014 Observational Health Data Sciences and Informatics. This work is based on work by the Observational Medical Outcomes Partnership (OMOP) and used under license from the FNIH at http://omop.fnih.org/publiclicense. Version updated on 13.03.2019, from https://github.com/OHDSI/CommonDataModel/wiki/COST The cost information is linked through the COST_EVENT_ID field to its entity, which denotes a record in a table referenced by the COST_EVENT_FIELD_CONCEPT_ID field. One cost record is generated for each response by a payer. In a claims databases, the payment and payment terms reported by the payer for the goods or services billed will generate one cost record. If the source data has payment information for more than one payer (i.e. primary insurance and secondary insurance payment for one entity), then a cost record is created for each reporting payer. Therefore, it is possible for one procedure to have multiple cost records for each payer, but typically it contains one or no record per entity. Payer reimbursement cost records will be identified by using the PAYER_PLAN_ID field. One cost record is generated for each money or currency amount associated with a record in one of the event tables. When dealing with summary costs, the cost of the goods or services the provider provides is often not known directly, but derived from the hospital charges multiplied by an average cost-to-charge ratio. This data is currently available for NIS datasets, or any other HCUP datasets. See also cost calculation explanation from AHRQ Drug costs are composed of ingredient cost (the amount charged by the wholesale distributor or manufacturer), the dispensing fee (the amount charged by the pharmacy and the sales tax). In claims data, generally there is one field representing the total payment from the payer for the service/device/drug. However, this field could be a calculated field if the source data provides separate payment information for the ingredient cost and the dispensing fee in case of prescription benefits. If there is more than one Payer in the source data, several cost records indicate that fact. The Payer reporting this reimbursement should be indicated under the PAYER_PLAN_ID field. For more information, please see https://github.com/OHDSI/CommonDataModel/wiki/COST

collegamento

http://omop.fnih.org/publiclicense

Keywords

versioni (1)
  1. 13/03/19 13/03/19 -
Titolare del copyright

Observational Medical Outcomes Partnership (OMOP)

Caricato su

13 marzo 2019

DOI

Per favore, per richiedere un accesso.

Licenza

Creative Commons BY-NC 3.0
Commenti del modello :

Puoi commentare il modello dati qui. Tramite i fumetti nei gruppi di articoli e articoli è possibile aggiungere commenti a quelli in modo specifico.

Torna ai commenti del modello
Commenti del gruppo di articoli per :

Commenti dell'articolo per :

Per scaricare i modelli di dati devi essere registrato. Per favore accesso o registrati GRATIS.

OMOP Common Data Model (CDM)

Inglese

Cost

1 moduli  
  1. StudyEvent: ODM
    1. Cost
Cost
Descrizione

Cost

Alias
UMLS CUI-1
C0220812
Payer plan period ID
Descrizione

An identifier for each unique combination of payer, plan, family code and time span.

Tipo di dati

integer

Alias
UMLS CUI [1,1]
C2348942
UMLS CUI [1,2]
C1301732
UMLS CUI [1,3]
C1948053
UMLS CUI [1,4]
C1300638
Person ID
Descrizione

A unique identifier for each PERSON.

Tipo di dati

integer

Alias
UMLS CUI [1]
C2348585
Cost ID
Descrizione

A unique identifier for each COST record.

Tipo di dati

integer

Alias
UMLS CUI [1,1]
C0220812
UMLS CUI [1,2]
C1300638
Cost event ID
Descrizione

A foreign key identifier to the event (e.g. Measurement, Procedure, Visit, Drug Exposure, etc) record for which cost data are recorded.

Tipo di dati

integer

Alias
UMLS CUI [1,1]
C0220812
UMLS CUI [1,2]
C0441471
UMLS CUI [1,3]
C1300638
Cost event field concept ID
Descrizione

A foreign key identifier to a concept in the CONCEPT table representing the identity of the field represented by COST_EVENT_ID

Tipo di dati

integer

Alias
UMLS CUI [1,1]
C0220812
UMLS CUI [1,2]
C1521738
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Cost concept ID
Descrizione

A foreign key that refers to a Standard Cost Concept identifier in the Standardized Vocabularies belonging to the 'Cost' vocabulary.

Tipo di dati

integer

Alias
UMLS CUI [1,1]
C0220812
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Cost type concept ID
Descrizione

A foreign key identifier to a concept in the CONCEPT table for the provenance or the source of the COST data and belonging to the 'Cost Type' vocabulary

Tipo di dati

integer

Alias
UMLS CUI [1,1]
C0220812
UMLS CUI [1,2]
C0332307
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Cost source concept ID
Descrizione

A foreign key to a Cost Concept that refers to the code used in the source.

Tipo di dati

integer

Alias
UMLS CUI [1,1]
C0220812
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Cost source value
Descrizione

The source value for the cost as it appears in the source data. (Type varchar(50))

Tipo di dati

text

Alias
UMLS CUI [1,1]
C0220812
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0805701
Currency concept ID
Descrizione

A foreign key identifier to the concept representing the 3-letter code used to delineate international currencies, such as USD for US Dollar. These belong to the 'Currency' vocabulary

Tipo di dati

integer

Alias
UMLS CUI [1,1]
C0560341
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Cost
Descrizione

The actual financial cost amount. The COST field represents the dollar amount, either incoming or outgoing.

Tipo di dati

float

Alias
UMLS CUI [1]
C0010186
Incurred date
Descrizione

The first date of service of the clinical event corresponding to the cost as in table capturing the information (e.g. date of visit, date of procedure, date of condition, date of drug etc).

Tipo di dati

date

Alias
UMLS CUI [1,1]
C0011008
UMLS CUI [1,2]
C0199168
UMLS CUI [1,3]
C0220812
Billed date
Descrizione

The date a bill was generated for a service or encounter

Tipo di dati

date

Alias
UMLS CUI [1,1]
C0011008
UMLS CUI [1,2]
C2981733
Paid date
Descrizione

The date payment was received for a service or encounter

Tipo di dati

date

Alias
UMLS CUI [1,1]
C0680264
UMLS CUI [1,2]
C0199168
UMLS CUI [1,3]
C0011008
Revenue code concept ID
Descrizione

A foreign key referring to a Standard Concept ID in the Standardized Vocabularies for Revenue codes belonging to the 'Revenue Code' vocabulary. Revenue codes are a method to charge for a class of procedures and conditions in the U.S. hospital system.

Tipo di dati

integer

Alias
UMLS CUI [1,1]
C1547834
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
DRG concept ID
Descrizione

A foreign key referring to a Standard Concept ID in the Standardized Vocabularies for DRG codes belonging to the 'DRG' vocabulary. Diagnosis Related Groups are US codes used to classify hospital cases into one of approximately 500 groups. APR-DRG codes were recently added to the vocabulary and are now supported along with MS-DRGs .

Tipo di dati

integer

Alias
UMLS CUI [1,1]
C0011928
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Revenue code source value
Descrizione

The source value for the Revenue code as it appears in the source data, stored here for reference. (Type varchar(50))

Tipo di dati

text

Alias
UMLS CUI [1,1]
C1547834
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0805701
DRG source value
Descrizione

The source value for the 3-digit DRG source code as it appears in the source data, stored here for reference. (Type varchar(50))

Tipo di dati

text

Alias
UMLS CUI [1,1]
C0011928
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0805701
Payer plan period ID
Descrizione

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.

Tipo di dati

integer

Alias
UMLS CUI [1,1]
C2348942
UMLS CUI [1,2]
C1301732
UMLS CUI [1,3]
C1948053
UMLS CUI [1,4]
C1300638
Ritorna all'inizio della pagina

Similar models

Cost

1 moduli
  1. StudyEvent: ODM
    1. Cost
Name
genere
Description | Question | Decode (Coded Value)
Tipo di dati
Alias
Item Group
Cost
C0220812 (UMLS CUI-1)
Payer plan period ID
Item
Payer plan period ID
integer
C2348942 (UMLS CUI [1,1])
C1301732 (UMLS CUI [1,2])
C1948053 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Person ID
Item
Person ID
integer
C2348585 (UMLS CUI [1])
Cost ID
Item
Cost ID
integer
C0220812 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Cost event ID
Item
Cost event ID
integer
C0220812 (UMLS CUI [1,1])
C0441471 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Cost event field concept ID
Item
Cost event field concept ID
integer
C0220812 (UMLS CUI [1,1])
C1521738 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Cost concept ID
Item
Cost concept ID
integer
C0220812 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Cost type concept ID
Item
Cost type concept ID
integer
C0220812 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Cost source concept ID
Item
Cost source concept ID
integer
C0220812 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Cost source value
Item
Cost source value
text
C0220812 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0805701 (UMLS CUI [1,3])
Currency concept ID
Item
Currency concept ID
integer
C0560341 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Cost
Item
Cost
float
C0010186 (UMLS CUI [1])
Incurred date
Item
Incurred date
date
C0011008 (UMLS CUI [1,1])
C0199168 (UMLS CUI [1,2])
C0220812 (UMLS CUI [1,3])
Billed date
Item
Billed date
date
C0011008 (UMLS CUI [1,1])
C2981733 (UMLS CUI [1,2])
Paid date
Item
Paid date
date
C0680264 (UMLS CUI [1,1])
C0199168 (UMLS CUI [1,2])
C0011008 (UMLS CUI [1,3])
Revenue code concept ID
Item
Revenue code concept ID
integer
C1547834 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
DRG concept ID
Item
DRG concept ID
integer
C0011928 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Revenue code source value
Item
Revenue code source value
text
C1547834 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0805701 (UMLS CUI [1,3])
DRG source value
Item
DRG source value
text
C0011928 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0805701 (UMLS CUI [1,3])
Payer plan period ID
Item
Payer plan period ID
integer
C2348942 (UMLS CUI [1,1])
C1301732 (UMLS CUI [1,2])
C1948053 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Ritorna all'inizio della pagina 

Contatto

Si prega di utilizzare questo modulo per feedback, domande e suggerimenti per miglioramenti.

I campi contrassegnati da * sono obbligatori.

Aiuto

Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

Watch Tutorial