DSM data testing: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m cat
m Text replacement - "[[Category: " to "[[Category:"
 
(8 intermediate revisions by the same user not shown)
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.
# open module DSM_Processor
# change public const path if necessary
# run Sub DSM_Data_prepper


# run query 1_requester_maker to populate Labs_requester; too slow to do with query
== Queries/Tests ==
# run query 2_labs_reformed_maker to deal with date formats and to split out MRNs etc
We requested data for 463 critical care patients.


[[Category: DSM Labs Extract]]
=== 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]]

Latest revision as of 10:32, 30 July 2025

We are currently comparing our third batch of one month of test data from DSM.

Follow Instructions for importing a batch of DSM Data to start.

Queries/Tests

We requested data for 463 critical care patients.

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)