L Labs Flowsheet table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) No edit summary |
Ttenbergen (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
The '''L_Labs_Flowsheet''' table contains the data we collect in the [[CCMDB.mdb]] and [[Centralized_data.mdb]] about the frequency at which labs are done in the ICU setting. Also see [[:Category:Labs]]. | The '''L_Labs_Flowsheet''' table contains the data we collect in the [[CCMDB.mdb]] and [[Centralized_data.mdb]] about the frequency at which labs are done in the ICU setting. Also see [[:Category:Labs]]. | ||
== Data Structure == | |||
See the L_Labs_Flowsheet table for current state, but this is a snapshot as of 2014-01-30 | |||
*L_Lab_Flowsheet_ID | |||
*Pat_ID | |||
*entry_dt | |||
*CBC | |||
*PT_PTT | |||
*Packed Cells | |||
*FFP | |||
*Platelets | |||
*Albumin_25pct | |||
*Albumin_5pct | |||
*Creatinine | |||
*MG | |||
*SGPT_ALT | |||
*Troponin | |||
*CXR | |||
*CT_Scan | |||
*Angio_Coronary | |||
*Angio_other | |||
*US_Echo | |||
*US_Abd | |||
*Sputum_CS | |||
*Blood_CS | |||
*Urine_CS | |||
*ABG | |||
*Pentaspan | |||
*MRI | |||
*Voluven | |||
== Legacy == | == Legacy == | ||
Revision as of 12:03, 30 January 2014
The L_Labs_Flowsheet table contains the data we collect in the CCMDB.mdb and Centralized_data.mdb about the frequency at which labs are done in the ICU setting. Also see Category:Labs.
Data Structure
See the L_Labs_Flowsheet table for current state, but this is a snapshot as of 2014-01-30
- L_Lab_Flowsheet_ID
- Pat_ID
- entry_dt
- CBC
- PT_PTT
- Packed Cells
- FFP
- Platelets
- Albumin_25pct
- Albumin_5pct
- Creatinine
- MG
- SGPT_ALT
- Troponin
- CXR
- CT_Scan
- Angio_Coronary
- Angio_other
- US_Echo
- US_Abd
- Sputum_CS
- Blood_CS
- Urine_CS
- ABG
- Pentaspan
- MRI
- Voluven
Legacy
- this replaced the L_Labs table