Drug Exposure‎ > ‎

DEX33: Counts of drug exposure records stratified by observation month

This query is used to count the drug exposure records stratified by observation month. The input to the query is a value (or a comma-separated list of values) of a month. If the input is omitted, all possible values are summarized.

 Parameter  Example  Mandatory  Notes
list of month numbers 3, 5  Yes

Sample query run:
The following is a sample run of the query. The input parameters are highlighted in blue

select  extract(month from d.drug_exposure_start_date) month_num, 
        COUNT(1) as exp_in_month_count
from drug_exposure d
where extract(month from d.drug_exposure_start_date) in (3, 5)
group by extract(month from d.drug_exposure_start_date)
order by 1 
Output field list:
 Field  Description
drug_exposure_start_date The start date for the current instance of drug utilization. Valid entries include a start date of a prescription, the date a prescription was filled, or the date on which a drug administration procedure was recorded.
drug_exposure_id A system-generated unique identifier for each drug utilization event.

Sample output record:
 Field  Description