Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

EMR Integration

Paid Plugin

This is a paid plugin. Please email contact@krishagni.com for more details


Goals - Why integrate with EMR?

  1. Improve productivity by reduced manual data entry
  2. Better data quality
  3. Powerful reporting (E.g. demographics, consents, surgical pathology reports, etc.)

Implementation Options

There are many ways OpenSpecimen can be integrated from EMR. 

  1. HL7 messages
  2. Nightly database dumps

Workflows

Adding a new participant

  1. Login to OpenSpecimen
  2. Enter an MRN
  3. OpenSpecimen looks-up EMR data and returns match.
  4. If no match found, error.
  5. If the match found, the user can review and confirm that the patient is correct.
  6. Once created, the details pulled from EMR cannot be edited in OpenSpecimen.

Editing a participant

  1. A participant is edited in EMR
  2. Information is sent to OpenSpecimen (via HL7 or nightly dump)
  3. OpenSpecimen will update its records for the updated information

HL7 based integration

Overview

This applies to the integration with any EMR like Epic, Cerner, Velos, etc which can send HL7 messages.

  1. EMR sends HL7 messages (ADT) to OpenSpecimen to add/edit patients on a preconfigured port

  2. OpenSpecimen processes the incoming messages, cleanses, and stores the resulting patient and visit records in the staging table.

  3. When an end-user does a search on MRN, OpenSpecimen searches the staging table and display the registration form with the prefilled patient information. When a match is not found, the registration form is blank/empty.

  4. The records from the staging table are purged after every 90 days. The retention period is configurable.

Messages Supported

Msg

Description

ADT_A01/ADT_A28

Add patient

ADT_A04/ADT_A08/ADT_A31

Edit patient

ADT_A40

Merge patient

Fields Supported

HL7 Field Code

OpenSpecimen Field Name

PID.3.1 (first rep)

eMPI

PID.3.1

MRN

PID.3.5

MRN Site

PID.5.1

Last name

PID.5.2

First name

PID.5.3

Middle name

PID.7

Date of birth

PID.8

Gender

PID.10 

Race

PID.19

SSN / UID

PID.22

Ethnicity

PID.29

Death date

PID.30

Vital Status

Nightly database export

  1. Every night, the EMR team provides a CSV or a database view/table with all the patient information.
  2. The schema for the table will be provided by OpenSpecimen.
  3. This table will be used as the "staging patient table" which will be used for lookup whenever a user enters MRN in the user interface.
Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com