Standard 401k to Elevate

Travis Viall

Mar 12, 2025

This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Elevate CSV file specifications. This transformation is used in a detamoov integration with Elevate.

Source File	Destination File
Standard 401k	Elevate CSV

File Specifications

File Type Generated	CSV
Header Row(s) Generated	Yes
Footer Row(s) Generated	No
End of Row Character	CRLF (Carriage Return Line Feed)
File Naming Generated	Production [Company Name]_[Plan Id]_[Payroll End Date in MMDDYYYY].csv

Field Mappings

The table below details the specific field mapping and transformation rules applied to ensure the Elevate format is created correctly from the standard 401k format.

Elevate Field Name	Standard 401k Field Name	Field Type	Details
Elevate Field Name	Standard 401k Field Name	Field Type	Details
SSN	SSN	STRING	Format SSN w/dashes
Division #		STRING
First Name	FIRST NAME	STRING
Last Name	LAST NAME	STRING
Address 1	ADDRESS LINE 1	STRING
Address 2	ADDRESS LINE 2	STRING
City	CITY	STRING
State	STATE	STRING
Zip	ZIP	STRING	##### or #####-####
Birth Date	DOB	DATE	MM/DD/YYYY
Hire Date	HIRE DATE	DATE	MM/DD/YYYY
Rehire Date	REHIRE DATE	DATE	MM/DD/YYYY
Termination Date	TERMINATION DATE	DATE	MM/DD/YYYY
Gross Earnings	CURRENT PAY PERIOD GROSS PAY	NUMBER
Hours	CURRENT PAY PERIOD HOURS WORKED	NUMBER
Loan Payments	401K LOAN 1 REPAYMENT 401K LOAN 2 REPAYMENT	NUMBER	Sum Loans
Employee Deferral	CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION	NUMBER
Employee Roth	CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION	NUMBER
Employee After Tax	CURRENT PAYROLL EMPLOYEE POSTTAX CONTRIBUTION	NUMBER
Employer Match	CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION	NUMBER
Safe Harbor Match	CURRENT PAYROLL SAFE HARBOR MATCH	NUMBER
Safe Harbor Non-Elective	CURRENT PAYROLL SAFE HARBOR NON ELECTIVE	NUMBER
Profit Sharing	CURRENT PAYROLL NON ELECTIVE	NUMBER
QACA Match		NUMBER
QACA Non Elective		NUMBER
Email Address	EMAIL	STRING

Tags