DSM data testing

currently in "DSM labs comparison" on Tina's desktop

1. open DSM_Labs_Consistency_check
2. open module DSM_Processor
3. change public const path if necessary
4. run Sub DSM_Data_prepper

1. run query 1_requester_maker to populate Labs_requester; too slow to do with query
2. run query 2_labs_reformed_maker to deal with date formats and to split out MRNs etc

Findings

We sent a list of patients for CC for one month, they sent use whom they had for the period.

We would not be able to find any tests in their data that we don't have, by definition of how we requested.

We requested 430 CC patients(rest med)

comparing number of patients

430 entries in requester, but some are duplicates: .

SELECT [1_requester_cc].D_ID, Count([1_requester_cc].D_ID) AS CountOfD_ID
FROM 1_requester_cc
GROUP BY [1_requester_cc].D_ID
HAVING (((Count([1_requester_cc].D_ID))>1))
ORDER BY Count([1_requester_cc].D_ID) DESC;

7 D_IDs show up twice in requester. Those patients have different instances.

Query 4_1_compare

• 13 - NO results
  • checked 3, there were labs in our data
  • confirmed that at least two have results in EPR
  • sent email to Alun Carter to see if he knows what's up
• 392 - results exist but not necessarily during stay
• 383 - have results during the stay (during column = -1)

(what did I mean by) No results for 40 of them.

comparing lab counts

6-2 lab count compare ONLY 423 ?! not 427?

6-3 pivot 430??

HSC lab import issue

Ran into problems with HSC labs being wrong after import, need to fix before continuing comparison. Have question out to Julie/Trish how to reconcile that... Ttenbergen 21:16, 2015 July 14 (CDT)

For next data request

• ask if they can include an Arrived time with the arrived date; expect differences if not. Ttenbergen 13:00, 2015 July 22 (CDT)