DSM Lab Extract: Difference between revisions
Ttenbergen (talk | contribs) m (updt) |
Ttenbergen (talk | contribs) m (→Log: log transferred from Task) |
||
Line 3: | Line 3: | ||
== Log == | == Log == | ||
*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) | *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) | ||
*since. | *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 | ||
** | *2014/Jul/21 We have a file share. Alun will hopefully have test data by end of week, or early next week | ||
*2014/Jul/17 Email from Chad Kitching re. share folder description | |||
*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) | *2014-06-12 emailed Loretta a sample request file. Ttenbergen 17:47, 2014 June 12 (CDT) | ||
== Requesting data == | == Requesting data == |
Revision as of 13:18, 2014 August 14
We are working on a way to get DSM to extract Labs for import to our DB.
Log
- 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)
- 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
- 2014/Jul/21 We have a file share. Alun will hopefully have test data by end of week, or early next week
- 2014/Jul/17 Email from Chad Kitching re. share folder description
- 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
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.
Data we will receive
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)
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)
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)
Requested from eHealth 2014-06-09, ticket 685698
Contacts
- Mark Curtis 9267014
- Loretta Eng 9261406 Leng @ dsmanitoba.CA
- data guy is Alun Carter