Patient Appointment List

Listing of patient appointments, by appointment date and time, based on NextGen Appointment History.

[DB Fields]

"pat_apt_hist"."appointment_date"

"pat_apt_hist"."reason"

"pat_apt_hist"."appt_subject"

"pat_apt_hist"."provider_id"

"provider_mstr"."last_name"

"provider_mstr"."first_name"

"pat_apt_hist"."person_id"

"person"."last_name"

"person"."first_name"

[Report Fields]

Appointment Date and Time = @ApptDate

Appointment Reason = "pat_apt_hist"."reason"

Appointment Provider = "provider_mstr"."last_name" , "provider_mstr"."first_name"

[Formula Fields]

@Appt Date = ToText(DateAdd("h", 5, {pat_apt_hist.appointment_date}), "yyyy-MM-ddTHH:mm:ss") + " (" + ToText({pat_apt_hist.appointment_date}) + ")"

[Report Parameters]

Appt Date, Last name, First Name

[Record Selection]

{pat_apt_hist.appointment_date} = {?Appt Date} and

{person.last_name} = {?Last Name} and

{person.first_name} = {?First Name}