Created Variables in TMSX or Med TMS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
 
(23 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{discussion}}
See
* How about HMORT? It's in Ed's Export. Ttenbergen 17:06, 2013 December 30 (CST)
* [[Centralized data front end.accdb#ADL_scores]]
** 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.
* [[Centralized data front end.accdb#Created_Variables]]
* [[Centralized data front end.accdb#Charlson_Comorbid_Score]]
* [[Centralized_data_front_end.accdb#Function_MOST_Score]]


Listed by [[User:JMojica|JMojica]] 11:21, 2013 December 20 (CST)
* [[Created_Variables_CC_maker_2021 query]]
* [[Created_Variables_CC_2021 table]]
* [[Created_Variables_Common_maker_2021 query]]
* [[Created_Variables_Common_2021 table]]


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
== Legacy Created Variables ==
The following are legacy created variables. Data to calculate them is no longer collected and the variables will not be made available the new system.
* TISS76 totals
* [[TMSX MedTMS legacy data#SAPS_2]]


*Age in years - see details in [[Date of Birth]]
== Related articles ==  
*Length of Stay in days - see details in [[LOS]]
{{Related Articles}}
*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


[[Category:2013 data upgrades]]
[[Category:2013 data upgrades]]
[[Category:Created Variables]]

Latest revision as of 01:30, 4 November 2025

See

Legacy Created Variables

The following are legacy created variables. Data to calculate them is no longer collected and the variables will not be made available the new system.

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Created_Variables_in_TMSX_or_Med_TMS&oldid=167942"