L Labs Flowsheet table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) No edit summary |
TOstryzniuk (talk | contribs) mNo 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]]. | ||
{{Discussion}} | |||
*oh......10 items should not have been on the HSC ICU view on this date? See [[Labs collected list]]. I am confused.[[User:TOstryzniuk|Trish Ostryzniuk]] 17:29, 2014 June 3 (CDT) | |||
== Data Structure == | == Data Structure == | ||
See the L_Labs_Flowsheet table for current state, but this is a snapshot as of 2014- | See the L_Labs_Flowsheet table for current state, but this is a snapshot as of 2014-Jan-30 | ||
*L_Lab_Flowsheet_ID | *L_Lab_Flowsheet_ID | ||
*Pat_ID | *Pat_ID | ||
Revision as of 16:29, 3 June 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.
- oh......10 items should not have been on the HSC ICU view on this date? See Labs collected list. I am confused.Trish Ostryzniuk 17:29, 2014 June 3 (CDT)
Data Structure
See the L_Labs_Flowsheet table for current state, but this is a snapshot as of 2014-Jan-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