Standard 401k to The Standard

Travis Viall

Jan 19, 2024

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

Source File	Destination file
Standard 401k	The Standard

File Specifications

File Type Generated	CSV
Header Row(s) Generated	Yes
Footer Row(s) Generated	No
End of Row Character	CRLF
File Naming Generated	[Plan ID]_[PayrollVendorID]_PayrollFile_[Date in YYYYMMDDHHMMSS].csv

Field Mappings

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

The Standard Field Name	Standard 401k Field Name	Field Type	Details
The Standard Field Name	Standard 401k Field Name	Field Type	Details
SSN	SSN	STRING	No Dashes
LAST NAME	LAST NAME	STRING
FIRST NAME MI	FIRST NAME	STRING	MI is optional
DOB	DOB	DATE	MM/DD/YYYY
DOH	HIRE DATE	DATE	MM/DD/YYYY If rehired, use rehire date as hire date
DOT	TERMINATION DATE	DATE	MM/DD/YYYY
ANNUAL SALARY		NUMBER	Not required unless plan specific
HOURS	CURRENT PAY PERIOD HOURS WORKED	NUMBER	Per Payroll Preferred, Round to whole number
TOTAL COMP	CURRENT PAY PERIOD GROSS PAY	NUMBER	Per Payroll Preferred, Round - Force 2 decimals
ELIGIBLE COMP		NUMBER
NON-REGULAR COMP		NUMBER
EMPLOYEE PRE-TAX CONTRIBUTION	CURRENT PAYROLL EMPLOYEE PRE-TAX	NUMBER	Round - Force 2 decimals
ROTH 401(K) CONTRIBUTION	CURRENT PAYROLL EMPLOYEE ROTH	NUMBER	Round - Force 2 decimals
OTHER EMPLOYEE CONTRIBUTIONS		NUMBER
EMPLOYER MATCH CONTRIBUTIONS	CURRENT PAYROLL EMPLOYER MATCH	NUMBER	Round - Force 2 decimals
SAFE HARBOR CONTRIBUTIONS	CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH	NUMBER	Round - Force 2 decimals
OTHER EMPLOYER CONTRIBUTIONS		NUMBER
LOAN PAYMENT	401K LOAN 1 REPAYMENT AND 401K LOAN 2 REPAYMENT	NUMBER	Sum, Round - Force 2 decimals
PAYROLL FREQUENCY	PAY PERIOD START DATE AND PAY PERIOD END DATE	STRING	W = WEEKLY B = BIWEEKLY S = SEMIMONTHLY M = MONTHLY



CONTRIBUTION RATE PRE-TAX		NUMBER	Plan Specific Transformation Required
CONTRIBUTION FLAT DOLLAR PRE-TAX		NUMBER	Plan Specific Transformation Required
CONTRIBUTION RATE ROTH		NUMBER	Plan Specific Transformation Required
CONTRIBUTION FLAT DOLLAR ROTH		NUMBER	Plan Specific Transformation Required
LANGUAGE		STRING
GENDER	GENDER	STRING	M = MALE F = FEMALE
GENDER	GENDER	STRING	M = MALE F = FEMALE
EXCLUDED EMPLOYEES		STRING
DIVISION CODE		STRING
STREET ADDRESS 1	ADDRESS LINE 1	STRING	Remove any commas
STREET ADDRESS 2	ADDRESS LINE 2	STRING	Remove any commas
CITY	CITY	STRING
STATE	STATE	STRING
ZIP CODE	ZIP	STRING	##### OR #####-####
EMAIL ADDRESS	EMAIL	STRING
PAY DATE	PAYROLL CHECK DATE	DATE	MM/DD/YYYY
PAYROLL BEGIN DATE	PAY PERIOD START DATE	DATE	MM/DD/YYYY
PAYROLL END DATE	PAY PERIOD END DATE	DATE	MM/DD/YYYY

Tags