Retirement Contribution Detail Extract Overview

The Advantage HRM system has the ability to track retirement contribution activity necessary for supporting state reporting requirements. Retirement contribution information is stored on the Retirement Contribution Detail table. You can use this table to generate interface files needed for retirement reporting, such as reports for the California State Teachers’ Retirement System (CalSTRS) and the California Public Employee’s Retirement System (CalPERS). 

The Retirement Contribution Detail table is a historical table, storing all records processed for retirement contribution reporting. The process used to populate the Retirement Contribution Detail table is as follows:

  1. The Advantage HRM Payroll engine updates the Deduction Detail tables with retirement information for deductions that have been identified on Deduction Plan as being part of a retirement system. Specifically, the Retirement Contribution Codes, Service Dates and Retirement Pay Codes fields are populated.

  2. The Retirement Contribution Extract process reads the Deduction Detail tables and does additional look ups on the reference pages as well as the employee’s primary (blank) assignment. It then performs summation and grouping logic based on the reference table setup.

  3. When the summation and grouping is complete, the Retirement Contribution Detail table is updated with the retirement deduction details.

This table can be viewed online using the Retirement Contribution Management (RTCM) activity folder. Adjustments to the table can be made by using the Retirement Contribution Adjustment (RCADJ) transaction. This transaction can be created from the RTCM activity folder or from the Transaction Catalog. 

Note: STRS Non-Members, employees who are eligible for STRS but who are not participating in STRS, are not currently handled by retirement processing. Therefore, these employees do not have any details updated to the Retirement Contribution Detail table when the Retirement Contribution Extract job is run.