Labs data: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m cleanup
m link fix
Line 19: Line 19:


== Data Structure ==
== Data Structure ==
The data is stored in the [[L_Labs_Flowsheet]] and [[L Labs Flowsheet DSM table|L_Labs_Flowsheet_DSM]] tables in the [[CCMDB.mdb]] and in [[Centralized_data.mdb]].  
The data is stored in the [[L_Labs_Flowsheet]] and [[L_Labs_DSM table]] in the [[CCMDB.mdb]] and in [[Centralized_data.mdb]].  


== Legacy Data ==
== Legacy Data ==

Revision as of 13:18, 12 September 2017

The Critical Care program counts labs, blood products, x-rays, and other tests.

Data Acquisition

Manual Data Collector Collection

Collectors use instructions in Lab Collection Process to do this.

Extract from DSM

Some data is extracted from DSM. See Category:DSM Labs Extract for more info.

RIS/PACS extract

We have sporadically tried to organize Direct Data Access for RIS/PACS for medical imaging data.

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 and L_Labs_DSM table in the CCMDB.mdb and in Centralized_data.mdb.

Legacy Data

see Category:Legacy Labs