This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Ascensus CSV file specifications. This transformation is used in a detamoov integration with Ascensus.
|
Source File |
Destination File |
|
Standard 401k |
Ascensus CSV |
File Specifications
|
File Type Generated |
CSV |
|
Header Row(s) Generated |
Yes, two header rows are created:
|
|
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 Ascensus csv format is created correctly from the standard 401k format.
|
Ascensus Field Name |
Standard 401k Field Name |
Field Size |
Details |
| Social Security | SSN |
######### format (no dashes included) |
|
| Last Name | Last Name |
Proper Casing applied |
|
| First Name | First Name | Proper Casing applied | |
|
MI |
|||
| Divisional Code |
|
||
| Total Compensation | Current Pay Period Gross Pay | Rounded to two decimal places | |
| Employee 401k | Current Payroll PreTax Contribution | Rounded to two decimal places | |
| Roth 401k |
Current Payroll Roth Contribution |
Rounded to two decimal places | |
| Loan Payment Amount | 401k Loan 1 Contribution | Rounded to two decimal places | |
| Match | Current Payroll Employer Match Contribution | Rounded to two decimal places | |
| Profit Sharing | Current Payroll Non Elective Contribution | Rounded to two decimal places | |
| Safe Harbor Match | Current Payroll Safe Harbor Match | Rounded to two decimal places | |
| Safe Harbor NEC | Current Payroll Safe Harbor Non Elective | Rounded to two decimal places | |
| Client Specific |
|
||
| Client Specific |
|
||
| Client Specific |
|
||
| Hours | Current Pay Period Hours Worked | Rounded to two decimal places | |
| Address 1 | Address Line 1 | ||
| Address 2 | Address Line 2 |
|
|
| City | City | ||
| State | State | ||
| Zip | Zip | ||
| Current Date of Hire | Hire Date, Rehire Date | The most recent date between these two fields will be used and formatted in MM/dd/yyyy format | |
| Employee Eligibility Date | Eligibility Date | MM/dd/yyyy format | |
| Current Date of Term |
Termination Date |
|
MM/dd/yyyy format |
|
Prior Date of Hire |
Hire Date, Rehire Date | The most past date between these two fields will be used and formatted in MM/dd/yyyy format | |
| Prior Date of Term |
|
||
| Estimate Annual Compensation |
|
||
| Employment Status |
|
|
|
| HCE Code | |||
|
Key EE Code |
|||
| Enrollment Eligibility |
|
|
|
| Union Statue Code |
|
||
| Employee Work Email |
|
