ABG Data: Difference between revisions

(22 intermediate revisions by 2 users not shown)

Line 3:

* [[Blood gas, arterial]]

ABG Data is not available via [[DSM Lab Extract]] because it is done directly in hospital. ~~We need to find~~ out ~~if there are local databases~~ we ~~might~~ be able to get ~~dumps~~ from.

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

{{DA |

* Identified as something we should do to streamline data collection. I have made this page to document progress toward this import. }}

* 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

** Allan will revisit with Lab people whether this is obtainable now [[User:Ttenbergen|Ttenbergen]] 11:34, 2022 February 9 (CST)

*** Allan is negotiating inclusion of Labs data with Grace hospital as per [[Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2023#ICU Database Task Group Meeting – April 19, 2023]], leaving this flagged to ensure update. [[User:Ttenbergen|Ttenbergen]] 14:00, 2023 May 17 (CDT)

}}

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

* Allan provided likely list of data elements we would use; Tina has imported these into a test program to check against the last DSM export.

** Arterial pH 8020

** Venous pH 8034

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

* imported items suggested by Allan for last round of data that Pagasa requested as per [[Lab identification in the DSM data]]

* somewhat arbitrarily limited the comparison set to pts ''Accept_DtTm''>#2019-04-01#, [[Dispo_DtTm]]<=#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 doesn't make sense, but that's a different story...)

** there may be some discrepancy between these just due to the cut-offs of the DSM data

** 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; ex: STB_ACCU-39439, HSC_SICb-2228

**** arterial: 151 matching D_IDs

***** 37 had a higher count in DSM than in CCI; ex: HSC_MICa-2331, STB_MICU-32190

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

***** 3 had a higher count in CCI than in DSM; ex: HSC_MICd-2535, STB_E5d-1761

**** venous: 537 matching D_IDs

***** 115 had a higher count in DSM than in CCI; ex: STB_MICU-32190, HSC_MICd-2438

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

***** 17 had a higher count in CCI than in DSM; ex: STB_ACCU-39513, HSC_MICa-2421

* I have saved the data and program I used at \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB\DSM Labs Imports\DSM_ABGs,

** the main program is ABG_DSM_CCI comparer.accdb but tables would need to be re-connected to use it from that location

** I have exported two excel sheets with the compare values and D_IDs in case someone wants to do some spot checks into the differences

== Log ==

in newest first order:

* 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 15:

Line 46:

[[Category: Labs]]

[[Category:Labs]]

[[Category:Data Sources]]

@@ Line 3: / Line 3: @@
 * [[Blood gas, arterial]]
-ABG Data is not available via [[DSM Lab Extract]] because it is done directly in hospital. We need to find out if there are local databases we might be able to get dumps from.
+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
+{{DA |
-* Identified as something we should do to streamline data collection. I have made this page to document progress toward this import. }}
+* 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
+** Allan will revisit with Lab people whether this is obtainable now [[User:Ttenbergen|Ttenbergen]] 11:34, 2022 February 9 (CST)
+*** Allan is negotiating inclusion of Labs data with Grace hospital as per [[Task_Team_Meeting_-_Rolling_Agenda_and_Minutes_2023#ICU Database Task Group Meeting – April 19, 2023]], leaving this flagged to ensure update. [[User:Ttenbergen|Ttenbergen]] 14:00, 2023 May 17 (CDT)
+}}
+=== ABG-related content from DSM ===
+* Allan provided likely list of data elements we would use; Tina has imported these into a test program to check against the last DSM export.
+** Arterial pH	8020
+** Venous pH	8034
+====Tina's comparison====
+* imported items suggested by Allan for last round of data that Pagasa requested as per [[Lab identification in the DSM data]]
+* somewhat arbitrarily limited the comparison set to pts ''Accept_DtTm''>#2019-04-01#, [[Dispo_DtTm]]<=#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 doesn't make sense, but that's a different story...)
+** there may be some discrepancy between these just due to the cut-offs of the DSM data
+** 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; ex: STB_ACCU-39439, HSC_SICb-2228
+**** arterial: 151 matching D_IDs
+***** 37 had a higher count in DSM than in CCI; ex: HSC_MICa-2331, STB_MICU-32190
+***** 111 (73%) had the same count (119 (78%) had +/-1 count)
+***** 3 had a higher count in CCI than in DSM; ex: HSC_MICd-2535, STB_E5d-1761
+**** venous: 537 matching D_IDs
+***** 115 had a higher count in DSM than in CCI; ex: STB_MICU-32190, HSC_MICd-2438
+***** 405 (75%) had the same count (454 (84%) had +/-1 count)
+***** 17 had a higher count in CCI than in DSM; ex: STB_ACCU-39513, HSC_MICa-2421
+* I have saved the data and program I used at \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB\DSM Labs Imports\DSM_ABGs,
+** the main program is ABG_DSM_CCI comparer.accdb but tables would need to be re-connected to use it from that location
+** I have exported two excel sheets with the compare values and D_IDs in case someone wants to do some spot checks into the differences
 == Log ==
 in newest first order:
+* 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 15: / Line 46: @@
 {{Related Articles}}
-[[Category: Labs]]
+[[Category:Labs]]
+[[Category:Data Sources]]