This article will describe the file transformation that has been created in detamoov to transform the standard deduction contribution file format to the Fidelity HSA Format file specifications. This transformation is used in a detamoov integration with Fidelity.
| Source File | Destination File |
| Standard Deduction Contribution | Fidelity HSA |
File Specifications
| File Type Generated | Fixed Length |
| Header Row(s) Generated | Only during Testing |
| Footer Row(s) Generated | No |
| End of Row Character | CRLF |
| File Naming Generated |
Test: FPRST.PAS.DTM1TXNS(+1) Production: FPRS.PAS.DTM1TXNS(+1) |
Field Mappings
The tables below details the specific field mapping and transformation rules applied to ensure the Fidelity HSA Contribution format is created correctly from the standard deduction contribution format.
Test Header:
| Fidelity HSA Field | Standard Deduction Contribution Field | Field Size | Field Start | Field End | Details |
| Test File Identifier | 7 | 1 | 7 | Set as 'TESTEDT' | |
| Filler | 73 | 8 | 80 | Space filled |
Record 19 - Contributions:
| Fidelity HSA Field | Standard Deduction Contribution Field | Field Size | Field Start | Field End | Details |
| Plan Number | Account Number | 5 | 1 | 5 | Fidelity Plan Number |
| Batch Group ID | 4 | 6 | 9 | ||
| Filler | 3 | 10 | 12 | ||
| Social Security Number | SSN | 11 | 13 | 23 | ###-##-#### |
| Filler | 1 | 24 | 24 | ||
| Reserved | 5 | 25 | 29 |
Default as '00000' |
|
| Record Identifier | 2 | 30 | 31 | Default as '19' | |
| Filler | 4 | 32 | 35 | ||
| Transaction Code | 3 | 36 | 38 |
Default as '220' |
|
| Filler | 2 | 39 | 40 | ||
| Source |
|
2 | 41 | 42 | 01 = Employee Basic 02 = Employee Catch-Up 03 = Employer Basic 04 = Employer Match 05 = Employer Incentive |
| Item Number | 2 | 43 | 44 | Default as '1' | |
| Filler | 1 | 45 | 45 | ||
| Amount |
Employee Basic = Current Payroll Employee Contribution Employee Catch Up = Current Payroll Employee Contribution 2 Employer Basic = Current Payroll Employer Contribution Employer Match = Current Payroll Employer Contribution 3 Employer Incentive = Current Payroll Employer Contribution 4 |
13 | 46 | 58 | |
| Filler | 4 | 59 | 62 | ||
| Tax Year | Payroll Check Date | 4 | 63 | 66 | Take YYYY from Check Date |
| Filler | 1 | 67 | 67 | ||
| Check Date | Payroll Check Date | 8 | 68 | 75 | YYYYMMDD |
| Reserved | 5 | 76 | 80 |
