Apr 03, 2024
This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the OneAmerica file specifications. This transformation is used in a detamoov integration with OneAmerica.
Source File | Destination file |
Standard 401k | OneAmerica |
File Specifications
File Type Generated | CSV |
Header Row(s) Generated | Yes |
Footer Row(s) Generated | No |
End of Row Character | CRLF |
File Naming Generated |
FTP__[Contract Number]__[Contract Number]PAYROLL__[Check Date in yyyy-mm-dd format].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.
OneAmerica Field Name | Standard 401k Field Name | Field Type | Details |
Contract Number | PLAN ID | STRING | |
Division | STRING | To be provided by OneAmerica per plan - needs a moov configuration output override | |
First Name | FIRST NAME | STRING | Use To Title Case |
Middle Name (or Initial) | MIDDLE NAME/INITIAL | STRING | Use To Title Case |
Last Name | LAST NAME | STRING | Use To Proper Case |
SSN | SSN | STRING | ###-##-#### format |
Gender | STRING | Male = M Female = F |
|
Employee Status | EMPLOYMENT STATUS | STRING | ACTIVE = A DECEASED = D LEAVE OF ABSENCE = L RETIRED = R TERMED = T TRANSFER = XT |
Union Status | STRING | ||
Address 1 | ADDRESS LINE 1 | STRING | |
Address 2 | ADDRESS LINE 2 | STRING | |
City | CITY | STRING | |
State | STATE | STRING | |
Zip Code | ZIP | STRING | ##### or #####-#### |
Birth Date | DOB | STRING | MM/DD/YYYY |
Hire Date | HIRE DATE | STRING | MM/DD/YYYY |
Rehire Date | REHIRE DATE | STRING | MM/DD/YYYY |
Termination Date | TERMINATION DATE | STRING | MM/DD/YYYY |
Payroll Date | PAYROLL CHECK DATE | STRING | MM/DD/YYYY |
415 Earnings | CURRENT PAY PERIOD GROSS WAGES | NUMERIC | Round 2 decimal places |
Plan Earnings | CURRENT PAY PERIOD GROSS WAGES | NUMERIC | Round 2 decimal places |
Hours | CURRENT PAY PERIOD HOURS WORKD | NUMERIC | Round 2 decimal places |
Excluded Earnings | NUMERIC | Round 2 decimal places | |
Employee Deferral | CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION | NUMERIC | Round 2 decimal places |
Employee Roth | CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION | NUMERIC | Round 2 decimal places |
Employee After Tax | CURRENT PAYROLL EMPLOYEE POSTTAX CONTRIBUTION | NUMERIC | Round 2 decimal places |
Employer Match | CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION | NUMERIC | Round 2 decimal places |
Safe Harbor Match | CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH CONTRIBUTION | NUMERIC | Round 2 decimal places |
Qualified Matching Contribution | CURRENT PAYROLL QUALIFIED MATCHING CONTRIBUTION | NUMERIC | Round 2 decimal places |
Safe Harbor Non-Elective | CURRENT PAYROLL SAFE HARBOR NON ELECTIVE CONTRIBUTION | NUMERIC | Round 2 decimal places |
Qualified Non-Elective Contribution | CURRENT PAYROLL NON ELECTIVE CONTRIBUTION | NUMERIC | Round 2 decimal places |
Profit Sharing | NUMERIC | ||
Money Purchase | NUMERIC | ||
Rollover | NUMERIC | ||
Rollover Roth | NUMERIC | ||
Loan Number | 401K LOAN 1 ID | STRING | |
Loan Payment | 401K LOAN 1 CONTRIBUTION | NUMERIC | Round 2 decimal places |
Loan Number | 401K LOAN 2 ID | STRING | |
Loan Payment | 401K LOAN 2 CONTRIBUTION | NUMERIC | Round 2 decimal places |
Loan Number | STRING | ||
Loan Payment | NUMERIC | ||
Loan Number | STRING | ||
Loan Payment | NUMERIC | ||
Email Address | STRING | ||
Work Email | STRING |