Standard 401k to EPARS
Jan 09, 2024
This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the EPARS file specifications. This transformation is used in a detamoov integration with EPARS.
| Source File | Destination file |
| Standard 401k | EPARS |
File Specifications
| File Type Generated | CSV |
| Header Row(s) Generated | |
| Footer Row(s) Generated | |
| End of Row Character | |
| File Naming Generated |
[Company Code]_[Check Date in MMddyyyyy]_[Current Date in MMddyyyy]_[Timestamp in hhmmssf].csv |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the EPARS Payroll Contribution csv format is created correctly from the standard 401k format.
| EPARS Field Name | Standard 401k Field Name | Field Type | Default Value | Details |
| EE SSN | SSN | STRING | Numeric only | |
| LAST NAME | LAST NAME | STRING | ||
| FIRST NAME | FIRST NAME | STRING | ||
| MIDDLE INITIAL | MIDDLE NAME/INITIAL | STRING | ||
| DOB | DOB | DATE | MMDDYYYY | |
| Employee Vendor | STRING | AXA 403b EE | Value may need an override. See VENDOR LIST | |
| Employee | CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION | NUMBER | Round Force 2 Decimals | |
| Employer Vendor | STRING | AXA 403b ER | Value may need an override. See VENDOR LIST | |
| Employer | CURRENT PAYROLL EMPLOYER MATCH | NUMBER | Round Force 2 Decimals | |
| Roth Vendor | STRING | AXA Roth 403b EE | Value may need an override. See VENDOR LIST | |
| ROTH | CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION | NUMBER | Round Force 2 Decimals |
Vendor List
AXA 403b EE
American Funds 403b EE
American Funds 403b ER
AXA 403b ER
AXA Roth 403b EE
