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 .