L Labs Flowsheet table: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) →Meaning of lines: VIC and OAKs - need reply here... thanks! |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (25 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
The '''L_Labs_Flowsheet''' table in the [[CCMDB. | {{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.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. | ||
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 | ||
* D_ID / Pat_ID - link to [[L_Log]] | |||
* 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 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 == | == 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]]. | 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]] | |||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: Labs]] | [[Category: Legacy Labs]] | ||
[[Category: L_Labs_Flowsheet table| *]] | |||
[[Category: L Table]] | |||
[[Category:Legacy Data structure]] | |||
}} | |||
Latest revision as of 08:35, 6 June 2023
Legacy Content
This page contains Legacy Content.- Explanation: These are no longer collected in labs, but are instead collected as part of CCI.
- Successor: Converting Lab Counts to CCI
Click Expand to show legacy content.
Collection change 2018-12-31
The L_Labs_Flowsheet table table in the CCMDB.accdb 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