TMSX MedTMS legacy data: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
 
(23 intermediate revisions by 2 users not shown)
Line 1: Line 1:
This article is about information we used to have in [[TMSX]] that is no longer collected, and for which we will not put a repository in place in the new set-up.  
This article is about information we used to have in [[TMSX]]/[[MedTMS]] that is no longer collected, and which is '''not''' now stored in [[Centralized_data.mdb]]. '''This data is now stored in [[Legacy TMS Data.mdb]].'''


'''[[:Category:Legacy Data]] might serve as a checklist for this article.'''
== [[Legacy TMS Data.mdb#Tables]] ==
* old pharmacy [[TMSX]]
* old Labs [[TMSX]], and HSC [[MedTMS]]
* ICU- [[:Category:TISS76 Legacy | TISS76]] unmapped items?


== Retention of this data ==
== Other databases ==
=== Data that is stored in TMSX ===
* [[TmpV2_1.mdb]]
Data that is stored in TMSX will be exported upon [[TMSX to Centralized go-life]].  
* [[Tasks_1.mdb]]
* [[Pharmacy.mdb]]


{{discussion}}
== Not yet addressed? ==
*Where should we store this data? If we put it onto CD/DVD it will eventually degrade. I propose we put it on one of the file shares, e.g. M:\. Ttenbergen 13:58, 2014 January 13 (CST)
 
=== Data that is not stored in TMSX ===
{{discussion}}
* Is there any legacy data that would not be addressed by the above? Ttenbergen 13:58, 2014 January 13 (CST)
 
== Legacy items ==
* old pharmacy  [[TMSX]], [[MedTMS]]
* old Labs [[TMSX]], [[MedTMS]]
* med- [[iTISS]]
* med- [[iTISS]]
* ICU- [[Category:TISS76 | TISS76]] unmapped items?
* <what else?> {{discussion}}


===MedTMS-SAPS2/APACHE II ===
===MedTMS-SAPS2/APACHE II ===
*[[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]] & [[APACHE II]] - we stopped on all new admissions to Medicine units in the Region was on December 31, 2006 and we retained [[HR]], [[RR]], [[AP Sys BP Field|Sys BP]], [[WBC]], [[GCS]]. 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)
** 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)
*** 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)
*NOTE, in medicine we collected, in tandem both SAPII and APACHE II. [[User:TOstryzniuk|Trish Ostryzniuk]] 17:21, 2014 February 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]]
Line 30: Line 24:
**LOGIT value based on the SAPS model - not documented on the wiki. And, I thought we stopped SAPS? is this needed?  
**LOGIT value based on the SAPS model - not documented on the wiki. And, I thought we stopped SAPS? is this needed?  
**Predicted Probability
**Predicted Probability
=== Other ===
Stick into some sort of "Legacy" data:
* [[Green sheets]]
* old [[:Category:TISS76 Legacy|TISS76]]  / [[iTISS]]
* old reg CPAP, SerUrea, DBili, UrineOutput, ActiveTx
== Related articles ==
{{Related Articles}}




[[Category:2013 data upgrades]]
[[Category:2013 data upgrades]]
[[Category:Legacy Data]]
[[Category:Master Database Programs]]

Latest revision as of 17:01, 2021 July 27

This article is about information we used to have in TMSX/MedTMS that is no longer collected, and which is not now stored in Centralized_data.mdb. This data is now stored in Legacy TMS Data.mdb.

Legacy TMS Data.mdb#Tables

Other databases

Not yet addressed?

MedTMS-SAPS2/APACHE II

  • SAPS II & APACHE II - we stopped on all new admissions to Medicine units in the Region was on December 31, 2006 and we retained HR, RR, Sys BP, WBC, GCS. 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)
  • NOTE, in medicine we collected, in tandem both SAPII and APACHE II. Trish Ostryzniuk 17:21, 2014 February 9 (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

Stick into some sort of "Legacy" data:

Related articles

Related articles: