Creating an expanded AUX reason code report

Last Updated : May 01, 2015 |

About this task

The standard CMS Supervisor reports for CMS include a new field for the Expanded AUX feature. The field contains the combined calculated time for AUX reason codes 10 through 99. This field will be in any reports that display time in AUX. If you need your report to include specific AUX reason codes, you should create a custom report or modify an existing standard report.

The following report is an example of the type of custom report you can create with Report Designer when you use the following procedure.

Procedure

  1. Open the CMS Supervisor interface and locate the Commands option on the menu bar.
  2. Select Commands > Reports.

    The system displays the Report Selector window.

  3. Select New.

    The system displays a prompt to run the report wizard.

  4. Select No.

    The system displays the Report Designer window.

  5. Select from the menu bar Edit > Inputs.

    The system displays the Edit Inputs window.

  6. Select Agent in the Input Types list, and then select the Add button.
  7. Select Date in the Input Types list, and then select the Add button.
  8. Select the OK button.

    The system returns to the Report Designer window.

  9. Select from the menu bar Edit > Queries.

    The system displays the Query Select window.

  10. Select the New button.

    The system displays the Query Assistant Window.

  11. Locate the Database section, and select Historical.
  12. Locate the table section, and select Agent Daily.
  13. Select the Next button.
  14. Locate the Database Items list.
  15. Select each of the following database items, and add the item to the Query Items list by selecting the Add button.

    • TI_AUXTIME

    • TI_AUXTIME0 through

    • TIAUXTIME99

  16. Select Next.

    The system displays the Query Assistant window.

  17. Select Next.

    The system displays the Query Assistant window.

  18. Locate the Operand1, Operator, and Operand2 lists.
  19. Scroll through the lists and select:

    • LOGID as Operand1

    • = as the Operator

    • [Agent] as Operand2

  20. Select the AND button.
  21. Scroll through the lists and select:

    • ROW_DATE as Operand1

    • = as the Operator

    • [Date] as Operand2

  22. Select the AND button.
  23. Select Next.
  24. Enter a name for the query, or accept the default query name.
  25. Select Done.

    The system displays the Query Select window.

  26. Select Close.

    The system redisplays the Report Designer window.

  27. Select from the menu bar Insert > Table.

    The system displays the Table Assistant window.

  28. Select your query in the Queries drop down list.
  29. Select the Add all button.
  30. Select Next.
  31. Right-click on the table, and then select Format table.
  32. Select Vertical in the Orientation section.
  33. Select Grid Lines on in the Options section.
  34. Select the Done button.
  35. Select from the menu bar Report > Run.
  36. Save the report when you exit. Select from the menu bar Report > Exit.