Project ABO TEE: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 40: Line 40:
=={{CCMDB Data Integrity Checks}}==
=={{CCMDB Data Integrity Checks}}==
* Each of the three projects must have one entry on the ITEM.   
* Each of the three projects must have one entry on the ITEM.   
** Implemented as query 's_tmp_ABO_TEE_checks'
** Implemented as query ''s_tmp_ABO_TEE_checks''


* All the three projects must not have blanks on completion of record.
* All the three projects must not have blanks on completion of record.

Revision as of 18:22, 25 March 2016

We are collecting blood type and cardiac function on CICU patients for analysis of outcomes, research, quality assurance.

Collection Instructions

  • Project A_T blood type
  • Blood type would be collected for all patients in CICU (no matter what type of procedure they had) .... if there is a blood type in chart (which there would be), need to collect it.
    • A
    • B
    • AB
    • O
    • z not available (starts with z to sort to end)
  • Project A_T LV fraction (LV ejection fraction from intra-op TEE (Transesophageal echocardiogram), before Cardiopulmonary bypass)
    • <20%
    • 20-29%
    • 30-49%
    • 50% or greater
    • z not available (starts with z to sort to end)
  • Project A_T function (Right ventricular function from intra-op TEE before cardiopulmonary bypass:)
    • If the documentation says mild-moderate or moderate to severe, then coding would be towards the worse value-eg. Mild-moderate would be recorded as moderate and moderate-severe would be recorded as severe.
    • Values are:
      • Normal
      • Mildy depressed
      • Moderately depressed
      • Severely depressed
      • z not available (starts with z to sort to end)

Collection parameters

  • Collected only at StB CICU
  • Start Date: 2013-01-28
  • End Date: planned as continuous collection without an end date
  • data is sent upon final-check only
  • data is saved in L_TmpV2 under Projects 'A_T blood type', 'A_T LV Fraction', and 'A_T Function' of Centralized_data.mdb

Data Use

Information will be provided by our statistician to physicians for further analysis.

  • Dr. R. Manji
  • Dr. A. Menkis

Template:CCMDB Data Integrity Checks

  • Each of the three projects must have one entry on the ITEM.
    • Implemented as query s_tmp_ABO_TEE_checks
  • All the three projects must not have blanks on completion of record.
    • automatic functionality, all tmp entries must have matching project/item entries

SAS Program

The SAS program to read the data can be found in X:\Julie\SAS_CFE\CFE_macros\CFE_ATBloodType.sas