When integrating PrismHR 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 utilities the Reserved fields in the Standard 401k to provide flexibility in mapping certain data elements during the client configuration process.
The following table shows the PrismHR default mappings of the Standard 401k Reserved fields:
|
Standard 401k Field |
Default PrismHR Data Element |
Can change mapping? |
|
Reserved1 |
Employee Subject Wages |
No |
|
Reserved2 |
Employee Department |
Yes |
|
Reserved3 |
Employee Pay Method |
Yes |
|
Reserved4 |
Employee Type |
Yes |
|
Reserved5 |
No default mapping |
Yes |
These field mappings are shown when configuring a client for the PrismHR 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 set this field by default. 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 Reserved4 (which is mapped to the Employee Type from PrismHR) 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:
FT|F
PT|P
To complete the configuration for your client, click the Next button at the bottom of the page and then the Save button on the moov summary page.
PrismHR has a concept of Hours Worked and Hours Paid. By default, detamoov maps Hours Paid to Current Pay Period Hours and YTD Hours in the Standard 401k. Reserved field mapping allows you to change the default mapping in the event that the retirement provider requires Hours Worked instead of Hours Paid.
For example, say Empower requires Hours Worked to be provided for YTD hours instead of Hours Paid. The first step would be to configure the PrismHR premier integration to change the Reserved field mappings. Here we can set Reserved5 to Hours Worked YTD.
Then a transformation override is required to update the default mapping for current pay period hours and YTD hours. To update the field mapping, locate the Action - Transform step, expand the Transformation Overrides section, and click ADD.
Then select the Hours Worked field from the dropdown menu and click Add Override.
Make note of the existing rules that are on the current transformation. These will need to be added back once the Input Field mapping is changed to Reserved5. For example, Empower requires that the Hours Worked field be a whole number without any separators and padded left with spaces.
To change the field mapping, hover over the last rule and click the trashcan icon. Then repeat for any additional rules that appear.
Once all rules are deleted, uncheck the current Input Field mapping (in this example, uncheck YTD Hours Worked) and then select Reserved5.
Then click Add Rule.
Note: all Reserved fields are set to a String data type. It's important to understand that if the desired output is a Date or Numeric you will first add the rule that will try and format it to the output. For example, the Hours Worked field above is a Numeric data type, so the first rule we select would be 'Try Format as Decimal'.
This rule formats the String data type to a Numeric data type that will open up the appropriate Transformation Rules.
Next, add the rules back to the Reserved5 Hours Worked field and click OK.
To complete the configuration for your client, click the Next button at the bottom of the page and then the Save button on the moov summary page.
