DSM Lab Extract: Difference between revisions
Ttenbergen (talk | contribs) (Created page with "We are working on a way to get DSM to extract Labs for import to our DB. == Requesting data == Query ''Labs_requester'' in Centralized data front end.mdb will generate a...") |
Ttenbergen (talk | contribs) |
||
| (67 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
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 == | == 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. | ||
== Processing data | == Processing data received from DSM == | ||
See | |||
* [[Instructions for importing a batch of DSM Data]] | |||
* [[Lab identification in the DSM data]] | |||
== File Share == | == File Share == | ||
\\ad.wrha.mb.ca\wrha\REGION\Shared\CCMDB_Lab_Exchange | |||
== Contacts == | == DSM Contacts == | ||
* | * main contact: Alun Carter | ||
*Loretta Eng 9261406 Leng @ dsmanitoba.CA | * Loretta Eng 9261406 Leng @ dsmanitoba.CA | ||
== Related articles == | |||
{{Related Articles}} | |||
[[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
\\ad.wrha.mb.ca\wrha\REGION\Shared\CCMDB_Lab_Exchange
DSM Contacts
- main contact: Alun Carter
- Loretta Eng 9261406 Leng @ dsmanitoba.CA