Labs data: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
||
| Line 22: | Line 22: | ||
== Data Structure == | == Data Structure == | ||
The data is stored in the [[L_Labs_Flowsheet]], [[L_Labs_DSM table]] and the [[CCI]] tables in the [[CCMDB. | 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.mdb]]. | ||
== Legacy Data == | == Legacy Data == | ||
Revision as of 10:45, 2019 September 22
The Critical Care program counts labs, blood products, x-rays, and other tests.
Data Acquisition
Collection in CCI
See Converting Lab Counts to CCI.
Extract from DSM
Some data is extracted from DSM. See Category:DSM Labs Extract for more info.
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
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).
reporting
As per Statistician, Labs are not reported in any regular periodic quarterly or fiscal year reports.
Data Structure
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.mdb.