Standard 401k to Sentry
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 Sentry file specifications. This transformation is used in a detamoov integration with Sentry.
| Source File | Destination file |
| Standard 401k | Sentry |
File Specifications
| File Type Generated | CSV |
| Header Row(s) Generated | Yes |
| Footer Row(s) Generated | No |
| End of Row Character | CRLF |
| File Naming Generated | DLFTTEN_FTP_[Plan Number - not K Number]_[K Number]-Pay[#-dependent on pay frequencies].csv.pgp |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the Sentry Payroll Contribution csv format is created correctly from the standard 401k format
BODY
| Sentry Field Name | Standard 401k Field Name | Field Size | Details |
| First Name | FIRST NAME | ||
| Middle Name | MIDDLE NAME/INITIAL | ||
| Last Name | LAST NAME | ||
| Gender | GENDER |
Male = M Female = F Unknown/Not Reported = U |
|
| SSN | SSN | ###-##-#### | |
| Address 1 | Address Line 1 | ||
| Address 2 | Address Line 2 | ||
| City | CITY | ||
| State | STATE | 2 character State code | |
| Zip | ZIP | ##### | |
| Birth Date | DOB | M/DD/YYYY | |
| Hire Date | HIRE DATE | M/DD/YYYY | |
| Rehire Date | REHIRE DATE | M/DD/YYYY | |
| Termination Date | TERMINATION DATE | M/DD/YYYY | |
| Check Date | PAYROLL CHECK DATE | M/DD/YYYY | |
| Payroll Begin Date | PAY PERIOD START DATE | M/DD/YYYY | |
| Payroll End Date | PAY PERIOD END DATE | M/DD/YYYYY | |
| Payroll Frequency | PAY PERIOD START DATE, PAY PERIOD END DATE |
WEEKLY = W BI-WEEKLY = B SEMI-MONTHLY = S MONTHLY = M |
|
| Gross Earnings | CURRENT PAY PERIOD GROSS PAY | ######.## | |
| YTD Earnings | YTD GROSS PAY | ######.## | |
| Hours | CURRENT PAY PERIOD HOURS WORKED | ######.## | |
| YTD Hours | YTD HOURS | ######.## | |
| Excluded Earnings | ######.## | ||
| YTD Excluded Earnings | ######.## | ||
| Employee Deferral | CURRENT PAYROLL EMPLOYEE PRETAX CONTRIBUTION | ######.## | |
| Employee Roth | CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION | #####.## | |
| Employee After Tax | CURRENT PAYROLL EMPLOYEE POSTTAX CONTRIBUTION | ######.## | |
| Loan Payments | 401k LOAN 1 REPAYMENT 401K LOAN 2 REPAYMENT | ######.## | |
| Loan Number | 401K LOAN ID | ||
| Employer Match | CURRENT PAYROLL EMPLOYER MATCH CONTRIBUTION | ######.## | |
| Safe Harbor Match | CURRENT PAYROLL SAFE HARBOR EMPLOYER MATCH | ######.## | |
| Qualified Matching Contribution | CURRENT PAYROLL QUALIFIED MATCHING CONTRIBUTION | ######.## | |
| Safe Harbor Non-Elective | CURRENT PAYROLL SAFE HARBOR NON-ELECTIVE | ######.## | |
| Qualified Non-Elective Contribution | ######.## | ||
| Profit Sharing | CURRENT PAYROLL NON-ELECTIVE CONTRIBUTION | ######.## | |
| Money Purchase | ######.## | ||
| Rollover | ######.## | ||
| Rollover Roth | ######.## | ||
| Plan ID | PLAN ID | ||
| Division |
