This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Sentinel Group file specifications. This transformation is used in a detamoov integration with Sentinel Group.
Source File | Destination file |
Standard 401k | Sentinel Group |
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]_RET.csv |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the Sentinel Group csv format is created correctly from the standard 401k format.
Sentinel Field Name |
Standard 401k Field Name |
Details |
Social Security Number |
SSN |
No Dashes |
Employee ID |
EMPLOYEE NUMBER |
|
Last Name |
LAST NAME |
|
First Name |
FIRST NAME |
|
Middle Initial |
MIDDLE NAME/INITIAL |
Take First Character |
Date Of Birth |
DOB |
MMDDYYYY |
Date Of Hire |
HIRE DATE |
MMDDYYYY |
Date of Termination |
TERMINATION DATE |
MMDDYYYY |
Date of Rehire |
REHIRE DATE |
MMDDYYYY |
Gender Code |
GENDER |
Male = M Female = F |
Employee Contribution -401(K) - Period |
CURRENT PAYROLL EMPLOYEE PREXTAX CONTRIBUTION |
|
Employee Contribution -Roth401(K) - Period |
CURRENT PAYROLL EMPLOYEE ROTH CONTRIBUTION |
|
Hours Worked - Period |
CURRENT PAY PERIOD HOURS WORKED |
|
Gross Compensation -Period |
CURRENT PAY PERIOD GROSS PAY |
|
Excluded Compensation - Period |
|
|
401-K Loan Repayment Amount 1 - Period |
401K LOAN 1 REPAYMENT |
|
401-K Loan Repayment Amount 2 - Period |
401K LOAN 2 REPAYMENT |
|
Address Line 1 |
ADDRESS LINE 1 |
Take first 30 Characters |
Address Line 2 |
ADDRESS LINE 2 |
|
City |
CITY |
|
State |
STATE |
Take first 2 Characters |
Zip |
ZIP |
Remove hyphen, numeric only |
Division/Department/PayrollAccount |
|
|
Hourly or Salary Employee |
|
|
Payroll Frequency |
PAY PERIOD START DATE AND PAY PERIOD END DATE |
Weekly = W Biweekly = B Semimonthly = S Monthly = M |
Payroll Check Date |
PAYROLL CHECK DATE |
MMDDYYYY |
Client Code |
COMPANY CODE |
|
Employee Classification |
|
|
Status Code |
EMPLOYMENT STATUS |
Active = A Terminated = T LOA = L Deceased = D Retired = R |
Email Address - Work |
|
|
Email Address - Other |
|
|
Phone Number - Mobile |
PHONE |
numeric only, if less than 10 digits send null |
Phone Number - Work |
PHONE |
numeric only, if less than 10 digits send null |
Other Contibution1 |
|
|
Other Contibution2 |
|
|
Other Contibution3 |
|
|