DSM data: Difference between revisions

(4 intermediate revisions by the same user not shown)

Line 1:

This ~~article~~ is about the data ~~in the~~ [[~~L_Labs_DSM table~~]] ~~and how it is aggregated from~~ the [[DSM Lab Extract]] ~~via~~ [[Instructions for importing a batch of DSM Data]] using [[DSM Labs Consistency check.accdb]].

This page is about the data elements we receive from DSM. We [[Instructions for requesting a batch of data from DSM|send them a request]], the provide us the [[DSM Lab Extract]], and we have an [[Instructions for importing a batch of DSM Data|import process]] that stores a subset of the data in the [[L_Labs_DSM table]] using [[DSM Labs Consistency check.accdb]].

The data in [[DSM Lab Extract]] contains one or more lines per ''any'' test performed for patients who are in our unit at any point in their stay~~. For~~ [[~~L_Labs_DSM table~~]] ~~we want a ''count'' of only the tests we decided to include (see~~ [[]]~~), and only~~ for the ~~period where they were on our unit~~.

The data in [[DSM Lab Extract]] contains one or more lines per ''any'' test performed for patients who are in our unit at any point in their stay, processed and filtered as per [[Lab identification in the DSM data]]. Our [[statistician]] can extract additional lab info from this as needed if we don't store it in general. We store results for the following tests.

~~== Date constraint ==~~

