CCMDB Wiki

S AllLabsTable: Difference between revisions

← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
mNo edit summary
mNo edit summary
 
(51 intermediate revisions by 5 users not shown)
Line 1: Line 1:
This is the new list of lab items on the laptop that we '''plan to''' collect in the ICU's in the Region.
This is a legacy article only, see [[:Category:Labs]]


{{Discussion}}
The S_AllLabs Table used to contain the labs we collect; it became obsolete when we changed to the [[L Labs Flowsheet]] table.
*'''Start Date: ????''' (to be provided shortly)
 
* See: [[Lab collection for elimination]]
This is the list of lab items collect in the ICU's in the Region starting '''January 1, 2011'''
* to See: original lab list on laptop/PDA go to: [[S AllLabsTable Ver1]]


{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
|-  
|-  
|style="font-size:9pt" width="50" height="49" align="center" valign="bottom" | number of lab test collected manually
| width="58" height="49" align="center" valign="bottom" | LabCode #
| width="58" align="center" valign="bottom" | LabCode #
| width="154" align="center" valign="bottom" | LabName-s_lab_table_Ver2_'''Other sites'''  
| width="154" align="center" valign="bottom" | LabName-s_lab_table_Ver2_'''Other sites'''
*(24 items)
|style="font-size:11pt" width="37"  valign="bottom" | &nbsp;
|style="font-size:11pt" width="37"  valign="bottom" | &nbsp;
| width="59" align="center" valign="bottom" | LabCode #
| width="59" align="center" valign="bottom" | LabCode #
| width="121" align="center" valign="bottom" | LabName-s_lab_ table_Ver2_'''HSC'''
| width="121" align="center" valign="bottom" | LabName-                 s_lab_ table_Ver2_'''HSC'''  
*(14 items)


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 1
| height="19" align="center" valign="bottom" | 38
| align="center" valign="bottom" | 38
| valign="bottom" | CBC
| valign="bottom" | CBC
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 40
| valign="bottom" | &nbsp;
|style="font-style:Italic;color:#C0C0C0" align="right" valign="bottom" | downloaded
 
|- style="font-size:11pt"
| height="19" align="center" valign="bottom" | 40
| valign="bottom" | PT/PTT
| valign="bottom" | PT/PTT
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-style:Italic;color:#C0C0C0" align="right" valign="bottom" | downloaded


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 2
| height="19" align="center" valign="bottom" | 50
| align="center" valign="bottom" | 40
| valign="bottom" | Packed Cells
| valign="bottom" | PT/PTT
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 50
| align="center" valign="bottom" | 50
Line 32: Line 37:


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 3
| height="19" align="center" valign="bottom" | 51
| align="center" valign="bottom" | 50
| valign="bottom" | FFP
| valign="bottom" | Packed Cells
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 51
| align="center" valign="bottom" | 51
Line 40: Line 44:


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 4
| height="19" align="center" valign="bottom" | 53
| align="center" valign="bottom" | 51
| valign="bottom" | Platelets
| valign="bottom" | FFP
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 53
| align="center" valign="bottom" | 53
Line 48: Line 51:


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 5
| height="19" align="center" valign="bottom" | 54
| align="center" valign="bottom" | 53
| valign="bottom" | Albumin 25%
| valign="bottom" | Platelets
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 54
| align="center" valign="bottom" | 54
Line 56: Line 58:


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 6
| height="19" align="center" valign="bottom" | 55
| align="center" valign="bottom" | 54
| valign="bottom" | Albumin 5%
| valign="bottom" | Albumin 25%
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 55
| align="center" valign="bottom" | 55
Line 64: Line 65:


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 7
| height="19" align="center" valign="bottom" | 63
| align="center" valign="bottom" | 55
| valign="bottom" | Creatinine
| valign="bottom" | Albumin 5%
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 97
| valign="bottom" | CXR
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 8
| align="center" valign="bottom" | 63
| valign="bottom" | Creatinine
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 104
|style="font-style:Italic;color:#C0C0C0" align="right" valign="bottom" | downloaded
| valign="bottom" | CT Scan


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 9
| height="19" align="center" valign="bottom" | 76
| align="center" valign="bottom" | 76
| valign="bottom" | MG
| valign="bottom" | MG
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 106
| valign="bottom" | &nbsp;
| valign="bottom" | Angio_coronary
|style="font-style:Italic;color:#C0C0C0" align="right" valign="bottom" | downloaded


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 10
| height="19" align="center" valign="bottom" | 77
| align="center" valign="bottom" | 77
| valign="bottom" | SGPT (ALT)
| valign="bottom" | SGPT (ALT)
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 107
| valign="bottom" | &nbsp;
| valign="bottom" | Angio_others
|style="font-style:Italic;color:#C0C0C0" align="right" valign="bottom" | downloaded


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 11
| height="19" align="center" valign="bottom" | 89
| align="center" valign="bottom" | 89
| valign="bottom" | Troponin (TNT)
| valign="bottom" | Troponin
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 109
| valign="bottom" | &nbsp;
| valign="bottom" | U/S Echo
|style="font-style:Italic;color:#C0C0C0" align="right" valign="bottom" | downloaded


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 12
| height="19" align="center" valign="bottom" | 97
| valign="bottom" | CXR
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 97
| align="center" valign="bottom" | 97
| valign="bottom" | CXR
| valign="bottom" | CXR
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 110
| valign="bottom" | U/S Abd


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 13
| height="19" align="center" valign="bottom" | 104
| valign="bottom" | CT Scan
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 104
| align="center" valign="bottom" | 104
| valign="bottom" | CT Scan
| valign="bottom" | CT Scan
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 136
| valign="bottom" | Pentaspan


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 14
| height="19" align="center" valign="bottom" | 106
| valign="bottom" | Angio_coronary
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 106
| align="center" valign="bottom" | 106
| valign="bottom" | Angio_coronary
| valign="bottom" | Angio_coronary
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 138
| valign="bottom" | MRI


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 15
| height="19" align="center" valign="bottom" | 107
| valign="bottom" | Angio_others
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 107
| align="center" valign="bottom" | 107
| valign="bottom" | Angio_others
| valign="bottom" | Angio_others
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 142
| valign="bottom" | Voluven


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 16
| height="19" align="center" valign="bottom" | 109
| valign="bottom" | U/S Echo
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 109
| align="center" valign="bottom" | 109
| valign="bottom" | U/S Echo
| valign="bottom" | U/S Echo
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | &nbsp;
| align="right" valign="bottom" | &nbsp;


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 17
| height="19" align="center" valign="bottom" | 110
| valign="bottom" | U/S Abd
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 110
| align="center" valign="bottom" | 110
| valign="bottom" | U/S Abd
| valign="bottom" | U/S Abd
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | &nbsp;
| align="right" valign="bottom" | &nbsp;


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 18
| height="19" align="center" valign="bottom" | 113
| align="center" valign="bottom" | 113
| valign="bottom" | Sputum C+S
| valign="bottom" | Sputum C+S
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | &nbsp;
| align="center" valign="bottom" | &nbsp;
| align="right" valign="bottom" | &nbsp;
|style="font-style:Italic;color:#C0C0C0" align="right" valign="bottom" | downloaded


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 19
| height="19" align="center" valign="bottom" | 114
| align="center" valign="bottom" | 114
| valign="bottom" | Blood C+S
| valign="bottom" | Blood C+S
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | &nbsp;
| align="center" valign="bottom" | &nbsp;
| align="right" valign="bottom" | &nbsp;
|style="font-style:Italic;color:#C0C0C0" align="right" valign="bottom" | downloaded


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 20
| height="19" align="center" valign="bottom" | 120
| align="center" valign="bottom" | 120
| valign="bottom" | Urine C+S
| valign="bottom" | Urine C+S
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | &nbsp;
| align="center" valign="bottom" | &nbsp;
| align="right" valign="bottom" | &nbsp;
|style="font-style:Italic;color:#C0C0C0" align="right" valign="bottom" | downloaded


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 21
| height="19" align="center" valign="bottom" | 135
| align="center" valign="bottom" | 135
| valign="bottom" | ABG (Blood Gas)
| valign="bottom" | ABG
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|style="font-style:Italic;color:#C0C0C0" align="right" valign="bottom" | downloaded


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 22
| height="19" align="center" valign="bottom" | 136
| valign="bottom" | Pentaspan
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 136
| align="center" valign="bottom" | 136
| valign="bottom" | Pentaspan
| valign="bottom" | Pentaspan
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 23
| height="19" align="center" valign="bottom" | 138
| valign="bottom" | MRI
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 138
| align="center" valign="bottom" | 138
| valign="bottom" | MRI
| valign="bottom" | MRI
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;


|- style="font-size:11pt"
|- style="font-size:11pt"
|style="font-weight:bold" height="19" align="center" valign="bottom" | 24
| height="19" align="center" valign="bottom" | 142
| valign="bottom" | Voluven
|  valign="bottom" | &nbsp;
| align="center" valign="bottom" | 142
| align="center" valign="bottom" | 142
| valign="bottom" | Voluven
| valign="bottom" | Voluven
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;
|  valign="bottom" | &nbsp;


|}
|}


== Legacy Data ==
Collection of the new version started:
* January 1, 2011 at HSC, CON, OAK, VIC ICU's
* '''St.Boniface''' started using the revised lab list in June 2010.
**CCU:  First serial number using revised list is 24295. 
**MICU: First serial number using revised list is 24289.
**CICU: First serial number using revised list is 24358.
***NOTE: All patients prior to the [[Serial number]]s shown above, used [[S AllLabsTable Ver1]] for "all other sites" until the patient was discharged from the unit.
* '''GRACE''' ICU started using the revised lab list in '''June 2010'''
** MICU first serial number using revised list: 6540.
See: [[Lab collection for elimination]]
See original lab list at [[S AllLabsTable (pre 2011 legacy version)]]


==Discussion==
*on the laptops, how do you mark NO labs, if there are no test done during stay?  --[[User:TOstryzniuk|TOstryzniuk]] 14:21, 2 June 2011 (CDT)
** you don't mark it explicitly; if there is not at least one line of entries (even if all are 0) then the program should complain [[User:Ttenbergen|Ttenbergen]] 15:30, 2 June 2011 (CDT)
** btw, this is also mentioned in [[Lab Collection Process]] [[User:Ttenbergen|Ttenbergen]] 15:39, 2 June 2011 (CDT)
***I have checked with Laura and Marie about the practise of counting abdomenal Xrays and including them with the chest Xrays. '''only chest Xrays''' are to be counted. Thanks to my mentors for this information!
*****The number of platelet '''units''' is to be counted. It is not like the TISS that counts the number of bags hung.


[[Category: Labs]]
[[Category: Legacy Labs]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=S_AllLabsTable"