DSM Lab Extract: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (→‎ABGs: m)
Line 9: Line 9:
== Known Issues ==
== Known Issues ==
=== ABGs ===
=== ABGs ===
The ABGs will not be complete, are only entered at STB and used to be at HSC but flakey lately. More info to come. Ttenbergen 13:17, 2014 August 14 (CDT)
Arterial Blood Gases and Venous Blood Gases are done locally and not usually uploaded to DSM, so we will continue to collect them manually for now.
There was also discussion whether we want to include venous blood gasses.
 
=== Aliases ===
=== Aliases ===
There might be some inconsistencies in how the labs are re-linked to patients who arrive as Jon Doe or have aliases in PHIN or Chart for other reason. If we want to include all patients with Aliases, we will need to do something to reconcile with [[Alias ID collection]].
There might be some inconsistencies in how the labs are re-linked to patients who arrive as Jon Doe or have aliases in PHIN or Chart for other reason. If we want to include all patients with Aliases, we will need to do something to reconcile with [[Alias ID collection]].

Revision as of 16:23, 2017 June 21

The DSM Lab Extract is a set of data we receive from Diagnostic Services of Manitoba. It is requested and processed by DSM Labs Consistency check.accdb and stored in the L Labs Flowsheet DSM table. It is requested via Instructions for requesting a batch of data from DSM and imported via Instructions for importing a batch of DSM Data. See DSM data for more info on the data once imported.

Things we still want to implement/fix

Template:Potential Change

  • we will want to store Lactate eventually

Known Issues

ABGs

Arterial Blood Gases and Venous Blood Gases are done locally and not usually uploaded to DSM, so we will continue to collect them manually for now.

Aliases

There might be some inconsistencies in how the labs are re-linked to patients who arrive as Jon Doe or have aliases in PHIN or Chart for other reason. If we want to include all patients with Aliases, we will need to do something to reconcile with Alias ID collection.

Requesting data

A file is exported to #File Share, and we ask #DSM Contacts to provide a new extract. See Instructions for requesting a batch of data from DSM for details.

Actions by DSM

DSM will take our file and generate an output of all labs for those patients for the admission. They will return it to us via the file share.

Processing data received from DSM

See Instructions for importing a batch of DSM Data

File Share

\\ad.wrha.mb.ca\wrha\REGION\Shared\CCMDB_Lab_Exchange

DSM Contacts

  • main contact: Alun Carter
  • Loretta Eng 9261406 Leng @ dsmanitoba.CA