This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Transamerica Large Market file specifications. This transformation is used in a detamoov integration with Transamerica Large Market plans.
| Source File | Destination file |
| Standard 401k | Transamerica Large Market |
File Specifications
| File Type Generated | CSV |
| Header Row(s) Generated | No |
| Footer Row(s) Generated | No |
| End of Row Character | CRLF |
| File Naming Generated |
Test: [Plan Id]_[Division]_MMDDYYYYHHMMSS_TEST.txt Prod: [Plan Id]_[Division]_MMDDYYYYHHMMSS.txt |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the Transamerica Large Market Payroll Contribution csv format is created correctly from the standard 401k format.
|
Transamerica Field Name |
Standard 401k Field Name |
Details |
|
Account Number |
PLAN ID |
|
|
Social Security Number |
SSN |
######### or |
|
Employee Number |
EMPLOYEE NUMBER |
|
|
Employee Division/Location Code |
|
Client specific identifier |
|
Class Code |
|
If required, Transamerica to provide valid codes |
|
Employee Last Name |
LAST NAME |
|
|
Employee Last Name Suffix |
|
|
|
Employee First Name |
FIRST NAME |
|
|
Employee Middle Initial |
MIDDLE NAME/INITIAL |
|
|
Birth Date |
DOB |
MM/DD/YYYY |
|
Hire Date |
HIRE DATE |
MM/DD/YYYY |
|
Adjusted Service Date |
|
MM/DD/YYYY |
|
Termination Date |
TERMINATION DATE |
MM/DD/YYYY |
|
Rehire Date |
REHIRE DATE |
MM/DD/YYYY |
|
Street Address Line 1 |
ADDRESS LINE 1 |
|
|
Street Address Line 2 |
ADDRESS LINE 2 |
|
|
City Name |
CITY |
|
|
State Code |
STATE |
|
|
Zip Code |
ZIP |
Numeric Only |
|
E-mail address |
|
|
|
Daytime/Work Phone Number |
PHONE |
|
|
Evening/Home Phone Number |
PHONE |
|
|
Mobile Phone Number |
PHONE |
|
|
Single Sign On Eligibility Code |
|
|
|
Single Sign On Id |
|
|
|
Marital Status Code |
MARITAL STATUS |
S = Single |
|
Employee Payroll Frequency |
|
12 = Monthly |
|
Gender |
GENDER |
M = Male |
|
Employee Highly Comp Code |
HIGHLY COMPENSATED EMPLOYEE |
Y = Yes |
|
Insider Investor Code |
|
Required for plans with employer stock as an investment option |
|
Language Code |
|
|
|
Termination Reason Code |
TERMINATION DATE |
0 = Normal Termination |
|
Current Hours Paid |
CURRENT PAY PERIOD HOURS WORKED |
|
|
Employer Non-elective Contribution amount |
CURRENT PAYROLL NON ELECTIVE CONTRIBUTION |
|
|
Employee After-tax Contribution amount |
CURRENT PAYROLL EMPLOYEE POSTTAX CONTRIBUTION |
|
|
Employee Pre Tax contribution amount |
CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION |
|
|
Employee Roth contribution amount |
CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION |
|
|
Employer Match contribution amount |
CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION |
|
|
Employer Safe Harbor Match Contribution amount |
CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH |
|
|
Employee Loan Repayment |
401K 1 LOAN REPAYMENT |
SUM |
|
Additional Source 1 Contribution Amount |
|
|
|
Additional Source 2 Contribution Amount |
|
|
|
Current Gross Compensation |
CURRENT PAY PERIOD GROSS PAY |
|
|
Current Plan Compensation |
|
|
|
Additional Compensation_1 |
|
|
|
Additional Compensation_2 |
|
|
|
Payroll Period Start Date |
PAY PERIOD START DATE |
MM/DD/YYYY |
|
Payroll Period End Date |
PAY PERIOD END DATE |
MM/DD/YYYY |
|
Paycheck Date |
PAYROLL CHECK DATE |
MM/DD/YYYY |
|
Department |
|
|
