TMSX MedTMS legacy data

see TMSX MedTMS retirement home for final resting place of TMSX/MedTMS

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

Category:Legacy Data might serve as a checklist for this article.

Legacy TMS Data.mdb

• old pharmacy TMSX
• old Labs TMSX, and HSC MedTMS
• ICU- TISS76 unmapped items?

Not yet addressed?

• med- iTISS

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

pulled in from evil twin page ""

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:

• Green Sheets
• old TISS/iTISS
• old SAPS data
• old labs and pharmacy data
• old reg CPAP, SerUrea, DBili, UrineOutput, ActiveTx