
Page | 19
MPOG help desk (support@mpog.zendesk.com) Last Updated: 5/8/2025
Appendix B – Q&A Cerner Sites
One of our Active Cerner sites met with one of our interested Cerner sites and discussed the
process of joining MPOG. Identifying information has been removed. Even though this discussion
was between two Cerner sites, it can be used as a reference for other EHRs as well.
Q1: What was the initial challenge faced by the team with MPOG's data requirements?
A1: The team was overwhelmed by the 100 data fields and struggled to adjust their thinking
to handle MPOG's requirement for all 10,000 data fields. They found it challenging to
comprehend and integrate all the requested fields.
Q2: How does MPOG handle data from dierent institutions with varying definitions?
A2: MPOG uses concepts to standardize fields from dierent institutions and a mapping
process called ‘variable mapping’ to align dierent terminologies. For example,
"provider" might be "clinician."
Q3: What infrastructure setup was required for the project?
A3: The team needed to set up servers to store data locally, which took about six months.
The IT Support Person played a crucial role in pulling data from various databases and
writing the necessary code, supported by an analyst with clinical experience.
Q4: What role did the Clinical Data Analyst play in the project?
A4: The analyst, who was also a nurse, was instrumental in interpreting clinician needs into
technical requirements and assisting with the data mapping process.
Q5: How does MPOG ensure data validation before submission?
A5: MPOG requires local data validation before sending it to their central storage. They
provide a suite of applications for this validation process, which must be done monthly
by a dedicated person, such as a research nurse.
Q6: What is the process for determining which anesthesia and related data to extract?
A6: The team needs to understand MPOG's data requirements and decide what data to pull
from their systems through a back-and-forth communication process.
Q7: What qualifications are essential for a developer working on this project?
A7: The developer should have experience with ETL, scripting, and possibly Cerner. They will
need to rely heavily on IT for access and guidance.
Q8: How did the IT Support Person handle the technical aspects of the project?
A8: The IT Support Person handled the programming side, using Python and SQL, and relied
on support from the IT team to understand Cerner's schemas and navigate the data
model.
Q9: How important is IT support for the project's success?
A9: IT support is crucial for navigating Cerner's extensive and complex data model. The
developer will need guidance to find specific data fields and ensure accurate data
extraction.