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.
Standard 401k to OneAmerica
print icon

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 EMAIL STRING  
Work Email   STRING  

 

scroll to top icon