You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > moovs > How to configure a moov - Payroll to Retirement > How to configure a Lincoln Director moov
How to configure a Lincoln Director moov
print icon

This article describes how to configure a client for the Standard 401k to Lincoln Director 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 Lincoln Director moov to your account by following these steps.

 

Once the Standard 401k to Lincoln Director moov has been added to your account, access the moovs section on the left side menu and click on the Standard 401k to Lincoln Director moov.

 

Notification Settings

 

The Standard 401k to Lincoln 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.

 

Configure a client

 

In the moov configuration section, click the Add button to add a new client to send retirement data to Lincoln.

 

Complete the ID and source

 

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 Lincoln as it provides the correct file name and SFTP directory used to send to Lincoln 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

 

 

Lincoln File Specifications

 

For more information on the Lincoln file specifications detamoov uses to transform the Standard 401k extract file, please visit the Standard 401k to Lincoln Financial help page.

 

UKG Ready Users

 

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 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:

 

Field Overrides

 

Lincoln requires that the Payroll Frequency be included in the file sent to them.  To include the Payroll Frequency, you can provide a field override using the following chart of values:

 

Weekly = W

Bi-Weekly = B

Semi-Monthly = S

Monthly = M

Quarterly = Q

Annually = A

 

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.

 

Transformation Overrides

 

Lincoln requires that the fields for data like contribution and loan amounts for each plan follow a specific format.  Below is sample data that Lincoln may send specific to your client's plan.

 

Sample data from Lincoln:

 

Plan ID: A1BC

Location Code: 0001

Payroll Frequency: S for Semi-monthly

Employment Statuses:  E for Eligible/Not Participating, P for Eligible/Participating, L for Leave, T for Terminated

Sources: EMPLOYEE SALARY DEFERRAL, ROTH
Loans: 0

 

Lincoln to detamoov field mapping

 

Each Lincoln field maps to a specific field on the detamoov moov definition's field override.  Below is a list of the mapping to ensure the Lincoln plan has the correct mapping:

 

Lincoln Source detamoov Field
EMPLOYEE SALARY DEFERRAL CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION
EMPLOYER DISCRETIONARY CURRENT PAYROLL NON ELECTIVE CONTRIBUTION
ROTH CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION
SAFE HARBOR/SIMPLE MATCH CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH
SAFE HARBOR/SIMPLE NON-ELECTIVE CURRENT PAYROLL SAFE HARBOR NON ELECTIVE

 

To ensure each client's plan is set up accurately, you must map each Lincoln Source to the appropriate detamoov Field.  Setting transformation overrides allows you to accomplish this and create a plan specific configuration for each client.  In the above sample data, there are 2 contribution amounts that must be mapped using the transformation overrides: EMPLOYEE SALARY DEFERRAL and ROTH.

 

To create a Transformation Override, locate the Action - Transform step, expand the Transformation Overrides panel and click the Add button.  Then in the pop-up window select the field you wish to override.  We'll start with EMPLOYEE SALARY DEFERRAL:

 

After you have selected the EMPLOYEE SALARY DEFERRAL field, click the Add Override button.

 

Lincoln requires that the header of each contribution or loan provided include the Plan ID.  detamoov gives you the ability to do just that but utilizing the Override Field Name on the Transformation Override page.

 

To correctly override the field name, enter in the Plan ID and then the Field Name exactly as it appears in the Field Name field above the Override Field Name field.  For example, in our sample data above you have a Plan ID of A1BC, so you would enter:

 

A1BC_EE SALARY DEFERRAL

 

Note that case-sensitivity is important and it must be entered exactly. Once the field name override is entered click the OK button.

Going back to our sample data, you would repeat the transformation override for the ROTH field.

 

Excluding fields from output

 

Now that all the contribution and/or loan amount fields have been mapped (our sample data has no loan amount so nothing to map there), you will need to remove any field not used that starts with  (PLAN ID).

 

To remove a field from the output, repeat the following steps for each field:

 

Step 1

 

On the Action - Transform step, click the Add button under the Transformation Overrides section and select the first (PLAN ID) field in the list and click Add Override.

 

Step 2

 

On the New Transformation Override page, toggle the 'Exclude from output' switch to the on position and click the OK button.

 

Note: it is important that you repeat these steps for every field remaining in the Select Field dropdown menu where the name of the field starts with (PLAN ID).

 

 

File Name Overrides

 

Lincoln file names are plan specific and are in the following format:

 

Test files:                     TEST-[PLAN ID]-[DATETIME IN YYYYMMDDHHmmss].csv

Production files:         [PLAN ID]-[DATETIME IN YYYYMMDDHHmmss].csv

 

If you do not store the Plan ID in payroll then you will need to add a File Name Override for the Plan ID field for both the testing and production file name.

 

To add a file name override, locate the Action -Name File step and toggle the 'Use default parameters' off.

 

In BOTH the Production and Test naming rule sections, locate the Custom Field for Plan ID and change the Naming Component Type to TEXT and then enter in the Plan ID in the Text field.

 

PRODUCTION FILE NAME:

 

TEST FILE NAME:

 

Notification step overrides

 

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.

scroll to top icon