May 28, 2024
This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Mutual Of America Premier file specifications. This transformation is used in a detamoov integration with Mutual Of America Premier.
Source File | Destination file |
Standard 401k | Mutual Of America |
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__[Plan ID]__PMOA.csv |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the Mutual Of America Payroll Contribution csv format is created correctly from the standard 401k format.
Mutual Of America Field Name | Standard 401k Field Name | Field Type | Details |
First Name | FIRST NAME | STRING | |
Middle Initial | MIDDLE NAME/INITIAL | STRING | |
Last Name | LAST NAME | STRING | |
SSN | SSN | STRING | Format SSN w/dashes |
Gender | GENDER | STRING | Male = M Female = F Unspecified = U |
Marital Status | MARITAL STATUS | STRING | Married = M Single = S Unspecified = U |
Address 1 | ADDRESS LINE 1 | STRING | Remove any commas |
Address 2 | ADDRESS LINE 2 | STRING | Remove any commas |
City | CITY | STRING | |
State | STATE | STRING | |
Zip | ZIP | STRING | 5 digits only |
Birth Date | DOB | DATE | MM/DD/YYYY |
Hire Date | HIRE DATE | DATE | MM/DD/YYYY |
Termination Date | TERMINATION DATE | DATE | MM/DD/YYYY |
Rehire Date | REHIRE DATE | DATE | MM/DD/YYYY |
Payroll Date | PAYROLL CHECK DATE | DATE | MM/DD/YYYY |
Plan Compensation | CURRENT PAY PERIOD GROSS PAY | NUMBER | Remove commas, Round Number - Force 2 decimals |
Hours Worked | CURRENT PAY PERIOD HOURS WORKED | NUMBER | Remove commas, Round Number - Force 2 decimals |
Excluded Earnings | NUMBER | Remove commas, Round Number - Force 2 decimals | |
Employee Deferral | CURRENT PAYROLL EMPLOYEE PRETAX | NUMBER | Remove commas, Round Number - Force 2 decimals |
Employee Roth | CURRENT PAYROLL EMPLOYEE ROTH | NUMBER | Remove commas, Round Number - Force 2 decimals |
Employer Match | CURRENT PAY PERIOD EMPLOYER MATCH | NUMBER | Remove commas, Round Number - Force 2 decimals |
Employer Base Contribution | CURRENT PAY PERIOD NON ELECTIVE | NUMBER | Remove commas, Round Number - Force 2 decimals |
Employee After Tax | CURENT PAYROLL EMPLOYEE AFTERTAX | NUMBER | Remove commas, Round Number - Force 2 decimals |
Safe Harbor Match | CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH | NUMBER | Remove commas, Round Number - Force 2 decimals |
Safe Harbor Base | CURREN PAYROLL SAFE HARBOR NON ELECTIVE | NUMBER | Remove commas, Round Number - Force 2 decimals |
Plan ID | PLAN ID | NUMBER | |
Loan Payment 1 | 401K LOAN 1 REPAYMENT | NUMBER | Remove commas, Round Number - Force 2 decimals |
Loan Number 1 | 401K LOAN 1 ID | NUMBER | |
Loan Payment 2 | 401K LOAN 2 REPAYMENT | NUMBER | Remove commas, Round Number - Force 2 decimals |
Loan Number 2 | 401K LOAN 2 ID | NUMBER | |
Loan Payment 3 | NUMBER | Remove commas, Round Number - Force 2 decimals | |
Loan Number 3 | NUMBER | ||
Loan Payment 4 | NUMBER | Remove commas, Round Number - Force 2 decimals | |
Loan Number 4 | NUMBER | ||
Loan Payment 5 | NUMBER | Remove commas, Round Number - Force 2 decimals | |
Loan Number 5 | NUMBER | ||
Employee ID | EMPLOYEE NUMBER | STRING | |
Leave of Absence Begin Date | DATE | MM/DD/YYYY | |
Leave of Absence End Date | DATE | MM/DD/YYYY | |
Cost Center 1 Code | STRING | ||
Cost Center 2 Code | STRING | ||
Cost Center 3 Code | STRING | ||
Employee Email Address | STRING | ||
Employee Phone Number | PHONE | STRING | Numeric only |