DEX38: Counts of stop reasons

This query is used to count stop reasons (stop_reason) across all drug exposure records. The input to the query is a value (or a comma-separated list of values) of a stop_reason. If the input is omitted, all existing values are summarized.

Input:

Parameter

Example

Mandatory

Notes

stop_reason

1

Yes

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

select count(1) as totExp , d.stop_reason
from drug_exposure d
where d.stop_reason in ('INVALID')
group by d.stop_reason
;

Output:
Output field list:

Field

Description

drug_exposure_id

The number of refills after the initial prescription. The initial prescription is not counted, values start with 0.

Count

The number of individual drug exposure occurrences used to construct the drug era.

stop_reason

The reason the medication was stopped, where available. Reasons include regimen completed, changed, removed, etc.