inst/QueryLibrary/Aggregate/drug_era/DER02.md

In sib-swiss/dsQueryLibraryServer: OMOP query Library

DER02: What is cost of ERA? - era -> exposure -> cost

Description

Query

SELECT        sum(COALESCE(c.total_paid, 0)) as total_cost4era
FROM        @cdm.drug_exposure e,
            @cdm.cost c
WHERE
        exists
                (
                select        1
                from        @cdm.drug_era r,
                            @vocab.concept_ancestor m
                where
                        r.drug_era_id = $1
                        and r.person_id = e.person_id
                        and r.drug_concept_id = m.ancestor_concept_id
                        and e.drug_concept_id = m.descendant_concept_id
                        and (e.drug_exposure_start_date >= r.drug_era_start_date) AND (e.drug_exposure_start_date <= r.drug_era_end_date)
                )
AND e. drug_exposure_id = c.cost_event_id

Input

| Parameter | Example | Mandatory | Notes | | --- | --- | --- | --- | | drug_era_id | 20 | Yes | |

Output

| Field | Description | | --- | --- | | Total_cost4era | Total cost for drug era |

Example output record

| Field | Description | | --- | --- | | Total_cost4era | 25.23 |

Documentation

https://github.com/OHDSI/CommonDataModel/wiki/

sib-swiss/dsQueryLibraryServer documentation built on Feb. 13, 2025, 8:07 p.m.