Schedule F File Layout.doc

109 KB Posted

Attached to
Long Terms Disability Insurance Administration Service
Solicitation number
RFP - 171 - 240000001383
Issued by
Ingham County, Lansing City, Michigan

About this file

Written by GovTribe AI ·

This document is a file layout for a Long-Term Disability (LTD) Demographics file related to a state and local contract opportunity in Michigan. The contract is for the administration of a LTD insurance program and involves the jurisdictions of Ingham County and the City of Lansing. The file layout describes the data fields and format for an employee demographics file that would be used as part of the LTD insurance enrollment and administration. Key details include employee information such as name, contact details, job details, hire date, salary, and union affiliation.

The contract opportunity also includes additional documents such as a non-disclosure agreement, a LTD enrollment census, a revised statement of work, and a revised proposal instructions worksheet. These documents provide further details on the scope of services, enrollment requirements, and proposal submission process for vendors interested in bidding on this LTD insurance administration contract.

View the file

Other files

File Type Posted
Exhibit 7 Safeguarding Contract Language.pdf PDF
Proposal Instructions Vendor Questions WorksheetREVISED.docx DOCX document
Schedule A Statement of WorkREVISED.docx DOCX document
Schedule B Pricing.xlsx XLSX spreadsheet
Schedule D Service Level Agreements for Hybrid Purchases.docx DOCX document
Hybrid Contract Terms.docx DOCX document
IRS Publication 1075.pdf PDF
Non-disclosure-agreement.docx DOCX document
Schedule E Data Security Requirements for Hybrid Purchases.docx DOCX document
Schedule G Section 2 Software Table.xlsx XLSX spreadsheet
Schedule J LTD Enrollment Census.xlsx XLSX spreadsheet
Department of Treasury Safeguard Requirements of Confidential Tax Data 7.doc DOC document
Schedule C Insurance Requirements.docx DOCX document
Schedule H Service Availability Report.xlsx XLSX spreadsheet
240000001383 LTD Questions Answers.pdf PDF
Schedule I Sample 5 year Claims Report.xlsx XLSX spreadsheet
Show all 16

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
10/14/2002

Rev 07/18/2005 Rev for 10X 2019 Rev Union Codes 6-30-2020

USER FILE Name
RECORD
LTD/WC DEMOGRAPHICS FILE
RECORD TYPE 1
DEPARTMENT
OFFICE
DIVISION
MANAGEMENT & BUDGET
MAIN
HRS (HRMN)
File Identifier
file MEDIA
RECORD SIZE
ZH905D01
DISK
2605

FILE ORGANIZATION

CSV

FIXED

OTHER

SEQUENCE

REMARKS

