Standard 401k to Epic

Travis Viall

Jun 01, 2023

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

Source File	Destination file
Standard 401k	Epic

File Specifications

File Type Generated	Pipe-delimited
Header Row(s) Generated
Footer Row(s) Generated
End of Row Character
File Naming Generated	Production: [Plan Id]_[file production date in YYYYMMDD]_payroll.txt Test: test_[Plan Id]_[file production date in YYYYMMDD]_payroll.txt

Field Mappings

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

Epic Field Name	Standard 401k Field Name	Field Size	Details
Company Code	COMPANY CODE	6
First Name	FIRST NAME	50
Middle Name	MIDDLE NAME/INITIAL	50
Last Name	LAST NAME	50
Title		15
SSN	SSN	11	Format to SSN, Keep Dashes
Employee ID	EMPLOYEE NUMBER	10
Gender	GENDER	1	Male = M Female = F
Employee Status	EMPLOYMENT STATUS	1	Deceased = D Leave = L Retirement = R Terminated = T
Marital Status	MARITAL STATUS	1
Pay Type		1
Union Status		1
Address 1	ADDRESS 1	50
Address 2	ADDRESS 2	50
City	CITY	25
State	STATE	2	2-Letter State Code
Zip	ZIP	10	##### 0r #####-####
Birth Date	DOB	10	MM/DD/YYYY
Hire Date	HIRE DATE	10	MM/DD/YYYY
Rehire Date	REHIRE DATE	10	MM/DD/YYYY
Adjusted Seniority Date		10	MM/DD/YYYY
Termination Date	TERMINATION DATE	10	MM/DD/YYYY
Leave of Absence Begin Date		10	MM/DD/YYYY
Leave of Absence End Date		10	MM/DD/YYYY
Check Date	PAYROLL CHECK DATE	10	MM/DD/YYYY
Payroll Begin Date	PAY PERIOD START DATE	10	MM/DD/YYYY
Payroll End Date	PAY PERIOD END DATE	10	MM/DD/YYYY
Payroll Frequency	PAY PERIOD START DATE AND PAY PERIOD END DATE	2	Weekly = W Bi-Weekly = B Semi = S Monthly = M
Cost Center Code 1		10
Cost Center Code 2		10
Cost Center Code 3		10
Gross Earnings	CURRENT PAY PERIOD GROSS PAY	13	##########.00
Plan Earnings		13	##########.00
Hours	CURRENT PAY PERIOD HOURS WORKED	13	##########.00
Excluded Earnings		13	##########.00
Employee Deferral	CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION	13	##########.00
Employee Roth	CURRENT EMPLOYEE ROTH CONTRIBUTION	13	##########.00
Employee After Tax	CURRENT EMPLOYEE POSTTAX CONTRIBTION	13	##########.00
Employer Match	CURRENT PAYROLL EMPLOYER MATCH CONTRIBTION	13	##########.00
Safe Harbor Match	CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH	13	##########.00
Qualified Matching	CURRENT PAYROLL QUALIFIED MATCHING CONTRIBUTION	13	##########.00
Safe Harbor Non-Elective	CURRENT PAYROLL SAFE HARBOR NON ELECTIVE	13	##########.00
Qualified Non-Elective		13	##########.00
Profit Sharing	CURRENT PAYROLL NON ELECTIVE CONTRIBUTION	13	##########.00
Money Purchase		13	##########.00
Loan Payment 1	401K LOAN 1 REPAYMENT	13	##########.00
Loan Number 1	401K LOAN 1 ID	10
Loan Payment 2	401K LOAN 2 REPAYMENTS	13	##########.00
Loan Number 2	401K LOAN 2 ID	10
Loan Payment 3		13	##########.00
Loan Number 3		10
Loan Payment 4		13	##########.00
Loan Number 4		10
Loan Payment 5		13	##########.00
Loan Number 5		10
YTD Gross Earnings	YTD GROSS PAY	13	##########.00
Plan YTD Earnings		13	##########.00
Plan YTD Hours		13	##########.00
Plan YTD Excluded Earnings		13	##########.00
Filler
Plan YTD Employee Deferral		13	##########.00
Plan YTD Employee Roth		13	##########.00
Plan YTD Employee After Tax		13	##########.00
Plan YTD Employee Match		13	##########.00
Plan YTD Safe Harbor Match		13	##########.00
Plan YTD Qualified Match		13	##########.00
Plan YTD Safe Harbor Non-Elective		13	##########.00
Plan YTD Qual Non-Elective		13	##########.00
Plan YTD Profit Sharing		13	##########.00
Plan YTD Money Purchase		13	##########.00
Plan YTD Rollover		13	##########.00
Plan ID	Plan ID	20

Tags