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 Voya Payroll Contribution fixed length file specifications. This transformation is used in a detamoov integration with Voya.
Source File |
Destination File |
Standard 401k |
Voya 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
Testing
|
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.
Voya Field Name | Standard 401k Field Name | Field Size | Field Position | Details |
RECORD TYPE | 7 | 1 | Hardcoded to INGWIN6 | |
EMPLOYER ID | Plan Id | 6 | 8 | |
PAYROLL CYCLE | Maps to the company's pay frequency | 1 | 14 | Monthly = 4 Semi-Monthly = 5 Bi-Weekly = 6 Weekly = 7 |
PAY DATE | PAYROLL CHECK DATE | 8 | 15 | YYYYMMDD |
IRS CODE | 4 | 23 | Default to '401K' | |
SSN | SSN | 9 | 27 | Only numeric values are accepted |
EMPLOYEE NUMBER | EMPLOYEE NUMBER | 10 | 36 | |
DEPARTMENT CODE | 10 | 46 | ||
LOCATION CODE | 4 | 56 | Default to 0001 | |
LAST NAME | LAST NAME | 20 | 60 | Uppercase value set |
FIRST NAME | FIRST NAME | 15 | 80 | Uppercase value set |
MI | MIDDLE NAME/INITIAL | 1 | 95 | Uppercase value set; Only middle initial |
ADDRESS LINE 1 | ADDRESS LINE 1 | 25 | 96 | Uppercase value set |
ADDRESS LINE 2 | ADDRESS LINE 2 | 25 | 121 | Uppercase value set |
CITY | CITY | 20 | 146 | Uppercase value set |
STATE | STATE | 2 | 166 | Uppercase value set; 2 Character State code |
ZIP CODE | ZIP | 5 | 168 | Take first 5 characters |
ZIP EXTENSION | 4 | 173 | Leave Blank | |
GENDER | GENDER | 1 | 177 | |
RESERVED | 20 | 178 | ||
MARITAL STATUS | MARITAL STATUS | 1 | 198 | |
EMPLOYEE STATUS CODE | 1 | 199 | Default To A unless DATE OF TERMINATION is provided and in the past, then set to T | |
DATE OF BIRTH | DOB | 8 | 200 | YYYYMMDD |
DATE OF ORIGINAL HIRE | HIRE DATE | 8 | 208 | YYYYMMDD |
DATE OF TERMINATION | TERMINATION DATE | 8 | 216 | YYYYMMDD |
DATE OF REHIRE | REHIRE DATE | 8 | 224 | YYYYMMDD |
LEAVE OF ABSENCE START DATE | 8 | 232 | ||
LEAVE OF ABSENCE END DATE | 8 | 240 | ||
PLAN YTD HOURS | YTD HOURS WORKED | 4 | 248 | Force to 0 decimals |
CURRENT PERIOD HOURS | CURRENT PAY PERIOD HOURS | 4 | 252 | Force to 0 decimals |
ANNIVERSARY HOURS | 4 | 256 | Leave Blank | |
SOURCE CODE 1 | 1 | 260 | If CURRENT PAYROLL EMPLOYEE PRETAX has a value > 0, enter A. | |
CONTRIBUTION AMOUNT SOURCE # 1 | CURRENT PAYROLL EMPLOYEE PRETAX | 9 | 261 | No decimal points, last two digits are implied as the decimal portion of the number |
SOURCE CODE 2 | 1 | 270 | If CURRENT PAYROLL EMPLOYEE ROTH has a value > 0, enter G. | |
CONTRIBUTION AMOUNT SOURCE # 2 | CURRENT PAYROLL EMPLOYEE ROTH | 9 | 271 | No decimal points, last two digits are implied as the decimal portion of the number |
SOURCE CODE 3 | 1 | 280 | If CURRENT PAYROLL EMPLOYER MATCH has a value > 0, enter D. | |
CONTRIBUTION AMOUNT SOURCE # 3 | CURRENT PAYROLL EMPLOYER MATCH | 9 | 281 | No decimal points, last two digits are implied as the decimal portion of the number |
SOURCE CODE 4 | 1 | 290 | If CURRENT PAYROLL EMPLOYEE POSTTAX has a value > 0, enter K | |
CONTRIBUTION AMOUNT SOURCE # 4 | CURRENT PAYROLL EMPLOYEE POSTTAX | 9 | 291 | No decimal points, last two digits are implied as the decimal portion of the number |
SOURCE CODE 5 | 1 | 300 | If CURRENT PAYROLL SAFE HARBOR NON ELECTIVE has a value > 0, enter W | |
CONTRIBUTION AMOUNT SOURCE # 5 | CURRENT PAYROLL SAFE HARBOR NON ELECTIVE | 9 | 301 | No decimal points, last two digits are implied as the decimal portion of the number |
SOURCE CODE 6 | 1 | 310 | If CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH has a value > 0, enter X | |
CONTRIBUTION AMOUNT SOURCE # 6 | CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH | 9 | 311 | No decimal points, last two digits are implied as the decimal portion of the number |
LOAN NUMBER | 401k LOAN 1 ID | 3 | 320 | |
EMPLOYEE LOAN PAYMENT | 401K LOAN 1 CONTRIBUTION | 9 | 323 | No decimal points, last two digits are implied as the decimal portion of the number |
LOAN NUMBER | 401K LOAN 2 ID | 3 | 332 | |
EMPLOYEE LOAN PAYMENT | 401K LOAN 2 CONTRIBUTION | 9 | 335 | No decimal points, last two digits are implied as the decimal portion of the number |
LOAN NUMBER | 3 | 344 | ||
EMPLOYEE LOAN PAYMENT | 9 | 347 | No decimal points, last two digits are implied as the decimal portion of the number | |
LOAN NUMBER | 3 | 356 | ||
EMPLOYEE LOAN PAYMENT | 9 | 359 | No decimal points, last two digits are implied as the decimal portion of the number | |
LOAN NUMBER | 3 | 368 | ||
EMPLOYEE LOAN PAYMENT | 9 | 371 | No decimal points, last two digits are implied as the decimal portion of the number | |
LOAN NUMBER | 3 | 380 | ||
EMPLOYEE LOAN PAYMENT | 9 | 383 | No decimal points, last two digits are implied as the decimal portion of the number | |
UNION MEMBER | 1 | 392 | ||
EMPLOYEE ELIGIBILITY CODE | 1 | 393 | ||
RESERVED | 8 | 394 | ||
YTD GROSS COMPENSATION | YTD GROSS PAY | 11 | 402 | No decimal points, last two digits are implied as the decimal portion of the number |
RESERVED | 11 | 413 | ||
YTD TEST (ADP/ACP) COMPENSATION | 11 | 424 | ||
YTD ALLOCATION/BENEFIT COMPENSATION | 11 | 435 | ||
RESERVED | 11 | 446 | ||
ANNUAL SALARY | 11 | 457 | ||
MISCELLANEOUS COMPENSATION | 11 | 468 | ||
RESERVED | 1 | 479 | ||
RESERVED | 9 | 480 | ||
KEY EMPLOYEE INDICATOR | 1 | 489 | ||
RESERVED | 1 | 490 | ||
RESERVED | 5 | 491 | ||
HIGHLY COMPENSATED EMPLOYEE | 1 | 496 | LEAVE BLANK | |
NON-RESIDENT ALIEN? | 1 | 497 | ||
RESERVED | 1 | 498 | ||
EMAIL ADDRESS | 40 | 499 | ||
TIER GROUP | 4 | 539 | ||
CLIENT DATA 1 | 10 | 543 | ||
CLIENT DATE 1 | 8 | 553 | ||
FILLER | 10 | 561 |