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 |
|
runAt |
|
Date file will be processed. |
|
foreignId |
|
Optional UID for employee |
|
firstName |
FIRST NAME |
|
|
middleName |
MIDDLE NAME/INITIAL |
|
|
lastName |
LAST NAME |
|
|
ssn |
SSN |
######### |
|
dob |
DOB |
YYYY-MM-DD |
|
emailAddress |
|
|
|
planCode |
ACCOUNT TYPE 1-5 |
Plan type tied to contribution |
|
eeAmount |
CURRENT PAYROLL EMPLOYEE CONTRIBUTION 1-5 |
Cannot be blank |
|
erAmount |
CURRENT PAYROLL EMPLOYER CONTRIBUTION 1-5 |
Cannot be blank |
|
contributionYear |
PAYROLL CHECK DATE |
Plan year of contribution |
|
payrollDate |
PAYROLL CHECK DATE |
YYYY-MM-DD |
|
contributionNotes |
|
255 character limit |