DSM Lab Extract: Difference between revisions

Line 1:

We are working on a way to get DSM to extract Labs for import to our DB.

== ~~Outstanding Issues ==~~

== Things we still want to implement/fix ==

~~=== additional labs ===~~

* we will want to store Lactate eventually

*we want ~~at least NA, K, Lactate but Allan Garland is consulting with colleagues~~ to ~~find out if we need additional~~

** Lactacte, NA and K are included with current output.

~~=== Culture and Sensitivity =~~==

~~Get from Group column in 2016-03 import; still testing Ttenbergen 16:29, 2016 September 29 (CDT)~~

~~Testing working out well. Pagasa did an audit and results were good with some exceptions we are now working on. Ttenbergen 17:29, 2016 October 6 (CDT)~~

~~====~~ we will ~~miss some ====~~

~~Some~~ store ~~the site as a "result" and it's free-form, so we may lose these. EG:~~

* fungal culture, site ETT, with C&S on same request#

== Known Issues ==

=== ABGs ===

The ABGs will not be complete, are only entered at STB and used to be at HSC but flakey lately. More info to come. Ttenbergen 13:17, 2014 August 14 (CDT)

There was also discussion whether we want to include venous blood gasses.

~~=== duplicate records ===~~

~~There were 1,865,570 records in the export.~~

~~There were 1,863,373 unique records.~~

~~2197 duplicates~~

~~Why the duplicates?~~

~~Need to confirm if this is still a problem. Ttenbergen 17:09, 2015 October 15 (CDT)~~

~~2012-03~~

~~There are 1685160 lines in table~~

~~There are 1684872 lines if I list only unique values.~~

~~288 diff - why?~~

== Requesting data ==

@@ Line 1: / Line 1: @@
 We are working on a way to get DSM to extract Labs for import to our DB.
-== Outstanding Issues ==
+== Things we still want to implement/fix ==
-=== additional labs ===
+* we will want to store Lactate eventually
-*we want at least NA, K, Lactate but Allan Garland is consulting with colleagues to find out if we need additional
-** Lactacte, NA and K are included with current output.
-=== Culture and Sensitivity ===
-Get from Group column in 2016-03 import; still testing Ttenbergen 16:29, 2016 September 29 (CDT)
-Testing working out well. Pagasa did an audit and results were good with some exceptions we are now working on. Ttenbergen 17:29, 2016 October 6 (CDT)
-==== we will miss some ====
-Some store the site as a "result" and it's free-form, so we may lose these. EG:
-* fungal culture, site ETT, with C&S on same request#
+== Known Issues ==
 === ABGs ===
 The ABGs will not be complete, are only entered at STB and used to be at HSC but flakey lately. More info to come. Ttenbergen 13:17, 2014 August 14 (CDT)
 There was also discussion whether we want to include venous blood gasses.
-=== duplicate records ===
-There were 1,865,570 records in the export.
-There were 1,863,373 unique records.
-duplicates
-Why the duplicates?
-Need to confirm if this is still a problem. Ttenbergen 17:09, 2015 October 15 (CDT)
--03
-There are 1685160 lines in table
-There are 1684872 lines if I list only unique values.
-diff - why?
 == Requesting data ==