Schedule F1- Data Feed-ORS.xls
XLS spreadsheet 29 KB Posted
- Attached to
- Health Insurance Database Management System
- Solicitation number
- RFP-171-250000003097-2
- Issued by
- Michigan
About this file
This file is a detailed record layout specification for a Request for Proposal (RFP) No. 250000003097 for a Health Insurance Database Management System for the Michigan Office of Retirement Services (ORS). The document provides a comprehensive field-level specification for an eligibility data feed, outlining 48 distinct data fields that cover employee and dependent information including social security numbers, demographic details, coverage tiers, plan codes, and premium information across medical, prescription, vision, and dental insurance categories.
The record layout specifies fixed-length character and float data types with precise starting positions and lengths for each field, suggesting a highly structured data exchange format. The specification includes personal identifiers like employee names, addresses, and status codes (Medicare, disability, student, COBRA), as well as detailed financial information such as vendor payments and member/plan premiums. The total record length is 511 characters, indicating a robust data capture mechanism for managing complex health insurance enrollment and eligibility tracking for the Michigan Office of Retirement Services.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 250000003097 - Health Insurance Database Management System RFP.docx | DOCX document | |
| Schedule F10- Data Feed- Vision.xlsx | XLSX spreadsheet | |
| Schedule F3- Data Feed-Medicare Medical.csv | CSV file | |
| Schedule F6- Data Feed-Hearing.xlsx | XLSX spreadsheet | |
| Schedule F7- Data Feed- Non Medicare Pharmacy.xlsx | XLSX spreadsheet | |
| Schedule F9- Data Feed-Dental.xls | XLS spreadsheet | |
| Schedule H Quarterly Vendor Reconciliation Report.xlsx | XLSX spreadsheet | |
| RFP 250000003097 - Bidder Question and Answer Response.xlsx | XLSX spreadsheet | |
| Schedule F4- Data Feed- Non-Medicare Lab.csv | CSV file | |
| Schedule G Service Availability.xlsx | XLSX spreadsheet | |
| Schedule I Sample Validation Report.xlsx | XLSX spreadsheet | |
| Schedule B - Healthcare Database.xlsx | XLSX spreadsheet | |
| Schedule F2-Data Feed Non-Medicare Medical.csv | CSV file | |
| Schedule F5- Data Feed-Medicare Lab.csv | CSV file | |
| Schedule F8- Data Feed- Medicare Pharmacy.xls | XLS spreadsheet | |
| Schedule J Software Table.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
Text version
Layout
| Request for Proposal No. 250000003097 | |||
| Health Insurance Database Management System for Michigan Office of Retirement Services | |||
| ORS Eligibility Feed - Record Layout | |||
| Field name | Type | Start | Length |
| EMPSSN | Character | 1 | 9 |
| PATDOB | Character | 10 | 10 |
| GENDER | Character | 20 | 1 |
| DEATHDT | Character | 21 | 10 |
| EMPREL | Character | 31 | 4 |
| DEPSSN | Character | 35 | 9 |
| EMPSTAT | Character | 44 | 1 |
| COVGTIERMED | Character | 45 | 6 |
| PLANCDMED | Character | 51 | 4 |
| COVGINDMED | Character | 55 | 1 |
| COVGTIERRX | Character | 56 | 6 |
| PLANCDRX | Character | 62 | 4 |
| COVGINDRX | Character | 66 | 1 |
| COVGTIERVIS | Character | 67 | 6 |
| PLANCDVIS | Character | 73 | 4 |
| COVGINDVIS | Character | 77 | 1 |
| COVGTIERDNTL | Character | 78 | 6 |
| PLANCDDNTL | Character | 84 | 4 |
| COVGINDDNTL | Character | 88 | 1 |
| ADDRESS | Character | 89 | 92 |
| CITY | Character | 181 | 28 |
| STATE | Character | 209 | 2 |
| ZIP | Character | 211 | 5 |
| COUNTRY | Character | 216 | 3 |
| ELIGMNTH | Character | 219 | 10 |
| MEDICARESTATCD | Character | 229 | 1 |
| DISSTATCD | Character | 230 | 1 |
| STUDENTSTATCD | Character | 231 | 1 |
| COBRASTATCD | Character | 232 | 1 |
| VNDRPYMTMED | Float | 233 | 10 |
| VNDRPYMTRX | Float | 243 | 10 |
| VNDRPYMTVIS | Float | 253 | 10 |
| VNDRPYMTDNTL | Float | 263 | 10 |
| MEMPREMMED | Float | 273 | 10 |
| MEMPREMRX | Float | 283 | 10 |
| MEMPREMVIS | Float | 293 | 10 |
| MEMPREMDNTL | Float | 303 | 10 |
| PLANPREMMED | Float | 313 | 10 |
| PLANPREMRX | Float | 323 | 10 |
| PLANPREMVIS | Float | 333 | 10 |
| PLANPREMDNTL | Float | 343 | 10 |
| FIRSTNAME | Character | 353 | 20 |
| LASTNAME | Character | 373 | 30 |
| PLANTYPE | Character | 403 | 4 |
| MEDFULLYINSIND | Character | 407 | 1 |
| RXFULLYINSIND | Character | 408 | 1 |
| DNTLFULLYINSIND | Character | 409 | 1 |
| VISFULLYINSIND | Character | 410 | 1 |
| FILLER | Character | 411 | 100 |
| RECTYPE | Character | 511 | 1 |
| Total Length: | 511 |
File details come from the government source that posted it. Updated .