DSM data testing

From CCMDB Wiki
Jump to navigation Jump to search

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)