From
ThrU
DESCRIPTION
FORMAT
Length
1
9
SOCSEC
9(9)
9
10
29
EMPLOYEE ID
9(20)
20
30
69
LAST NAME
X(40)
40
70
109
FIRST NAME
X(40)
40
110
110
MIDDLE INITIAL
X(1)
1
111
130
GROUP ID (ESTABLISHMENT)
X(20)
20
131
131
GENDER
X(1)
1
132
191
JOB TITLE (JOB DESCRIPTION)
X(60)
60
192
231
JOB ID (JOB CODE)
X(40)
40
232
233
COMM MODE (05)
9(2)
2
234
241
BIRTHDATE (CCYYMMDD)
9(8)
8
242
341
ADDR1
X(100)
100
342
441
ADDR2
X(100)
100
442
541
ADDR3 & ADDR4
X(100)
100
581
CITY
X(40)
40
582
585
STATE
X(4)
4
586
605
POSTAL CODE
X(20)
20
606
609
COUNTRY CODE
X(4)
4
610
629
HOME PHONE
X(20)
20
630
649
HOME FAX (N/A)
X(20)
20
650
749
HOME EMAIL (N/A)
X(100)
100
750
769
WORK PHONE
X(20)
20
770
789
WORK FAX (N/A)
X(20)
20
790
889
WORK ADDR1
X(100)
100
890
989
WORK ADDR2 (N/A)
X(100)
100
990
1089
WORK ADDR3 (N/A)
X(100)
100
1090
1129
WORK CITY
X(40)
40
1130
1133
WORK STATE
X(4)
4
1134
1153
WORK ZIP
X(20)
20
1154
1157
WORK COUNTRY
X(4)
4
1158
1257
WORK EMAIL
X(100)
100
1258
1265
DATE HIRED
9(8)
8
1266
1273
ORIGINAL DATE HIRED (N/A)
9(8)
8
1274
1281
ADJ DATE HIRED
9(8)
8
1282
1288
MONTHS OF SERVICE (N/A)
X(7)
7
1289
1296
MONTHS OF SERVICE AS OF (N/A)
9(8)
8
1297
1304
STD BENEFIT SERVICE DATE (N/A)
9(8)
8
1305
1312
LTD BENEFIT SERVICE DATE (N/A)
9(8)
8
1313
1313
ACTIVE EMPLOYEE
X(1)
1
1314
1320
SICK LEAVE BALANCE
9(7)
7
1321
1321
EXEMPT STATUS (0 or 1)
9
1
1322
1333
CURRENT BASE SALARY
9(12)
12
1334
1335
CURRENT SALARY WAGE BASIS
X(2)
2
1336
1347
ADD SALARY AMOUNT (N/A)
9(10)V99
12
1348
1349
ADD SALARY PERIOD BASIS (N/A)
X(2)
2
1350
1358
SUPERVISOR SSN
9(9)
9
1359
1378
SUPERVISOR EMP ID
9(20)
20
1379
1387
#1CONTACT SSN (N/A)
X(9)
9
1388
1407
#1CONTACT EMP ID (N/A)
X(20)
20
1408
1416
#2CONTACT SSN (N/A)
X(9)
9
1417
1436
#2CONTACT EMP ID (N/A)
X(20)
20
1437
1443
HOURS WORKED (N/A)
9(7)
7
1444
1451
PAY PERIOD BEGIN DATE (CCYYMMDD)
9(8)
8
1452
1453
PAY PERIOD FREQUENCY (08)
9(2)
2
1454
1454
PAY PERIOD RECORD TYPE (N/A)
X
1
1455
1462
PAY PERIOD END DATE (CCYYMMDD)
9(8)
8
1463
1482
PASSWORD (N/A)
X(20)
20
1483
1484
ROLE NAME ID (01)
9(2)
2
1485
1504
HEALTH INSURANCE ID (N/A)
X(20)
20
1505
1505
ORCE INDICATOR (KEY EMPLOYEE (N/A))
X
1
1506
1506
VIP (N/A)
X
1
1507
1606
USER LOGON (N/A)
X(100)
100
1607
1608
MODE OF RECV DOC (05)
9(2)
2
1609
1858
EMPLOYEE WORK SCHEDULE (N/A)
X(250)
250
1859
1868
PROCESS LEVEL
X(10)
10
1869
1878
UNION CODE
X(10)
10
1879
1898
#3 UNION CODE (SPACES N/A)
X(20)
20
1899
1918
#4 UNION CODE (SPACES N/A)
X(20)
20
1919
1968
#5 UNION CODE (Y/N for PT-PI-INDICATOR)
X(50)
50
1969
2008
STANDARD WORK SCHEDULE NAME (N/A)
X(40)
40
2009
2016
TERMINATION DATE (CCYYMMDD)
9(8)
8
2017
2266
GROUP TYPE BREAKDOWN (N/A)
X(250)
250
2267
2516
GROUP ROLE DETAIL (N/A)
X(250)
250
2517
2520
EMPLOYEE PLAN CODE
X(4)
4
2521
2526
DEPARTMENT NUMBER
X(6)
6
2527
2527
MARITAL STATUS
X(1)
1
2528
2539
LOCATION NUMBER
X(12)
12
2540
2549
ESTABLISHMENT CODE
X(10)
10
2550
2579
ESTABLISHMENT DESCRIPTION
X(30)
30
2580
2581
EMPLOYEE PLAN TYPE
X(2)
2
2582
2589
ENROLLEE START DATE (CCYYMMDD)
9(8)
8
2590
2597
ENROLLMENT END DATE (CCYYMMDD)
9(8)
8
2598
2605
LTD ENROLLMNT DATE (CCYYMMDD)
9(08)
8

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