TMSX MedTMS legacy data: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "Legacy Legacy" to "Legacy")
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
'' see [[TMSX MedTMS retirement home]] for final resting place of TMSX/MedTMS
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]].'''


This article is about information we used to have in [[TMSX]] that is no longer collected, and which is not now stored in [[Centralized_data.mdb]]
== [[Legacy TMS Data.mdb#Tables]] ==
 
'''[[:Category:Legacy Data]] might serve as a checklist for this article.'''
 
== Legacy TMS Data.mdb ==
* old pharmacy [[TMSX]]
* old pharmacy [[TMSX]]
* old Labs [[TMSX]], and HSC [[MedTMS]]
* old Labs [[TMSX]], and HSC [[MedTMS]]
* ICU- [[:Category:TISS76 Legacy | TISS76]] unmapped items?
* ICU- [[:Category:TISS76 Legacy | TISS76]] unmapped items?
== Other databases ==
* [[TmpV2_1.mdb]]
* [[Tasks_1.mdb]]
* [[Pharmacy.mdb]]


== Not yet addressed? ==
== Not yet addressed? ==
Line 18: Line 19:
*** 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)
*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 25: Line 25:
**Predicted Probability
**Predicted Probability


== pulled in from evil twin page "" ==
=== Other ===
Eds_to_Centralized.mdb currently being set up on Tina's desktop, this is just a spot where I keep notes for now.
 
 
???
* old AUX data
* linking data
* pre-pat_id D_ids... what will we use?
* export phi into _PHI
* fix sending to centralized to:
** combine adm/trans/disch dt/tm
 
Need to accommodate:
* transfer_tracker.mdb
 
Likely to go away:
* imaging.mdb
** can combine that data from PHI and centralized... need to decide where to store it
* PDA_Pending.mdb
** should be able to check centralized with appropriate query
 
Leave where is:
* tmp_v2_1.mdb
* Tasks_1.mdb
* pharmacy.mdb
 
Stick into some sort of "Legacy" data:  
Stick into some sort of "Legacy" data:  
* Green Sheets
* [[Green sheets]]
* old TISS/iTISS
* old [[:Category:TISS76 Legacy|TISS76]]  / [[iTISS]]
* old SAPS data
* old labs and pharmacy data
* old reg CPAP, SerUrea, DBili, UrineOutput, ActiveTx
* old reg CPAP, SerUrea, DBili, UrineOutput, ActiveTx


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




[[Category:2013 data upgrades]]
[[Category:2013 data upgrades]]
[[Category:Legacy Data]]
[[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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=TMSX_MedTMS_legacy_data&oldid=151439"