You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Standard 401k to Voya
print icon

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

  • [Employer ID]_VoyaPayrollFile-detamoov_yyyyMMddHHmmss.txt.pgp

Testing

  • [Employer ID]_TEST-VoyaPayrollFile-detamoov_yyyyMMddHHmmss.txt.pgp

 

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 EMAIL 40 499  
TIER GROUP   4 539  
CLIENT DATA 1   10 543  
CLIENT DATE 1   8 553  
FILLER   10 561  


 

scroll to top icon