Legacy TMS Data.mdb: Difference between revisions

(20 intermediate revisions by 2 users not shown)

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.

{{S:\MED\CCMED|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''' - [[:Category:TISS76 ~~Legacy~~ Legacy | TISS76]]

* '''L_TISS76''' - [[:Category:TISS76 Legacy | 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.~~mdb~~]]. Open program. Build and run manual queries.

Copy into one directory with [[Centralized_data.mdb]], [[PHI.mdb]] and [[CCMDB.accdb]]. Open program. Build and run manual queries.

Or, access from SAS.

Line 15:

Line 17:

=== Reporting ===

various [[~~CCVSM general information~~]]

various [[Critical Care Vital Signs Monitoring]]

* Critical Care Quality Improvement Team VAP and CLI Report

* Critical Care Vital Sign Monitor data submission and report

Line 24:

Line 26:

== Log ==

=== 2015-~~Aug~~-24 ===

=== 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-~~Apr~~-15 ===

=== 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.

== 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:Backup]]

[[Category:Master Database Programs]]

@@ 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.
+{{S:\MED\CCMED|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''' - [[:Category:TISS76 Legacy Legacy | TISS76]]
+* '''L_TISS76''' - [[:Category:TISS76 Legacy | 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.mdb]]. Open program. Build and run manual queries.
+Copy into one directory with [[Centralized_data.mdb]], [[PHI.mdb]] and [[CCMDB.accdb]]. Open program. Build and run manual queries.
 Or, access from SAS.
@@ Line 15: / Line 17: @@
 === Reporting ===
-various [[CCVSM general information]]
+various [[Critical Care Vital Signs Monitoring]]
 *  Critical Care Quality Improvement Team  VAP and CLI Report
 *  Critical Care Vital Sign Monitor data submission and report
@@ Line 24: / Line 26: @@
 == Log ==
-=== 2015-Aug-24 ===
+=== 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-Apr-15 ===
+=== 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.
+== 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:Backup]]
+[[Category:Master Database Programs]]