Labs - Legacy Article: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m (Text replacement - "ccmdb.accdb" to "CCMDB.accdb")
 
(70 intermediate revisions by 3 users not shown)
Line 1: Line 1:
The [[Critical Care]] program collects a count of a [[S_Labs]] list of labs performed.
{{LegacyContent
|explanation=The collection process and data structure were changed repeatedly.
|successor=[[Labs data]]
|content=


Some time ago, the count was done on the [[Lab_Collection_Form]].  
This article is an index for information about legacy lab collection.  


The data is now stored in the [[L_Labs]] tables on the PDA and in the [[CCMDB.mdb]].  
=== Data Structure ===
The data was stored in the [[L_Labs]] table.  


At HSC labs are downloaded, for more info see [[Lab Downloading at HSC]].
=== Labs Downloading at HSC ===
At HSC labs (for Critical Care and Medicine) were downloaded.


== TISS / Pharm corellation ==
=== List of lab items collected ===
The following items on your pharmacy form should be confirmed against the corresponding items on the [[:Category:TISS|TISS]]:
See: [[S_AllLabs]]
* ABGs  - items 57 and 58


== Limited number of labs ==
=== Lab form ===
Only <how many> 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.  
Some time ago, the count was done on the [[Lab_Collection_Form]].  


On the rare occasion when more different labs than that are performed on a patient, it is not clear which should be given priorities high enough to be sent.   
=== 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.[[User:TOstryzniuk|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)


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.
See: [[Lab Downloading start/stop dates]]


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.  
=== Items Removed ===
Removed from [[CCMDB.accdb]]'s & [[L_Labs Flowsheet]]- June 2014
*136. Pentaspan
*142. Voluven


In other words, for now there is no good answer to your question, and when an answer becomes available, it will make the question moot. :-)








[[Category:Data_Collection_Guide]]
[[Category: Legacy Labs | *]]
}}

Latest revision as of 21: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"