This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Daybright Financial file specifications. This transformation is used in a detamoov integration with Daybright Financial.
| Source File | Destination file |
| Standard 401k | Daybright Financial |
File Specifications
| File Type Generated | CSV |
| Header Row(s) Generated | Yes |
| Footer Row(s) Generated | No |
| End of Row Character |
CRLF |
| File Naming Generated |
[PlanId]_[CheckDate in MM-DD-YYYY]_[Division ID]_MMDDYYYYHHMMSS.csv |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the Daybright Financial csv format is created correctly from the standard 401k format.
|
Daybright Field Name |
Standard 401k Field Name |
Details |
|
Plan ID |
PLAN ID |
|
|
Division ID |
|
Provided by Daybright during integration |
|
SSN |
SSN |
Format w/Dashes |
|
First Name |
FIRST NAME |
|
|
M.I. |
MIDDLE NAME/INITIAL |
|
|
Last Name |
LAST NAME |
|
|
Address Line 1 |
ADDRESS LINE 1 |
Remove commas |
|
Address Line 2 |
ADDRESS LINE 2 |
Remove commas |
|
City |
CITY |
|
|
State |
STATE |
|
|
Postal Code |
ZIP |
|
|
Birth Date |
DOB |
MM-DD-YYYY |
|
Hire Date |
HIRE DATE |
MM-DD-YYYY |
|
Termination Date |
TERMINATION DATE |
MM-DD-YYYY |
|
Rehire Date |
REHIRE DATE |
MM-DD-YYYY |
|
Phone # |
PHONE |
Numeric only |
|
Internet address - Office |
|
|
|
Internet address - Home |
|
|
|
Current Hours |
CURRENT PAY PERIOD HOURS WORKED |
Round - Force 2 |
|
Current Salary |
CURRENT PAY PERIOD GROSS PAY |
Round - Force 2 |
|
Regular Deferral |
CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION |
Round - Force 2 |
|
Roth 401(k) |
CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION |
Round - Force 2 |
|
Match |
CURRENT PAYROLL EMPLOYER MATCH |
Round - Force 2 |
|
Loan Payment |
401K LOAN 1 REPAYMENT |
Sum multiple loans |
