L Labs Flowsheet table: Difference between revisions

m data structure
m Text replacement - "[[Category: " to "[[Category:"
 
(46 intermediate revisions by 4 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]]. See [[Labs collected list]] for a list.
{{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.
 
It is linked to [[L_Log table]] by [[D_ID]].


== Data Structure ==
== Data Structure ==
* D_ID - link to [[L_Log]]
* L_Lab_Flowsheet_ID - unique record ID
* Entry_dt #NAME?
* D_ID / Pat_ID - link to [[L_Log]]
* CBC
* Entry_dt - date line was entered, see [[#Meaning of lines]]
* PT_PTT
 
* Packed_Cells
{{#ask: [[Category:L_Labs_Flowsheet table table]]
* FFP
| ?FieldName
* Platelets
| ?FieldDataType
* Albumin_25pct
| ?DataElementSortIndex = order in table
* Albumin_5pct
|sort=DataElementSortIndex
* Creatinine
|order=ascending
* MG
|format=broadtable
* SGPT_ALT
|default=No pages for labs that meet the semantic mediawiki criteria
* Troponin
|headers=show
* CXR
|class=sortable wikitable smwtable
* CT_Scan
}}
* Angio_coronary
 
* Angio_others
== Meaning of lines ==
* US_Echo
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]].
* US_Abd
* Sputum_CS
* Blood_CS
* Urine_CS
* ABG
* Pentaspan - '''no longer collected'''
* MRI
* Voluven - '''no longer collected'''


==Labs no longer collected ==
See: [[:Category: Legacy Labs | Legacy Labs]]


== Legacy ==
* this replaced the [[L_Labs]] table


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