ABG Data: Difference between revisions

(10 intermediate revisions by 2 users not shown)

Line 5:

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. Blood gas data is in DSM listing; need to compare to see if we can use it }}

* 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 ===

Line 14:

Line 17:

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

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

* 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 ~~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...)

* 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

Line 21:

Line 25:

*** 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 ~~mathing~~ D_IDs

**** arterial: 151 matching D_IDs

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

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

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

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

***** 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 ==

Line 39:

Line 46:

[[Category: Labs]]

[[Category:Labs]]

[[Category:Data Sources]]

@@ Line 5: / Line 5: @@
 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. Blood gas data is in DSM listing; need to compare to see if we can use it }}
+* 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 ===
@@ Line 14: / Line 17: @@
 ====Tina's comparison====
-* imported items suggested by Allan for last round of data that Pagasa requested.
+* 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 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...)
+* 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
@@ Line 21: / Line 25: @@
 *** 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 mathing D_IDs
+**** arterial: 151 matching D_IDs
-***** 37 had a higher count in DSM than in CCI
+***** 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
+***** 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
+***** 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
+***** 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 ==
@@ Line 39: / Line 46: @@
 {{Related Articles}}
-[[Category: Labs]]
+[[Category:Labs]]
 [[Category:Data Sources]]