You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Transformations > Prebuilt File Transformations > Standard 401k to Mutual Of America Premier
Standard 401k to Mutual Of America Premier
print icon

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 EMAIL STRING  
Employee Phone Number PHONE STRING Numeric only
scroll to top icon