L Labs Flowsheet table

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