Jun 01, 2023
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 (Carriage Return Line Feed) |
File Naming Generated |
Production
Test
|
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 | Position | Field Size | Details |
---|---|---|---|---|
PLAN NUMBER | PLAN ID | 1 | 13 | |
EMPLOYEE SSN | SSN | 14 | 11 | |
DIVISION NUMBER | 25 | 20 | ||
LAST NAME | LAST NAME | 45 | 35 | |
FIRST NAME | FIRST NAME | 80 | 20 | |
MIDDLE NAME | MIDDLE NAME/INITIAL | 100 | 20 | |
NAME SUFFIX | 120 | 15 | ||
BIRTH DATE | DOB | 135 | 10 | MM/DD/YYYY Format |
GENDER | GENDER | 145 | 1 | A default value of U will be used if the Standard 401k value is not set to M or F. |
MARITAL STATUS | MARITAL STATUS | 146 | 1 | If no value is found in the Standard 401k file, a blank value will be used. |
ADDRESS LINE 1 | ADDRESS LINE 1 | 147 | 35 | |
ADDRESS LINE 2 | ADDRESS LINE 2 | 182 | 35 | |
CITY | CITY | 217 | 20 | |
STATE | STATE | 237 | 2 | Uppercase value set. |
ZIP CODE | ZIP CODE | 239 | 10 | |
HOME PHONE NUMBER | PHONE | 249 | 10 | All non-digit characters will be removed from the Standard 401k value sent. |
WORK PHONE NUMBER | 259 | 10 | ||
WORK EXT | 269 | 4 | ||
COUNTRY CODE | 273 | 2 | ||
HIRE DATE | HIRE DATE | 275 | 10 | MM/DD/YYYY Format |
TERMINATION DATE | TERMINATION DATE | 285 | 10 | MM/DD/YYYY Format |
RE-HIRE DATE | REHIRE DATE | 295 | 10 | MM/DD/YYYY Format |
CHECKDATE | PAYROLL CHECK DATE | 305 | 10 | MM/DD/YYYY Format |
CONTRIBUTION AMOUNT 1 (EMPLOYEE PRETAX CONTRIBUTION) |
CURRENT PAYROLL EMPLOYEE PRETAX | 315 | 10 | If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places. If no value exists in the Standard 401k file, zeroes will fill the entire field. |
CONTRIBUTION AMOUNT 2 (EMPLOYER MATCH CONTRIBUTION) |
CURRENT PAYROLL EMPLOYER MATCH | 325 | 10 | If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places. If no value exists in the Standard 401k file, zeroes will fill the entire field. |
CONTRIBUTION AMOUNT 3 (LOAN REPAYMENTS) |
401k LOAN 1 CONTRIBUTION + 401K LOAN 2 CONTRIBUTION |
335 | 10 | If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places. If no value exists in the Standard 401k file, zeroes will fill the entire field. |
CONTRIBUTION AMOUNT 4 (EMPLOYEE ROTH CONTRIBUTION) |
CURRENT PAYROLL EMPLOYEE ROTH | 345 | 10 | If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places. If no value exists in the Standard 401k file, zeroes will fill the entire field. |
CONTRIBUTION AMOUNT 5 (EMPLOYEE SAFE HARBOR NON-ELECTIVE CONTRIBUTION OR EMPLOYEE NON-ELECTIVE CONTRIBUTION OR QUALIFIED ELECTIVE CONTRIBUTION) |
SUM OF CURRENT PAYROLL SH NON-ELECTIVE, CURRENT PAYROLL NON ELECTIVE AND CURRENT PAYROLL QUALIFIED ELECTIVE |
355 | 10 | If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places. If no value exists in the Standard 401k file, zeroes will fill the entire field. |
CONTRIBUTION AMOUNT 6 (EMPLOYER SAFE HARBOR MATCH CONTRIBUTION OR EMPLOYER QUALIFIED MATCHING CONTRIBUTION) |
SUM OF CURRENT PAYROLL SH EMPLOYER MATCH, CURRENT PAYROLL QUALIFIED MATCHING |
365 | 10 | If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places. If no value exists in the Standard 401k file, zeroes will fill the entire field. |
CONTRIBUTION AMOUNT 7 (EMPLOYEE AFTERTAX CONTRIBUTION) |
CURRENT PAYROLL EMPLOYEE POSTTAX | 375 | 10 | If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places. If no value exists in the Standard 401k file, zeroes will fill the entire field. |
CONTRIBUTION AMOUNT 8 | 385 | 10 | If a value exists in the Standard 401k file, the value will be rounded to 2 decimal places. If no value exists in the Standard 401k file, zeroes will fill the entire field. | |
HOURS WORKED | YTD HOURS WORKED | 395 | 5 | Values will be rounded to the nearest integer value (no decimal). |
YTD TOTAL COMPENSATION | YTD GROSS PAY | 400 | 11 | |
YTD PLAN COMPENSATION | YTD GROSS PAY | 411 | 11 | |
HIGHLY COMP EMPLOYEE CODE | HIGHLY COMPENSATED EMPLOYEE | 422 | 1 | |
PARTICIPATION DATE | ELIGIBILITY DATE | 423 | 10 | MM/DD/YYYY Format |
ELIGIBILITY CODE | 433 | 1 | ||
WORK EMAIL ADDRESS | 434 | 80 | ||
SALARY AMOUNT | 514 | 17 | ||
SALARY AMOUNT QUALIFIER | 531 | 2 | ||
TERMINATION REASON CODE | 533 | 20 | ||
FEDERAL EXEMPTIONS | 553 | 2 | ||
EMPLOYER ASSIGNED ID | EMPLOYEE NUMBER | 555 | 10 | |
PERSONAL EMAIL ADDRESS | 565 | 80 | ||
MOBILE PHONE | 645 | 10 |