The [https://apps.sbgh.mb.ca/labmanual/test/findTestPrepare St. Boniface Lab Information Manual] contains documentation on the meaning of some of the results.

The ~~DSM dump includes Collected Date~~/~~Time, Arrived Date~~/~~Time and Test Arrived Date~~/~~Time~~. ~~I use CollectedDate if available, and ArrivedDate otherwise. This decision was based not so much~~ on ~~what would actually be~~ the ~~data we would want to use, but instead on which data was consistently available. Not all these columns are always filled~~.

*<code>[Arrive_DtTm]<=CDate(Nz([COLLECTEDDATE],[arriveddate]))+CDate(Nz([CollectedTime],[LabarrivedTime]))</code>

*<code>CDate(Nz([COLLECTEDDATE],[arriveddate]))+CDate(Nz([CollectedTime],[LabarrivedTime]))<=[Dispo_DtTm]</code>

== ~~Lab type constraint~~ ==

=== DSM results we store ===

~~The s_mapping_lab table in [[Instructions for importing a batch of DSM Data]] defines which~~ labs ~~will be counted~~ as ~~which tests.~~

====via labs====

~~On every run of [[Instructions for importing a batch of DSM Data]], there is a check to find out if any new labs are in the new data that are not in the table~~. ~~During testing, most times included a few new labs. For these new labs it would need to be decided if they are a type we collect before finishing the import~~.

* Creatinine as taken from Creatinine

* MG as taken from Magnesium

* SGPT (ALT) as taken from ALT

* Troponin as taken from hs Troponin T

* CBC as taken from HGB

* PT as taken from PT (seconds)

* PTT as taken from Par Thrombo Time

* INR as taken from INR

* Arterial pH as taken from Arterial pH

* Arterial CO2 as taken from Arterial CO2

* Arterial O2 as taken from Arterial O2

* Arterial Bic. as taken from Arterial Bic.

* Venous pH as taken from Venous pH

* Venous CO2 as taken from Venous CO2

* Venous O2 as taken from Venous O2

* Venous Bic as taken from Venous Bic

* Blood Gas K as taken from Blood Gas K

* Blood Gas Ca as taken from Blood Gas Ca

* Venous Lactate as taken from Venous Lactate

* INR as taken from INR

* Blood Gas Sodium as taken from Blood Gas Sodium

* Blood Gas Glucos as taken from Blood Gas Glucos

* Arterial Lactate as taken from Arterial Lactate

* Troponin as taken from Troponin I WB

* PTT as taken from 1:1 PTT Separate

* PTT as taken from 1:1 PTT Together

* PTT as taken from 1:4 PTT Separate

* PTT as taken from 1:4 PTT Together

* PTT as taken from 1:9 PTT Separate

* PTT as taken from 1:9 PTT Together

[[Category:DSM Labs Extract]]

====via lab groups====

* Urine_CS via Midstream Urine

* Urine_CS via Catheter urine

* Urine_CS via Misc. urine

* Sputum_CS via Sputum

* Sputum_CS via Endotracheal

* Blood_CS via Blood for AFB

* Blood_CS via Blood culture(1)

* Blood_CS via Blood culture(2)

* Blood_CS via Blood culture(3)

== Related articles ==

[[Category:DSM Labs Extract | *]]

@@ Line 1: / Line 1: @@
-This article is about the data in the [[L_Labs_DSM table]] and how it is aggregated from the [[DSM Lab Extract]] via [[Instructions for importing a batch of DSM Data]] using [[DSM Labs Consistency check.accdb]].
+This page is about the data elements we receive from DSM. We [[Instructions for requesting a batch of data from DSM|send them a request]], the provide us the [[DSM Lab Extract]], and we have an [[Instructions for importing a batch of DSM Data|import process]] that stores a subset of the data in the [[L_Labs_DSM table]] using [[DSM Labs Consistency check.accdb]].
-The data in [[DSM Lab Extract]] contains one or more lines per ''any'' test performed for patients who are in our unit at any point in their stay. For [[L_Labs_DSM table]] we want a ''count'' of only the tests we decided to include (see [[]]), and only for the period where they were on our unit.
+The data in [[DSM Lab Extract]] contains one or more lines per ''any'' test performed for patients who are in our unit at any point in their stay, processed and filtered as per [[Lab identification in the DSM data]]. Our [[statistician]] can extract additional lab info from this as needed if we don't store it in general. We store results for the following tests.
-== Date constraint ==
+The [https://apps.sbgh.mb.ca/labmanual/test/findTestPrepare St. Boniface Lab Information Manual] contains documentation on the meaning of some of the results.
-The DSM dump includes Collected Date/Time, Arrived Date/Time and Test Arrived Date/Time. I use CollectedDate if available, and ArrivedDate otherwise. This decision was based not so much on what would actually be the data we would want to use, but instead on which data was consistently available. Not all these columns are always filled.
-*<code>[Arrive_DtTm]<=CDate(Nz([COLLECTEDDATE],[arriveddate]))+CDate(Nz([CollectedTime],[LabarrivedTime]))</code>
-*<code>CDate(Nz([COLLECTEDDATE],[arriveddate]))+CDate(Nz([CollectedTime],[LabarrivedTime]))<=[Dispo_DtTm]</code>
-== Lab type constraint ==
+=== DSM results we store ===
-The s_mapping_lab table in [[Instructions for importing a batch of DSM Data]] defines which labs will be counted as which tests.
+====via labs====
-On every run of [[Instructions for importing a batch of DSM Data]], there is a check to find out if any new labs are in the new data that are not in the table. During testing, most times included a few new labs. For these new labs it would need to be decided if they are a type we collect before finishing the import.
+* Creatinine as taken from Creatinine
+* MG as taken from Magnesium
+* SGPT (ALT) as taken from ALT
+* Troponin as taken from hs Troponin T
+* CBC as taken from HGB
+* PT as taken from PT (seconds)
+* PTT as taken from Par Thrombo Time
+* INR as taken from INR
+* Arterial pH as taken from Arterial pH
+* Arterial CO2 as taken from Arterial CO2
+* Arterial O2 as taken from Arterial O2
+* Arterial Bic. as taken from Arterial Bic.
+* Venous pH as taken from Venous pH
+* Venous CO2 as taken from Venous CO2
+* Venous O2 as taken from Venous O2
+* Venous Bic as taken from Venous Bic
+* Blood Gas K as taken from Blood Gas K
+* Blood Gas Ca as taken from Blood Gas Ca
+* Venous Lactate as taken from Venous Lactate
+* INR as taken from INR
+* Blood Gas Sodium as taken from Blood Gas Sodium
+* Blood Gas Glucos as taken from Blood Gas Glucos
+* Arterial Lactate as taken from Arterial Lactate
+* Troponin as taken from Troponin I WB
+* PTT as taken from 1:1 PTT Separate
+* PTT as taken from 1:1 PTT Together
+* PTT as taken from 1:4 PTT Separate
+* PTT as taken from 1:4 PTT Together
+* PTT as taken from 1:9 PTT Separate
+* PTT as taken from 1:9 PTT Together
-[[Category:DSM Labs Extract]]
+====via lab groups====
+* Urine_CS via Midstream Urine
+* Urine_CS via Catheter urine
+* Urine_CS via Misc. urine
+* Sputum_CS via Sputum
+* Sputum_CS via Endotracheal
+* Blood_CS via Blood for AFB
+* Blood_CS via Blood culture(1)
+* Blood_CS via Blood culture(2)
+* Blood_CS via Blood culture(3)
+== Related articles ==
+{{Related Articles}}
+[[Category:DSM Labs Extract | *]]