Labs - Legacy Article: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(re-linking required, see top of article)
m (Text replacement - "ccmdb.accdb" to "CCMDB.accdb")
 
(15 intermediate revisions by 2 users not shown)
Line 1: Line 1:
What linked to labs will need to be re-linked to somewhere more sensible. Could anyone help re-direct the pages at [[:Special:WhatLinksHere/Labs]]
{{LegacyContent
|explanation=The collection process and data structure were changed repeatedly.
|successor=[[Labs data]]
|content=


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


Lab collection process - tallying lab tests.  For more information see [[Lab Collection Process]].
=== Data Structure ===
The data was stored in the [[L_Labs]] table.  


The [[Critical Care]] program collects a count of a  list ([[S_AllLabs]]) of labs performed.
=== 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 form ===
Some time ago, the count was done on the [[Lab_Collection_Form]].  


== Data use ==
=== HSC used to be downloaded ===
Used for research project only so far.  Requests are usually for specific lab test items: Dr. Kumar (all lab data, if he using all, don't know), Dr. Manjit, Dr. Garland, Dr. Bell(Blood products).
Manual collection of additional Lab items HSC ICU:
Labs are not reported in any regular periodic quarterly or fiscal year reports.[[User:TOstryzniuk|Trish Ostryzniuk]] 16:15, 2012 October 1 (CDT) as per [[Statistician]].
*Start date: all NEW ICU admissions starting '''August 1.2014''':
* Do we know if anyone is using the image data specifically? I am curious as this relates to [[RIS/PACS]]... Ttenbergen
**'''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)
 
See: [[Lab Downloading start/stop dates]]
 
=== Items Removed ===
Removed from [[CCMDB.accdb]]'s & [[L_Labs Flowsheet]]- June 2014
*136. Pentaspan
*142. Voluven


== Data Structure ==
The data is stored in the [[L_Labs]] table 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.


=== List of lab items collected ===
See: [[S_AllLabs]]


== Legacy Info ==


=== Lab form ===
Some time ago, the count was done on the [[Lab_Collection_Form]].


[[Category: Labs]]
[[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"