L Labs Flowsheet table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m moved to Labs - Legacy Article |
Ttenbergen (talk | contribs) m data structure |
||
| Line 1: | Line 1: | ||
The '''L_Labs_Flowsheet''' table | The '''L_Labs_Flowsheet''' table in the [[CCMDB.mdb]] and [[Centralized_data.mdb]] contains the data we collect as part of [[Lab Collection Process]]. See [[Labs collected list]] for a list. | ||
== Data Structure == | == Data Structure == | ||
[[ | * D_ID - link to [[L_Log]] | ||
* Entry_dt #NAME? | |||
* CBC | |||
* PT_PTT | |||
* Packed_Cells | |||
* FFP | |||
* Platelets | |||
* Albumin_25pct | |||
* Albumin_5pct | |||
* Creatinine | |||
* MG | |||
* SGPT_ALT | |||
* Troponin | |||
* CXR | |||
* CT_Scan | |||
* Angio_coronary | |||
* Angio_others | |||
* US_Echo | |||
* US_Abd | |||
* Sputum_CS | |||
* Blood_CS | |||
* Urine_CS | |||
* ABG | |||
* Pentaspan - '''no longer collected''' | |||
* MRI | |||
* Voluven - '''no longer collected''' | |||
== Legacy == | == Legacy == | ||
Revision as of 13:03, 16 April 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. See Labs collected list for a list.
Data Structure
- D_ID - link to L_Log
- Entry_dt #NAME?
- CBC
- PT_PTT
- Packed_Cells
- FFP
- Platelets
- Albumin_25pct
- Albumin_5pct
- Creatinine
- MG
- SGPT_ALT
- Troponin
- CXR
- CT_Scan
- Angio_coronary
- Angio_others
- US_Echo
- US_Abd
- Sputum_CS
- Blood_CS
- Urine_CS
- ABG
- Pentaspan - no longer collected
- MRI
- Voluven - no longer collected
Legacy
- this replaced the L_Labs table