Labs - Legacy Article: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
m Text replacement - "ccmdb.accdb" to "CCMDB.accdb"
 
(44 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Image:Construction26.gif]]
{{LegacyContent
|explanation=The collection process and data structure were changed repeatedly.
|successor=[[Labs data]]
|content=


The [[Critical Care]] program collects a count of a  list ([[S_AllLabs]]) of labs performed.
This article is an index for information about legacy lab collection.  


Some time ago, the count was done on the [[Lab_Collection_Form]].  
=== Data Structure ===
The data was stored in the [[L_Labs]] table.  


The data is now stored in the [[L_Labs]] tables on the PDA and in the [[CCMDB.mdb]]. There are '''two separate tables''' for labs.  One is for HSC ICU's only the other lab table is for all other ICU's in the city.  The reason for this is that HSC downloads lab from the Hospital computer system and at other sites this is not done.......yet.
=== Labs Downloading at HSC ===
At HSC labs (for Critical Care and Medicine) were downloaded.   


At HSC labs (for Critical Care and Medicine) are downloaded.  For more info see [[:Category:Lab download HSC | Lab downloading at HSC]].
=== List of lab items collected ===
See: [[S_AllLabs]]


Lab collection process - tallying lab tests.  For more information see [[Lab Collection Process]].
=== Lab form ===
 
Some time ago, the count was done on the [[Lab_Collection_Form]].  
== Data Integrity Rules, a.k.a TISS / Pharm corellation ==
The following items on your pharmacy form should be confirmed against the corresponding items on the [[:Category:TISS|TISS]]:
* ABGs  - items 57 and 58
 
== Limited number of labs ==
Only '''24''' labs can actually be sent in. You can collect as many as you want, but only those with the highest priority will actually be sent.
 
=== Which labs should be given preference ===
On the rare occasion more than 24 different labs are performed on a patient.
 
Since we cross-check labs against the TISS, all the labs that are referenced on the TISS need to be sent.
 
As for the rest, the labs are collected mostly for a cost estimate, so the most expensive ones are of most interest to us. Apparently a request for up-to-date lab costs has been in to the lab people for some time, but there are difficulties in getting an answer.
Once we have updated costs, we would actually change the CCMDB.mdb so it would pick the most important labs automatically based on cost, much like we are now doing for comorbids.
===Labs that are currently manually collected - TABLE===
*This is a master list of lab items that are on every PDA.
**TRUE means item is collected at a site
**FALSE means item is NOT collected at a site.
 
*For LAB items, the PDA can be set to different VIEWING lists.
**View all LABS  (Master PDA lab list)
**Collect at HSC  (subset of Master PDA lab list for HSC only. )
**Collect at Others  (subset of Master PDA lab list for:  STB, GRA, CON, OAK, GRA)
{{Discussion}}
Another point that should be mentioned is when there are no labs on a given patient.  Access will not send without something in the lab list.  Trish suggested putting in a value in access but then deleting in the the excel program after sending into that folder in the regional server.  --[[User:LKolesar|LKolesar]] 11:04, 19 March 2009 (CDT)
*Tina, for ccmdb, we should add a separate check for NO lab or NO pharm.  The above work around is not the best thing to be doing.--[[User:TOstryzniuk|TOstryzniuk]] 11:35, 19 March 2009 (CDT)
:See change log:  [http://ltc.umanitoba.ca/wikis/ccmdb/index.php/CCMDB.mdb_Change_Log_2009#March_2.09-NO_LABS_and_NO_Pharmacy separate check box for NO Lab or NO pharm].--[[User:TOstryzniuk|TOstryzniuk]] 11:41, 19 March 2009 (CDT)
 
It is important that if you are NOT at the HSC that when you select a LAB item that the '''VIEW''' on your PDA is set to '''COLLECT at OTHER SITES'''.[[User:TOstryzniuk|TOstryzniuk]] 12:31, 27 February 2009 (CST)
 
 
{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
|-
| width="44" height="29" align="right" valign="bottom" | LabCode
| width="98" align="center" valign="bottom" | LabName
|style="font-size:11pt" width="60" align="center" valign="bottom" | HSC_Collect_Manual
|style="font-size:11pt" width="67" align="center" valign="bottom" | Other_Collect_Manual
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 38
| valign="bottom" | CBC
| align="right" valign="bottom" | False
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 39
|  valign="bottom" | CBC Diff
| align="right" valign="bottom" | False
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 40
|  valign="bottom" | PT/PTT
| align="right" valign="bottom" | False
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 58
|  valign="bottom" | K
| align="right" valign="bottom" | False
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 61
|  valign="bottom" | Glucose
| align="right" valign="bottom" | False
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 63
|  valign="bottom" | Creatinine
| align="right" valign="bottom" | False
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 76
|  valign="bottom" | MG
| align="right" valign="bottom" | False
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 77
|  valign="bottom" | SGPT
| align="right" valign="bottom" | False
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 81
|  valign="bottom" | CPK
| align="right" valign="bottom" | False
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 89
|  valign="bottom" | Troponin
| align="right" valign="bottom" | False
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 113
|  valign="bottom" | Sputum C+S
| align="right" valign="bottom" | False
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 114
|  valign="bottom" | Blood C+S
| align="right" valign="bottom" | False
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 120
|  valign="bottom" | Urine C+S
| align="right" valign="bottom" | False
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 135
|  valign="bottom" | [[:Category: ABG | ABG]]
| align="right" valign="bottom" | False
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 99
|  valign="bottom" | Skull Xray
|style="color:#0000FF" valign="bottom" | True
| align="right" valign="bottom" | False
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 100
|  valign="bottom" | Sinus Xray
|style="color:#0000FF" valign="bottom" | True
| align="right" valign="bottom" | False
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 101
|  valign="bottom" | C-Spine Xray
|style="color:#0000FF" valign="bottom" | True
| align="right" valign="bottom" | False
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 102
|  valign="bottom" | L-Spine Xray
|style="color:#0000FF" valign="bottom" | True
| align="right" valign="bottom" | False
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 103
|  valign="bottom" | Other Xray
|style="color:#0000FF" valign="bottom" | True
| align="right" valign="bottom" | False
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 105
|  valign="bottom" | Lung Scan
|style="color:#0000FF" valign="bottom" | True
| align="right" valign="bottom" | False
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 108
|  valign="bottom" | Fluroscopy
|style="color:#0000FF" valign="bottom" | True
| align="right" valign="bottom" | False
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 111
|  valign="bottom" | EEG
|style="color:#0000FF" valign="bottom" | True
| align="right" valign="bottom" | False
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 125
|  valign="bottom" | Sputum Mycoplasma
|style="color:#0000FF" valign="bottom" | True
| align="right" valign="bottom" | False
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 126
|  valign="bottom" | Serum Mycoplasma
|style="color:#0000FF" valign="bottom" | True
| align="right" valign="bottom" | False
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 131
|  valign="bottom" | HIV
|style="color:#0000FF" valign="bottom" | True
| align="right" valign="bottom" | False
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 132
|  valign="bottom" | VDRL
|style="color:#0000FF" valign="bottom" | True
| align="right" valign="bottom" | False
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 133
|  valign="bottom" | Viral Titre
|style="color:#0000FF" valign="bottom" | True
| align="right" valign="bottom" | False
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 134
|  valign="bottom" | Hepatitis Screen
|style="color:#0000FF" valign="bottom" | True
| align="right" valign="bottom" | False
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 48
|  valign="bottom" | Group & Match
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 50
|  valign="bottom" | Packed cells
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 51
|  valign="bottom" | FFP
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 52
|  valign="bottom" | SP
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 53
|  valign="bottom" | Platelets
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 54
|  valign="bottom" | Albumin 25 %
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 55
|  valign="bottom" | Albumin 5%
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 96
|  valign="bottom" | EKG
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 97
|  valign="bottom" | CXR
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 98
|  valign="bottom" | ABD Xray
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 104
|  valign="bottom" | CT Scan
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 106
|  valign="bottom" | Angio-Coronary
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 107
|  valign="bottom" | Angio-Other
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 109
|  valign="bottom" | U /S Echo
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 110
|  valign="bottom" | U /S Abd
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 136
|  valign="bottom" | Pentaspan
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True
 
|- style="font-size:11pt"
| height="14" align="right" valign="bottom" | 137
|  valign="bottom" | MUGA
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True


|- style="font-size:11pt"
=== HSC used to be downloaded ===
| height="14" align="right" valign="bottom" | 138
Manual collection of additional Lab items HSC ICU:
|  valign="bottom" | MRI
*Start date: all NEW ICU admissions starting '''August 1.2014''':  
|style="color:#0000FF" valign="bottom" | True
**'''TEST file: Between July 2-18.14''' -  HSC ICU collector's to do Test for 1 pt each enter dummy data of additional lab items.  They are to advise Pagasa and Trish via email, which serial number they will do test on for a SENT complete patient.[[User:TOstryzniuk|Trish Ostryzniuk]] 17:18, 2014 July 2 (CDT)
|style="color:#0000FF" valign="bottom" | True
*38. CBC
*40. PT/PTT
*63. Creatinine
*76. MG
*77. SGPT (ALT)
*89. Troponin (TNT)
*113. Sputum C+S
*114. Blood C+S
*120. Urine C+S
*135. ABG (Blood Gas)


|- style="font-size:11pt"
See: [[Lab Downloading start/stop dates]]
| height="14" align="right" valign="bottom" | 142
|  valign="bottom" | Voluven
|style="color:#0000FF" valign="bottom" | True
|style="color:#0000FF"  valign="bottom" | True


|}
=== Items Removed ===
Removed from [[CCMDB.accdb]]'s & [[L_Labs Flowsheet]]- June 2014
*136. Pentaspan
*142. Voluven


*[[User:TOstryzniuk|TOstryzniuk]] 12:19, 27 February 2009 (CST)






===July 20.09===
*Platelet counting for '''LAB DATA''' is for assessing cost and volume given and is tallied as follows:
**1 adult dose of PLATELETS = 5 units
**2 adult doses of PLATELETS = 10 units
*for '''Item 23 TISS''': 1 adult dose counts as 1 bag and 2 adult doses counts as 2 bags.  TISS is for WORKLOAD measure. 


==January 30.09==
[[Category: Legacy Labs | *]]
*ICU Lab tests that are being manually collected and downloaded are currently being reviewed by the ICU database Task team.  Updates will be posted here when available.--[[User:TOstryzniuk|TOstryzniuk]] 17:38, 3 February 2009 (CST)
}}
 
[[Category:Data_Collection_Guide]]
[[Category:Data Integrity Rules]]
[[Category: Lab_Tests]]
[[Category:Questions]]
[[Category: Questions_Lab]]

Latest revision as of 20:27, 2020 July 24

Legacy Content

This page contains Legacy Content.
  • Explanation: The collection process and data structure were changed repeatedly.
  • Successor: Labs data

Click Expand to show legacy content.

This article is an index for information about legacy lab collection.

Data Structure

The data was stored in the L_Labs table.

Labs Downloading at HSC

At HSC labs (for Critical Care and Medicine) were downloaded.

List of lab items collected

See: S_AllLabs

Lab form

Some time ago, the count was done on the Lab_Collection_Form.

HSC used to be downloaded

Manual collection of additional Lab items HSC ICU:

  • Start date: all NEW ICU admissions starting August 1.2014:
    • TEST file: Between July 2-18.14 - HSC ICU collector's to do Test for 1 pt each enter dummy data of additional lab items. They are to advise Pagasa and Trish via email, which serial number they will do test on for a SENT complete patient.Trish Ostryzniuk 17:18, 2014 July 2 (CDT)
  • 38. CBC
  • 40. PT/PTT
  • 63. Creatinine
  • 76. MG
  • 77. SGPT (ALT)
  • 89. Troponin (TNT)
  • 113. Sputum C+S
  • 114. Blood C+S
  • 120. Urine C+S
  • 135. ABG (Blood Gas)

See: Lab Downloading start/stop dates

Items Removed

Removed from CCMDB.accdb's & L_Labs Flowsheet- June 2014

  • 136. Pentaspan
  • 142. Voluven
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Labs_-_Legacy_Article&oldid=145422"