DataDirect 2.2 User Guide
DataDirect Overview
•DataDirect is an application that allows users to create queries using data
submitted to MPOG for quality improvement (QI) and research purposes.
•It contains multiple filters that can help easily identify a cohort of patients and
access data following appropriate approvals.
•Researchers can use DataDirect to identify patient, case, and institution counts
for the cohort they are interested in studying.
•Quality Champions can generate a list of patients to audit outcomes or processes
of case. As an example, the Quality Champion for the site may be interested in
identifying patients who received reversal for neuromuscular blockade and
compare that to institution reintubation rates to identify if any correlation exists.
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 2
Gaining DataDirect Access
•DataDirect contains a limited dataset. Protected Health Information is excluded
except for dates of service.
•However, because DataDirect may contain information regarding hospital level
quality indicators (i.e. hospital mortality), approval from the appropriate hospital
department (i.e. Quality or Health Information Management) is required.
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 3
•To gain access to DataDirect, an
authorization form must be
completed. This process is automated
via signNow. The link to the form can
be found here: MPOG DataDirect
Affidavit
•Please complete the form and enter
your Authorized Hospital Leader’s
email where indicated. This signature
is required for all requests.
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 4
Creating a Query
When creating a query, there are three modes you can choose from.
•Cohort Only
•Generates a count to rapidly determine feasibility of a research or QI project. There is no ability to download data, and no
additional approval (e.g. Institutional Review Board) is required for access.
•Public dissemination of counts (e.g. journal publication, conference abstract, invited talk, social media post, etc.) is NOT
allowed. However, counts may be used as preliminary data for multicenter PCRC proposals, and/or shared solely with
authorized individuals (see MPOG DataDirect Affidavit).
•Quality Report
•Generates a cohort count, data query, and case list for a specific site. Although DataDirect will display final case counts,
institutions will remain anonymized.
•Research
•Allows for cohort identification across all sites and downloading sample data from your site only.
•Public dissemination of single-center study findings (e.g. journal publication, conference abstract, invited talk, social media
post, etc.) must be first approved by your Authorized Hospital Leader (see MPOG DataDirect Affidavit).
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 5
•Next, apply filters to define your
cohort and return only cases that
you're interested in. The
available filters are listed on the
left sidebar while the size of your
cohort will be dynamically
updated on the right.
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 9
Step 2: Filter Patient Population
•This section begins to narrow the
population of cases for your
project. Additionally, based on
the type of project and your role,
you may be able to choose cases
for your institution or for all
institutions in MPOG. Please
select the most relevant starting
population if differing from the
default.
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 10
Filter: Population
•Perioperative case characteristics
from the clinical documentation
and professional fee billing
systems. Some patient
characteristics (ASA status) may
change from one case to another
and reflect the information
known at the time of that case.
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 12
Filter: Cases
•MPOG derives diagnoses
information from professional
billing sources, discharge
diagnoses codes, or clinician
entered information in the health
record. In this section you will
primarily see Elixhauser
Comorbidities. However, MPOG
has also derived other diagnoses
from diagnoses codes or clinician
entered data.
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 13
Filter: Diagnoses
Use this section to narrow your cohort to the specific
diagnoses you are interested in.
•Begin typing the desired diagnosis name (or associated ICD-9 and ICD-10 codes)
into the Diagnosis Code field. ICD-10 codes were required as of October 1, 2015,
therefore historical data may only include ICD-9 codes.
•If you are interested in capturing diagnosis data for a case that occurred before this
date, please choose both ICD-9 and ICD-10 codes. Select the codes you desire, then
click Save changes
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 14
•MPOG concepts are the raw
data dictionary for MPOG.
Variables from the original
electronic health record are
mapped to concepts to help
standardize data across
participating sites. Please note
that due to variability in
documentation practices, sites
may use different MPOG
concepts to describe similar
phenomena.
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 16
Filter: Concepts
You may need to reference your local Variable Mapping for the
concepts that are used at your site to build an accurate QI report or
data query for your institution.
•Laboratory values in this screen
are curated lab phenotypes,
available for the most common
labs and use cases. These are
distinct from the Laboratory
Concepts that can be selected
from the Concept screen include
all MPOG laboratory data.
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 18
Filter: Laboratories
Edit Filters
•This allows you to rearrange the order in which filters are
applied to the cohort.
•Please note that individual filters are joined to one
another using “and” logic. Therefore, cases must meet
all filter criteria in sequential order to be included in the
cohort.
•To rearrange the filter order, click the Edit Filters button
in the right-side panel. A brief on-screen guide will pop-
up that details the functionality. This guide can also be
viewed via the Guide button within the Edit Filters
section.
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 20
Adding filter groups
•Users can also add filter groups to combine
individual filters using “or” logic from within the
Edit Filters screen.
•Cases meeting any of the criteria within a filter
group are included in the cohort.
•To add a filter group, click the Add a Filter Group
button at the bottom or drag and drop a filter
(using the symbol) next to another filter.
•Please note that any empty filter groups will be
ignored.
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 21
Individual Filters vs. Filter Groups
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 23
This query uses
individual filters
to combine
procedure text
and procedure
codes using
“and” logic →
cases need to
meet both filter
criteria to be
included
This query utilizes the
filter group to combine
procedure text and
procedure codes using
“or” logic → cases can
meet either filter
criteria to be included
•Now that you've chosen which
cases should be included, you will
need to define which data
elements should be returned in the
result set. This includes pre-
computed MPOG Phenotypes and
raw MPOG Concepts.
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 24
Step 3: Select Report Columns
More information about MPOG
Phenotypes is available here.
•Enter the password previously set to view the spreadsheet.
•A summary of the data, and characteristics of the data queried, are among the
tabs available in the Excel Spreadsheet.
•Due to row limits in Excel, results that exceed 1 million rows are split into
multiple numbered tabs.
•These results will need to be merged into a single file using a text editor to
have complete data.
Last Updated: 6/8/2023 Contact: support@mpog.zendesk.com 29
