Standard 401k to Empower v2025.1
Feb 12, 2025
This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Empower Payroll Contribution fixed length file specifications. This transformation is used in a detamoov integration with Empower.
|
Source File |
Destination File |
|
Standard 401k |
Empower 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 |
CRLF |
|
File Naming Generated |
Production: ftp[date time stamp down to the millisecond[Plan ID].txt.pgp Testing: Testftp[date time stamp down to the millisecond[Plan ID].txt.pgp |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the Empower Payroll Contribution fixed length file is created correctly from the standard 401k format.
| Empower Field Name | STANDARD FILE MAPPING | Field Size | Field Start | Field End | Details |
| Plan Number | PLAN ID | 13 | 1 | 13 | |
| Employee SSN | SSN | 11 | 14 | 24 | Numeric Only |
| Division number | 20 | 25 | 44 | Required if plan is divisionalized | |
| Last Name | LAST NAME | 35 | 45 | 79 | |
| First Name | FIRST NAME | 20 | 80 | 99 | |
| Middle Name | MIDDLE NAME/INITIAL | 20 | 100 | 119 | |
| Name Suffix | 15 | 120 | 134 | ||
| Birth Date | DOB | 10 | 135 | 144 | |
| Gender | GENDER | 1 | 145 | 145 | M = Male F = Female N = Non-Binary U = Unspecified |
| Marital Status | MARITAL STATUS | 1 | 146 | 146 | M = Married S = Single D = Divorced W = Widowed |
| Address Line 1 | ADDRESS LINE 1 | 35 | 174 | 181 | |
| Address Line 2 | ADDRESS LINE 2 | 35 | 182 | 216 | |
| City | CITY | 20 | 217 | 236 | |
| State | STATE | 2 | 237 | 238 | Upper Case |
| Zip Code | ZIP | 10 | 239 | 248 | Numeric Only |
| Home Phone Number | PHONE | 10 | 249 | 258 | Numeric Only |
| Work Phone Number | 10 | 259 | 268 | ||
| Work Phone Ext. | 4 | 269 | 272 | ||
| Country Code | 2 | 273 | 274 | ||
| Hire Date | HIRE DATE | 10 | 275 | 284 | MM/DD/YYYY |
| Termination Date | TERMINATION DATE | 10 | 285 | 294 | MM/DD/YYYY |
| Re-Hire Date | REHIRE DATE | 10 | 295 | 304 | MM/DD/YYYY |
| Checkdate | PAYROLL CHECK DATE | 10 | 305 | 314 | MM/DD/YYYY |
| Contribution Amount 1 | CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION | 10 | 315 | 324 | Round Number - Force 2 decimals Pad left zeros |
| Contribution Amount 2 | CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION | 10 | 325 | 334 | Round Number - Force 2 decimals Pad left zeros |
| Contribution Amount 3 | 401k LOAN REPAYMENT 1 401k LOAN REPAYMENT 2 |
10 | 335 | 344 | Sum Round Number - Force 2 decimals Pad left zeros |
| Contribution Amount 4 | CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION | 10 | 345 | 354 | Round Number - Force 2 decimals Pad left zeros |
| Contribution Amount 5 | CURRENT PAYROLL SAFE HARBOR NON ELECTIVE CURRENT PAYROLL NON ELECTIVE CONTRIBUTION CURRENT PAYROLL QUALIFIED ELECTIVE CONTRIBUTION |
10 | 355 | 364 | Sum Round Number - Force 2 decimals Pad left zeros |
| Contribution Amount 6 | CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH CURRENT PAYROLL QUALIFIED MATCHING CONTRIBUTION |
10 | 365 | 374 | Sum Round Number - Force 2 decimals Pad left zeros |
| Contribution Amount 7 | CURRENT PAYROLL EMPLOYEE POSTTAX CONTRIBUTION | 10 | 375 | 384 | Round Number - Force 2 |
| Numeric Padding | |||||
| Contribution Amount 8 | 10 | 385 | 394 | ||
| Hours Worked | YTD HOURS WORKED | 5 | 395 | 399 | Whole number |
| YTD Total Compensation | YTD GROSS PAY | 11 | 400 | 410 | |
| YTD Plan Compensation | YTD GROSS PAY | 11 | 411 | 421 | |
| YTD Pre Entry Compensation | 11 | 422 | 432 | ||
| Highly Comp Employee Code | 1 | 433 | 433 | Y = Yes | |
| Percent of Ownership | 6 | 434 | 439 | ||
| Officer Determination | 1 | 440 | 440 | Y = Yes | |
| Participation Date | 10 | 441 | 450 | MM/DD/YYYY | |
| Eligibility Code | 1 | 451 | 451 | Y = Yes N = No |
|
| Filler | 1 | 452 | 452 | ||
| LOA Reason Code | 1 | 453 | 453 | L = LOA M = Military |
|
| LOA Start Date | 10 | 454 | 463 | MM/DD/YYYY | |
| LOA End Date | 10 | 464 | 473 | MM/DD/YYYY | |
| Work Email Address | 80 | 474 | 553 | ||
| Salary Amount | 17 | 554 | 570 | ||
| Salary Amount Qualifier | 2 | 571 | 572 | A = Annual M = Monthly S = Semi-Monthly B = Bi-Weekly H = Hourly W = Weekly |
|
| Termination Reason Code | 20 | 573 | 592 | DE = Death DI = Disability LA = Laid Off R = Retirement S = Separation |
|
| Sarbanes Oxley Reporting Indicator | 1 | 593 | 593 | Y = Yes N = No |
|
| Filler | 6 | 594 | 599 | ||
| Federal Exemptions | 2 | 600 | 601 | ||
| Employee Assigned ID | EMPLOYEE NUMBER | 10 | 602 | 611 | |
| Compliance Status Code | 6 | 612 | 617 | D = Death E = Excluded I = Disabled L = Leased Employees M = Military Leave N = Non-Resident Alien R = Retired S = Age/Service req. not met T = Terminated in prior year with comp due to severance pay U = Union/collectve bargaining employee X = member of an excludable class 0 (zero) = when an employee moved ouf of a status code |
|
| Personal Email Address | 80 | 618 | 697 | ||
| Mobile Phone | 10 | 698 | 707 | ||
| Pay Frequency | PAY PERIOD START DATE PAY PERIOD END DATE |
1 | 708 | 708 | M = Monthly S = Semi-Monthly B = Bi-Weekly W = Weekly Q = Quarterly A = Annually |
| Location | 20 | 709 | 728 | ||
| Department | 20 | 729 | 748 | ||
| Part Time/Full Time Indicator | 1 | 749 | 749 | F - Full-Time P = Part-Time |
|
| Long Term/Part Time Eligibility Indicator | 1 | 750 | 750 | Y = Yes N = No or null |
|
| FICA Prior Year Indicator | 1 | 751 | 751 | Y = Yes N = No or null |
|
| Union Indicator | 1 | 752 | 752 | Y = Yes N = No |
|
| Ethnicity Code | 2 | 753 | 754 | AK = American Indian/Alaska Native AS = Asian B= Black HI = Hispanic ME = Two or more races ND = Non-Disclosure PI = Pacific Islander WH = Caucasian |
|
| Employment Type | 7 | 755 | 761 | ||
| Employee Type | 1 | 762 | 762 | E = Executive S = Salary H = Hourly |
|
| Public Safety Office Indicator | 1 | 763 | 763 | Y = Yes N = No Null acceptable |
