This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the CalSavers Payroll Contribution fixed length file specifications. This transformation is used in a detamoov integration with CalSavers.
Source File |
Destination File |
Standard 401k |
CalSavers Payroll Contribution Fixed Length |
File Specifications
File Type Generated |
Fixed length |
Header Row(s) Generated |
No |
Footer Row(s) Generated |
No |
End of Row Character |
|
File Naming Generated |
Production <Program>_<EIN>_<EmployeeDeduction/9X>_ASTRO_AsciiA8Fmt_YYYYMMDD_HHMMSS_<sequence>_[Anything you want here].txt |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the Empower Payroll Contribution fixed length format is created correctly from the standard 401k format.
Empower Field Name |
Standard 401k Field Name |
Field Size |
Details |
Payroll Number |
Payroll Run Number |
6 |
|
Employer ID/BIN |
Company EIN |
11 |
|
Payroll End Date |
Pay Period End Date |
8 |
|
Social Security Number |
SSN |
9 |
|
Last Name, First Name |
Last Name, First Name |
32 |
|
Address Line 1 |
Address Line 1 |
30 |
|
Address Line 2 |
Address Line 2 |
30 |
|
City, State |
City, State |
20 |
|
Zip |
Zip |
9 |
|
Date of Birth |
DOB |
8 |
Will be in MMDDYYYY |
Date of Hire |
Hire Date |
8 |
Will be in MMDDYYYY |
Date of Termination |
Termination Date |
8 |
Will be in MMDDYYYY |
Gross Wages Pay Period |
Current Pay Period Gross Pay |
11 |
No Decimal Places, No Commas |
Traditional Deferral Amount |
Current Payroll Pretax Contribution |
11 |
No Decimal Places, No Commas |
Loan Repayment |
401K Loan 1 Repayment |
11 |
No Decimal Places, No Commas |
ER Match |
Current Payroll Employer Match Contribution |
11 |
No Decimal Places, No Commas |
Profit Sharing |
Current Payroll Non Elective Contribution |
11 |
No Decimal Places, No Commas |
Roth Deferral Amount |
Current Payroll Employee Roth Contribution |
11 |
No Decimal Places, No Commas |
Current Pay Period Hours |
Current Pay Period Hours Worked |
4 |
No Decimal Places, No Commas |
Division Code |
|
5 |
|
External Payroll Id |
Employee Number |
25 |
|
Extra Spaces for Future Fields |
|
192 |
|