Standard 401k to SS&C
Dec 08, 2023
This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the SS&C file specifications. This transformation is used in a detamoov integration with SS&C.
| Source File | Destination file |
| Standard 401k | SS&C |
File Specifications
| File Type Generated | CSV |
| Header Row(s) Generated | Yes (custom fixed length) |
| Footer Row(s) Generated | No |
| End of Row Character | CRLF |
| File Naming Generated |
DFI.DIDET01A.CARDIN.D[YYMMDD].T[hhmmss] |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the SS&C Payroll Contribution csv format is created correctly from the standard 401k format.
| SS&C Field Name | Standard 401k Field Name | Field Type | Details |
| Payroll Date | PAYROLL CHECK DATE | DATE | YYYYMMDD |
| SSN | SSN | STRING | FORMAT SSN, REMOVE DASH |
| Employee ID | EMPLOYEE NUMBER | STRING | |
| First Name | FIRST NAME | STRING | |
| Middle Name | MIDDLE NAME/INITIAL | STRING | |
| Last Name | LAST NAME | STRING | |
| Street 1 | ADDRESS LINE 1 | STRING | |
| Street 2 | ADDRESS LINE 2 | STRING | |
| City | CITY | STRING | |
| State/Country | STATE | STRING | |
| Zip Code | ZIP | STRING | FORMAT Zip Code, REMOVE DASH |
| Phone Domestic/Foreign | STRING | ||
| Phone Number | PHONE | STRING | ###-###-#### |
| Birth Date | DOB | DATE | YYYYMMDD |
| Marital Status | MARITAL STATUS | STRING | MARRIED = M SINGLE = S DIVORCED = D WIDOWED = W |
| Gender Code | GENDER | STRING | FEMALE = F MALE = M UNKNOWN = U N/A = Z |
| Employment Status | EMPLOYMENT STATUS | STRING | Active = A Terminated = T Disabled = D Deceased = C Retired = R Leave of Absence = L |
| Hire Date | HIRE DATE | DATE | YYYYMMDD |
| Employment End Date | TERMINATION DATE | DATE | YYYYMMDD |
| Employment End Reason | STRING | Disabled = D Terminated = T Deceased = E Retired = R |
|
| Leave Of Absence Begin Date | DATE | YYYYMMDD | |
| Leave Of Absence End Date | DATE | YYYYMMDD | |
| Location Code | STRING | May be required if plan has multiple. Plan Sponsor would need to provide these. | |
| Affiliate | STRING | May be required if plan has multiple. Plan Sponsor would need to provide these. | |
| Payroll Frequency | STRING | Weekly = W Biweekly = B Semi-monthly = S Monthly = M Quarterly = Q |
|
| Compensation Type Amount 1 | CURRENT PAY PERIOD GROSS PAY | NUMERIC | Round - Force 2 decimals |
| Compensation Type Amount 2 | YTD GROSS PAY | NUMERIC | Round - Force 2 decimals |
| Compensation Type Amount 3 | NUMERIC | ||
| Compensation Type Amount 4 | NUMERIC | ||
| Compensation Type Amount 5 | NUMERIC | ||
| Hours Amount 1 | CURRENT PAY PERIOD HOURS WORKED | NUMERIC | Round - Force 2 decimals |
| Hours Amount 2 | YTD HOURS WORKED | NUMERIC | Round - Force 2 decimals |
| Job ID | STRING | ||
| Department Code | STRING | ||
| Department Number | STRING | ||
| Store Code | STRING | ||
| Division Code | STRING | ||
| Region Code | STRING | ||
| Payroll Site | STRING | ||
| Type of Work | STRING | ||
| Event Date | STRING | YYYYMMDD | |
| Non-Resident Alien | STRING | ||
| Contractor | STRING | ||
| Union Code | STRING | ||
| Payroll Type | STRING | ||
| Work Schedule Type | STRING | ||
| EE Is Inside Trader | STRING | ||
| EE is An Officer | STRING | ||
| EE Is An HCE | HIGHLY COMPENSATED EMPLOYEE | STRING | |
| EE Is A Key | KEY EMPLOYEE | STRING | |
| Contribution Amount 1 | Plan Specific | NUMERIC | Round - Force 2 decimals |
| Contribution Amount 2 | Plan Specific | NUMERIC | Round - Force 2 decimals |
| Contribution Amount 3 | Plan Specific | NUMERIC | Round - Force 2 decimals |
| Contribution Amount 4 | Plan Specific | NUMERIC | Round - Force 2 decimals |
| Contribution Amount 5 | Plan Specific | NUMERIC | |
| Contribution Amount 6 | Plan Specific | NUMERIC | |
| Contribution Amount 7 | Plan Specific | NUMERIC | |
| Contribution Amount 8 | Plan Specific | NUMERIC | |
| Contribution Amount 9 | Plan Specific | NUMERIC | |
| Contribution Amount 10 | Plan Specific | NUMERIC | |
| Contribution Amount 11 | Plan Specific | NUMERIC | |
| Contribution Amount 12 | Plan Specific | NUMERIC | |
| Contribution Amount 13 | Plan Specific | NUMERIC | |
| Contribution Amount 14 | Plan Specific | NUMERIC | |
| Contribution Amount 15 | Plan Specific | NUMERIC | |
| Contribution Amount 16 | Plan Specific | NUMERIC | |
| Contribution Amount 17 | Plan Specific | NUMERIC | |
| Contribution Amount 18 | Plan Specific | NUMERIC | |
| Contribution Amount 19 | Plan Specific | NUMERIC | |
| Contribution Amount 20 | Plan Specific | NUMERIC | |
| Contribution Amount 21 | Plan Specific | NUMERIC | |
| Contribution Amount 22 | Plan Specific | NUMERIC | |
| Contribution Amount 23 | Plan Specific | NUMERIC | |
| Contribution Amount 24 | Plan Specific | NUMERIC | |
| Contribution Amount 25 | 401K LOAN 1 ID | NUMERIC | |
| Loan ID - 1 | 401K LOAN 1 REPAYMENT | NUMERIC | Force 2 decimals |
| Loan Amount - 1 | 401K LOAN 2 ID | NUMERIC | |
| Loan ID - 2 | 401K LOAN 2 REPAYMENT | NUMERIC | Force 2 decimals |
| Loan Amount - 2 | NUMERIC | ||
| Loan ID - 3 | NUMERIC | ||
| Loan Amount - 3 | NUMERIC | ||
| Loan ID - 4 | NUMERIC | ||
| Loan Amount - 4 | NUMERIC | ||
| Loan ID - 5 | NUMERIC | ||
| Loan Amount - 5 | NUMERIC | ||
| Loan ID - 6 | NUMERIC | ||
| Loan Amount - 6 | NUMERIC | ||
| Loan ID - 7 | NUMERIC | ||
| Loan Amount - 7 | NUMERIC | ||
| Loan ID - 8 | NUMERIC | ||
| Loan Amount - 8 | NUMERIC | ||
| Loan ID - 9 | NUMERIC | ||
| Loan Amount - 9 | NUMERIC | ||
| Loan ID - 10 | NUMERIC | ||
| Loan Amount - 10 | NUMERIC | ||
| Loan ID - 11 | NUMERIC | ||
| Loan Amount - 11 | NUMERIC | ||
| Loan ID - 12 | NUMERIC | ||
| Loan Amount - 12 | NUMERIC | ||
| Loan ID - 13 | NUMERIC | ||
| Loan Amount - 13 | NUMERIC | ||
| Loan ID - 14 | NUMERIC | ||
| Loan Amount - 14 | NUMERIC | ||
| Loan ID - 15 | NUMERIC | ||
| Loan Amount - 15 | NUMERIC | ||
| Loan ID - 16 | NUMERIC | ||
| Loan Amount - 16 | NUMERIC | ||
| Loan ID - 17 | NUMERIC | ||
| Loan Amount - 17 | NUMERIC | ||
| Loan ID - 18 | NUMERIC | ||
| Loan Amount - 18 | NUMERIC | ||
| Loan ID - 19 | NUMERIC | ||
| Loan Amount - 19 | NUMERIC | ||
| Loan ID - 20 | NUMERIC | ||
| Loan Amount - 20 | NUMERIC |
