9.2 L&I Processing

Purpose: Use this document as a reference for processing payments to L&I in ctcLink.

Audience:  Payroll Administrators.

L & I Process

View Query

Navigation:  NavBar > Navigator > Reporting Tools > Query > Query Viewer

  1. The Query Viewer search page displays.
  2. Enter CTC_MEDAID_HOURS_RPT in the Search bar and select Search.
  3. The Search Results display.
  4. Select HTML link in the Run to HTML column (make sure pop up blocker does not prevent the new screen from appearing).
Query viewer search page
  1. The Query CTC_MEDAID_HOURS_RPT - L & I Hours Reporting page displays.
  2. Enter the Earliest Pay Period End date or select from the lookup results.
  3. Enter the Latest Pay Period End date or select from the lookup results.
  4. Enter the Co code or select from the lookup results.
  5. Select the View Results button.
    • Note: If you get an error that the query is returning too many rows then you will need to Schedule the query.
  6. Download results as needed by selecting the Excel Spreadsheet link that populates when the query produces results.
Query page with end dates and view results button
  1. The process to view the CTC_MEDAID_HOURS_RPT is now complete.

L&I Website

Note: L&I maintains its own portal whereby individual colleges access their information.  At this point in the process college users should reference the L&I information so they can use that data and the PeopleSoft data to understand what amount should be sent to L&I.

Request Voucher from AP

Send an email to the appropriate AP Admin to enter a regular voucher and send payment.  While information is sent to Finance every Payroll, they will hold payment until Payroll indicates that a payment needs to be sent to L&I.

Note: See Finance QRG: 9.2 Entering a Regular Voucher for next step in the process for Finance.

  1. The L & I process is now complete.
  2. End of procedure.


Add your comment

E-Mail me when someone replies to this comment