This article describes how to configure a client for the Standard 401k to Principal IPP 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 Principal IPP moov to your account by following these steps.
Once the Standard 401k to Principal IPP moov has been added to your account, access the moovs section on the left side menu and click on the Standard 401k to Principal IPP moov.
The Standard 401k to Principal IPP 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 Principal.
Client/Entity - either select an existing client or click the + sign to create a new client.
Status - the status field is important when configuring a new integration with Principal as it provides the correct SFTP directory used to send to Principal while in their testing phase. This field should be set to 'Testing' until the 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
Principal IPP File Specifications
For more information on the Principal IPP file specifications detamoov uses to transform the Standard 401k extract file, please visit the Standard 401k to Principal IPP 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 Check Date and Pay Period End 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:
Principal requires the Pay Frequency to be included in the file sent to them. To provde the Pay Frequency, locate the Action - Transform step, click the Field Overrides panel, and click the Add button. Then, select field 72: Pay Frequency and enter the value from the table below that matches the plan's payroll frequency:
1 = Daily
2 = Weekly
3 = Semi-Monthly
4 = Monthly
5 = Annual
6 = One-Time
7 = Quarterly
8 = Semi-Annual
9 = Bi-Weekly
If you do not store the Principal Plan ID in payroll, override the Contract Number field.
Transformation Overrides - Contribution Fields
The Employee and Employer Contribution fields are plan specific and are provided by Principal. Principal will send you a file layout specific to your client's plan for each contribution field that needs to be provided in the file they receive. Below is an example of how the specifications for the contribution fields may look in your client's file layout. Here the plan has a PreTax employee contribution in Position 48 and an Employer Match in position 108.
For each contribution you will need to create a transformation override to apply the correct mapping and rules Principal requires. The following rules must be added in the following order to each applicable contribution field (as outline in detail below):
Input Field: field that corresponds to the contribution field for Principal (Roth, PreTax, ER Match, etc.).
Input Field Empty: True = 0.00, toggle input passthrough ON
Round Number - Force Decimal: Decimal = 2
Remove Separators
Numeric Padding
To add a Transformation Override, locate the Action - Transform step, expand the Transformation Overrides panel and click the Add button.
In the example above, there is an Elective Deferral in Employee Contribution 1 Amount. Since this is a PreTax contribution, select field 6: EE Contribution Amount 1 from the dropdown and click ADD OVERRIDE.
Then hover over the Padding Left rule and click the Trashcan Icon to delete the rule.
Then hover over the Default Value rule and click the Trashcan Icon to delete the rule.
Now select Current Payroll Employee PreTax Contribution from the Input Fields dropdown.
Click the Add Rule button and select the Input Field Empty rule. In the True field, enter 0.00, then toggle the Input passthrough switch ON.
Then click the Add Rule button and select the Round Number - Force Decimals and enter a 2 into the Decimals field.
Then click the Add Rule button and select the Remove Separators rule.
Then click the Add Rule button and select the Numeric Padding rule and click OK.
Transformation Overrides - Employment Condition
The Employment Condition of each employee may be required. The standard 401k report doesn't include this information by default. Please use one of the five Reserved fields in the report to pass this information to detamoov. Then you can do a transformation override to replace the values coming out of payroll to the following values:
1 = Full Time
2 = Part Time
3 = Seasonal
4 = Temporary
PrismHR Users
If your client's plan requires the Employment Condition field and you integrate using the PrismHR API with detamoov, you can use the Employee Type mapping to the Reserved4 field.
To add a Transformation Override, locate the Action - Transform step, expand the Transformation Overrides panel and click the Add button.
Then select field 93: Employment Condition from the dropdown and click ADD OVERRIDE.
Then select the correct Reserved field from the Input Fields dropdown menu (Reserved4 if you are a PrismHR user).
Then click the Add Rule button and select the Replace/Remove exact value using a list. In the Replacement Groups field, create a pipe separated replacement group for each value expected from payroll. For example, if we expect PT for Part Time and FT for Full Time, our replacement groups would look like this:
Click OK to complete the transformation override.
Transformation Overrides - Compensation Basis
The Compensation Basis for each employee may be required. The standard 401k report doesn't include this information by default. Please use one of the five Reserved fields in the report to pass this information to detamoov. Then you can do a transformation override to replace the values coming out of payroll to the following values:
1 = Salaried
2 = Hourly
3 = Commission
4 = Non-Commission
5 = Non-Hourly
6 = Non-Salaried
PrismHR Users
If your client's plan requires the Compensation Basis field and you integrate using the PrismHR API with detamoov, you can use the Employee Type mapping to the Reserved3 field.
To add a Transformation Override, locate the Action - Transform step, expand the Transformation Overrides panel and click the Add button.
Then select field 95: Compensation Basis from the dropdown and click ADD OVERRIDE.
Then select the correct Reserved field from the Input Fields dropdown menu (Reserved3 if you are a PrismHR user).
Then click the Add Rule button and select the Replace/Remove exact value using a list. In the Replacement Groups field, create a pipe separated replacement group for each value expected from payroll. For example, if we expect H for Hourly and S for Salary, our replacement groups would look like this:
Click OK to complete the transformation override.
If you do not store the Principal Plan ID in payroll, you will need to override the Header row to include it. To override the Header row, locate the Action - Header/Footer Rows step and toggle the 'Use default parameters' switch OFF. Then click the 'Row index: 1' panel.
Then change both Plan ID Component Types to Text and enter in the Plan ID in the Text field.
If the Remittance Group for your client's plan doesn't match the default (00000), you will need to provide the correct value in the Remittance Group (edit) field of the Header row.
Plan ID
If you do not store the Principal Plan ID in payroll, you will need to override the file name to include it. To override the file name, locate the Action - Name File step and toggle the 'Use default parameters' switch OFF. Then change to Plan ID Naming Component to Text and enter in the Plan ID in the text field.
Remittance Group
You will also need to provide the plan's Remittance Group value by replacing the text [Remittance Group] with the correct value.
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.
