4. 200000001275 - Schedule J - Flex Spend Enrollment File Description (ZB607D01).docx

37 KB Posted

Attached to
Flexible Spending Accounts
Solicitation number
RFP 171 200000001275 2
Issued by
Grand Traverse County, Lansing City, Michigan

About this file

Written by GovTribe AI ·

This is a file description document for the State of Michigan Department of Information Technology, Enterprise Application Services, Human Resources Management division, detailing the technical specifications for a Flexible Spending Account (FSA) enrollment file (ZB607D01). The document outlines the fixed-format structure and data requirements for processing flex spending enrollment records in CSV format on disk media, with a standard record size of 330 characters. The file accommodates three record types: a header record (Type 10) containing file metadata such as client identification and creation date; employee enrollment records (Type 20) capturing comprehensive employee information including personal details, address, hire date, employment status, and enrollment specifics; and a trailer record (Type 90) providing summary counts of total employee records and aggregate record counts.

The enrollment file supports both new hire (NE) and re-enrollment (RE) statuses and tracks critical payroll and deduction information including pay codes for medical care (GM01) and dependent care (GK01) benefits. Data fields include employee identifiers, demographic information, compensation amounts (annual and anticipated biweekly deduction amounts), plan effective dates, leave and reactive dates, plan stop dates, and employment status indicators. The file structure enables the state to process and manage employee flexible spending account elections, with fields designed to accommodate various employee circumstances such as termination codes, leave start dates, and country codes for comprehensive benefit administration and payroll integration.

View the file

Other files

File Type Posted
6. 200000001275 - Schedule L â¿¿ FSA Deduction Remittance File Description (ZR124).docx DOCX document
5. 200000001275 - Schedule K â¿¿ FBMC Adjudication File Description (ZB609D01).docx DOCX document
2. 200000001275 - Schedule A - Statement of Work - Flexible Spending Account 4-3-2020.docx DOCX document
8. 200000001275 - Contract Terms - Flexible Spending Account.docx DOCX document
7. 200000001275 - Schedule M - Sample Admin Fee Claims Invoice.xlsx XLSX spreadsheet
200000001275 - Bidder Questions & Responses - Flexible Spending Account.xlsx XLSX spreadsheet
9. 200000001275 - Schedule N - Health Savings Account (HSA) Questionnaire (Optional).docx DOCX document
200000001275 - Amendment 1 Information - Flexible Spending Account.docx DOCX document
1. 200000001275 - Proposal Instructions-CT-Vendor Questions - Flexible Spending Account - 4-3-2020.docx DOCX document
2. 200000001275 - Schedule A - Statement of Work - Flexible Spending Account.docx DOCX document
3. 200000001275 - Schedule B - Pricing - Flexible Spending Account.xlsx XLSX spreadsheet
1. 200000001275 - Proposal Instructions-CT-Vendor Questions - Flexible Spending Account.docx DOCX document
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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

date

PAGE

FILE DESCRIPTION
Rev 8/28/2007
4
USER FILE Name
RECORD
FLEX SPENDING ENROLLMENT
TRAILER RECORD TYPE 90
DEPARTMENT
OFFICE
DIVISION
DEPT INFORMATION TECHNOLOGY
ENTERPRISE APPLICATION SERVICES
HRMN
File Identifier
file MEDIA
RECORD SIZE
ZB607D01
DISK
330
FILE ORGANIZATION
CSV
FIXED
OTHER
SEQUENCE

REMARKS

