L Labs Flowsheet table

From CCMDB Wiki
Revision as of 11:37, 30 October 2015 by TOstryzniuk (talk | contribs) (→Data Structure: minor)
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 - date line was entered, see #Meaning of lines
  • CBC
  • PT_PTT
  • Packed_Cells
  • FFP
  • Platelets
  • Albumin_25pct
  • Albumin_5pct
  • Creatinine
  • MG
  • SGPT_ALT
  • Troponin (TNT)
  • CXR
  • CT_Scan
  • Angio_coronary
  • Angio_others
  • US_Echo
  • US_Abd
  • Sputum_CS
  • Blood_CS
  • Urine_CS
  • ABG
  • MRI
  • Pentaspan -no longer collected
  • 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.

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)

Retrieved from "https://ccmdb.kuality.ca/index.php?title=L_Labs_Flowsheet_table&oldid=46099"