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]].
+{{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	See: [[Lab Collection Process]] for guidelines re: PT/PTT
-*	Packed_Cells
-*	FFP
-*	[[Platelets]]
-*	Albumin_25pct
-*	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
-*	MRI
-==No longer collected ==
+{{#ask: [[Category:L_Labs_Flowsheet table table]]
-*	Pentaspan
+| ?FieldName
-*	Voluven
+| ?FieldDataType
+| ?DataElementSortIndex = order in table
+|sort=DataElementSortIndex
+|order=ascending
+|format=broadtable
+|default=No pages for labs that meet the semantic mediawiki criteria
+|headers=show
+|class=sortable wikitable smwtable
+}}
 == 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]]
-==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:Legacy Labs]]
+[[Category:L_Labs_Flowsheet table| *]]
+[[Category:L Table]]
+[[Category:Legacy Data structure]]
+}}