# Blue Cross Blue Shield Michigan

### Payerset Notes

**Table of Contents**

<https://mrf.payerset.com/bcbs-michigan>

### Compliance Scorecard

Overall Rating: <mark style="color:green;">**5/5**</mark>**&#x20;- Excellent**

<table data-view="cards"><thead><tr><th></th><th></th><th></th><th></th><th data-hidden data-card-cover data-type="files"></th></tr></thead><tbody><tr><td><strong>Table of Contents</strong></td><td><strong>★★★★★</strong></td><td><mark style="color:green;"><strong>5/5</strong></mark></td><td><ul><li>Are the MRFs kept up to date each month? </li><li>Is the Table of Contents link easily accessible?</li><li>Is the Table of Contents properly formatted?</li></ul></td><td></td></tr><tr><td><strong>File Accessibility</strong></td><td><strong>★★★★★</strong></td><td><mark style="color:green;"><strong>5/5</strong></mark></td><td><ul><li>Are there any barriers to downloading the files?</li><li>Do the Table of Contents links expire before publishing new links?</li></ul></td><td></td></tr><tr><td><strong>Data Quality</strong></td><td><strong>★★★★★</strong></td><td><mark style="color:green;"><strong>5/5</strong></mark></td><td><ul><li><p>What percentage of the MRFs are properly formatted and parseable</p><ul><li>5 Stars - 100%</li><li>4 Stars - 80%...</li></ul></li></ul></td><td></td></tr></tbody></table>

### Schema: BCBS\_MICHIGAN

#### **Data Validation**

| Record Type                   | Record Count  |
| ----------------------------- | ------------- |
| Negotiated Rates              | 21,262,028    |
| Nonstandard Codes             | 4,435         |
| Providers                     | 9,648,150,077 |
| Bundled Codes                 | 475,842,213   |
| Covered Services (Capitation) | 335,390       |

### Additional Observations

**Machine-Readable Price Transparency Files Review**

* **MRFs Up-to-Date:** ✔️ Yes, the MRFs are kept up to date each month.
* **Table of Contents Accessibility:** ✔️ The Table of Contents link is easily accessible.
* **Table of Contents Formatting:** ✔️ Yes, the Table of Contents is properly formatted.
* **File Download Barriers:** ✔️ No barriers to downloading the MRFs.
* **File Accessibility Percentage:** ✔️ 100% of the files are accessible - though there is one file with an unsupported extension, but we believe this is not a "real" MRF.

**Overall Assessment:** BCBS Michigan does a great job of posting these files each month. They duplicate provider data substantially, but that can be a result of interpretation of the CMS rules.

As of May 2024, there is a single file that has invalid JSON, but it appears to be an old file from April, specifically this file: <https://bcbsm.sapphiremrfhub.com/mrfs/202405/2024-04-08\\_BCBSMI\\_IH0000000015\\_ffs\\_in-network.json.gz\\_14016f858662e4a37ed266f4f29eb7a54ad44ae1>
