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

• D_ID - link to L_Log
• Entry_dt - date line was entered, see #Meaning of lines
• 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

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.