Standard 401k to Propser

Travis Viall

Jan 05, 2024

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

Source File	Destination file
Standard 401k	Prosper

File Specifications

File Type Generated	CSV
Header Row(s) Generated	YES
Footer Row(s) Generated	NO
End of Row Character	CRLF
File Naming Generated	Production: [Current Date in yyyymmdd]_[Plan ID]_[GUID].csv

Filed Mappings

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

Prosper Field Name	Standard 401k Field Name	Field Type	Details
Prosper Field Name	Standard 401k Field Name	Field Type	Details
ssn	SSN	STRING	Include dashes
division ID		STRING
name-first	FIRST NAME	STRING
name-last	LAST NAME	STRING
address-street1	ADDRESS LINE 1	STRING
address-street2	ADDRESS LINE 2	STRING
address-city	CITY	STRING
address-state	STATE	STRING
address-postal code	ZIP	STRING
date of birth	DOB	DATE	MM/DD/YYYY
date of hire-original	HIRE DATE	DATE	MM/DD/YYYY
termination date	TERMINATION DATE	DATE	MM/DD/YYYY
date of rehire	REHIRE DATE	DATE	MM/DD/YYYY
Employee Type		STRING	use "O" (for Other) to indicate an Excluded Employee
Employee Sub		STRING	use "F" for full-time; use "P" for part-time; use "B" if the employee varies
Key Employee	KEY EMPLOYEE	STRING
current salary	CURRENT PAY PERIOD GROSS PAY	NUMBER	remove separators, round force 2 decimals
current hours of service	CURRENT PAY PERIOD HOURS WORKED	NUMBER	round force 2 decimals
loan payment	401k LOAN 1 REPAYMENT & 401K LOAN 2 REPAYMENT	NUMBER	sum, remove separators keep decimal, round force 2 decimals
current pretax deferral $	CURRENT PAYROLL EMPLOYEE PRETAX	NUMBER	remove separators keep decimal, round force 2 decimals
ROTH deferral $	CURRENT PAYROLL EMPLOYEE ROTH	NUMBER	remove separators keep decimal, round force 2 decimals
work email address	EMAIL	STRING

Tags