This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the RPG Consultants file specifications. This transformation is used in a detamoov integration with RPG Consultants.
| Source File | Destination file |
| Standard 401k | RPG Consultants |
File Specifications
| File Type Generated | CSV |
| Header Row(s) Generated | Yes |
| Footer Row(s) Generated | No |
| End of Row Character | CRLF |
| File Naming Generated |
Prod: [Plan ID]_[DivisionID]_[Payroll Name]_[PayDate in MMDDYYYY].csv Test: TEST_[Plan ID]_[DivisionID]_[Payroll Name]_[PayDate in MMDDYYYY].csv |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the RPG Consultants Payroll Contribution csv format is created correctly from the standard 401k format.
| RPG Field Name |
Standard 401k Field Name |
Details |
|
PlanID |
PLAN ID |
|
|
Division ID |
|
Provided by RPG |
|
Pay Frequency Code |
PAY PERIOD START DATE |
A = Annual |
|
Pay Sequence Number |
|
Provided by RPG |
|
Period Beginning Date |
PAY PERIOD START DATE |
MM/DD/YYYY |
|
Period Ending Date |
PAY PERIOD END DATE |
MM/DD/YYYY |
|
Pay Date |
PAYROLL CHECK DATE |
MM/DD/YYYY |
|
SSN |
SSN |
###-##-#### |
|
Last Name |
LAST NAME |
|
|
First Name |
FIRST NAME |
|
|
Pre-Tax Deferral |
CURRENT PAYROLL EMPLOYEE PRETAX |
|
|
Roth Contribution |
CURRENT PAYROLL EMPLOYEE ROTH |
|
|
After-Tax Contribution |
CURRENT PAYROLL EMPLOYEE POSTTAX |
|
|
Discretionary Match |
CURRENT PAYROLL EMPLOYER MATCH |
|
|
Safe Harbor Match |
CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH |
|
|
Safe Harbor Non-Elective |
CURRENT PAYROLL SAFE HARBOR NON ELECTIVE |
|
|
Employer Profit Sharing |
CURRENT PAYROLL NON ELECTIVE |
|
|
Loan Repayment |
401K LOAN 1 REPAYMENT |
Sum multiple loans |
|
Period Salary |
CURRENT PAY PERIOD GROSS PAY |
|
|
Period Hours |
CURRENT PAY PERIOD HOURS WORKED |
|
|
Union Employee |
|
|
|
Address |
ADDRESS LINE 1 |
|
|
Address2 |
ADDRESS LINE 2 |
|
|
City |
CITY |
|
|
State |
STATE |
|
|
5 digit Zip |
ZIP |
|
|
Mobile Phone |
PHONE |
###-###-#### |
|
|
|
|
|
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 |
REHIRE DATE |
MM/DD/YYYY |
|
Pad |
|
Default to O |
