This article will describe the file transformation that has been created in detamoov to transform the Standard Deduction file format to the Optum Financial HSA/FSA Contributions file specifications. This transformation is used in a detamoov integration with Optum Financial.
| Source File | Destination file |
| Standard Deduction | Optum Financial HSA/FSA Contributions |
File Specifications
| File Type Generated | Fixed Length |
| Header Row(s) Generated | No |
| Footer Row(s) Generated | No |
| End of Row Character | CRLF |
| File Naming Generated |
Prod: cn_detamoov_[clientname]_YYYYMMDDHHMMSS.txt Test: test_cn_detamoov_[clientname]_YYYYMMDDHHMMSS.txt |
Field Mappings
The table below details the specific field mapping and transformation rules applied to ensure the Optum Financial 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.
|
Optum Field Name |
Standard Deduction Field Name |
Field Size |
Start |
End |
Details |
|
Account SSN |
SSN |
11 |
1 |
11 |
###-##-#### or |
|
Employee ID |
|
20 |
12 |
31 |
|
|
Pay Date |
PAYROLL CHECK DATE |
8 |
32 |
39 |
YYYYMMDD |
|
Billing Group Identifier |
PAYROLL START DATE |
30 |
40 |
69 |
Upper Case |
|
Enrollment Submitter ID |
|
20 |
70 |
89 |
Confirm with Optum |
|
Employer ID |
ACCOUNT NUMBER |
30 |
90 |
119 |
Upper Case |
|
Employer Offering ID |
ACCOUNT TYPE X |
30 |
120 |
149 |
Identifies plan type + plan year |
|
Contribution Amount |
CURRENT EMPLOYEE PAYROLL CONTRIBUTION X |
8 |
150 |
157 |
No Negative or Zero records |
|
Contribution Description |
|
30 |
185 |
187 |
Displayed alongside contribution |
|
Special Contribution Type Code |
|
5 |
188 |
192 |
|
|
Partner Employee ID |
|
30 |
193 |
222 |
Alternate for SSN |
|
Filler |
|
28 |
223 |
250 |
|
