This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the CMC Interactive file specifications. This transformation is used in a detamoov integration with CMC Interactive.
| Source File | Destination file |
| Standard 401k | CMC Interactive |
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]_MMDDYYYYHHMMSS.csv |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the CMC Interactive Payroll Contribution csv format is created correctly from the standard 401k format.
|
CMC Field Name |
Standard 401k Field Name |
Details |
|
Plan ID |
PLAN ID |
|
|
Division |
|
Override if needed |
|
Pay End Date |
PAYROLL CHECK DATE |
YYYYMMDD |
|
Pay Frequency Code |
PAY PERIOD START DATE |
A = Annual |
|
Pay Frequency Sequence Number |
|
Will be provided by CMC |
|
Social Security Number |
SSN |
Format SSN w/dashes |
|
Name - Last |
FIRST NAME |
|
|
Name - First |
LAST NAME |
|
|
Date of Birth |
DOB |
YYYYMMDD |
|
Date of Hire - Original |
HIRE DATE |
YYYYMMDD |
|
Date of Rehire |
REHIRE DATE |
YYYYMMDD |
|
Termination Date |
TERMINATION DATE |
YYYYMMDD |
|
Gross Earnings |
CURRENT PAY PERIOD GROSS PAY |
|
|
Current Hours of Service |
CURRENT PAY PERIOD HOURS WORKED |
|
|
Pre Tax Deferrals |
CURRENT PAYROLL EMPLOYEE PRETAX |
|
|
Roth Deferrals |
CURRENT PAYROLL EMPLOYEE ROTH |
|
|
Loan Payments |
401K LOAN 1 REPAYMENT |
Sum |
|
Address - Street 1 |
ADDRESS LINE 1 |
|
|
Address - Street 2 |
ADDRESS LINE 2 |
|
|
Address - City |
CITY |
|
|
Address - State |
STATE |
|
|
Address - Postal Code |
ZIP |
Take first 5 |
|
Home Email |
|
|
|
Cell Phone |
PHONE |
|
