L Labs Flowsheet table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
TOstryzniuk (talk | contribs)
Line 25: Line 25:
* Urine_CS
* Urine_CS
* [[:Category: ABG | ABG]]
* [[:Category: ABG | ABG]]
* Pentaspan - '''no longer collected'''
* MRI
* MRI
* Pentaspan -'''no longer collected'''
* Voluven - '''no longer collected'''
* Voluven - '''no longer collected'''



Revision as of 11:37, 30 October 2015

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)