Prescription Renewal

Identify prescription renewals (including medication name, dose and date renewed), by (renewing) end user, based on the NextGen Patient Medication table.

[DB Fields]

"patient_medication"."date_last_refilled"

"person"."last_name"

"person"."first_name"

"patient_medication"."person_id"

"fdb_medication"."dose"

"patient_medication"."modify_timestamp"

"patient_medication"."create_timestamp"

"fdb_medication"."brand_name"

"patient_medication"."org_refills"

"user_mstr"."last_name"

"user_mstr"."first_name"

[Report Fields]

Patient Name = @PatientName

Medication Name = "fdb_medication"."brand_name"

Dose = "fdb_medication"."dose"

Date Renewed = @DateRenewed

Renewed By = @Username

[Formula Fields]

@DateRenewed =

if (IsNull({patient_medication.modify_timestamp})) then

ToText(DateAdd("h", 5, {patient_medication.create_timestamp}), "yyyy-MM-ddTHH:mm:ss")

else

ToText(DateAdd("h", 5, {patient_medication.modify_timestamp}), "yyyy-MM-ddTHH:mm:ss")

@PatientName = {person.last_name} + ", " + {person.first_name}

{user_mstr.last_name} + ", " + {user_mstr.first_name}

[Report Parameters]

None

[Record Selection]

{patient_medication.date_last_refilled} <> '' and

{patient_medication.date_last_refilled} <> '00000000' and

{patient_medication.org_refills} <> ""