From
ThrU
DESCRIPTION
FORMAT
Length
1
2
RECORD TYPE 10
9(2)
2
3
52
CLIENT (“STATE OF MICHIGAN”)
X(50)
50
53
102
PROVIDER NAME – N/A
X(50)
50
103
106
CLIENT NUMBER (299)
9(4)
4
107
114
FILE TYPE (“ENROLL” or “ELIG”)
X(8)
8
115
122
CREATE DATE - CCYYMMDD
9(8)
8
123
330
FILLER
X(208)
208
SCHEDULE J - FLEX SPEND ENROLLMENT
date
PAGE
FILE DESCRIPTION
Rev. 08/28/2007
1
USER FILE Name
RECORD
FLEX SPENDING ENROLLMENT
HEADER RECORD TYPE 10
DEPARTMENT
OFFICE
DIVISION
DEPT INFORMATION TECHNOLOGY
ENTERPRISE APPLICATION SERVICES
HRMN
File Identifier
file MEDIA
RECORD SIZE
ZB607D01
DISK
330
FILE ORGANIZATION
CSV
FIXED
OTHER
SEQUENCE

REMARKS

From
ThrU
DESCRIPTION
FORMAT
Length
1
2
RECORD TYPE 20
9(2)
2
3
11
FICA NUMBER
9(9)
9
12
20
EMPLOYEE NUMBER
9(9)
9
21
50
LAST NAME
X(30)
30
51
54
SUFFIX
X(4)
4
55
69
FIRST NAME
X(15)
15
70
84
MIDDLE NAME or INITIAL
X(15)
15
85
114
ADDRESS 1
X(30)
30
115
144
ADDRESS 2
X(30)
30
145
174
ADDRESS 3
X(30)
30
175
204
ADDRESS 4
X(30)
30
205
222
CITY
X(18)
18
223
224
STATE
X(2)
2
225
234
POSTAL CODE
X(10)
10
235
242
HIRE DATE – CCYYMMDD
9(8)
8
243
243
GENDER

M=MALE, F=FEMALE

X(1)
1
244
244
MARITAL STATUS

M=MARRIED, S=SINGLE, W=WIDOWED,

D=DIVORCED, L=LEGALLY SEPARATED

X(1)
1
245
254
ANNUAL-AMT

(Total Amount from all Curr Yr records)

9(8)V99
10
255
262
WORK LOCATION

(PROCESS LEVEL)

X(8)
8
263
268
PAY CODE

GM01=MEDICAL CARE, GK01=DEPENDENT CARE

X(6)
6
267
276
PLAN EFFECTIVE DATE (CCYYMMDD)
9(8)
8
277
278
ENROLLMENT STATUS

(RE=Re-enroll, NE=New hire)

X(2)
2
279
280
PAYROLLS IN CALENDAR YEAR
9(2)
2
281
282
PAYROLLS WITH DEDUCTIONS
9(2)
2
283
284
EMPLOYEE STATUS

(See SOM status code list)

X(2)
2
285
292
LEAVE START DATE – CCYYMMDD
9(8)
8
293
300
REACTIVE DATE – CCYYMMDD
9(8)
8
301
308
PLAN STOP DATE – CCYYMMDD
9(8)
8
309
310
TERMINATION CODE – N/A see status
X(2)
2
311
318
BIRTH DATE
9(08)
8
319
328
ANTICIPATED BIWEEKLY AMT
9(8)V99
10
329
330
COUNTRY CODE
X(02)
2
date
PAGE
FILE DESCRIPTION
Rev. 8/28/2007
3
USER FILE Name
RECORD
FLEX SPENDING ENROLLMENT
EMPLOYEE RECORD TYPE 20
DEPARTMENT
OFFICE
DIVISION
DEPT INFORMATION TECHNOLOGY
ENTERPRISE APPLICATION SERVICES
HRMN
File Identifier
file MEDIA
RECORD SIZE
ZB607D01
DISK
330
FILE ORGANIZATION
CSV
FIXED
OTHER
SEQUENCE

REMARKS

From
ThrU
DESCRIPTION
FORMAT
Length
1
2
RECORD TYPE 90
9(2)
2
3
6
CLIENT NUMBER (299)
X(4)
4
7
14
TOTAL EMPLOYEE RECORDS

(record type 20 count)

9(8)
8
15
22
TOTAL RECORD COUNT

(header + employee + trailer)

9(8)
8
23
330
FILLER
X(308)
308

File details come from the government source that posted it. Updated .