6. 200000001275 - Schedule L â¿¿ FSA Deduction Remittance File Description (ZR124).docx
DOCX document 36 KB Posted
- Attached to
- Flexible Spending Accounts
- Solicitation number
- RFP 171 200000001275 2
- Issued by
- Grand Traverse County, Lansing City, Michigan
About this file
This is a technical file description document for the FSA Deduction Remittance File (ZR124), prepared by the Department of Management & Budget, Human Resources Management Division. The document outlines the specifications for a fixed-format data file that processes Flexible Spending Account (FSA) deductions for state employees. The file structure includes three record types: a header record containing paycheck dates, pay period information, file creation dates, company codes, vendor identification, and customer codes; detail records documenting individual employee deductions with employee numbers, Social Security numbers, names, coverage options, contract numbers, employee and state share amounts, total deduction amounts, plan types, and tax identification codes; and a trailer record summarizing total record counts and total dollar amounts. The file organization uses fixed-format fields on disk media with a standard record size of 169 bytes per line, with file names varying by vendor as defined in the AP10 system.
The document specifies precise field lengths and data formats for each data element within the FSA deduction remittance process, including numeric fields for amounts in currency format (CCYYMMDD for dates and S9(7)V99 for monetary values) and alphanumeric fields for employee and vendor information. This technical specification enables standardized data exchange between the state and contracting vendors responsible for FSA administration and deduction processing. The file description was dated October 10, 2005, and provides the foundational technical requirements for vendors submitting FSA deduction remittance information to the state.
View the file
Other files
Show all 12
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
date
PAGE
| FILE DESCRIPTION |
| 10/10/05 |
| 3 |
| USER FILE Name |
| RECORD |
| DEDUCTION REMITTANCE FILE |
| TRAILER |
| DEPARTMENT |
| OFFICE |
| DIVISION |
| MANAGEMENT & BUDGET |
| MAIN |
| HRS (HRMN) |
| File Identifier |
| file MEDIA |
| RECORD SIZE |
| ZR124Dxx |
| DISK |
| 169 |
| FILE ORGANIZATION |
| CSV |
| FIXED |
| OTHER |
| SEQUENCE |
REMARKS
File name varies with the Vendor. Last 2 characters of file name defined on AP10.
| From |
| ThrU |
| DESCRIPTION |
| FORMAT |
| Length |
| 1 |
| 1 |
| RECORD TYPE |
| X(1) “H” |
| 1 |
| 2 |
| 9 |
| PAYCHECK DATE |
| 9(8) CCYYMMDD |
| 8 |
| 10 |
| 11 |
| PP NO |
| 99 |
| 2 |
| 12 |
| 19 |
| PP START DATE |
| 9(8) CCYYMMDD |
| 8 |
| 20 |
| 27 |
| PP END DATE |
| 9(8) CCYYMMDD |
| 8 |
| 28 |
| 35 |
| FILE CREATION DATE |
| 9(8) CCYYMMDD |
| 8 |
| 36 |
| 39 |
| COMPANY |
| 9(4) |
| 4 |
| 40 |
| 48 |
| VENDOR |
| X(9) |
| 9 |
| 49 |
| 78 |
| VENDOR ADDR1 |
| X(30) |
| 30 |
| 79 |
| 98 |
| CUSTOMER CODE |
| X(20) |
| 20 |
| 99 |
| 103 |
| PROGRAM |
| X(5) value “ZR124” |
| 5 |
| 104 |
| 169 |
| FILLER – spaces |
| X(66) |
| 66 |
| Schedule L – FSA Deduction Remittance |
| date |
| PAGE |
| FILE DESCRIPTION |
| 10/10/05 |
| 1 |
| USER FILE Name |
| RECORD |
| DEDUCTION REMITTANCE FILE |
| HEADER |
| DEPARTMENT |
| OFFICE |
| DIVISION |
| MANAGEMENT & BUDGET |
| MAIN |
| HRS (HRMN) |
| File Identifier |
| file MEDIA |
| RECORD SIZE |
| ZR124Dxx |
| DISK |
| 169 |
| FILE ORGANIZATION |
| CSV |
| FIXED |
| OTHER |
| SEQUENCE |
REMARKS
File name varies with the Vendor. Last 2 characters of file name defined on AP10.
| From |
| ThrU |
| DESCRIPTION |
| FORMAT |
| Length |
| 1 |
| 1 |
| RECORD TYPE |
| X(1) “D” |
| 1 |
| 2 |
| 10 |
| EMPLOYEE |
| 9(9) |
| 9 |
| 11 |
| 19 |
| SSN |
| 9(9) |
| 9 |
| 20 |
| 49 |
| LAST-NAME |
| X(30) |
| 30 |
| 50 |
| 64 |
| FIRST-NAME |
| X(15) |
| 15 |
| 65 |
| 65 |
| MIDDLE-INIT |
| X |
| 1 |
| 66 |
| 69 |
| NAME-SUFFIX |
| X(4) |
| 4 |
| 70 |
| 99 |
| LAST-NAME-PRE |
| X(30) |
| 30 |
| 100 |
| 104 |
| PROCESS-LEVEL |
| X(5) |
| 5 |
| 105 |
| 108 |
| CODE |
| X(4) |
| 4 |
| 109 |
| 110 |
| COV-OPTION |
| 99 |
| 2 |
| 111 |
| 130 |
| CASE-CONTRACT-NUMBER |
| X(20) |
| 20 |
| 131 |
| 139 |
| EMPLOYEE-SHARE |
| S9(7)V99 |
| 9 |
| 140 |
| 148 |
| STATE-SHARE |
| S9(7)V99 |
| 9 |
| 149 |
| 157 |
| TOTAL-DED-AMT |
| S9(7)V99 |
| 9 |
| 158 |
| 159 |
| PLAN-TYPE |
| XX |
| 2 |
| 160 |
| 169 |
| TAX-ID-CODE |
| X(10) |
| 10 |
| date |
| PAGE |
| FILE DESCRIPTION |
| 10/10/05 |
| 2 |
| USER FILE Name |
| RECORD |
| DEDUCTION REMITTANCE FILE |
| DETAIL |
| DEPARTMENT |
| OFFICE |
| DIVISION |
| MANAGEMENT & BUDGET |
| MAIN |
| HRS (HRMN) |
| File Identifier |
| file MEDIA |
| RECORD SIZE |
| ZR124Dxx |
| DISK |
| 169 |
| FILE ORGANIZATION |
| CSV |
| FIXED |
| OTHER |
| SEQUENCE |
REMARKS
File name varies with the Vendor. Last 2 characters of file name defined on AP10.
| From |
| ThrU |
| DESCRIPTION |
| FORMAT |
| Length |
| 1 |
| 1 |
| RECORD TYPE |
| X(1) “T” |
| 1 |
| 2 |
| 11 |
| TOTAL RECORD COUNT |
| 9(10) |
| 10 |
| 12 |
| 24 |
| TOTAL DOLLAR AMOUNT |
| S9(11)V99 |
| 13 |
| 25 |
| 169 |
| FILLER – spaces |
| X(145) |
| 145 |
File details come from the government source that posted it. Updated .