Prescription Stop

Identify prescription stops (including medication name, dose and date stopped), by (stopping) end user, based on the NextGen Patient Medication table.

[DB Fields]

"person"."last_name"

"person"."first_name"

"patient_medication"."person_id"

"patient_medication"."modify_timestamp"

"patient_medication"."create_timestamp"

"fdb_medication"."brand_name"

"patient_medication"."date_stopped"

"patient_medication"."modified_by"

"user_mstr"."last_name"

"user_mstr"."first_name"

[Report Fields]

Patient Name = @PatientName, Change Date(Report Param under the @PatientName field)

Medication name = "fdb_medication"."brand_name"

Stop Date = @Stop Date

Change Date = @UTCDate, "patient_medication"."modify_timestamp" (under the @UTCDate field)

User name = @UserName

[Formula Fields]

@DateStopped =

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

{patient_medication.create_timestamp}

else

{patient_medication.modify_timestamp}

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

@Stop Date = {patient_medication.date_stopped}[5 to 6]+"/"+{patient_medication.date_stopped}[7 to 8]+"/"+{patient_medication.date_stopped}[1 to 4]

@UserName = Trim({user_mstr.first_name}) + " " + Trim({user_mstr.last_name})

@UTCDate =

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")

[Report Parameters]

Change Date

[Record Selection]

{@DateStopped} = {?Change Date} and

{patient_medication.date_stopped} <> '' and

{patient_medication.date_stopped} <> '00000000'