DSM Lab Extract: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (→‎Log: log transferred from Task)
(62 intermediate revisions by 3 users not shown)
Line 1: Line 1:
We are working on a way to get DSM to extract Labs for import to our DB.
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_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.  


== Log ==
== Things we still want to implement/fix ==
*2014/Aug/14 phone call with Loretta to confirm what is needed. Requested early sample data so we can start our processing... Ttenbergen 13:17, 2014 August 14 (CDT)
None currently
*2014/Aug/07 submitted test data at Loretta’s request
 
*2014/Jul/31 emailed Loretta again, since no news from Alun; ooomsg says back Tue Aug 5
== Known Issues ==
*2014/Jul/21 We have a file share. Alun will hopefully have test data by end of week, or early next week
=== Aliases ===
*2014/Jul/17 Email from Chad Kitching re. share folder description
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]].
*2014-07-14 emailed Alun and Loretta re progress
*2014-06-16 talked with Loretta on Friday. She said Alun Carter is the data guy we will work with. She suggested a different format and requested a list of labs we want, which I gave her. Also emailed Alun to get this moving. However, he is on vacation for 3 weeks, will f/u when he is back
*2014-06-12 emailed Loretta a test extract;
*2014-06-12 emailed Loretta a sample request file. Ttenbergen 17:47, 2014 June 12 (CDT)


== Requesting data ==
== Requesting data ==
Query ''Labs_requester'' in [[Centralized data front end.mdb]] will generate a list of patients we have encountered in '''<what cycle time?>'''.
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.
 
The list includes:
*Hosp mrn
*Phin
*Admit date time
*Discharge date time
 
The file will need to be extracted to the [[#File Share]]. We could automate the process but it'll be manual for now.


== Actions by DSM ==
== 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.  
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.  


== Data we will receive ==
== Processing data received from DSM ==
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)
See
 
* [[Instructions for importing a batch of DSM Data]]
== Processing data on receipt ==
* [[Lab identification in the DSM data]]
Will need to work out this part... I will need an import mechanism, and we may end up changing the lab structure to make this "clean".Ttenbergen 17:06, 2014 June 12 (CDT)


== File Share ==
== File Share ==
2014-07-10 email exchange with Sergio Pardini who said that Citrix group needs to set up the share... asked him why since that has never been required before, no reply yet Ttenbergen 09:59, 2014 July 14 (CDT)
\\ad.wrha.mb.ca\wrha\REGION\Shared\CCMDB_Lab_Exchange


Requested from eHealth 2014-06-09, ticket 685698
== DSM Contacts ==
* main contact: Alun Carter
* Loretta Eng 9261406 Leng @ dsmanitoba.CA


== Contacts ==
== Related articles ==  
*Mark Curtis 9267014
{{Related Articles}}
*Loretta Eng 9261406 Leng @ dsmanitoba.CA
* data guy is Alun Carter




[[Category:Labs]]
[[Category: DSM Labs Extract]]
[[Category: Data Sources]]

Revision as of 17:35, 2019 December 9

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_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

None currently

Known Issues

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

File Share

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

DSM Contacts

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

Related articles

Related articles: