This article describes how to configure a client for the Standard 401k to Principal 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 moov to your account by following these steps.
Once the Standard 401k to Principal moov has been added to your account, access the moovs section on the left side menu and click on the Standard 401k to Principal moov.
The Standard 401k to Principal 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 sent 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.
On the moov maintenance page, click the Add button within the moov configuration section 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 file name sent 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
You're now ready to complete the customization for this plan required by the Principal.
For more information on the Principal file specifications detamoov uses to transform the Standard 401k extract file, please visit the Standard 401k to Principal help page.
Quick overview of the Principal File Specifications
Though detamoov creates the Principal file layout for you, we thought it was important to give you a brief overview of the Principal file specifications. These specifications follow a fixed length format text file. Each record/row is exactly 240 characters.
Unlike many retirement providers where one retirement plan participant equals one record/row to the retirement plan provider, Principal may require up to six rows/records each payroll per plan participant. Each record is identified by a specific 3 digit record type:
- 180 - basic demographic data
- 181 - rehire data
- 220 - address data
- 240 - phone and email data
- 407 - contribution data
- 408 - loan repayment data
The rest of this article will describe ways you may need to customize data going to the Principal for each client you configure within detamoov.
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 Hours Begin Date, Hours End Date and Pay 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:
Contract Number Field Overrides
If the Plan ID is not stored in your payroll system and not included in the Standard 401k file detamoov receives you will need to create Field Overrides to provide the Plan ID inside the Contract Number fields in all areas that the Principal requires it.
Under the Action - Transform step, click on the Field Overrides banner and click the Add button.
Add a field override for the following fields with an Override Type of Text and the Override Value of the Plan ID:
4: Contract Number
34: Contract Number
51: Contact Number
66: Contract Number
113: Contract Number
128: Contract Number
143: Contract Number
156:Contract Number
Transformation Overrides
For every client/plan you configure to transfer to Principal, transformation overrides are required since each Principal plan requires different data elements and different values. We know, what a pain but unfortunately this is how the Principal does things and we built our standard 401k to Principal transformation to handle every situation that may be required.
Most common we see transformation overrides required for the 180 and 407 Records. Below details scenarios we typically see but please refer to the specific plan document provided by the Principal. And if you're not comfortable doing this on your end (which we don't blame you if you're not), don't hesitate to reach out to us at detamoov for support at [email protected].
Depending on your client's plan, you may need to override fields for the 180 Record. To understand if you need to override these fields, please review the Principal specifications for your client's plan.
Below is an example of a plan document we've encountered a few times helping detamoov customers. If your client's 180 record is identical to the one pictured below, you will need to override four fields:
- Eligibility Hours
- Hours Begin Date
- Hours End Date
- Vesting Hours
To override the fields for a 180 Record, click on the Transformation Overrides banner and click the Add button.
Eligibility Hours override
In the Action - Transform step, click on the Transformation Overrides banner and select the Eligibility Hours option from the dropdown and click 'Add Override'.
On the page on the right, hover over the "Padding Left" Transformation Rule and click the trashcan icon to delete the rule.
Repeat this step for the "Numeric Only" and "Round Number - Force Decimal" Transformation Rules so that no rules appear.
Click on the Input Fields dropdown and uncheck the "Current Pay Period Hours Worked" option and then click OK.
Hours Begin Date override
In the Action - Transform step, click on the Transformation Overrides banner and select the Hours Begin Date option from the dropdown and click 'Add Override'.
On the page on the right, hover over the "Date Format Conversion" Transformation Rule and click the trashcan icon to delete the rule.
Click on the Input Fields dropdown and uncheck the "Pay Period Start Date" option and then click OK.
Hours End Date override
In the Action - Transform step, click on the Transformation Overrides banner and select the Hours End Date option from the dropdown and click 'Add Override'.
On the page on the right, hover over the "Date Format Conversion" Transformation Rule and click the trashcan icon to delete the rule.
Click on the Input Fields dropdown and uncheck the "Pay Period End Date" option and then click OK.
Vesting Hours field override
In the Action - Transform step, click on the Transformation Overrides banner and select the Vesting Hours option from the dropdown and click 'Add Override'.
On the page on the right, hover over the "Padding Left" Transformation Rule and click the trashcan icon to delete the rule.
Repeat this step for the "Round Number" Transformation Rule so that no rules appear.
Click on the Input Fields dropdown and uncheck the "YTD Hours Worked" option and then click OK.
The 407 record is what reports the contributions made by plan participants to their retirement plan based on payroll deductions. Every plan will have different contribution types that must be reported to Principal. You will need to create transformation overrides to report the correct contribution types. Please refer to the plan's Principal specifications to ensure the proper overrides are configured. And again, if you're not comfortable doing this don't hesitate to reach out to our support at [email protected].
To override the fields for a 407 record, click on the Transformation Overrides banner and click the Add button.
Since each plan has different contributions set up, please refer to your Principal plan documentation for the exact mappings.
The example below requires 3 transformation overrides for each contribution type: Contribution Qualifier Type, Contribution Qualifier, and Contribution Amount.
Example of a 407 Record for Employee Pre-Tax Contribution:
|
Field Name |
Length |
Position |
Value/Comments |
|
Contribution Qualifier Type |
1 |
73 |
L |
|
Elective Deferral Qualifier |
3 |
74-76 |
001 |
|
Elective Deferral Amount |
10 |
77-86 |
$500 = 0000050000 |
Note: Each Contribution Qualifier Type listed on the Principal plan for your client will need to have three transformation overrides: Contribution Qualifier Type, Contribution Qualifier, and Qualifier Amount. The example below shows how you can override these fields for a single Contribution Qualifier.
Contribution Qualifier Type override
Select the Contribution Qualifier Type 1 option from the dropdown and click 'Add Override'.
On the New Transformation Override page on the right, click the Add Rule button. Select 'Default Value' in the Transformation Rule dropdown and enter the value that corresponds to the Contribution Qualifier Type from the plan specifications. Click OK.
The example below shows the value from the 407 record example above. Your mappings may differ from the values provided here.
Contribution Qualifier override
Select the Contribution Qualifier 1 option from the dropdown and click 'Add Override'.
On the New Transformation Override page on the right, click the Add Rule button. Select 'Default Value' in the Transformation Rule dropdown and enter the value that corresponds to the Contribution Qualifier from the plan specifications. For the example above, this would be the value for the Elective Deferral Qualifier row. Click OK.
The example below shows the value from the 407 record example above. Your mappings may differ from the values provided here.
Contribution Amount override
Select the Contribution Amount 1 option from the dropdown and click 'Add Override'.
On the New Transformation Override page on the right, select the 'Current Payroll Employee PreTax Contribution' option from the Input Fields dropdown.
Click the Add Rule button and select the 'Round Number - Force Decimals' option from the Transformation Rule dropdown and then enter a 2 in the Decimals field.
Click the Add Rule button again and select the "Convert to EBCDIC Signed" option.
Click the Add Rule button and select the "Replace/Remove String" option from the Transformation Rule dropdown and Enter a period (.) in the "Replace" field and leave the "With" field blank.
Click the Add Rule button and select the "Padding Left" option from the Transformation Rule dropdown and then enter a zero (0) into the Fill Character field. Click OK.
Plan funded by a single account
If the plan you are setting up only has one bank account built on the Principal's side, then you will need to remove the Record 500 footer row from the configuration.
To remove the Record 500 footer, locate the Action - Header/Footer Rows step and toggle the 'use default parameters' to the off position. Under the Footer Rows section, click the 
icon on Row index: 1.
Plan funded by multiple accounts
If the client has several bank accounts listed with Principal, then you will need to indicate which bank account needs to be used to pull the funds.
To indicate the bank account, locate the Action - Header/Footer Rows step and toggle the 'use default parameters' to the off position and click on the Row index: 1 under the Foot Rows section.
Locate the Contract Number field and change the Row Component Type to TEXT and enter in the plan's Contract Number.
Then locate the EFT Code field and enter the EFT Code in 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.
