Run Time and Effort BI Publisher Query

Purpose:  To execute the Run Time and Effort BI Publisher Query in ctcLink.

Audience:  Time and Labor Specialists.

You must have all of these local college managed security roles:

  • ZD_DS_QUERY_VIEWER
  • ZD_DS_QRY_PAYROLL  

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

NOTE:  This report is only intended to serve the requirement for a certification statement for Time and Effort of faculty and exempt employees where after the fact reporting is not mandated.

Time and Effort BI Publisher Query

Navigation:  Reporting Tools > BI Publisher > Query Report Scheduler

  1. The Query Report Scheduler search page displays.
  2. Enter an existing Run Control ID or select the Add a New Value tab.
  3. Enter the new Run Control ID.
  4. Select the Add button.
  5. The Query Report Scheduler page displays.
  6. Select Data Source Type: Connected Query
  7. Select Report Name: BHC_CO_00002.
Query Report Scheduler
  1. The Prompt pagelet displays.
  2. Fill in the following Prompt for Query:  GL Unit, From Pay Period End Date and To Pay Period End Date
  3. ID (this EMPL ID must have Job Data which contains a combo code that is paid from a project/grant in the chartfield).
  4. Select the OK button.
Query Report Scheduler - Prompt 1 pagelet
  1. The Query Report Scheduler page displays.  Select the Run button. (The Run Control automatically saves.)
Query Report Scheduler - Run
  1. The Process Scheduler Request page displays.  Select the OK button.
  2. The Query Report Scheduler page displays.
  3. Select the Process Monitor link at the top of the page.
  4. Select the Refresh button until the process has a Run Status of Success and Distribution Status of Posted.
  5. Select the Go Back to Query Report Scheduler link at the bottom of the Process Monitor page.
  6. Select the Report Manager link at the top of the reports page.
  7. In the List tab, select the name of the report (BHC_CO_00002  BHC_CO_00002.rtf) that corresponds to your process instance.
Report Manager - List tab with Report Name highlighted
  1. Once inside the report, select the file with .rtf at the end and it will give you the option to open or download depending on your internet browser settings.
Report Index - File List with name highlighted
  1. The report will display employee’s time and effort data as shown below:
Example Staff Effort Certification Report

End of procedure.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.