Lab Collection Process: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
Line 22: Line 22:




The following labs and tests are collected:
See [[S AllLabsTable]] for labs that we collect.
*albumin 25%
*albumin 5%
*Packed cells
*Platelets
*FFP
*Pentaspan
*Voluven
*Angio coronary
*Angio other
*CXR
*CT scan
*MRI
*U/S echo
*U/S abd
*ABG
*CBC
*PT/PTT
*Creatinine
*Magnesium
*SGPT (ALT)
*Troponin
*Blood cultures
*Sputum cultures
*Urine cultures


[[Category: Labs]]
[[Category: Labs]]
[[Category: Data_Collection_Guide]]
[[Category: Data_Collection_Guide]]

Revision as of 14:32, 2 June 2011

Note: See Labs for more general info on the labs data.

The Critical Care database counts the laboratory tests listed at S_AllLabs for every patient for their entire LOS in a unit. Different collection of labs is collected at HSC than elsewhere. Some lab data at HSC is imported directly.

Lab Collection Process

  • For every ICU patient,
    • for every laboratory test on S_AllLabs
      • locate the specific lab,
      • enter the number of times the test was performed
    • if a patient has no labs by the end of their stay:

enter a date and leave zeros under all the labs.

      • if a culture is taken but the sample was inadequate to produce a result, the culture is still counted under lab counts.

Lab Dat Clean up for ICU and Med

  • Found a bug in ICU and Med MAIN lab data file with the lab uploader.exe. If multiple batches of lab data are uploading one after another without exiting upload program between each batch, the first patient lab file is left open and accumulates any lab totals.
  • Fixed lab data and program for ICU and medicine April.2011
    • ICU LAB Before Ed Cleaning the lab_sub Mar 2, 2011
    • ICU LAB After Ed Cleaned the Lab_sub Apr. 6, 2011

PTorres 13:34, 7 April 2011 (CDT)


See S AllLabsTable for labs that we collect.