This article describes how to configure a client for the Standard 401k to T. Rowe Price (SS&C) moov definition. Each client configuration will vary based on their plan specification and will need to be configured accordingly.
If you have not already done so, please add the Standard 401k to T. Rowe Price (SS&C) moov to your account by following these steps.
Once the Standard 401k to T. Rowe Price (SS&C) moov has been added to your account, access the moovs section on the left side menu and click on the Standard 401k to T. Rowe Price (SS&C) moov.
The Standard 401k to T. Rowe Price (SS&C) moov provides a notification for when the moov is complete. The notification can be sent to any email address you wish and can also be configured to send to multiple email addresses.
To edit the notification step, click on the cog icon under the Action - Notify step on the left. Then toggle the "Use default parameters" off and enter in the email addresses you would like to receive the notification. If you would like to enter multiple email addresses, separate them with a comma. A Reply to email is also required in the event that a recipient of the notification replies to the email.
Note: these settings apply to any client configuration you set up for this specific moov. You also have the ability to configure the notification step for each client configuration if you wish to add or remove email addresses per client.
To save your parameters click on the Save Changes button.
In the moov configuration section, click the Add button to add a new client to send retirement data to T. Rowe Price (SS&C).
Client/Entity - either select an existing client or click the + sign to create a new client.
Status - This field should be set to 'Testing' until SS&C's testing phase has been completed.
Expected Frequency - the client's payroll frequency
File Name Starts With - typically the client or company code within your payroll platform. The value entered into this field is important as the file you send to detamoov must start with this value.
File Name Contains - optional value that is included in the file name
For more information on the SS&C file specifications detamoov uses to transform the Standard 401k extract file, please visit the Standard 401k to SS&C help page.
If you are a UKG Ready user and an employee was not paid in the current pay period, a field override is needed to provide the Payroll Date. detamoov has provided custom fields that take the existing dates from the source file and allow you to apply them to the missing fields.
To provide the override custom fields, locate the Action - Transform step, click the Field Overrides panel, and click the Add button. Then select the appropriate field from the Output Field dropdown, change the Override Type to Custom Field, and then select the Custom field from the dropdown menu as shown below:
SS&C requires that the Payroll Frequency be included in the file sent to them. To ensure this field is correct, create a field override for the Payroll Frequency field using the following values:
W = Weekly
B = Biweekly
S = Semi-monthly
M = Monthly
Q = Quarterly
To add a Field Override, locate the Action - Transform step, expand the Field Overrides panel and click the Add button. Then select the appropriate Output field, set the Override Type to Text and enter the Override Value.
Contribution mapping is plan specific and the SS&C plan specifications are needed to map the contribution fields in detamoov. The following is a fictitious example of plan specifics. Please check with SS&C to determine your client's plan contribution fields mappings.
Example Contribution sources:
- Field 51: Employee Elective Deferral
- Field 52: Employer Matching
- Field 53: Qualified Non Elective
- Field 54: Roth Elective Deferral
For each contribution on your client's plan, you must create a transformation override to map the appropriate field in the Standard 401k. To add a transformation override, locate the Action - Transform step, expand the Transformation Overrides panel and click the Add button.
Then select the appropriate contribution field, and click the ADD OVERRIDE button.
On the New Transformation Override window, select the Input Field that corresponds to the Contribution Amount field selected. For example, we have selected 51: Contribution Amount 1, which is the Employee Elective Deferral amount for this plan. This field maps to the Current Payroll Employee PreTax Contribution field in the Standard 401k, so we will select this input field.
Next, click the ADD RULE button and select the Round Number - Forced Decimals rule and enter a 2 into the Decimals field. Then click the ADD RULE button again and select Input Field Empty. In the True field, enter in 0.00 and toggle the Input Passthrough switch ON. Then click OK.
For each Contribution Type in the plan, add a transformation override as outlined above. For our example plan, we would complete the remaining transformation overrides for:
Field 52: Contribution Amount 2 = Employer Matching
Field 53: Contribution Amount 3 = Qualified Non Elective
Field 54: Contribution Amount 4 = Roth Elective Deferral
SS&C will provide you with plan specifications related to the header row. Below is an example of what these specifications look like (these are fictitious specifications and your client's plan specifications will vary):
System ID: DFI
ICU Tax ID: 521309931
Plan Sponsor Tax ID: 123456789
Map Prefix: 123456_ABC
Map Name: : 123456_ABC_execupay (generated by SS&C)
Display Name: 12345ABC (generated by SS&C)
To enter this information in the header row, locate the Action - Header / Footer row step and toggle the "Use default parameters" off and click the Row index: 1 to expand the header row.
Each piece of the plan information below will need to be entered into a specific part of the header row. Below is a list of the header row components and the values needed:
System ID: this is pre-populated with DFI
ICU Tax ID: this is pre-populated with 521309931. If your client's plan ICU Tax ID is different, enter it into this field
Plan Sponsor Tax ID: this is generated from the Standard 401k extract using the Company EIN field.
Map Prefix (Plan ID): this is generated from the Standard 401k extract using the Plan ID field. If you do not store the Plan ID in payroll, you will need to change the Row Component Type to Text and enter in the Plan ID in the Text Field.
Map Prefix (Plan Name override first 3 chars): this value comes from the Map Prefix section of the plan specifications above (123456_ABC) after the underscore (_). For our sample plan, we would enter ABC in the Text field.
Map Name (Plan ID): this is generated from the Standard 401k extract using the Plan ID field. If you do not store the Plan ID in payroll, you will need to change the Row Component Type to Text and enter in the Plan ID in the Text Field.
Map Name (Plan Name override first 3 chars): this value comes from the Map Name section of the plan specifications above (123456_ABC_execupay) after the first underscore (_). For our sample plan, we would enter ABC in the Text field.
Map Name (Payroll Provider): this value comes from the Map Name section of the plan specifications above (123456_ABC_execupay) after the second underscore (_). For our sample plan, we would change the Row Component Type to Text and enter execupay in the Text field.
Display Name: this value comes from the Display Name section of the plan specifications above (12345ABC). For our sample plan, we would remove the text PAYROLL enter 12345ABC into the Text field.
At the beginning of this article you configured the notification step for the moov to send a notification once the moov had completed. You also have the ability to configure the notification step for each client configuration if you wish to add or remove email addresses per client.
To override the notification step, locate the Action - Notify step and toggle the "Use default parameters" off and enter/remove email addresses from Email Address and Reply To fields. If you would like to enter multiple email addresses, separate them with a comma.
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.
