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 Retirement Plan Consultants
Standard 401k to Retirement Plan Consultants
print icon

This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Retirement Plan Consultants Payroll Contribution fixed length file specifications. This transformation is used in a detamoov integration with Retirement Plan Consultants.

 

Source File

Destination File

Standard 401k

Retirement Plan Consultants Payroll Contribution Fixed Length

 

File Specifications

File Type Generated

CSV

Header Row(s) Generated

No

Footer Row(s) Generated

No

End of Row Character

CRLF (Carriage Return Line Feed)

File Naming Generated

Production

  • [PLAN_ID]_[CURRENT DATE IN YYYYMMDD FORMAT]_[TEST OR BLANK].CSV

 

Field Mappings

The table below details the specific field mapping and transformation rules applied to ensure the Retirement Plan Consultants Payroll Contribution fixed length format is created correctly from the standard 401k format.

Empower Field Name

Standard 401k Field Name

Field Size

Details

FIRST NAME

FIRST NAME

 

 

MIDDLE NAME MIDDLE NAME/INITIAL  

 

LAST NAME

LAST NAME

 

 

SSN SSN  

 

ADDRESS 1 ADDRESS LINE 1  

 

ADDRESS 2 ADDRESS LINE 2  

 

CITY

CITY

 

 

STATE STATE    
ZIP ZIP    
BIRTH DATE DOB  

MM/DD/YYYY format

HIRE DATE HIRE DATE  

MM/DD/YYYY format

REHIRE DATE REHIRE DATE  

MM/DD/YYYY format

TERMINATION DATE TERMINATION DATE   MM/DD/YYYY format
CHECK DATE PAYROLL CHECK DATE  

MM/DD/ YYYY format

PAYROLL BEGIN DATE PAY PERIOD START DATE   MM/DD/YYYY format
PAYROLL END DATE

PAY PERIOD END DATE

 

MM/DD/YYYY format

PAYROLL FREQUENCY

     
GROSS EARNINGS CURRENT PAY PERIOD GROSS PAY    
YTD EARNINGS YTD GROSS PAY    
HOURS CURRENT PAY PERIOD HOURS WORKED    
YTD HOURS YTD HOURS WORKED    
EXCLUDED EARNINGS

 

   
YTD EXCLUDED EARNINGS      
EMPLOYEE DEFERRAL CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION

 

 
EMPLOYEE ROTH CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION

 

 
EMPLOYEE AFTER TAX CURRENT PAYROLL EMPLOYEE POSTTAX CONTRIBUTION

 

 
LOAN PAYMENTS 401K LOAN 1 REPAYMENT

 

 
LOAN NUMBER  401K LOAN 1 ID

 

 
EMPLOYER MATCH CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION

 

 
SAFE HARBOR MATCH CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH

 

 
QUALIFIED MATCHING CONTRIBUTION CURRENT PAYROLL QUALIFIED MATCHING CONTRIBUTION

 

 
SAFE HARBOR NON-ELECTIVE CURRENT PAYROLL SAFE HARBOR NON-ELECTIVE

 

 
QUALIFIED NON-ELECTIVE CONTRIBUTION CURRENT PAYROLL QUALIFIED NON ELECTIVE CONTRIBUTION

 

 

PROFIT SHARING    

 

MONEY PURCHASE  

 

 
ROLLOVER

 

 

 

ROLLOVER ROTH

 

 

 

PLAN ID

PLAN ID

 

 

PAYROLL SEQUENCE NUMBER

 

 

 

USER DEFINED 2

 

 

 

USER DEFINED 3

 

 

 

USER DEFINED 4

 

 

 

USER DEFINED 5

 

 

 

scroll to top icon