Input:
| Parameter |
Example |
Mandatory |
Notes |
| list of drug_concept_id |
906805, 1517070, 19010522 |
Yes |
|
Sample query run:
The following is a sample run of the query. The input parameters are highlighted in blue
SELECT avg(dc.total_out_of_pocket) as avg_out_pocket_cost,
d.drug_concept_id
from drug_cost dc,
drug_exposure d
where d.drug_exposure_id = dc.drug_exposure_id
and dc.total_out_of_pocket > 0
and d.drug_concept_id in (906805, 1517070, 19010522)
group by d.drug_concept_id
;
Output:
Output field list:
| Field |
Description |
| drug_concept_id |
A foreign key that refers to a standard concept identifier in the vocabulary for the drug concept. |
| drug_cost |
|
| drug_exposure_id |
A foreign key identifier to the drug record for which cost data are recorded. |
| total_out_of_pocket |
The total amount paid by the person as a share of the expenses, excluding the copay. |
Sample output record:
| Field |
Description |
| drug_concept_id |
|
| drug_cost |
|
| drug_exposure_id |
|
| total_out_of_pocket |
|
|
|
