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 Deduction to Lively HSA/FSA Contributions
Standard Deduction to Lively HSA/FSA Contributions
print icon

This article will describe the file transformation that has been created in detamoov to transform the Standard Deduction file format to the Lively HSA/FSA Contributions file specifications.  This transformation is used in a detamoov integration with Lively.

 

 Source File  Destination file
 Standard Deduction  Lively HSA/FSA Contributions

 

File Specifications

 

File Type Generated  CSV
Header Row(s) Generated    Yes
Footer Row(s) Generated  No
End of Row Character  CRLF
File Naming Generated

 [Company Name]_contributions_MMDDYY.csv   

 

Field Mappings

 

The table below details the specific field mapping and transformation rules applied to ensure the Lively HSA/FSA Contribution format is created correctly from the Standard Deduction format.  A sample of the Standard Deduction can be found attached to this article.

 

 

Lively Field Name

Standard Deduction Field Name

Details

companyId

ACCOUNT NUMBER

Lively provided company ID
Field override required if not in source data

runAt

 

Date file will be processed. 
If blank, will process day of upload

foreignId

 

Optional UID for employee

firstName

FIRST NAME

 

middleName

MIDDLE NAME/INITIAL

 

lastName

LAST NAME

 

ssn

SSN

#########

dob

DOB

YYYY-MM-DD

emailAddress

EMAIL

 

planCode

ACCOUNT TYPE 1-5

Plan type tied to contribution

eeAmount

CURRENT PAYROLL EMPLOYEE CONTRIBUTION 1-5

Cannot be blank
Negative amounts accepted
Set to 0 if null

erAmount

CURRENT PAYROLL EMPLOYER CONTRIBUTION 1-5

Cannot be blank
Negative amounts accepted
Set to 0 if null

contributionYear

PAYROLL CHECK DATE

Plan year of contribution
Take YYYY of Payroll Check Date

payrollDate

PAYROLL CHECK DATE

YYYY-MM-DD
Date contributions should be processed.
If blank, it will process immediately

contributionNotes

 

255 character limit

scroll to top icon