Schedule F5- Data Feed-Medicare Lab.csv
CSV file 3 KB Posted
- Attached to
- Health Insurance Database Management System
- Solicitation number
- RFP-171-250000003097-2
- Issued by
- Michigan
About this file
This is a Request for Proposal (RFP No. 250000003097) for a Health Insurance Database Management System issued by the Michigan Office of Retirement Services, specifically detailing a data feed schedule for Medicare laboratory information. The file provides a comprehensive column layout for a CSV file named "BCBS_MI_Lab_Detail" with precise specifications for data capture, including 45 distinct fields that range from service dates and lab results to provider and patient demographic information.
The data feed appears designed to capture granular healthcare laboratory transaction details, with fields accommodating extensive medical and administrative data such as lab order identifiers, result values, reference ranges, provider details, patient information, and contract-related metadata. The structured format suggests a robust system for tracking Medicare laboratory interactions, with each column defined by specific character type, start position, and length, enabling precise data management and integration for the Michigan Office of Retirement Services' healthcare database system.
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, Fixed record length,,,,, BCBS_MI_Lab_Detail,,,,,,, # Description: BCBS MI MA Lab ,,,,,,, # Column Layouts:,,,,,,, # col name, alias, missing value, type, start, length, file missing value, format RECTYPE,RECTYPE,,Character (1),1,1,,ASCII LABNAMECD,LABNAMECD,,Character (20),2,20,,ASCII SVCDT,SVCDT,,Character (38),3,38,,ASCII DX1,DX1,,Character (20),4,20,,ASCII ABNORMALCD,ABNORMALCD,,Character (20),5,20,,ASCII LABORDERID,LABORDERID,,Character (38),6,38,,ASCII RESULTVALUE,RESULTVALUE,,Character (12),7,12,,ASCII RESULTTEXT,RESULTTEXT,,Character (80),8,80,,ASCII REFHIGH,REFHIGH,,Character (12),9,12,,ASCII REFLOW,REFLOW,,Character (12),10,12,,ASCII REFTEXT,REFTEXT,,Character (80),11,80,,ASCII RESULTCOMMENTS,RESULTCOMMENTS,,Character (200),12,200,,ASCII RESULTUNITS,RESULTUNITS,,Character (70),13,70,,ASCII LOINCCD,LOINCCD,,Character (20),14,20,,ASCII LOINCNAME,LOINCNAME,,Character (80),15,80,,ASCII LOCALLABCD,LOCALLABCD,,Character (20),16,20,,ASCII LOCALLABNAME,LOCALLABNAME,,Character (80),17,80,,ASCII PROVID,PROVID,,Character (80),18,80,,ASCII NPI,NPI,,Character (80),19,80,,ASCII ORDPROVNAME,ORDPROVNAME,,Character (80),20,80,,ASCII ORDACCTNAME,ORDACCTNAME,,Character (100),21,100,,ASCII ORDPROVADDR1,ORDPROVADDR1,,Character (100),22,100,,ASCII ORDPROVADDR2,ORDPROVADDR2,,Character (35),23,35,,ASCII ORDPROVCITY,ORDPROVCITY,,Character (20),24,20,,ASCII ORDPROVSTATE,ORDPROVSTATE,,Character (5),25,5,,ASCII ORDPROVZIP,ORDPROVZIP,,Character (20),26,20,,ASCII ORDPROVPHONE,ORDPROVPHONE,,Character (20),27,20,,ASCII CONTRACTNUM,CONTRACTNUM,,Character (20),28,20,,ASCII GROUPNUM,GROUPNUM,,Character (12),29,12,,ASCII GROUPSEGMENT,GROUPSEGMENT,,Character (12),30,12,,ASCII EMPSSN,EMPSSN,,Character (9),31,9,,ASCII SSN,SSN,,Character (9),32,9,,ASCII PATDOB,PATDOB,,Character (38),33,38,,ASCII GENDER,GENDER,,Character (20),34,20,,ASCII FIRSTNAME,FIRSTNAME,,Character (35),35,35,,ASCII LASTNAME,LASTNAME,,Character (35),36,35,,ASCII MIDNAME,MIDNAME,,Character (35),37,35,,ASCII PROCCD,PROCCD,,Character (20),38,20,,ASCII PROVNAME,PROVNAME,,Character (80),39,80,,ASCII PROVADDR1,PROVADDR1,,Character (100),40,100,,ASCII PROVADDR2,PROVADDR2,,Character (100),41,100,,ASCII PROVCITY,PROVCITY,,Character (38),42,38,,ASCII PROVSTATE,PROVSTATE,,Character (20),43,20,,ASCII PROVZIP,PROVZIP,,Character (5),44,5,,ASCII PROVNPI,PROVNPI,,Character (10),45,10,,ASCII
Other files
| File | Type | Posted |
|---|---|---|
| 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 | |
| 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 | |
| Schedule B - Healthcare Database.xlsx | XLSX spreadsheet | |
| Schedule F2-Data Feed Non-Medicare Medical.csv | CSV file | |
| Schedule F8- Data Feed- Medicare Pharmacy.xls | XLS spreadsheet | |
| Schedule J Software Table.xlsx | XLSX spreadsheet | |
| Schedule F1- Data Feed-ORS.xls | XLS 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 .