DSM Lab Extract

From CCMDB Wiki
Revision as of 17:06, 2014 June 12 by 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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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 list of patients we have encountered in <what cycle time?>.

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

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 on receipt

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

Requested from eHealth 2014-06-09, ticket 685698

Contacts

  • Mark Curtis 9267014
  • Loretta Eng 9261406 Leng @ dsmanitoba.CA
Retrieved from "https://ccmdb.kuality.ca/index.php?title=DSM_Lab_Extract&oldid=39129"