Standard Benefit Contribution to FloresHR HSA

Travis Viall

Apr 07, 2026

This article will describe the file transformation that has been created in detamoov to transform the standard benefit contribution file format to the FloresHR file specifications. This transformation is used in a detamoov integration with FloresHR. An example of the standard benefit contribution format can be found at the bottom of this article.

Source File	Destination file
Standard Benefit Contribution	FloresHR

File Specifications (Demographics and Enrollment)

File Type Generated	ACSII Pipe Delimited
Header Row(s) Generated	No
Footer Row(s) Generated	No
End of Row Character	CRLF
File Naming Generated	Test: TEST.[Group Employer ID].comboeligibility.MMDDYYYY Prod: [Group Employer ID].comboeligibility.MMDDYYY

File Specifications (Payroll Deposit)

File Type Generated	ASCII Pipe Delimited
Header Row(s) Generated	No
Footer Row(s) Generated	No
End of Row Character	CRLF
File Naming Generated	Test: TEST.[Group Employer ID].deposit.MMDDYYYY Prod: [Group Employer ID].deposit.MMDDYYYY

Field Mappings

The table below details the specific field mapping and transformation rules applied to ensure the FloresHR format is created correctly from the standard benefit contribution format.

Demographics

Field	FloresHR Field Name	Standard Benefit Field Name	Details
Field	FloresHR Field Name	Standard Benefit Field Name	Details
1	Record Type		Default to 'IB'
2	Employer ID	GROUP NUMBER	Flores provides value
3	Employee ID	SSN	Typically SSN No dashes
4	Birth Date	DOB	YYYYMMDD
5	SSN	SSN	No dashes
6	Last Name	LAST NAME
7	First Name	FIRST NAME
8	Employee Status	ENROLLMENT STATUS	1 = New 2 = Active 3 = Temporarily Inactive 5 = Terminated If Hire date within pay period, sent = 1
9	Eligibility Date	HIRE DATE	YYYYMMDD Date employee is eligible to elect benefits
10	Termination Date	TERMINATION DATE	YYYYMMDD Date employee is no longer eligible for benefits
11	Address Line 1	ADDRESS LINE 1
12	Address Line 2	ADDRESS LINE 2
13	City	CITY
14	State	STATE
15	Zip	ZIP	No Dashes
16	Country		Set to 'US'
17	Email	EMAIL
18	Mobile Number	PHONE	Numeric only
19	Alernate Phone Number
20	Shipping Address Line 1
21	Shipping Address Line 2
22	Shipping Address City
23	Shipping Address State
24	Shipping Address Zip
25	Shipping Address Country
26	Division
27	Class

Enrollment

Field	FloresHR Field Name	Standard Benefit Field Name	Details
Field	FloresHR Field Name	Standard Benefit Field Name	Details
1	Record ID		Default to 'IC'
2	Employer ID	GROUP NUMBER	Flores provides value
3	Plan ID	BENEFIT PLAN ID	Flores provides value
4	Account Type Code	BENEFIT TYPE	Flores provides value
5	Plan Start Date	BENEFIT BEGIN DATE	YYYYMMDD
6	Plan End Date	BENEFIT END DATE	YYYYMMDD
7	Employee ID	SSN	Typically SSN No dashes
8	Employee SSN	SSN	No dashes
9	Account Status	ENROLLMENT STATUS	2 = Active 3 = Temporarily Inactive 5 = Terminated
10	Coverage Effective Date	ELIGIBILITY DATE	YYYYMMDD
11	Coverage Termination Date	TERMINATION DATE	YYYYMMDD Blank if Active HSA - do not pass if employee ceases contributions but employer intends to continue coverage When date is passed, account holder will be charged directly for ongoing monthly admin fees
12	Employee Per Pay Period Election	CURRENT PAYROLL EMPLOYEE CONTRIBUTION	If no value, set to 0
13	Employee Annual Election Amount		If no value, set to 0
14	Employer Per Pay Period Election	CURRENT PAYROLL EMPLOYER CONTRIBUTION	If no value, set to 0
15	Employer Annual Election Amount		If no value, set to 0
16	Coverage Tier ID	COVERAGE TIER	Flores provides value - required for HSA ie - Employee, Family, Single, EE, EE1
17	Auto Deposit Calendar ID		Blank if providing an IH deposit file
18	Auto Enrollment Dependents		Default 0
19	Auto Deposit Last Allocation Date		Leave blank

Payroll Deposit

Field	FloresHR Field Name	Standard Benefit Field Name	Details
1	Record ID		Default to 'IH'
2	Employer ID	GROUP NUMBER	Flores provides value
3	Employee ID	SSN	Typically SSN No dashes
4	Plan ID	BENEFIT PLAN ID	Flores provides value
5	Account Type	BENEFIT TYPE	Flores provides value
6	Plan Start Date	BENEFIT BEGIN DATE	YYYYMMDD Flores provides value
7	Plan End Date	BENEFIT END DATE	YYYYMMDD Flores provides value
8	Deposit Type		1 = Payroll Deposit 2 = Prefunded
9	Effective Date	PAYROLL DATE	YYYYMMDD The date when the contributions are applied to EEs YTD contributions Required for Payroll Deposit Type
10	Employee Deposit Amount	CURRENT PAYROLL EMPLOYEE CONTIBUTION	If no value, set to 0
11	Employer Deposit Amount	CURRENT PAYROLL EMPLOYER CONTRIBUTION	If no value, set to 0

Tags

Attachments