Schedule F File Layout.doc
DOC document 109 KB Posted
- Solicitation number
- RFP 171 240000001383 2
- Issued by
- Michigan
About this file
This is a file layout specification document for a Schedule F user file maintained by the Department of Management & Budget, specifically detailing the structure and data fields for a Long-Term Disability/Workers' Compensation Demographics File. The document, originally created on October 14, 2002, with revisions through June 30, 2020, outlines the fixed-format record structure for employee demographic and employment data stored on disk media (identifier ZH905D01) with a total file size of 2,605 characters per record. The file layout specifies 98 distinct data fields organized in CSV or fixed-format configuration, capturing comprehensive employee information including personal identifiers, employment history, compensation details, contact information, insurance data, and organizational classifications.
The file structure encompasses employee records containing Social Security numbers, employee IDs, names, demographic information, job classifications, employment dates, salary information, benefit service dates, supervisor relationships, work schedules, union codes, and termination dates. Key fields include active employee status indicators, exempt status designations, current base salary with wage basis indicators, health insurance identifiers, employee plan codes, department numbers, establishment codes, and enrollment dates for benefits programs. The layout accommodates multiple union code assignments and includes process level designations, work schedule specifications, and standard work schedule names. Data fields utilize numeric and alphanumeric formats with defined character lengths, supporting the administrative management of state employee records across multiple organizational units and benefit enrollment periods.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Hybrid Contract Terms.docx | DOCX document | |
| Schedule J LTD Enrollment Census.xlsx | XLSX spreadsheet | |
| IRS Publication 1075.pdf | ||
| 240000001383 LTD Questions Answers.pdf | ||
| Schedule D Service Level Agreements for Hybrid Purchases.docx | DOCX document | |
| Schedule G Section 2 Software Table.xlsx | XLSX spreadsheet | |
| Schedule C Insurance Requirements.docx | DOCX document | |
| Schedule B Pricing.xlsx | XLSX spreadsheet | |
| Schedule I Sample 5 year Claims Report.xlsx | XLSX spreadsheet | |
| Department of Treasury Safeguard Requirements of Confidential Tax Data 7.doc | DOC document | |
| Schedule H Service Availability Report.xlsx | XLSX spreadsheet | |
| Exhibit 7 Safeguarding Contract Language.pdf | ||
| Schedule E Data Security Requirements for Hybrid Purchases.docx | DOCX document | |
| Proposal Instructions Vendor Questions WorksheetREVISED.docx | DOCX document | |
| Non-disclosure-agreement.docx | DOCX document | |
| Schedule A Statement of WorkREVISED.docx | DOCX document |
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
Text version
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 .