L Labs Flowsheet table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Data Structure: links and completeness
m Data Structure: semantic table
Line 6: Line 6:
* D_ID / Pat_ID - link to [[L_Log]]
* D_ID / Pat_ID - link to [[L_Log]]
* Entry_dt - date line was entered, see [[#Meaning of lines]]
* Entry_dt - date line was entered, see [[#Meaning of lines]]
* CBC
 
* PT_PTT See: [[Lab Collection Process]] for guidelines re: PT/PTT
{{#ask: [[Category:L_Labs_Flowsheet]]  
* Packed_Cells
|format=broadtable
* FFP
|default=No pages for labs that meet the semantic mediawiki criteria
* [[Platelets]]
|headers=show
* Albumin_25pct
|class=sortable wikitable smwtable
* Albumin_5pct
}}
* Creatinine
* MG
* SGPT_ALT
* Troponin  (TNT)
* [[CXR]]
* CT_Scan
* [[Coronary Angiogram | 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 culture | Blood C+S]]'''
* Urine_CS
* [[:Category: ABG | ABG]] Arterial Blood Gas
* [[Venous blood gas]]
* ''Pentaspan'' - legacy
* MRI
* ''Voluven'' - legacy


== Meaning of lines ==
== Meaning of lines ==

Revision as of 16:33, 5 December 2016

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

No pages for labs that meet the semantic mediawiki criteria

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