L Labs Flowsheet table: Difference between revisions
Jump to navigation
Jump to search
m Text replacement - "L Labs Flowsheet" to "L_Labs_Flowsheet table" |
m Text replacement - "L_Labs_Flowsheet" to "L_Labs_Flowsheet table" |
||
| 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]]. | The '''L_Labs_Flowsheet table''' table in the [[CCMDB.mdb]] and [[Centralized_data.mdb]] 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. | ||
| Line 10: | Line 10: | ||
* Entry_dt - date line was entered, see [[#Meaning of lines]] | * Entry_dt - date line was entered, see [[#Meaning of lines]] | ||
{{#ask: [[Category:L_Labs_Flowsheet table]] | {{#ask: [[Category:L_Labs_Flowsheet table table]] | ||
| ?FieldName | | ?FieldName | ||
| ?FieldDataType | | ?FieldDataType | ||
| Line 31: | Line 31: | ||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: Labs]] | [[Category: Labs]] | ||
[[Category: L_Labs_Flowsheet table|*]] | [[Category: L_Labs_Flowsheet table table|*]] | ||
[[Category:L Table]] | [[Category:L Table]] | ||
Revision as of 16:52, 29 November 2017
The L_Labs_Flowsheet table table in the CCMDB.mdb and Centralized_data.mdb 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
- 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
No pages for labs that meet the semantic mediawiki criteria
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: Legacy Labs