Legacy TMS Data.mdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
Ttenbergen (talk | contribs) m →Log |
||
| Line 24: | Line 24: | ||
== Log == | == Log == | ||
=== 2015- | === 2021-07-05 === | ||
* Changed to .accdb and fixed linkings to other dbs that had changed to .accdb some time ago. | |||
* Tested in Access 2019 | |||
=== 2015-08-24 === | |||
copied to network Ttenbergen 12:48, 2015 August 24 (CDT) | copied to network Ttenbergen 12:48, 2015 August 24 (CDT) | ||
* re-imported TISS76 because the original had wrong dates as per email from Julie 2014-08-21. Ttenbergen 12:48, 2015 August 24 (CDT) | * re-imported TISS76 because the original had wrong dates as per email from Julie 2014-08-21. Ttenbergen 12:48, 2015 August 24 (CDT) | ||
=== 2015- | === 2015-04-15 === | ||
copied to network Ttenbergen 15:55, 2015 April 16 (CDT) | copied to network Ttenbergen 15:55, 2015 April 16 (CDT) | ||
Original file, imported data from \\HSC1MSFP0001\MED_CCMED\CCMDB_Special_Projects\MCHP\2015\ as per email from Julie from 2015-02-26. | Original file, imported data from \\HSC1MSFP0001\MED_CCMED\CCMDB_Special_Projects\MCHP\2015\ as per email from Julie from 2015-02-26. | ||
== Related articles == | == Related articles == | ||
Revision as of 13:30, 5 July 2021
X:\CCMDB\Legacy_TMS_Data\Legacy_TMS_Data.mdb contains the legacy data from TMSX and MedTMS that we decided to keep around in MS Access format, but not import into Centralized_data.mdb. A backup copy exists in M:\\Backup\Legacy TMS Data. Since this data is not changing, there is no backup process.
Tables
- L_TISS76 - TISS76
- L_Pharmacy_pre_2012 - Legacy Drugs before 2012
- L_Labs_pre_2014_Aug - Legacy Labs List pre 2012
Instructions
Copy into one directory with Centralized_data.mdb, PHI.mdb and CCMDB.accdb. Open program. Build and run manual queries.
Or, access from SAS.
Used for
Reporting
various Critical Care Vital Signs Monitoring
- Critical Care Quality Improvement Team VAP and CLI Report
- Critical Care Vital Sign Monitor data submission and report
- Critical Care Database requests involving research projects
Requested changes
- do we need to add anything else from TMSX MedTMS legacy data?
Log
2021-07-05
- Changed to .accdb and fixed linkings to other dbs that had changed to .accdb some time ago.
- Tested in Access 2019
2015-08-24
copied to network Ttenbergen 12:48, 2015 August 24 (CDT)
- re-imported TISS76 because the original had wrong dates as per email from Julie 2014-08-21. Ttenbergen 12:48, 2015 August 24 (CDT)
2015-04-15
copied to network Ttenbergen 15:55, 2015 April 16 (CDT) Original file, imported data from \\HSC1MSFP0001\MED_CCMED\CCMDB_Special_Projects\MCHP\2015\ as per email from Julie from 2015-02-26.