Schedule F4- Data Feed- Non-Medicare Lab.csv
CSV file 1 KB Posted
- Attached to
- Health Insurance Database Management System
- Solicitation number
- RFP-171-250000003097-2
- Issued by
- Michigan
About this file
This is a data feed specification file for a Request for Proposal (RFP No. 250000003097) involving the Michigan Office of Retirement Services, specifically for a Health Insurance Database Management System. The document outlines a detailed comma-delimited CSV file format for lab data from Quest, with comprehensive column layouts and specifications for data ingestion. The file defines 21 distinct columns with specific data types, lengths, and formatting requirements, including service dates, policy numbers, diagnostic codes, patient identifiers, and healthcare provider information.
The technical specification includes precise data attributes such as service dates (SVCDT), policy numbers, diagnostic codes (DX1), order details, reference data, procedure codes, and patient demographic information like social security numbers, group numbers, date of birth, and gender. Each column is meticulously defined with start positions, lengths, and ASCII formatting standards, suggesting a highly structured data exchange mechanism for healthcare and insurance database management. The file appears to be part of a larger system integration project for managing health insurance data for the Michigan Office of Retirement Services.
Text of this file
Request for Proposal No. 250000003097 ,,,,,,, Health Insurance Database Management System for the Michigan Office of Retirement Services,,,,,,, #Table Name, File Format,Comma Delimited,,,,, BCBSMI_QUEST_SINGLE_RECORD,,,,,,, # Description: Lab data from Quest,,,,,,, # Column Layouts:,,,,,,, # col name, alias, missing value, type, start, length, file missing value, format SVCDT,SVCDT,,Date,1,8,,ASCII MMDDYYYY DX1,DX1,,Character (18),2,18,,ASCII POLICYNUMBER,POLICYNUMBER,,Integer,3,20,,ASCII ABNORMCD,ABNORMCD,,Character (2),4,2,,ASCII ORDERID,ORDERID,,Character (16),5,16,,ASCII RESLIT,RESLIT,,Character (18),6,18,,ASCII RESNUM,RESNUM,,Integer,7,13,,ASCII REFRH,REFRH,,Float,8,13,,ASCII prec6 REFRL,REFRL,,Float,9,13,,ASCII prec6 RESUNITS,RESUNITS,,Integer,10,20,,ASCII ORDLOC,ORDLOC,,Character (10),11,10,,ASCII ORDNAME,ORDNAME,,Character (30),12,30,,ASCII UPIN,UPIN,,Character (6),13,6,,ASCII NPI,NPI,,Character (19),14,19,,ASCII PROCCD,PROCCD,,Character (5),15,5,,ASCII RESCDNAT,RESCDNAT,,Character (10),16,10,,ASCII RESCDLOC,RESCDLOC,,Character (10),17,10,,ASCII SSN,SSN,,Character (10),18,10,,ASCII GRPNUM,GRPNUM,,Character (4),19,4,,ASCII PATDOB,PATDOB,,Date,20,8,,ASCII MMDDYYYY GENDER,GENDER,,Character (1),21,1,,ASCII
Other files
| File | Type | Posted |
|---|---|---|
| Schedule F1- Data Feed-ORS.xls | XLS spreadsheet | |
| 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 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
File details come from the government source that posted it. Updated .