Created Variables in TMSX or Med TMS: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(16 intermediate revisions by the same user not shown)
Line 1: Line 1:
*TISS Total Scores Day1 to Day10 - this has to be revised depending on and TISS28.
See
*Transfer Delay Over 4 hours in days for survivors - this is derived by subtracting 4 hours from Transfer Delay above.
* [[Centralized data front end.accdb#ADL_scores]]
===Bed Occupancy Per day===
* [[Centralized data front end.accdb#Created_Variables]]
[[bed occupancy]]
* [[Centralized data front end.accdb#Charlson_Comorbid_Score]]
* Is this per ward? hospital? Ttenbergen 15:02, 2013 December 23 (CST)
* [[Centralized_data_front_end.accdb#Function_MOST_Score]]
*** 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.
*** Decimal fractions for part-days? Ttenbergen 22:45, 2014 January 15 (CST){{discussion}}
* [[Multiple Encounter]] "Enc" in TMSX output
* [[Readmissions]]  
* [[Continuous Stay]]


== created variables implemented ==
* [[Created_Variables_CC_maker_2021 query]]
* [[Centralized data front end.mdb#ADL_scores]]
* [[Created_Variables_CC_2021 table]]
* [[Centralized data front end.mdb#Created_Variables]]
* [[Created_Variables_Common_maker_2021 query]]
* [[Centralized data front end.mdb#Charlson_Comorbid_Score]] - '''work in progress'''
* [[Created_Variables_Common_2021 table]]
* [[Centralized_data_front_end.mdb#Function_MOST_Score]]- '''work in progress'''


== Legacy Created Variables ==
== 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.
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
* TISS76 totals
* [[TMSX_legacy_data#SAPS_2]]
* [[TMSX MedTMS legacy data#SAPS_2]]


== Related articles ==
{{Related Articles}}


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

Latest revision as of 01:30, 4 November 2025