9.2 Sending Pay to Payroll via FWL Pay Line Extract

Purpose: Use this document as a reference for how to send pay amounts, from the FWL Pay Line, where the  'Ok to Pay' has been checked, and run the automated process to extract all Pay Lines to send to Payroll in ctcLink.

Audience: HR\Payroll Staff.

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

  • ZZ FWL Pay Processing

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

Navigations: 

Campus Solutions (CS):  NavBar > Navigator > Curriculum Management > CTC Custom > Faculty Workload > Faculty Workload Processing > FWL Pay Line Extract

Human Capital Management (HCM):  NavBar > Navigator > Payroll for North America > CTC Custom > Paysheet Holding Update

While marking Ok to Pay can be done manually it is not efficient; therefore, it is recommended that colleges run the FWL OPT Mass Assignment to check Ok to Pay for all unsent Pay Line rows on or before a specific Pay Date.

Note: For information on how to manage negative Pay Lines refer to the Quick Reference Guide - Managing Negative Pay Lines.

Sending Pay to Payroll via FWL Pay Line Extract

FWL Pay Line Extract

CS Navigation:  NavBar > Navigator > Curriculum Management > CTC Custom > Faculty Workload > Faculty Workload Processing > FWL Pay Line Extract

  1. The Faculty Workload Payline run control search page displays.
  2. Enter an existing Run Control ID.
  3. Or select Add a New Value tab and enter a new Run Control ID (e.g. FWL_PAYLINE_P17) and select Add.
add a new value tab

Note: The payroll process is not term specific, therefore the process to extract pay from FWL does not use the Term.  The Pay Date will always be the next upcoming payroll date for that selected Pay Group.

  1. The Faculty Workload Pay Line page displays.
  2. On the Run Control Parameter page enter the following:
    • Company: Enter the Company Code or use the Look Up.
    • Pay Group: Enter the Pay Group or use the Look Up.  
      • The Pay Date parameter allows the system to sweep through all Pay Lines marked Ok to Pay  based on the individual class start and end date payment not yet sent to payroll with the selected Pay Date or earlier.  The system also will pick up ANY negative Pay Lines marked Ok to Pay and not yet sent to payroll, regardless of Pay Date.
    • Off Cycle: Leave the Off-Cycle check box unchecked.  Leaving this box unchecked will stop the off-cycle pay calendar entries from appearing in the Look Up Pay Date window.
  1. Select Save to store the parameters against the Run Control ID.
  2. Select Run to launch the process.
faculty worklaod pay line select save and run
  1. The Process Scheduler Request page displays.
  2. Select the OK button.
Process Scheduler Request page
  1. The Faculty Workload Pay Line page displays.
  2. Select the Process Monitor link.
select process monitor link
  1. The Process Monitor page displays.
  2. When the Run Status = Success and the Distribution Status = Posted, select the Details link.
select the Details link
  1. The Process Detail page displays.
  2. Select the View Log/Trace link.
select view log/trace link
  1. The View Log/Trace page displays.
  2. Select the HCM Pay Line Extract log file.
select log file link
  1. The Process / Interface Log displays.
  2. The log file will report the total number of rows from the FWL Pay Line that were picked up and sent to payroll.
  3. The log file will also report the total number of rows added to the Pay Sheet Upload (PSHUP) staging table.
Process / Interface log
  1. Once a Pay Line has been extracted to post to the Pay Sheet Upload (PSHUP) staging table, that Pay Line row will be marked in the Pay Sent check box.
  2. Note: the payline will be sent each row based on the start and end date of a class.
  3. Once the summarized pay line data has been added to the Pay Sheet staging table it can be seen in the Paysheet Holding Update page.
  4. The process to run the FWL pay line extract is now complete.

Paysheet Holding Update (PSHUP_TXN)

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

  • ZD FWL HCM View Pay
  • ZZ SS Payroll
  • ZZ Payroll Processing
  • ZZ FWL HCM Pay Process

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

HCM Navigation:  NavBar > Navigator > Payroll for North America > CTC Custom > Paysheet Holding Update

  1. The Paysheet Holding Update search page displays.
  2. Enter the Search Criteria.
  3. Select the Search button.
Paysheet Holding Update search page
  1. The Paysheet Holding Update (PSHUP_TXN) page displays.
  1. The process to send pay to payroll via FWL Pay Line Extract is now complete.
  2. End of procedure.

0 Comments

Add your comment

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