I am conducting an HRU (Healthcare Resource Utilization) analysis focused on the cost associated with a patient population across different domains and subcategories.
I have been able to link various domain tables to the cost table using the cost_event_id.
Where I am encountering some confusion is with the Visit domain.
I can link the visit_occurrence table to the cost table by matching visit_occurrence_id = cost_event_id, and I can also link the visit_detail table to the cost table by matching visit_detail_id = cost_event_id.
In some cases, I’ve found that cost records exist for both tables. I’m trying to determine whether the cost for the Visit domain is drawn from both tables and, if so, what the difference is between them. I did some digging but could not find good OMOP documentation on cost table.
Tagging @jenniferduryea and @Gowtham_Rao for the expertise.
documentation:cdm:cost [Observational Health Data Sciences and Informatics]
| cost_domain_id | corresponding CDM table |
|---|---|
| Drug | DRUG_EXPOSURE |
| Visit | VISIT_OCCURRENCE |
| Procedure | PROCEDURE_OCCURRENCE |
| Device | DEVICE_EXPOSURE |
| Measurement | MEASUREMENT |
| Observation | OBSERVATION |
| Specimen | SPECIMEN |