This article describes the file transformation that has been created in detamoov to transform the standard 401k file format to the USICG Connect file specifications. This transformation is used in a detamoov integration with USICG.
|
Source File |
Destination file |
|
Standard 401k |
USICG |
File Specifications
| File Type Generated | CSV |
| Header Row(s) Generated | Yes |
| Footer Row(s) Generated | No |
| End of Row Character | CRLF |
| File Naming Generated |
detamoov_[Plan Id]_YYYYMMDDHHMMSS.csv |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the USICG csv format is created correctly from the standard 401k format.
|
USICG Field Name |
Standard 401k Field Name |
Details |
|
Last Name |
LAST NAME |
Title Case |
|
First Name |
FIRST NAME |
Title Case |
|
Middle Initial |
MIDDLE NAME/INITIAL |
Title Case |
|
Social Security Number |
SSN |
No Dashes |
|
Company Code |
COMPANY CODE |
|
|
Date of Birth |
DOB |
MM/DD/YYYY |
|
Date of Hire |
HIRE DATE |
MM/DD/YYYY |
|
Date of Participation |
|
MM/DD/YYYY |
|
Date of Termination |
TERMINATION DATE |
MM/DD/YYYY |
|
Date of Rehire |
REHIRE DATE |
MM/DD/YYYY |
|
Status Code |
EMPLOYMENT STATUS |
A= Active |
|
Payroll Frequency |
PAYROLL BEGIN DATE |
0= Weekly |
|
Ownership Percentage |
|
|
|
Officer Code |
|
Y = Officer |
|
Target Annual Compensation |
|
|
|
Pre Tax Deferral % |
|
|
|
Pre-Tax Deferral Amount |
CURRENT PAYROLL EMPLOYEE PRETAX |
|
|
Roth Deferral % |
|
|
|
Roth Contribution |
CURRENT PAYROLL EMPLOYEE ROTH |
|
|
Employer Match Contribution |
CURRENT PAYROLL EMPLOYER MATCH |
|
|
Employer Non-Elective Contribution |
CURRENT PAYROLL NON ELECTIVE |
|
|
PTD Plan Eligible Compensation* |
CURRENT PAY PERIOD GROSS PAY |
|
|
PTD Gross Compensation |
CURRENT PAY PERIOD GROSS PAY |
|
|
PTD Hours |
CURRENT PAY PERIOD HOURS WORKED |
|
|
YTD Pre-Tax Deferral |
|
|
|
YTD Roth Contribution |
|
|
|
YTD Match Contribution |
|
|
|
YTD Non-Elective Contribution |
|
|
|
YTD Hours |
YTD HOURS WORKED |
|
|
YTD Plan Eligible Compensation* |
YTD GROSS PAY |
|
|
YTD Gross Compensation |
YTD GROSS PAY |
|
|
Address 1 |
ADDRESS LINE 1 |
|
|
Address 2 |
ADDRESS LINE 2 |
|
|
City |
CITY |
|
|
ST |
STATE |
|
|
Zip Code |
ZIP |
|
|
Loan Repayment |
401K LOAN 1 REPAYMENT |
Combine multiple loans |
|
Phone Number |
PHONE |
|
|
Email Address |
|
|
