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)