When integrating PrismHCM for payroll to retirement providers, detamoov captures the contribution and census data via the API and converts it to our Standard 401k specifications. Although most of the employee data is captured, there may be a need for additional data for a specific retirement provider. detamoov utilizes the Reserved fields 1-5 in the Standard 401k to provide flexibility in mapping certain data elements during the client configuration process.
The following table shows the available PrismHCM employee elements and their Reserved Field Name, along with any additional details related to the field:
| Reserved Field Name | Details |
|---|---|
| Annual Salary | |
| Current Pay Period Subject Wages | |
| Current Pay Period Excluded Wages | |
| Department | |
| Division | Division Name only |
| Employee Category |
Full Time Part Time Etc. |
| Hourly Rate | |
| Location Code | |
| Pay Group |
Payroll's Pay Schedule Name Is not returned for non-scheduled payrolls |
| Pay Type |
Hourly Salary |
| Payroll Run Type | |
| Termination Reason Code | |
| YTD Plan Compensation | |
| YTD Excluded Compensation | |
| YTD PreTax Employee Amount |
Sum PreTax and Catch Up contributions |
| YTD Roth Employee Amount |
Sum Roth and Roth Catch Up contributions |
| YTD Non-Elective Amount | |
| YTD Qualified Elective Amount | |
| YTD Employer Match Amount |
Sum Employer PreTax, Catchup, Roth and Roth Catchup |
| YTD Qualified Matching Amount |
These fields can be mapped when configuring a client for the PrismHCM Premier Integration:
The Reserved fields are available as Input Fields in the transformation step of the moov and can be used to override existing transformation behavior.
For example, Empower may require that the Part Time/Full Time Indicator is set for your client's plan, but detamoov does not set this field by default.
First, map the Employee Category to a reserved field in the premier configuration, complete the schedule and click OK:
To update the field mapping, locate the Action - Transform step, expand the Transformation Overrides section, and click ADD.
Then select the Part Time/Full Time Indicator field from the dropdown menu and click Add Override.
Then select Reserved1 (which we mapped to the Employee Category from PrismHCM in the premier configuration) from the Input Fields dropdown and click Add Rule.
Select the 'Replace/Remove exact value using a list' rule and enter in the following Replacement Groups and click OK:
Full Time|F
Part Time |P
