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 John Hancock
Standard 401k to John Hancock
print icon

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

 

Source File

Destination File

Standard 401k

John Hancock Payroll Contribution CSV

 

File Specifications

File Type Generated

CSV

Header Row(s) Generated

Yes

Footer Row(s) Generated

No

End of Row Character

CRLF (Carriage Return Line Feed)

File Naming Generated

Production

  • AP_[PlanID]_[uniquefilename].csv

Test

  • TS_[PlanID]_[uniquefilename].csv

 

Field Mappings

The table below details the specific field mapping and transformation rules applied to ensure the John Hancock Payroll Contribution csv format is created correctly from the standard 401k format.

Empower Field Name

Standard 401k Field Name

Field Size

Details

COMB.H10    

Hardcoded to comb.d

CONT# Plan Id  

 

SSN# SSN  

 

FIRSTNAME

First Name    
LASTNAME Last Name  

 

INITIAL Middle Name/Initial    
NAMEPREFIX    

 

EEID#

Employee Number

   
ADDRESS 1 Address Line 1    
ADDRESS 2 Address Line 2    
CITY City    
STATE State    
ZIP CODE Zip    
COUNTRY

 

   
STATERES

 

   
ERPROVEMAIL Email  

 

DIVISION

 

 

 

BIRTHDATE DOB   Will be in MMDDYYYY
HIREDATE

Hire Date

 

Will be in MMDDYYYY
EMPLSTAT Employment Status    
EMPLSTATDATE

Hire Date, Rehire Date, Termination Date

  Most recent date will be selected and formatted in MMDDYYYY
ELIGIND      
ELIGDATE Eligibility Date   Will be in MMDDYYYY
OPTOUTIND      
YTDHRS

YTD Hours

 

 

PlanYTDComp

 

 

 

PLANYTDCOMP    

 

PlanYtdHrsComp    

 

YtdHrsWkCompdt

 

 

 

YTDHRSWRCOMPDT

Pay Period End Date

 

Will be in MMDDYYYY

BASE SALARY

     
BFTXDEFPCT

 

 

 

BFTXFLTDODEF

 

   
DESIGROTHPCT

 

 

 

DESIGROTHAMT

 

   
TRANS#

 

 

DATE

Pay Period End Date

  Will be in MMDDYYYY
EEDEF Current Payroll Pretax Contribution  

 

ERMAT

Current Payroll Employer Match Contribution

   
QMAC

Current Payroll Qualified Matching Contribution

 

 

SHMAC

Current Payroll Safe Harbor Employer Match

   
ERMC3    

 

EEROT

Current Payroll Roth Contribution

   
QNEC

Current Payroll Non Elective Contribution

 

 

SHNEC Current Payroll Safe Harbor Non Elective    
ERPS

Current Payroll Profit Share Contribution

 

 

EERC

 

   
EEVND

Current Payroll Post Tax Contribution

 

 

EEVD

 

 

 
EEMAN

 

 

 

ERMP

 

   
ERCON

 

 

 

S/HGR      
EEMT1

 

 

 

EEMT2

 

 

 

ERMT1

 

 

 

ERMT2

 

   
ERMT3

 

 

 

ERMT4

 

 

 
ERMT5

 

 

 
ERMT6

 

 

 

LOANID 401K Loan 1 ID    
LOADAMT 401K Loan 1 Contribution    
LOANID 401K Loan 2 ID    
LOADAMT 401K Loan 2 Contribution    
LOANID      
LOADAMT      
LOANID      
LOADAMT      
LOANID      
LOADAMT      
LOANID      
LOADAMT      
LOANID      
LOADAMT      
LOANID      
LOADAMT      
LOANID      
LOADAMT      
LOANID      
LOADAMT      

 

scroll to top icon