This article describes the file transformation that has been created in detamoov to transform the standard 401k file format to the ADP Connect file specifications. This transformation is used in a detamoov integration with ADP Connect.
|
Source File |
Destination file |
|
Standard 401k |
ADP Connect |
File Specifications
| File Type Generated | CSV |
| Header Row(s) Generated | Yes |
| Footer Row(s) Generated | No |
| End of Row Character | CRLF |
| File Naming Generated |
[Plan Id]_YYYYMMDDHHMMSS.csv |
Field Mappings
The tables below detail the specific field mappings and transformation rules applied to ensure the ADP Connect csv format is created correctly from the standard 401k format.
|
ADP Field Name |
Standard 401k Field Name |
Details |
|
Check Date |
PAYROLL CHECK DATE |
MM/DD/YYYY |
|
SSN |
SSN |
No dashes |
|
Employee Name |
FIRST NAME |
Concatenate w/space |
|
Address Line 1 |
ADDRESS LINE 1 |
|
|
Address Line 2 |
ADDRESS LINE 2 |
|
|
City |
CITY |
|
|
State |
STATE |
|
|
ZIP Code |
ZIP |
Take first 5 chars |
|
Date of Birth |
DOB |
MM/DD/YYYY |
|
Date of Hire |
HIRE DATE |
MM/DD/YYYY |
|
Date of Termination |
TERMINATION DATE |
MM/DD/YYYY |
|
Date of Rehire |
REHRE DATE |
MM/DD/YYYY |
|
HCE Code |
HIGHLY COMPENSATED EMPLOYEE |
Y = Yes |
|
Key Employee Code |
KEY EMPLOYEE |
Y = Yes |
|
Employee Status |
EMPLOYMENT STATUS |
A = Active |
|
YTD Gross Compensation |
YTD GROSS PAY |
|
|
Pretx Elective Deferral $ |
CURRENT PAYROLL EMPLOYEE PRETAX |
|
|
Roth Elective Deferral $ |
CURRENT PAYROLL EMPLOYEE ROTH |
|
|
YTD Plan Compensation |
|
|
|
Hours Worked PTD |
CURRENT PAY PERIOD HOURS WORKED |
|
|
Hours Worked YTD |
YTD HOURS WORKED |
|
|
Company Code |
COMPANY CODE |
|
|
Pay Frequency |
PAY PERIOD START DATE |
W = Weekly |
|
|
|
|
|
Mobile Phone Number |
PHONE |
No dashes or other symbols |
|
Employee ID/File # |
EMPLOYEE NUMBER |
|
|
Location - 4 characters |
|
|
|
Secondary Location |
|
|
|
Date of Plan Eligibility |
|
|
|
Plan Compensation PTD |
|
|
|
Gross Compensation PTD |
CURRENT PAY PERIOD GROSS PAY |
|
|
Elgible Gross Compensation YTD |
|
|
|
Date of Match Eligibility |
|
|
|
Alt Eligiblity Date |
|
|
|
Exclusion Indicator |
|
|
|
Loan Number 1 |
401K LOAN 1 ID |
|
|
Loan Repayment 1 |
401K LOAN 1 REPAYMENT |
|
|
Loan Number 2 |
401K LOAN 2 ID |
|
|
Loan Repayment 2 |
401K LOAN 2 REPAYMENT |
|
|
Union Indicator |
|
|
|
Employer Match |
CURRENT PAYROLL EMPLOYER MATCH |
SUM |
|
Non-Elective Contributions |
CURRENT PAYROLL NON-ELECTIVE |
SUM |
|
After Tax Contributions |
CURRENT PAYROLL EMPLOYEE POSTTAX |
|
