Milestone 4 - Production Data Uploads, Measure Calculations, and Final Validations
Creation date: 5/5/2023 3:57 PM
Updated: 5/16/2025 12:38 PM
Once you have completed all work within the Sandbox Portal, you will be ready to begin your final stretch of onboarding within the PIPE Production site. At this point, you will now be working with live data that will be used for official measure calculations. It is crucial that all tasks are properly completed to avoid unnecessary errors.
Tasks
- Medical Group Registration: Your medical group will need to confirm your registration that was migrated from DDS. Any registration changes necessary for data testing will be corrected at this stage, but most registration updates will be done when annual registration opens.
- Cross-mapping: If your medical group does not have standard codes for required medications and allergies, you will need to submit a cross-map file that links your internal codes to our value set. MNCM will then work with you to review the codes to determine eligibility for inclusion.
- Historical Data Upload 1: Your medical group will now upload the first of two necessary historical data sets to the PIPE Production system. This first set will include data for 2023 dates of service.
- Custom Measure Period: Your medical group will now create your first custom measure period. This will be for 2023 dates of service and used for test calculations.
- Calculation of Measure Results: Once the first historical data set has been uploaded without errors, you will now calculate preliminary test measure rates. MNCM will work with your team to compare these rates and measure populations to your recent 2023 submission results. Note: Depression test calculations will not be available until three full years of historical data set has been uploaded.
- Primary Source Verification 2 (PSV2): At this stage, your medical group will participate in measure-specific validation with MNCM to verify numerator compliance and denominator exclusion. This will operate similar to previous audits under DDS. If errors are identified, query adjustments may be made, and reimporting of data may be necessary. All adjustments will be re-validated by the MNCM team.
- Historical Data Upload 2: Once rates and populations have been verified based on the first historical data set, your medical group will now upload the rest of required historical data. This includes data from 2020 through 2022 and 2024 to date.
Milestone-Specific Resources
- PIPE Clinic and Provider Registration - This article provides instructions for completing clinic and provider registration under PIPE, as well as a copy of the provider registration template.
- Registration Video Tutorial
- PIPE Medication & Allergy Cross-Map Template - This file provides a template for submitting requested cross-maps of internal medication or allergy codes for numerator compliance. Only medications and allergies that will be considered for numerator compliance need to be cross-mapped, and all codes must be reviewed by MNCM before they will be added.
- Cross Mapping Video Tutorial
- PIPE Data Submission Instructions - This document provides instructions for uploading and importing data files into the PIPE system. Please note: the Demographic file must always be fully imported before attempting to upload the other data files.
- File Upload and Import Video Tutorial
- PIPE Measure Calculation Instructions - This file details the creation of custom measure periods and how to conduct measure calculations. Please note: all cross-mapped codes must be submitted to MNCM for review prior to addition of any value set.
- PSV2 Video Overview
- Patient Level Validation Video Overview
Please contact your designated Project Coordinator or support@mncm.org for further questions.