This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Employee Fiduciary Payroll Contribution fixed length file specifications. This transformation is used in a detamoov integration with Employee Fiduciary.
|
Source File |
Destination File |
|
Standard 401k |
Employee Fiduciary Payroll Contribution CSV |
File Specifications
|
File Type Generated |
CSV |
|
Header Row(s) Generated |
No |
|
Footer Row(s) Generated |
No |
|
End of Row Character |
|
|
File Naming Generated |
Production
|
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the Employee Fiduciary Payroll Contribution csv format is created correctly from the standard 401k format.
|
Empower Field Name |
Standard 401k Field Name |
Field Size |
Details |
|
PLAN ID |
PLAN ID |
|
|
| DIVISION |
|
||
| PAYROLL FREQUENCY |
|
WEEKLY = W |
|
|
PAYROLL BEGIN DATE |
PAY PERIOD START DATE |
MM/DD/YYYY format |
|
| PAYROLL END DATE | PAY PERIOD END DATE |
MM/DD/YYYY format |
|
|
CHECK DATE |
PAYROLL CHECK DATE |
|
|
| SSN |
SSN |
|
|
| LAST NAME | LAST NAME | ||
| MIDDLE NAME | MIDDLE NAME/INITIAL | ||
| FIRST NAME | FIRST NAME |
|
|
|
TITLE |
|
||
| GENDER | GENDER |
|
|
| EMAIL ADDRESS (WORK) | |||
| EMAIL ADDRESS (OTHER) |
|
||
| ADDRESS 1 | ADDRESS LINE 1 | ||
| ADDRESS 2 |
ADDRESS LINE 2 |
|
|
| CITY | CITY | ||
| STATE | STATE | ||
| ZIP | ZIP | ||
| BIRTHDATE | DOB | MM/DD/YYYY format | |
|
HIRE DATE |
HIRE DATE | MM/DD/YYYY format | |
| TERMINATION DATE | TERMINATION DATE | MM/DD/YYYY format | |
| REHIRE DATE | REHIRE DATE | MM/DD/YYYY format | |
| GROSS EARNINGS | CURRENT PAY PERIOD GROSS PAY | ||
| PLAN EARNINGS | CURRENT PAY PERIOD GROSS PAY | ||
| HOURS | CURRENT PAY PERIOD HOURS WORKED | ||
| EXCLUDED EARNINGS |
|
||
| SECTION 125 | |||
| LOAN PAYMENTS | 401K LOAN 1 REPAYMENT | ||
| EMPLOYEE DEFERRAL | CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION |
|
|
| EMPLOYEE ROTH | CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION |
|
|
| 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 NON-ELECTIVE CONTRIBUTION |
|
|
| PROFIT SHARING |
|
||
| MONEY PURCHASE |
|
|
