Data Linkages

(Data linkage is a method of bringing information from different sources together about the same person or entity to create a new, richer dataset.)

Department of Health Master Patient Index (DOHMPI)

DOHMPI is a secure identity resolution, data integration, and information sharing hub for the Utah Department of Health (UDOH). It provides the following services for several authorized programs, both inside and outside of UDOH:

Real-time Identity Resolution and Record Linkage: Using both probabilistic and deterministic algorithms, DOHMPI links identities across independently administered data systems.

Extract, Transform, and Load (ETL): DOHMPI loads data in both real-time and batch modes ensuring up-to-date identity linkage from source programs. It includes vocabulary transformations to ensure data consistency across heterogeneous data systems (e.g., state, gender code mappings, etc.)

Push and Pull Messaging: DOHMPI supports data queries and messaging between source and consumer data systems in both real-time and batch modes.

Data Notification: DOHMPI provides timely program-specific notifications to consumer systems (e.g., death notifications, duplicate identities, etc.)

Identity Linked Data Warehousing: DOHMPI simplifies the integration of multiple source systems with a data warehouse by using existing data connections. It provides identity data synchronization which ensures proper correlation of identity data in the data warehouse if linked identities in DOHMPI are updated. DOHMPI protects the privacy of source system identities by using ID to Pseudo ID mappings and limited data transforms, making the data research-ready.

Application Programming Interface (API): In addition to integrating with database connections or manual extracts, DOHMPI provides a secure API for use by both data sources and consumers. Typical use cases for the API include program-specific notifications and on-demand identity linkage to existing DOHMPI identities.

Data Sharing Hub: DOHMPI is like an airport hub for data integration and sharing for UDOH. This architecture reduces the cost and complexity associated with point-to-point data connections and integrations.

Data Informatics & Data Analytics Tools

(Tools that are used for data analysis and informatics in healthcare)

a) Cognos: IBM Cognos Business Intelligence is a web-based business analytics toolset that provides users with a single, self-service portal to access and produce reports, dashboards, and ad-hoc queries quickly and securely. The HIO manages Cognos Analytics for the Department of Health and provides services including the following: (i) extracting data from source systems; (ii) cleansing, aggregating, transforming, and preparing data for analysis; and (iii) creating interactive reports and dashboards for insights and discovery.

Cognos Analytics Restricted (CAR) is a secure instance of Cognos Analytics for creating dashboards and reports from either sensitive or non-sensitive data, requiring users to log in to view the dashboards and reports. Users can publish non-regulated, anonymous, public/aggregated content that can be embedded into a website and accessed by the general public in the Cognos Analytics Public (CAP) instance.

b) Redcap: REDCap (Research Electronic Data Capture) is a secure web application for building and managing online surveys and databases. Online surveys and databases could be designed and built very quickly, thanks to the intuitive user interface and workflow. The environment is completely secure with access and authentication managed by UMD(internal users) and APadmin(external users). The HIO manages REDCap for the Department of Health and provides consulting services to other bureaus and offices of the agency.

Using REDCap's stream-lined process for rapidly developing projects, users may create and design projects using: 1) the online method from a web browser (Online Designer); and/or 2) the offline method by constructing a 'data dictionary' template file in Microsoft Excel, which can be later uploaded into REDCap. Both surveys and databases -- or a combination of the two -- can be built using these methods. REDCap provides audit trails for tracking data manipulation and user activity, as well as automated export procedures for data downloads to Excel, PDF, and common statistical package data formats (SPSS, SAS, Stata, R). Also included are a built-in project calendar, a scheduling module, ad-hoc reporting tools, and advanced features, such as branching logic, file uploading (import tools), and calculated fields.

There are currently three instances of REDCap in production: a public instance with non-restricted data projects, a private instance with protected data projects, and a dedicated instance for COVID-19 projects.


(the ability of different systems and software applications to communicate and exchange data accurately, effectively, and consistently)

Health Data Exchange Standards: The trained informaticists at the HIO office provide a wide range of interoperability services to clients internally at UDOH, with the primary goal of optimizing their workflow and delivering cost-effective, innovative solutions using best practices and current industry standards. We specialize in health data exchange standards like the HL7 v2, v3 CDA, and FHIR. We have re-engineered information exchange processes, developed and deployed newer, more efficient workflows using healthcare industry acceptable standards and technology, including HL7 standards like v.2x and FHIR.

Public Health Infrastructure: (How the State Health Department shares data with Health Information Exchange (HIE) for timely alerts to the provider): The HIO office maintains the Gateway Server at UDOH, a single point of exchange to send and receive data between the UDOH systems and external partners. Using data integration tools like Mirth and Rhapsody and homegrown APIs, this server extracts data from source systems, transforms to the desired format, and routes files to the appropriate destination. Currently this server exchanges (i) information between Medicaid and UHIN; (ii) death certificates between Vital Records Office and Intermountain; and (iii) death notifications between the Vital Records Office and UHIN and Intermountain. We are developing APIs to exchange COVID-19 lab results and EMS records with UHIN.

Public Health Informatics research support: The HIO office collaborates with national partners like the National Center for Health Statistics (NCHS) at CDC, clinical partners and other jurisdictions to evaluate newer standards and technologies like the HL7 Fast Healthcare Interoperability Resources (FHIR) and the Substitutable Medical Applications and Reusable Technologies(SMART apps).