L Labs Flowsheet table: Difference between revisions

m Data Structure: links and completeness
m Text replacement - "[[Category: " to "[[Category:"
 
(24 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The '''L_Labs_Flowsheet''' table  in the [[CCMDB.mdb]] and [[Centralized_data.mdb]] contains the data we collect as part of [[Lab Collection Process]].  
{{DISPLAYTITLE:L_Labs_Flowsheet table}}{{LegacyContent
|explanation=These are no longer collected in labs, but are instead collected as part of [[CCI]].
|successor=[[Converting Lab Counts to CCI]]
|content=
 
Collection change 2018-12-31
 
 
The '''L_Labs_Flowsheet table''' table  in the [[CCMDB.accdb]] and [[Centralized_data.accdb]] contains the data we collect as part of [[Lab Collection Process]].  
 
Also see [[Labs collected list]] for a list.
Also see [[Labs collected list]] for a list.
It is linked to [[L_Log table]] by [[D_ID]].


== Data Structure ==
== Data Structure ==
Line 6: Line 17:
* 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 table table]]  
* Packed_Cells
| ?FieldName
* FFP
| ?FieldDataType
* [[Platelets]]
| ?DataElementSortIndex = order in table
* Albumin_25pct
|sort=DataElementSortIndex
* Albumin_5pct
|order=ascending
* Creatinine
|format=broadtable
* MG
|default=No pages for labs that meet the semantic mediawiki criteria
* SGPT_ALT
|headers=show
* Troponin  (TNT)
|class=sortable wikitable smwtable
* [[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 ==
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]].
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 ==
{{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)
==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 ==
==Labs no longer collected ==
Line 51: Line 37:




[[Category: Data structure]]
[[Category:Data structure]]
[[Category: Labs]]
[[Category:Legacy Labs]]
[[Category: L Labs Flowsheet|*]]
[[Category:L_Labs_Flowsheet table| *]]
[[Category:L Table]]
[[Category:Legacy Data structure]]
}}