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
Test
|
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 |
|
||
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 |