9.2 MetLife Interface and Transmittal

Purpose:  Use this document as a reference for how to understand the MetLife interface and transmittal's relationship to PeopleSoft at a high level in ctcLink.

Audience:  Benefits Administrators, Payroll Administrators.

MetLife Interface and Transmittal

Before MetLife File Gets to ctcLink

  1. A single file is sent to the Data Services Integration team at SBCTC from MetLife containing all college data; both schools in Legacy and ctcLink.
  2. The file is split out by system (ctcLink and Legacy).   The ctcLink file is transferred to the production environment and automatically loaded into the HCM pillar.
  3. The file is also split out by college and becomes available in SUE (Secure Upload Engine) for ctcLink users to download and use for validation of the automatic data load into HCM.
    • College administrators will need to access SUE to retrieve their validation CSV file.
    • Confirm the CSV changes match entries in ctcLink.
    • Generally an email will come from SBCTC (currently from jboesenberg) to announce the upload has occurred.
    • Another email follows the first with your login and password.
    • New administrators should send in a service desk ticket to request access (and it will be vetted for security purposes).

MetLife Inbound File

This is a change only (add, change, remove) file sent from MetLife with deduction data.  Any change to deduction data would cause an employee to be included in the file.

  • Specifics of the file construction can be found in the interface technical document I-119.
  • SSN is used as the employee identifier.

The file is generally produced 4 days prior to payroll, but is scheduled to run every night so a human being does not necessarily need to run this process.

  • The Inbound file, like the Outbound file, includes all colleges so once the file is generated and loaded there will be no new file until the next pay period.

Generally, new data will result in new effective dated records being added to the general deduction for that employee, but it is possible that corrections will be sent requiring the update of an existing record.  These would be recognized using the dates based on pay period end date.  

  • This can start the deduction, change the deduction, or stop the deduction.

Note: PeopleSoft table PS_CTC_MET_REMIT maintains the billing file pay end dates that have been processed and will need to be updated for any reruns required.

Navigation:  NavBar > Navigator > Benefits > CTC Custom > CTC Interfaces > Inbound MetLife Billing

  1. The Inbound MetLife Enrollment run control search page displays.
  2. Enter an existing Run Control ID or select the Add a New Value to add a new one.
  3. Select the Search button.
Inbound MetLIfe Enrollment search page
  1. The Inbound MetLife Billing page displays.
  2. Select the Run button.
Inbound MetLife Billing page
  1. The Process Scheduler Request page displays.
  2. Select the OK button.
  3. The Inbound MetLife Billing page displays.
  4. Select the Process Monitor link.
  5. The Process Monitor page displays.
  6. Select the Refresh button until the process runs to Success/Posted.
  7. The process to run the Inbound MetLife Billing is now complete.

MetLife Outbound File

Note: The outbound process is consolidated, so all runs of a specified payroll must complete successfully at all colleges specified.  If all colleges specified have not completed the specified payroll, do not send the MetLife Remit file.

Outbound file covers all people who had MetLife Insurance deduction 000065 taken from their paycheck that pay period.

  • Specifics of the file construction can be found in the interface technical document I-120.

This run is completed by a specific employee in SBCTC, and is not run by the colleges themselves.

Navigation: NavBar > Navigator > Benefits > CTC Custom > CTC Interfaces > Outbound MetLife Remit

  1. The Outbound MetLife Transmittal search page displays.
  2. On the Find an Existing Value tab, enter the Run Control ID.
  3. Select the Search button.
Find an Existing Value tab
  1. The Outbound MetLife Remit page displays.
  2. Enter the Pay Period End Date.
  3. Select the Run button.

 

Outbound MetLife Remit page
  1. The Process Scheduler Request page displays.
  2. Select the OK button.
  3. The Outbound MetLife Transmittal page displays.
  4. Select the Process Monitor link.
  5. The Process Monitor page displays.
  6. Select the Refresh button until the process runs to Success/Posted.
  7. The process to run the Outbound MetLife Transmittal is now complete.
  8. End of procedure.

0 Comments

Add your comment

E-Mail me when someone replies to this comment