Labs data: Difference between revisions

Created page with "The Critical Care program counts labs, blood products, x-ays, and other tests. Collectors use instructions in Lab Collection Process to do this. At HSC labs (for Crit..."
 
m Text replacement - "[[Centralized_data.accdb]]" to "Centralized_data.accdb"
 
(18 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The [[Critical Care]] program counts labs, blood products, x-ays, and other tests. Collectors use instructions in [[Lab Collection Process]] to do this.
The [[Critical Care]] program counts labs, blood products, x-rays, and other tests.  


At HSC labs (for Critical Care and Medicine) are downloaded.  For more info see [[:Category:Lab download HSC | Lab downloading at HSC]].
== Data Acquisition ==
{{discussion}} is downloading still going on? Ttenbergen 10:51, 2014 January 30 (CST)
=== Collection in CCI ===
See [[Converting Lab Counts to CCI]].  


== x-ray / imaging ==
=== Extract from DSM ===
* Do we know if anyone is using the image data specifically? I am curious as this relates to [[RIS/PACS]]... Ttenbergen
Some data is extracted from DSM. See [[:Category:DSM Labs Extract]] for more info.
 
We are also looking into getting the [[ABG Data]].
 
 
=== Potential: RIS/PACS extract ===
We have sporadically tried to organize [[Direct Data Access for RIS/PACS]] for medical imaging data.  
 
=== Legacy: Manual Data Collector Collection ===
Collectors use instructions in [[Lab Collection Process]] to do this.


== Data use ==
== Data use ==
=== research ===
=== research ===
Used for research project only so far.  Requests are usually for specific lab test items:  Dr. Kumar (all lab data, if he using all, don't know), Dr. Manjit, Dr. Garland, Dr. Bell(Blood products).
Used for research project only so far.  Requests are usually for specific lab test items:  Dr. Kumar (all lab data, if he using all, don't know), Dr. Manjit, Dr. Garland, Dr. Bell(Blood products).
=== reporting ===
=== reporting ===
Labs are not reported in any regular periodic quarterly or fiscal year reports.[[User:TOstryzniuk|Trish Ostryzniuk]] 16:15, 2012 October 1 (CDT) as per [[Statistician]].
As per [[Statistician]], Labs are not reported in any regular periodic quarterly or fiscal year reports.


== Data Structure ==
== Data Structure ==
The data is stored in the [[L_Labs_Flowsheet]] table in the [[CCMDB.mdb]] and in [[Centralized_data.mdb]].  
The data is stored in the [[L_Labs_Flowsheet]], [[L_Labs_DSM table]] and the [[CCI]] tables in the [[CCMDB.accdb]] and in [[Centralized_data.accdb]].  


== Legacy Data ==
== Legacy Data ==
see [[Master_ICU_Database_Lab_List]]
see [[:Category:Legacy Labs]]
 


[[Category:Labs]]
[[Category:Labs | *]]