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

Template:Discussion SAPS II; we stopped end of 2006. I propose we keep the result with the other legacy data rather than re-implementing scoring for this. Ttenbergen 17:06, 2013 December 30 (CST) * Yes we can keep but only up to Dec 2006. After that, the scores are not valid because the data elements are dummy. JMojica 16:20, 2014 January 6 (CST)

• SAPS - collection of some SAPS elements were discontinued in Dec 2006. See details in SAPS II
  • SAPS Total Score
  • LOGIT value based on the SAPS model - not documented on the wiki. And, I thought we stopped SAPS? is this needed?
  • Predicted Probability

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