L Labs Flowsheet table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (minor)
(→‎Meaning of lines: ABC counts)
Line 35: Line 35:
{{Discussion}}
{{Discussion}}
Does everyone count ABG from labs in EPR at their site or from paper in charts? Thank you. -[[User:TOstryzniuk|Trish Ostryzniuk]] 12:35, 2015 October 30 (CDT)
Does everyone count ABG from labs in EPR at their site or from paper in charts? Thank you. -[[User:TOstryzniuk|Trish Ostryzniuk]] 12:35, 2015 October 30 (CDT)
==HSC==
*off EPR in labs
==Grace==
*manually from paper chart
==Con==
*manually from paper chart
==STB==
==Oak==
==VIC==




[[Category: Data structure]]
[[Category: Data structure]]
[[Category: Labs]]
[[Category: Labs]]

Revision as of 12:53, 2015 October 30

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

  • 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)

HSC

  • off EPR in labs

Grace

  • manually from paper chart

Con

  • manually from paper chart

STB

Oak

VIC