Standard 401k to Human Interest

Travis Viall

Dec 12, 2023

This article will describe the file transformation that has been created in detamoov to transform the standard 401k file format to the Human Interest Census and Payroll Format file specifications. This transformation is used in a detamoov integration with Human Interest.

Human Interest Census file

Source File	Destination file
Standard 401k	Human Interest Census

Census File Specifications

File Type Generated	CSV
Header Row(s) Generated	Yes
Footer Row(s) Generated	No
End of Row Character	CRLF (Carriage Return Line Feed)
File Naming Generated	[Plan ID]_[Company Name]_CENSUS_[Current Date in YYYY-MM-DD]_[HHmmss].csv

Census Field Mappings

The tables below details the specific field mapping and transformation rules applied to ensure the Human Interest Census .csv format is created correctly from the standard 401k format.

Field #	Human Interest Field Name	Standard 401k Field Name	Field Type	Details
Field #	Human Interest Field Name	Standard 401k Field Name	Field Type	Details
1	Employee ID	EMPLOYEE NUMBER	STRING
2	First Name	FIRST NAME	STRING
3	Last Name	LAST NAME	STRING
4	SSN	SSN	STRING	Format SSN with dashes
5	Gender	GENDER	STRING	Female, Male, Other
6	Compensation Unit		STRING
7	Annual Salary		NUMBER
8	Hourly Rate		NUMBER
9	Email	EMAIL	STRING
10	Email 2		STRING
11	Phone	PHONE	STRING	Format Phone with dashes
12	Address Line 1	ADDRESS LINE 1	STRING
13	Address Line 2	ADDRESS LINE 2	STRING
14	City	CITY	STRING
15	State	STATE	STRING
16	Zip Code	ZIP	NUMBER	Take first 5 chars
17	Birth Date	DOB	DATE	MM/DD/YYYY
18	Hire Date	HIRE DATE	DATE	MM/DD/YYYY
19	Previous Termination Date	TERMINATION DATE	DATE	MM/DD/YYYY
20	Rehire Date	REHIRE DATE	DATE	MM/DD/YYYY
21	Termination Date	TERMINATION DATE	DATE	MM/DD/YYYY
22	Employment Type		STRING

Human Interest Payroll File

Source File	Destination file
Standard 401k	Human Interest Payroll

Payroll File Specifications

File Type Generated	CSV
Header Row(s) Generated	Yes
Footer Row(s) Generated	No
End of Row Character	CRLF (Carriage Return Line Feed)
File Naming Generated	[Plan ID]_[Company Name]_PAYROLL_[Pay Date in YYYY-MM-DD]_[HHmmss].csv

Payroll Field Mappings

The tables below details the specific field mapping and transformation rules applied to ensure the Human Interest Payroll.csv format is created correctly from the standard 401k format.

Field #	Human Interest Payroll Field Name	Standard 401k Field Name	Field Type	Details
Field #	Human Interest Payroll Field Name	Standard 401k Field Name	Field Type	Details
1	Pay Date	PAYROLL CHECK DATE	STRING	MM/DD/YYYY
2	Employee ID	EMPLOYEE NUMBER	STRING
3	First Name	FIRST NAME	STRING
4	Last Name	LAST NAME	STRING
5	SSN	SSN	STRING	Format SSN with dashes
6	Gross Earnings	CURRENT PAY PERIOD GROSS PAY	NUMBER
7	Hours	CURRENT PAY PERIOD HOURS WORKED	NUMBER
8	Traditional 401(k) Contribution	CURRENT PAYROLL EMPLOYEE PRETAX	NUMBER
9	Roth 401(k) Contribution	CURRENT PAYROLL EMPLOYEE ROTH	NUMBER
10	401(k) Employer Contribution	CURRENT PAYROLL EMPLOYER MATCH OR CURRENT PAYROLL SH MATCH	NUMBER
11	401(k) Total Loan	401k LOAN REPAYMENT 1 AND 401k LOAN REPAYMENT 2	NUMBER	SUM fields

Tags