You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Transformations > Prebuilt File Transformations > Standard 401k to Sentinel Group
Standard 401k to Sentinel Group
print icon

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

 

Email Address - Other

EMAIL

 

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

 

 

 

scroll to top icon