9.2 Run Time and Effort Connected Query
Purpose: To execute the run time and effort connected query in ctcLink.
Audience: Time and Labor Specialists.
You must have all of these local college managed security roles:
- ZD TL Admin View Time
- ZD_DS_QUERY_VIEWER
- ZD_DS_QRY_PAYROLL
- ZD_DS_QRY_PAY_GARN_HIGH_SENS
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 Connected Query
Navigation: NavBar > Navigator > Reporting Tools > BI Publisher > Query Report Scheduler
- The Query Report Scheduler search page displays.
- Enter an existing Run Control ID or select the Add a New Value tab.
- Enter the new Run Control ID.
- Select the Add button.
- The Query Report Scheduler page displays.
- Select Data Source Type: Connected Query
- Select Report Name: BHC_CO_00002.
- The Prompt 1 pagelet displays.
- Fill in the following Prompt for Query:
- GL Unit
- From Pay Period End Date
- To Pay Period End Date
- ID (this EMPL ID must have Job Data which contains a combo code that is paid from a project/grant in the chartfield).
- Select the OK button.
- The Prompt 2 pagelet displays.
- Repeat the same values in Prompt 2.
- Select the OK button.
- The Prompt 3 pagelet displays (the connected query is in actuality three queries so the information must be identical to return a valid value).
- Repeat the same value in Prompt 3.
- Select the OK button.
- The Query Report Scheduler page displays.
- Select the Run button.
- The Process Scheduler Request page displays.
- Select the OK button.
- The Query Report Scheduler page displays.
- Make note of the Process Instance number.
- Select the Process Monitor link at the top of the page.
- Select the Refresh button until the process PSXPQRYRPT has a Run Status of Success/Posted.
- Select the Go Back to Query Report Scheduler link at the bottom of the Process Monitor page.
- Select the Report Manager link at the top of the reports page.
- In the List tab, select the name of the report (BHC_CO_00002 BHC_CO_00002.rtf) that corresponds to your process instance.
- 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.
- The report will display the following fields:
- Staff Name, Staff Department (Job Data value)
- Account Number (Finance value)
- Fund (Finance value)
- Dept (Job Data value)
- Department Name (Job Data value)
- Project ID (Finance value)
- Activity (Finance value)
- Activity Description (Finance value)
- Amount (Payroll value)
- Budget Effort (Job Data value)
- Job Nbr (Job Data value)
- Job Nbr Report Start Date (Payroll Period Begin Date)
- Job Nbr Report End Date (Payroll Period End Date)
- Actual Effort (if different)
- Other Salary Sources
- Certification Statement
The run time and effort connected query process is now complete.
End of procedure.
0 Comments
Add your comment