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: . 7 are in requestor twice?!

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;

Query 4_1_compare

13 - NO results (checked 3, there were labs in our data) 392 - results exist but not during stay 383 - have results during the stay (during column = -1)

(how did I get the next two, and are they still correct with the corrected data) 392 - have results, but out of timeframe 383 - have results in timeframe 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)