L Labs Flowsheet table

From CCMDB Wiki
Revision as of 13:03, 16 April 2015 by Ttenbergen (talk | contribs) (data structure)
Jump to navigation Jump to search

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 #NAME?
  • 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


Legacy

  • this replaced the L_Labs table