Standard 401k to CUNA Mutual
Jun 01, 2023
This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the CUNA Mutual file specifications. This transformation is used in a detamoov integration with CUNA Mutual.
| Source file | Destination file |
| Standard 401k | CUNA Mutual |
File Specifications
| File Type Generated | CSV |
|
Header Row(s) Generated |
Yes |
| Footer Row(s) Generated | No |
| End of Row Character | CRLF (Carriage Return Line Feed) |
| File Naming Generated | FTP__CM[Plan Number]__BPO_0001__[Plan Pay Frequency]--[Payroll Check Date in YYYY-MM-DD format]__1.csv |
Field Mappings
The table below details that specific field mapping and transformation rules applied to CUNA Mutual Payroll Contribution csv format is created correctly from the standard 401k format.
BODY
| CUNA Mutual Field Name | Standard 401k Field Name | Field size | Details |
| First Name | FIRST NAME | 30 | Use to Title Case |
| Last Name | LAST NAME | 30 | Use to Proper Case |
| SSN | SSN | 11 | Use Format SSN with Dashes |
| EE Deferral | CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION | 13 | ######.00 |
| EE Roth | CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION | 13 | ######.00 |
| EE After Tax | CURRENT PAYROLL EMPLOYEE POSTTAX CONTRIBUTION | 13 | ######.00 |
| ER Nonelective | CURRENT PAYROLLL NON-ELECTIVE CONTRIBUTION | 13 | ######.00 |
| ER Nonelective Additional | 13 | ######.00 | |
| Match | CURRENT PAYROLL EMPLOYEE MATCH CONTRIBUTION | 13 | ######.00 |
| SH MATCH | CURRENT PAYROLL SAFE HARBOR EMPLOYER CONTRIBUTION | 13 | ######.00 |
| QACA MATCH | 13 | ######.00 | |
| SH Nonelective | CURRENT PAYROLL SAFE HARBOR NON ELECTIVE CONTRIBUTION | 13 | ######.00 |
| QNEC | 13 | ######.00 | |
| QACA Nonelective | 13 | ######.00 | |
| QMAC | CURRENT PAYROLL QUALIFIED MATCHING CONTRIBUTION | 13 | ######.00 |
| Prevailing Wage | 13 | ######.00 | |
| 1st Loan No | 401k LOAN 1 ID | 5 | |
| 1st Loan Pmt | 401K LOAN 1 CONTRIBUTION | 13 | ######.00 |
| 2nd Loan No | 401K LOAN 2 ID | 5 | |
| 2nd Loan Pmt | 401k LOAN 2 CONTRIBUTION | 13 | ######.00 |
| Prior ER ID | 6 | ||
| Mandatory After Tax | 13 | ######.00 | |
| Money Purchase | 13 | ######.00 | |
| Address Line 1 | ADDRESS LINE 1 | 40 | |
| Address Line 2 | ADDRESS LINE 2 | 40 | |
| Address Line 3 | 40 | ||
| City | CITY | 28 | |
| State | STATE | 2 | |
| Zip Code | ZIP | 10 | Use the format Zip transformation rule |
| Foreign Address | 1 | ||
| Email Address | 50 | Should be the employee's work email address...we only get one so we'll map it | |
| Birth Date | DOB | 10 | MM/DD/YYYY |
| Hire Date | HIRE DATE | 10 | MM/DD/YYYY |
| Entry Date | 10 | MM/DD/YYYY | |
| Rehire Date | REHIRE DATE | 10 | MM/DD/YYYY |
| Status Change Date | 10 | MM/DD/YYYY | |
| Status Change Reason | 1 |
SERVICE SEPARTATED = 1 MILITARY LOA = 2 PARRENTAL LOA - 3 OTHER LOA = 4 SERVICE SEPARATED-DECEASED = 5 SERVICE SEPARATED-DISABILITY = 6 RETURN FROM LEAVE = 8 |
|
| Location | 4 | ||
| Period Hours | CURRRENT PAY PERIOD HOURS WORKED | 13 | ######.00 |
| Period Gross Comp | CURRENT PAY PERIOD GROSS PAY | 13 | ######.00 |
| Period Excluded Comp | 13 | ######.00 | |
| YTD Hours | YTD HOURS WORKED | 13 | ######.00 |
| YTD Gross Comp | YTD GROSS PAY | 13 | ######.00 |
| YTD Excluded Comp | 13 | ######.00 | |
| Business Group | 6 | ||
| PT Seasonal Temp | 1 |
FULL TIME = F PART TIME = P |
|
| Union or NRA | 5 | ||
| Excluded All Sources | 1 |
YES = Y No = N |
|
| Excluded EE Deferral | 1 |
YES=Y NO=N |
|
| Excluded Match | 1 |
YES=Y NO=N |
|
| Excluded NonMatch | 1 |
Yes = Y No = N |
