This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Benefit Consultants Group Payroll Contribution csv file specifications. This transformation is used in a detamoov integration with Benefit Consultants Group (BCG).
|
Source File |
Destination File |
|
Standard 401k |
Benefit Consultants Group 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
|
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the Benefit Consultants Group Payroll Contribution csv format is created correctly from the standard 401k format.
|
Empower Field Name |
Standard 401k Field Name |
Field Size |
Details |
| Pad |
|
||
| Plan Id | Plan Id |
|
|
| Pay End Date |
Pay Period End Date |
|
|
| Pay Start Date | Pay Period Start Date |
|
|
| Social Security Number | SSN |
|
|
| Name - Last | Last Name |
|
|
| Name - First |
First Name |
|
|
| Address - Street 1 | Address Line 1 | ||
| Address - Street 2 | Address Line 2 | ||
| Address - City | City |
|
|
|
Address - State |
State |
|
|
| Address - Postal Code | Zip |
|
|
| Date of Birth | DOB | MM/DD/YYYY format | |
| Date of Hire - Original | Date of Hire |
MM/DD/YYYY format |
|
| Date of Rehire | Rehire Date | MM/DD/YYYY format | |
|
Employment Status Code |
Employment Status |
|
|
| Pad | |||
| Employment Status Date |
Termination Date |
||
| Pad | |||
| Pad | |||
| Pad | |||
| Pad | |||
| Current Salary | |||
| Current Hours of Service | YTD Hours Worked | ||
| Current Deferral | CURRENT PARYOLL EMPLOYEE PRETAX CONTRIBUTION |
|
|
| CURRENT USER DEFINED 1 $ | CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION |
|
|
| Employer Match | CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION |
|
|
| Employer | |||
| CURRENT USER DEFINED 2 $ | CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH |
|
|
| Loan Payment |
401K Loan 1 Repayment |
|
|
| PAY FREQUENCY CODE |
Pay Period Start Date Pay Period End Date |
W = WEEKLY S = SEMI-MONTHLY B = BIWEEKLY |
|
| PAY FREQUENCY SEQUENCE NUMBER |
|
