Created Variables in TMSX or Med TMS

• How about HMORT? It's in Ed's Export. Ttenbergen 17:06, 2013 December 30 (CST)
  • This data is direct entry and not created because we don't have the hospital death data. We will get a more detail of hospital outcome from WRHA later.

Listed by JMojica 11:21, 2013 December 20 (CST)

The following variables are being created in the Master Database of Critical Care (TMSX) and/or Medicine Database (MedTMS), being exported and are being used in the reports

• Age in years - see details in Date of Birth
• Length of Stay in days - see details in LOS
• Transfer Delay in days
  • calculated as the difference between Discharge Date_time and Transfer Ready Date_time
  • see details in Admit, Transfer and Discharge date and time
• APACHE - see details in APACHE Scoring table
  • Total APACHE SCORE
  • Mean Blood Pressure
  • Glasgow Coma Scale - (Glasgow Coma Scale)
  • Acute Physiological points
  • Age points
  • Chronic Health points
• TISS Total Scores Day1 to Day10 - this has to be revised depending on TISS76 and TISS28.
• Total ADL Score based on points 1,3,6 - this has to be changed by points 0,3,6. See details in ADL

SAPS

see TMSX_legacy_data#SAPS_2

Other Created Variables needed in the reports

• Transfer Delay Over 4 hours in days for survivors - this is derived by subtracting 4 hours from Transfer Delay above.
• Bed Occupancy Per day
  • Is this per ward? hospital? Ttenbergen 15:02, 2013 December 23 (CST)
    • We can make it per day per ward per hospital for now and sum up in any combinations in another queries later.
  • Defines as the total number of beds being occupied by patients in a given calendar day.
• Charlson Comorbidity Score - see details Charlson Comorbid coding
• MOST Score - see details of elements in MOST Score Elements
• Readmissions - see details in Multiple Encounters and Readmissions "Enc" in TMSX output