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. Also see Labs collected list for a list.

Data Structure

• L_Lab_Flowsheet_ID - unique record ID
• D_ID / Pat_ID - link to L_Log
• Entry_dt - date line was entered, see #Meaning of lines
• CBC
• PT_PTT See: Lab Collection Process for guidelines re: PT/PTT
• Packed_Cells
• FFP
• Platelets
• Albumin_25pct
• Albumin_5pct
• Creatinine
• MG
• SGPT_ALT
• Troponin (TNT)
• CXR
• CT_Scan
• Angio_coronary
• Angio_others - see Category: Angiogram for other types of angios collected
• US_Echo 'Echocardiogram
• US_Abd Abdominal ultrasound
• Sputum_CS - Sputum C+S
• Blood_CS - Blood C+S
• Urine_CS
• ABG Arterial Blood Gas
• Venous blood gas
• Pentaspan - legacy
• MRI
• Voluven - legacy

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.

ABG question for collectors

Template:Discussion Does everyone count ABG from labs in EPR at their site or from paper in charts? Thank you. -Trish Ostryzniuk 12:35, 2015 October 30 (CDT)

Collection Method

• HSC: off EPR in labs
• Grace: manually from paper chart
• Con: manually from paper chart
• STB: EPR
• Oak: ???
• VIC: manually from paper chart. ABG's aren't entered into the EPR at this site.

Labs no longer collected

See: Legacy Labs