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.
Standard 401k to Empower
print icon

This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Empower Payroll Contribution fixed length file specifications. This transformation is used in a detamoov integration with Empower.

 

Source File

Destination File

Standard 401k

Empower Payroll Contribution Fixed Length

 

File Specifications

File Type Generated

Fixed length

Header Row(s) Generated

No

Footer Row(s) Generated

No

End of Row Character

CRLF (Carriage Return Line Feed)

File Naming Generated

Production

  • ftp[UniqueDate][Plan Number].txt.pgp

Test

  • TESTftp[UniqueDate][Plan Number].txt.pgp

 

Field Mappings

The table below details the specific field mapping and transformation rules applied to ensure the Empower Payroll Contribution fixed length format is created correctly from the standard 401k format.

Empower Field Name Standard 401k Field Name Position Field Size Details
PLAN NUMBER PLAN ID 1 13  
EMPLOYEE SSN SSN 14 11  
DIVISION NUMBER   25 20  
LAST NAME LAST NAME 45 35  
FIRST NAME FIRST NAME 80 20  
MIDDLE NAME MIDDLE NAME/INITIAL 100 20  
NAME SUFFIX   120 15  
BIRTH DATE DOB 135 10 MM/DD/YYYY Format
GENDER GENDER 145 1 A default value of U will be used if the Standard 401k value is not set to M or F.
MARITAL STATUS MARITAL STATUS 146 1 If no value is found in the Standard 401k file, a blank value will be used.
ADDRESS LINE 1 ADDRESS LINE 1 147 35  
ADDRESS LINE 2 ADDRESS LINE 2 182 35  
CITY CITY 217 20  
STATE STATE 237 2 Uppercase value set.
ZIP CODE ZIP CODE 239 10  
HOME PHONE NUMBER PHONE 249 10 All non-digit characters will be removed from the Standard 401k value sent.
WORK PHONE NUMBER   259 10  
WORK EXT   269 4  
COUNTRY CODE   273 2  
HIRE DATE HIRE DATE 275 10 MM/DD/YYYY Format
TERMINATION DATE TERMINATION DATE 285 10 MM/DD/YYYY Format
RE-HIRE DATE REHIRE DATE 295 10 MM/DD/YYYY Format
CHECKDATE PAYROLL CHECK DATE 305 10 MM/DD/YYYY Format
CONTRIBUTION AMOUNT 1
(EMPLOYEE PRETAX CONTRIBUTION)
CURRENT PAYROLL EMPLOYEE PRETAX  315 10 If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places.  If no value exists in the Standard 401k file, zeroes will fill the entire field.
CONTRIBUTION AMOUNT 2
(EMPLOYER MATCH CONTRIBUTION)
CURRENT PAYROLL EMPLOYER MATCH  325 10 If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places.  If no value exists in the Standard 401k file, zeroes will fill the entire field.
CONTRIBUTION AMOUNT 3
(LOAN REPAYMENTS)
401k LOAN 1 CONTRIBUTION +
401K LOAN 2 CONTRIBUTION
335 10 If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places.  If no value exists in the Standard 401k file, zeroes will fill the entire field.
CONTRIBUTION AMOUNT 4
(EMPLOYEE ROTH CONTRIBUTION)
CURRENT PAYROLL EMPLOYEE ROTH  345 10 If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places.  If no value exists in the Standard 401k file, zeroes will fill the entire field.
CONTRIBUTION AMOUNT 5
(EMPLOYEE SAFE HARBOR NON-ELECTIVE CONTRIBUTION OR EMPLOYEE NON-ELECTIVE CONTRIBUTION OR QUALIFIED ELECTIVE CONTRIBUTION)
SUM OF 
CURRENT PAYROLL SH NON-ELECTIVE, 
CURRENT PAYROLL NON ELECTIVE AND 
CURRENT PAYROLL QUALIFIED ELECTIVE
355 10 If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places.  If no value exists in the Standard 401k file, zeroes will fill the entire field.
CONTRIBUTION AMOUNT 6
(EMPLOYER SAFE HARBOR MATCH CONTRIBUTION OR EMPLOYER QUALIFIED MATCHING CONTRIBUTION)
SUM OF 
CURRENT PAYROLL SH EMPLOYER MATCH, 
CURRENT PAYROLL QUALIFIED MATCHING
365 10 If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places.  If no value exists in the Standard 401k file, zeroes will fill the entire field.
CONTRIBUTION AMOUNT 7
(EMPLOYEE AFTERTAX CONTRIBUTION)
CURRENT PAYROLL EMPLOYEE POSTTAX  375 10 If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places.  If no value exists in the Standard 401k file, zeroes will fill the entire field.
CONTRIBUTION AMOUNT 8   385 10 If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places.  If no value exists in the Standard 401k file, zeroes will fill the entire field.
HOURS WORKED YTD HOURS WORKED 395 5 Values will be rounded to the nearest integer value (no decimal).
YTD TOTAL COMPENSATION YTD GROSS PAY 400 11  
YTD PLAN COMPENSATION YTD GROSS PAY 411 11  
HIGHLY COMP EMPLOYEE CODE HIGHLY COMPENSATED EMPLOYEE 422 1  
PARTICIPATION DATE ELIGIBILITY DATE 423 10 MM/DD/YYYY Format
ELIGIBILITY CODE   433 1  
WORK EMAIL ADDRESS EMAIL 434 80  
SALARY AMOUNT   514 17  
SALARY AMOUNT QUALIFIER   531 2  
TERMINATION REASON CODE   533 20  
FEDERAL EXEMPTIONS   553 2  
EMPLOYER ASSIGNED ID EMPLOYEE NUMBER 555 10  
PERSONAL EMAIL ADDRESS EMAIL 565 80  
MOBILE PHONE   645 10  

 

scroll to top icon