ABG Data: Difference between revisions

Line 4:

Initially we thought ABG Data is not available via [[DSM Lab Extract]] because it is done directly in hospital. Turns out it is fed into the DSM stream so we should be able to get it from there as BGAS.

{{DA | 1

* Identified as something we should do to streamline data collection. I have made this page to document progress toward this import. Blood gas data is in DSM listing; need to compare to see if we can use it }}

=== ABG-related content from DSM ===

Line 10:

Line 13:

** Venous pH 8034

====Tina's comparison====

* imported items suggested by Allan for last round of data that Pagasa requested.

* somewhat arbitrarily limited the comparison set to pts acceptDtTM>#2019-04-01#, dispo<=#2019-08-16# and vetted to exclude records that were not part of this import, and compared them to only "acquired" CCIs (there were a lot of "admit" ABGs which probably doensn't make sense, but that's a different story...)

** In this subset:

*** in DSM data, there were 635 D_IDs: 933 arterial, 2178 venous

*** in CCI data, there were 856 D_IDs: total px_count 817 arterial, 1964 venous

*** there were ''no'' D_IDs that were in CCI but not in DSM

*** there were 41 D_IDs that were in DSM but not in CCI

**** arterial: 151 mathing D_IDs

***** 37 had a higher count in DSM than in CCI

***** 111 (73%) had the same count (119 (78%) had +/-1 count)

***** 3 had a higher count in CCI than in DSM

**** venous: 537 matching D_IDs

***** 115 had a higher count in DSM than in CCI

***** 405 (75%) had the same count (454 (84%) had +/-1 count)

***** 17 had a higher count in CCI than in DSM

~~{{DA | 1~~

* Identified as something we should do to streamline data collection. I have made this page to document progress toward this import. Blood gas data is in DSM listing; need to compare to see if we can use it }}

== Log ==

in newest first order:

* Dec 4, 2019 - ~~Tina imported ABG-related content (~~see [[#~~ABG-related content from DSM~~]]~~) from DSM records to test~~.

* Dec 4, 2019 - see [[#Tina's comparison]].

* Nov 14, 2019 - Contacting Kim Webster; the hospitals do not have a DB, but should be available as BGAS from DSM; we need to contact out DSM contact; Tina to check if we already get that.

* Nov 5, 2019 - Discussed at [[Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2019#ICU Database Task Group Meeting – November 5, 2019 | Task]], this is now a priority since we need to streamline collection

@@ Line 4: / Line 4: @@
 Initially we thought ABG Data is not available via [[DSM Lab Extract]] because it is done directly in hospital. Turns out it is fed into the DSM stream so we should be able to get it from there as BGAS.
+{{DA | 1
+* Identified as something we should do to streamline data collection. I have made this page to document progress toward this import. Blood gas data is in DSM listing; need to compare to see if we can use it }}
 === ABG-related content from DSM ===
@@ Line 10: / Line 13: @@
 ** Venous pH	8034
+====Tina's comparison====
+* imported items suggested by Allan for last round of data that Pagasa requested.
+* somewhat arbitrarily limited the comparison set to pts acceptDtTM>#2019-04-01#, dispo<=#2019-08-16# and vetted to exclude records that were not part of this import, and compared them to only "acquired" CCIs (there were a lot of "admit" ABGs which probably doensn't make sense, but that's a different story...)
+** In this subset:
+*** in DSM data, there were 635 D_IDs: 933 arterial, 2178 venous
+*** in CCI data, there were 856 D_IDs: total px_count 817 arterial, 1964 venous
+*** there were ''no'' D_IDs that were in CCI but not in DSM
+*** there were 41 D_IDs that were in DSM but not in CCI
+**** arterial: 151 mathing D_IDs
+***** 37 had a higher count in DSM than in CCI
+***** 111 (73%) had the same count (119 (78%) had +/-1 count)
+***** 3 had a higher count in CCI than in DSM
+**** venous: 537 matching D_IDs
+***** 115 had a higher count in DSM than in CCI
+***** 405 (75%) had the same count (454 (84%) had +/-1 count)
+***** 17 had a higher count in CCI than in DSM
-{{DA | 1
-* Identified as something we should do to streamline data collection. I have made this page to document progress toward this import. Blood gas data is in DSM listing; need to compare to see if we can use it }}
 == Log ==
 in newest first order:
-* Dec 4, 2019 - Tina imported ABG-related content (see [[#ABG-related content from DSM]]) from DSM records to test.
+* Dec 4, 2019 - see [[#Tina's comparison]].
 * Nov 14, 2019 - Contacting Kim Webster; the hospitals do not have a DB, but should be available as BGAS from DSM; we need to contact out DSM contact; Tina to check if we already get that.
 * Nov 5, 2019 -  Discussed at [[Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2019#ICU Database Task Group Meeting – November 5, 2019 | Task]], this is now a priority since we need to streamline collection