L Labs Flowsheet table: Difference between revisions

← Older edit

@@ Line 1: / Line 1: @@
-The '''L_Labs_Flowsheet''' table contains the data we collect in the [[CCMDB.mdb]] and [[Centralized_data.mdb]] about the frequency at which labs are done in the ICU setting. Also see [[:Category:Labs]].
+{{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 ==
-[[Labs collected list]]
+*	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]]
+{{#ask: [[Category:L_Labs_Flowsheet table table]]
+| ?FieldName
+| ?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]].
+==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]]
+}}