DSM data testing: Difference between revisions

Retrieved from "https://ccmdb.kuality.ca/index.php?title=DSM_data_testing"

@@ Line 1: / Line 1: @@
-currently in "DSM labs comparison" on Tina's desktop
+We are currently comparing our third batch of one month of test data from DSM.
-# open DSM_Labs_Consistency_check
+Follow [[Instructions for importing a batch of DSM Data]] to start.
-# import data into table called Trial_export
+== Queries/Tests ==
+We requested data for 463 critical care patients.
-[[Category:Labs]]
+=== 4_1_compare ===
+A count per site of comparison between how many records we requested and how many we received at least some data back for.
+ Site	request_count	found_count
+ CON	26	25
+ GRA	36	36
+ HSC	142	137
+ OAK	32	29
+ STB	194	178
+ VIC	33	31
+=== 4-2_list admissions w nothing_reported_back ===
+A list of records for which we requested but did not receive labs. There were 27 out of 463, 5.8%.
+Emailed Trish/Gail/Pagasa to check a few to find out if legit or what's wrong. Ttenbergen 18:16, 2015 October 15 (CDT)
+=== 6_1_count_compare ===
+Comparison of what is in import and in CFE for the following:
+* CBC, PTT, Creatinine, magnesium, sgpt, troponin
+Dr Garland suggested these would be a good subset to compare.
+=== 6_3_pivot_CBC ===
+Comparison of accuracy for CBC across sites
+=== 6_3_pivot_PTT ===
+Comparison of accuracy for PTT across sites
+=== 6_4_outliers ===
+Listing of records where counts don't match.
+Emailed Trish/Gail/Pagasa to check a few to find out if legit or what's wrong. Ttenbergen 18:16, 2015 October 15 (CDT)
+[[Category:DSM Labs Extract]]