L Labs Flowsheet table: Difference between revisions

← Older edit

@@ 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 ==
-*	D_ID	- link to [[L_Log]]
+*	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]]
-*	CBC
-*	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
-*	Angio_coronary
-*	Angio_others
-*	US_Echo
-*	US_Abd
-*	Sputum_CS
-*	Blood_CS
-*	Urine_CS
-*	ABG
-*	Pentaspan - '''no longer collected'''
-*	MRI
-*	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]].
-{{Discussion}}
+==Labs no longer collected ==
-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)
+See: [[:Category: Legacy Labs | Legacy Labs]]
-[[Category: Data structure]]
+[[Category:Data structure]]
-[[Category: Labs]]
+[[Category:Legacy Labs]]
+[[Category:L_Labs_Flowsheet table| *]]
+[[Category:L Table]]
+[[Category:Legacy Data structure]]
+}}