L Labs Flowsheet table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m data structure |
Ttenbergen (talk | contribs) m m |
||
| Line 3: | Line 3: | ||
== Data Structure == | == Data Structure == | ||
* D_ID - link to [[L_Log]] | * D_ID - link to [[L_Log]] | ||
* Entry_dt # | * Entry_dt - date line was entered, see [[#Meaning of lines]] | ||
* CBC | * CBC | ||
* PT_PTT | * PT_PTT | ||
| Line 29: | Line 29: | ||
* Voluven - '''no longer collected''' | * 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_Flowsheet_sum]]. | |||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: Labs]] | [[Category: Labs]] | ||
Revision as of 13:06, 16 April 2015
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.
Data Structure
- D_ID - link to L_Log
- Entry_dt - date line was entered, see #Meaning of lines
- CBC
- PT_PTT
- Packed_Cells
- FFP
- Platelets
- Albumin_25pct
- Albumin_5pct
- Creatinine
- MG
- SGPT_ALT
- Troponin
- 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_Flowsheet_sum.