This article describes the file transformation that has been created in detamoov to transform the standard 401k file format to the HowardSimon file specifications. This transformation is used in a detamoov integration with HowardSimon.
|
Source File |
Destination file |
|
Standard 401k |
HowardSimon |
File Specifications
| File Type Generated | CSV |
| Header Row(s) Generated | Yes |
| Footer Row(s) Generated | No |
| End of Row Character | CRLF |
| File Naming Generated |
[Plan Id]_YYYYMMDDHHMMSSFF.csv |
Field Mappings
The tables below detail the specific field mappings and transformation rules applied to ensure the HowardSimon csv format is created correctly from the standard 401k format.
|
Field |
HowardSimon Field Name |
Standard 401k Field Name |
Details |
|
1 |
SSN |
SSN |
###-##-#### |
|
2 |
Last Name |
LAST NAME |
|
|
3 |
First Name |
FIRST NAME |
|
|
4 |
Address 1 |
ADDRESS LINE 1 |
|
|
5 |
Address 2 |
ADDRESS LINE 2 |
|
|
6 |
City |
CITY |
|
|
7 |
State |
STATE |
|
|
8 |
Zip Code |
ZIP |
|
|
9 |
Date of Birth |
DOB |
MM/DD/YYYY |
|
10 |
Original Hire Date |
HIRE DATE |
MM/DD/YYYY |
|
11 |
Termination Date |
TERMINATION DATE |
MM/DD/YYYY |
|
12 |
Date of Rehire |
REHIRE DATE |
MM/DD/YYYY |
|
13 |
Current Hours |
CURRENT PAY PERIOD HOURS WORKED |
|
|
14 |
Current Salary |
CURRENT PAY PERIOD GROSS PAY |
|
|
15 |
Current Pre-Tax |
CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION |
|
|
16 |
Current Roth |
CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION |
|
|
17 |
Loan Repayment |
401K LOAN 1 CONTRIBUTION |
Sum all loans |
|
18 |
Employer Match |
CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION |
|
|
19 |
Employer Profit Sharing |
CURRENT PAYROLL NON ELECTIVE CONTRIBUTION |
|
|
20 |
Email Address |
|
|
