Standard 401k to KTrade

Travis Viall

May 06, 2024

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

Source File	Destination file
Standard 401k	KTrade

File Specifications

File Type Generated	CSV
Header Row(s) Generated	Yes
Footer Row(s) Generated	No
End of Row Character	CRLF
File Naming Generated	Testing: Test_[Plan ID]_[Date in yyyyMMddhhmmssfff].csv Production: [Plan ID]_[Date in yyyyMMddhhmmssfff].csv

Field Mappings

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

Ktrade Field Name	Standard 401k Field Name	Field Type	Details
Ktrade Field Name	Standard 401k Field Name	Field Type	Details
Plan ID	PLAN ID	STRING
Begin Date	PAY PERIOD START DATE	DATE	MM/DD/YYYY
Check Date	PAYROLL CHECK DATE	DATE	MM/DD/YYYY
Pay Frequency	PAY PERIOD START DATE AND PAY PERIOD END DATE	STRING	Weekly = W
			Bi-Weekly = B
			Monthly = M
			Semi-Monthly = S
Payroll Sequence		STRING	Per plan - field override
SSN	SSN	STRING	Format SSN w/dashes
LastName	LAST NAME	STRING
FirstName	FIRST NAME	STRING
Date of Birth	DOB	DATE	MM/DD/YYYY
Date of Hire	HIRE DATE	DATE	MM/DD/YYYY
Termination Date	TERMINATION DATE	DATE	MM/DD/YYYY
Date of Rehire	REHIRE DATE	DATE	MM/DD/YYYY
Current Compensation	CURRENT PAY PERIOD GROSS PAY	NUMBER
Current Hours	CURRENT PAY PERIOD HOURS WORKED	NUMBER
Deferral	CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION	NUMBER
Loan Payment	401K LOAN 1 REPAYMENT, 401K LOAN 2 REPAYMENT	NUMBER	Sum values
ER Profit Sharing	CURRENT PAYROLL NON ELECTIVE CONTRIBUTION	NUMBER
Roth	CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION	NUMBER
ER Match	CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION	NUMBER
SH Match	CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH	NUMBER
ER Safe Harbor	CURRENT PAYROLL SAFE HARBOR NON ELECTIVE	NUMBER
Division ID		STRING	Per plan - field override