Created Variables in TMSX or Med TMS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
|||
| Line 24: | Line 24: | ||
=== SAPS === | === SAPS === | ||
{{discussion}} | {{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. [[User:JMojica|JMojica]] 16:20, 2014 January 6 (CST) | *[[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. [[User:JMojica|JMojica]] 16:20, 2014 January 6 (CST) | |||
*** Sorry, what I meant was keep the data '''outside''' of the new data structure since we are no longer collecting it. At the simplest, this would mean "keep" them as the last export from TMSX that we do. Would that work for you, Julie, since I anticipate you are the only person who might draw back on this data? Ttenbergen 10:05, 2014 January 9 (CST) | |||
*SAPS - collection of some SAPS elements were discontinued in Dec 2006. See details in [[SAPS II]] | *SAPS - collection of some SAPS elements were discontinued in Dec 2006. See details in [[SAPS II]] | ||
**SAPS Total Score | **SAPS Total Score | ||
Revision as of 10:05, 9 January 2014
- 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
- 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)
- Sorry, what I meant was keep the data outside of the new data structure since we are no longer collecting it. At the simplest, this would mean "keep" them as the last export from TMSX that we do. Would that work for you, Julie, since I anticipate you are the only person who might draw back on this data? Ttenbergen 10:05, 2014 January 9 (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.
- Is this per ward? hospital? Ttenbergen 15:02, 2013 December 23 (CST)
- 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