Skip to main content

Service History widget

  1. Last updated
  2. Save as PDF

The Service History widget displays the most recent 30 services entered for a specified client.

The following fields should be displayed in the widget:

  • Service Date 
  • Status (Appointment status)
  • Start Time
  • End Date
  • Staff Name 
  • Program
  • Service Code 
  • Duration
  • Costs (Charge)
  • Location (Site)

The items should be listed in descending order by Service Date.

Widget SQL Statement

Select:  TOP 30 TO_CHAR(date_of_service,'MM-DD-YYYY') as "Date" ,
SYSTEM.billing_tx_history.appointment_status_value as "Status", SYSTEM.billing_tx_history.appt_start_time as "Start Time", SYSTEM.billing_tx_history.appt_end_time as "End Time", SYSTEM.billing_tx_history.v_PROVIDER_NAME as "Staff Name", SYSTEM.billing_tx_history.program_value as "Program", SYSTEM.billing_tx_history.SERVICE_CODE as "Service Code", SYSTEM.billing_tx_history.duration as "Duration", SYSTEM.billing_tx_history.cost_of_service as "Cost", SYSTEM.billing_tx_history.location_value as "Location" FROM SYSTEM.billing_tx_history WHERE (SYSTEM.billing_tx_history.FACILITY=?FACILITY) AND (SYSTEM.billing_tx_history.PATID=?PATID) ORDER BY SYSTEM.billing_tx_history.date_of_service DESC

For more information, see the Billing Widget Consoles training guide.