Getting Started:
Import Manager Data Flow
3
Data Flow - Overview
Last Updated: 9/25/2026
Contact: support@mpog.zendesk.com
4
Import Manager Data Flow - Overview
• Your data travels from your Electronic Health Record (EHR) and your billing files
into MPOG Import Manager in five steps:
1. Extract – Files are generated by extracting data from the source system. These files are then placed into
a file share accessible by the MPOG import utility.
2. Import - Files are removed from the file share and inserted directly into the Import Manager database.
3. Consume
– Files stored within the Import Manager are parsed into tabular data and inserted into
staging tables. Additionally, metadata regarding variable usage is generated for later mapping.
4. Handoff– The tabular data is inserted into the designated MPOG MAS database.
5. Upload or Transfer – Using the transfer utility within the MPOG Application Suite, surgical cases are
uploaded to the MPOG central repository.
Contact: support@mpog.zendesk.com
Last Updated: 9/25/2026
6
File Pipeline – Step by Step
Last Updated: 9/25/2026
Contact: support@mpog.zendesk.com
7
Step 1: Extract
1. Files are generated by extracting data
from the source system (for example,
Epic or Cerner).
2. Extracted files are placed into a file
share so the import utility can access
them.
3. This process is completed by the site
technical person
Contact: support@mpog.zendesk.com
Last Updated: 9/25/2026
9
Step 3: Consume
• Files are parsed into tabular data and are
then inserted into “staging data tables”.
• The data are separated into the following 12
“tabs”:
• Administration Route
• Administration Type
• Admission Type
• Ethnicity
• Gender
• Lab Type
• Observation Type
• Observation Detail Type
• Procedure Service
• Race
• Staff Type
• Units of Measurement (Administration)
Contact: support@mpog.zendesk.com
Last Updated: 9/25/2026
12
Wrapping Up
Additional Considerations and a Summary of the Full Data Flow
Last Updated: 9/25/2026
Contact: support@mpog.zendesk.com
13
Additional Considerations
• Extract:
• Chronicles (Operational System): Anesthesia Billing and Hospital Billing Data
• Clarity (Analytical System): Clinical Data - EPIC
• Consume:
• Files that are consumed successfully will be visible in the variable mapping tool but may not be
seen in case viewer
• Most Consume errors are related to extract issues
• Some data issues can arise during Step 1 Extract: Pulling data from the source system.
• Errors found during Step 3 Consume are usually related to an issue with the extract.
• Other issues can arise during Step 4 Handoff: Moving the imported data from Import
Manager to the App Suite (MPOG Database)
Contact: support@mpog.zendesk.com
Last Updated: 9/25/2026
14
In Summary…
Summary of the full data flow: Clinical data is extracted to a file share, where billing files
also arrive. The file share is imported into Import Manager, which consumes files into
staging tables and supports variable mapping, location mapping and content sync. Data is
then handed off to the LOCAL MPOG database, used by Case Viewer and Diagnostics. After
PHI Scrub and Transfer, it is uploaded to the CENTRAL MPOG database, which powers the
Dashboard, Provider Contacts, MQUARK, the Measure Case Report Tool and Collation
Mapping.
Clinical Data
EXTRACT
Billing Files
File Share
IMPORT
Import
Manager
CONSUME
HANDOFF
Local MPOG
Database
UPLOAD
PHI Scrub
Transfer
Central
MPOG
Database
Contact: support@mpog.zendesk.com
Last Updated: 9/25/2026
