Created Variables in TMSX or Med TMS: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{discussion}} | {{discussion}} | ||
* How about HMORT? It's in Ed's Export. Ttenbergen 17:06, 2013 December 30 (CST) | * 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 [[User:JMojica|JMojica]] 11:21, 2013 December 20 (CST) | Listed by [[User:JMojica|JMojica]] 11:21, 2013 December 20 (CST) | ||
| Line 23: | 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) | [[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 - 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 | ||
| Line 33: | Line 34: | ||
*Bed Occupancy Per day | *Bed Occupancy Per day | ||
** Is this per ward? hospital? Ttenbergen 15:02, 2013 December 23 (CST) | ** Is this per ward? hospital? Ttenbergen 15:02, 2013 December 23 (CST) | ||
*** We can make it per ward per hospital. if want to sum up in any combination in other queries. | |||
**Defines as the total number of beds being occupied by patients in a given calendar day. | **Defines as the total number of beds being occupied by patients in a given calendar day. | ||
*Charlson Comorbidity Score - see details [[Charlson Comorbid coding]] | *Charlson Comorbidity Score - see details [[Charlson Comorbid coding]] | ||
Revision as of 16:20, 6 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
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 ward per hospital. if want to sum up in any combination in other queries.
- 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