Updating the Provider Select List - Updating the Provider Select List - OnBase - Other - Clinician Complete and Return - Other/Clinician-Complete-and-Return/1.2/Clinician-Complete-and-Return/Administration/Update-SQL-Queries-in-the-Reporting-Dashboard/Updating-the-Provider-Select-List - 1.2 - 1.2

Clinician Complete and Return

Platform
Other
Product
Clinician Complete and Return
Release
1.2
License
ft:lastPublication
2026-07-31T00:46:37.531000
ft:locale
en-US

The Provider Select List for the CCR - Provider Assignments Awaiting Action dashboard uses custom SQL and must be updated for each customer environment.

To update the Provider Select List, you need to update the SQL statement by replacing placeholder data with the actual Keyword # of the Keyword Types found in OnBase Configuration.

To update the Provider Select List:

  1. Open the Reporting Dashboard in the Unity Client or Web Client.
    • To open the Reporting Dashboard in the Unity Client, on the Home ribbon, click Dashboards.
    • To open the Reporting Dashboard in the Web Client, click the menu button and, under Reporting Dashboards, click Gallery.
  2. Click the Administration button.
  3. Under Administration, click Global Select Lists.
    The Manage Select Lists dialog box is displayed.
  4. Under Select List, select Physician.
  5. In the select statement entry distinct(KG.kg###), ensure the number represented by ### is the Keyword # of the CCR Provider Name Keyword Type as it appears in OnBase Configuration in the Keyword Type Configuration dialog box.
  6. In the inner join entry hsi.keygroupdata###, ensure the number represented by ### is the Keyword Group # of the CCR - Form Assignment Keyword Type Group as it appears in OnBase Configuration in the Keyword Type Group Configuration dialog box.
  7. In the where clause entry KG.kgxxx = 'UNACKNOWLEDGED', ensure the number represented by ### is the Keyword # of the CCR Assignment Status Keyword Type as it appears in OnBase Configuration in the Keyword Type Configuration dialog box.
  8. Click OK.
    Changes to the Provider Select List are saved.