L Labs Flowsheet table: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) m →Data Structure: minor |
TOstryzniuk (talk | contribs) m →Data Structure: minor |
||
Line 18: | Line 18: | ||
* [[CXR]] | * [[CXR]] | ||
* CT_Scan | * CT_Scan | ||
* Angio_coronary | * [[Coronary Angiogram | Angio_coronary]] | ||
* Angio_others - see [[:Category: Angiogram]] for other types of angios collected | * Angio_others - see [[:Category: Angiogram]] for other types of angios collected | ||
* US_Echo '''[[Echocardiogram]]'' | * US_Echo '''[[Echocardiogram]]'' | ||
Line 26: | Line 26: | ||
* Urine_CS | * Urine_CS | ||
* [[:Category: ABG | ABG]] Arterial Blood Gas | * [[:Category: ABG | ABG]] Arterial Blood Gas | ||
* MRI | * MRI | ||
==No longer collected == | ==No longer collected == | ||
* Pentaspan | * Pentaspan |
Revision as of 12:00, 30 October 2015
The L_Labs_Flowsheet table in the CCMDB.mdb and Centralized_data.mdb contains the data we collect as part of Lab Collection Process. Also see Labs collected list for a list.
Data Structure
- D_ID - link to L_Log
- Entry_dt - date line was entered, see #Meaning of lines
- CBC
- PT_PTT See: Lab Collection Process for guidelines re: PT/PTT
- Packed_Cells
- FFP
- Platelets
- Albumin_25pct
- Albumin_5pct
- Creatinine
- MG
- SGPT_ALT
- Troponin (TNT)
- CXR
- CT_Scan
- Angio_coronary
- Angio_others - see Category: Angiogram for other types of angios collected
- US_Echo 'Echocardiogram
- US_Abd Abdominal ultrasound
- Sputum_CS - Sputum C+S
- Blood_CS - Blood C+S
- Urine_CS
- ABG Arterial Blood Gas
- MRI
No longer collected
- Pentaspan
- Voluven
Meaning of lines
Lines in this table give an incremental picture of how many labs were counted since last count for this patient. For a total count of labs for a patient see Query L_Labs_total.
Template:Discussion Does everyone count ABG from labs in EPR at their site or from paper in charts? Thank you. -Trish Ostryzniuk 12:35, 2015 October 30 (CDT)
HSC
- off EPR in labs
Grace
- manually from paper chart
Con
- manually from paper chart