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