Patient Alerts

Listing of Patients with Rx canceled during Drug Utilization Review, as well as listing of critical range lab results by Provider.

DUR Alerts

Criteria Description:

Patients with a record in the dur_audit table

Data Reference:

{dur_audit.event_text} <> "Rx Cancelled in DUR"

DUR Cancelled

Criteria Description:

Patients with a record in the dur_audit table

Data Reference:

{dur_audit.event_text} = "Rx Cancelled in DUR

LAB Alerts

Data Reference:

Record in the lab_critical_range audit table

[DB Fields]

user_mstr.first_name

user_mstr.last_name, dur_audit

user_mstr.user_id=dur_audit.created_by

dur_audit.event_text

user_mstr.last_name, lab_critical_range_audit

lab_critical_range_audit

user_mstr.user_id=lab_critical_range_audit.created_by

[Formula Fields]

SELECT user_mstr.first_name, user_mstr.last_name, dur_audit.*

FROM dur_audit

JOIN user_mstr ON user_mstr.user_id=dur_audit.created_by

WHERE dur_audit.event_text = 'Rx Cancelled in DUR'

Then, via a subreport, show the data from the lab critical range audit table for the same user

SELECT user_mstr.first_name, user_mstr.last_name, lab_critical_range_audit.*

FROM lab_critical_range_audit

JOIN user_mstr ON user_mstr.user_id=lab_critical_range_audit.created_by