9.2 Salary Base Calculation Report

Purpose:  Run the salary base calculation report in ctcLink.

Audience: Benefits Administrator.

You must have at least one of these local college managed security roles:

  • ZD Benefits Reporting

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

PREREQUISITES: Employees must have Job Data and information accessible from FWL.  LTD and Optional LTD should be populated for some employees who also exist in FWL.

Salary Base Calculation Report

Navigation:  NavBar > Navigator > Benefits > CTC Custom > PTF LTD Report

  1. The PTF LTD Salary Base Calc. run control search page displays.
  2. Select the Add a New Value tab and enter a new Run Control ID if this is the first time ever running this report.
  3. Otherwise, enter the existing Run Control ID.
  4. Select the Add or Search button.
PTF LTD Salary Base Calc search page
  1. The PTF LTD Salary Base Calculation Report page displays.
  2. Enter the Company.
  3. Enter the As Of Date.
  4. Select one of the following the Radio buttons (Only one can be run at a time.):
    • All Active PTF
    • Active PTF with Opt LTD
    • EMPL ID(s) 
  5. Select the Run button.  
Process Request Parameters
  1. The Process Scheduler Request page displays.
  2. Select the OK button.
Process Scheduler Request page
  1. The PTF LTD Report page displays. Notice the Process Instance number.
  2. Select the Process Monitor link.
Process Monitor link
  1. The Process List tab displays.
  2. Select the Refresh button until the Run Status is 'Success' and Distribution Status is 'Posted'.
  3. Select the Details link.
Process List tab
  1. The Process Detail page displays.
  2. Select the View Log/Trace link.
Process Detail page
  1. The View Log/Trace page displays.
  2. Select the first .log file.
View Log/Trace page
  1. The Log File page displays in a new window.
  2. The log file mentions the report is generated in the Report Manager.
  3. Close the pop-up window.  The View Log/Trace page is redisplayed.
  4. Select the Return button to close the page.
  5. Select the OK button on the Process Detail page to it.
  6. The Process List tab is now displayed from the Process Monitor page.
  7. Select the Go Back to PTF LTD Salary Base Calc at the bottom of the Process Monitor page.
Process List go back link
  1. The PTF LTD Report page displays.
  2. Select the Report Manager link.
Report Manager link
  1. The Report Manager page displays.
  2. Select the Administration tab.
  3. Select the ****.pdf file.
  4. Run the PTF LTD Report for additional employee types and validate data in report until all three radio buttons have been run once.
Administration tab in report manager
  1. To download data into Excel file format, click on Details link in Process Monitor.
Process Monitor at Process List tab Details link
  1. The Process Detail page opens. Select the View Log/Trace link under the Actions list.
Process Detail page View Log/Trace link
  1. The View Log/Trace page opens. In the File List grid, locate the CSV file and click to open.
  2. Once opened, this file will load directly into Excel.

The process to run the salary base calculation reports is now complete.

End of procedure.

0 Comments

Add your comment

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