Created Variables in TMSX or Med TMS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,810 edits
No edit summary
No edit summary
 
(34 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The following variables are created in the Master Database of Critical Care (TMSX) and/or Medicine Database (MedTMS) and are used in the reports
See
* [[Centralized data front end.accdb#ADL_scores]]
* [[Centralized data front end.accdb#Created_Variables]]
* [[Centralized data front end.accdb#Charlson_Comorbid_Score]]
* [[Centralized_data_front_end.accdb#Function_MOST_Score]]


*Age in years - see details in [[Date of Birth]]
* [[Created_Variables_CC_maker_2021 query]]
*Length of Stay in days - see details in [[LOS]]
* [[Created_Variables_CC_2021 table]]
*Transfer Delay in days
* [[Created_Variables_Common_maker_2021 query]]
**calculated as the difference between Discharge Date_time and Transfer Ready Date_time
* [[Created_Variables_Common_2021 table]]
**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
**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 - 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
**Predicted Probability


== 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]]


==Other Created Variables needed in the reports==  
== Related articles ==  
*Transfer Delay Over 4 hours in days for survivors - this is derived by subtracting 4 hours from Transfer Delay above.
{{Related Articles}}
*Bed Occupancy
 
*Charlson Comorbidity Score
[[Category:2013 data upgrades]]
*MOST Score
[[Category:Created Variables]]
*Readmissions

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"