Created Variables in TMSX or Med TMS

• 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

variables available in query created_variables in Centralized data front end.mdb

• Age in years - see details in Date of Birth
• Length of Stay in days - see details in LOS
• Transfer Delay in days
• 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