Legacy TMS Data.mdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m file move |
|||
| (21 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
\ | [[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 == | == Tables == | ||
* '''L_TISS76''' - [[:Category:TISS76 | TISS76]] | * '''L_TISS76''' - [[:Category:TISS76 Legacy | TISS76]] | ||
* '''L_Pharmacy_pre_2012''' - [[Legacy Drugs before 2012]] | * '''L_Pharmacy_pre_2012''' - [[Legacy Drugs before 2012]] | ||
* '''L_Labs_pre_2014_Aug''' - [[Legacy Labs List pre 2012]] | * '''L_Labs_pre_2014_Aug''' - [[Legacy Labs List pre 2012]] | ||
* '''L_Dxs''' data pre 2019_Jan when ICD10 started- [[L Dxs table]] | |||
* '''L_Como''' data pre 2019_Jan when ICD10 started- [[L Como table]] | |||
== Instructions == | == Instructions == | ||
Copy into one directory with [[Centralized_data.mdb]], [[PHI.mdb]] and [[CCMDB. | Copy into one directory with [[Centralized_data.mdb]], [[PHI.mdb]] and [[CCMDB.accdb]]. Open program. Build and run manual queries. | ||
Or, access from SAS. | Or, access from SAS. | ||
| Line 15: | Line 17: | ||
=== Reporting === | === Reporting === | ||
various [[ | various [[Critical Care Vital Signs Monitoring]] | ||
* Critical Care Quality Improvement Team VAP and CLI Report | * Critical Care Quality Improvement Team VAP and CLI Report | ||
* Critical Care Vital Sign Monitor data submission and report | * Critical Care Vital Sign Monitor data submission and report | ||
| Line 24: | Line 26: | ||
== Log == | == Log == | ||
=== 2015- | === 2022-08-10 === | ||
copied to server and informed Julie [[User:Ttenbergen|Ttenbergen]] 15:32, 2022 August 10 (CDT) | |||
* imported [[L_Dxs table]] and [[L_Como table]] in preparation of removing them from [[Centralized data.mdb]] | |||
=== 2021-07-05 === | |||
* removed code that tried to connect to other programs because it was broken, and fixing it would have required changing this to a .accdb, and why? | |||
* updated Main form to explain that this should only be accessed as data file | |||
* 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) | 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}} | |||
[[Category: Data Repository]] | [[Category:Data Repository]] | ||
[[Category: Legacy Data]] | [[Category:Legacy Data]] | ||
[[Category: Legacy Pharmacy]] | [[Category:Legacy Pharmacy]] | ||
[[Category: Legacy Labs]] | [[Category:Legacy Labs]] | ||
[[Category: MCHP]] | [[Category:MCHP]] | ||
[[Category:Backup]] | |||
[[Category:Master Database Programs]] | |||
Latest revision as of 08:48, 12 August 2024
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
- L_Dxs data pre 2019_Jan when ICD10 started- L Dxs table
- L_Como data pre 2019_Jan when ICD10 started- L Como table
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
2022-08-10
copied to server and informed Julie Ttenbergen 15:32, 2022 August 10 (CDT)
- imported L_Dxs table and L_Como table in preparation of removing them from Centralized data.mdb
2021-07-05
- removed code that tried to connect to other programs because it was broken, and fixing it would have required changing this to a .accdb, and why?
- updated Main form to explain that this should only be accessed as data file
- 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.