Legacy TMS Data.mdb: Difference between revisions

(8 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\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.accdb]]. A backup copy exists in {{M:|Backup\Legacy TMS Data}}. Since this data is not changing, there is no backup process.

== Tables ==

Line 5:

* '''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.

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

Or, access from SAS.

Line 26:

Line 28:

=== 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~~]]

* imported [[L_Dxs table]] and [[L_Como table]] in preparation of removing them from [[Centralized_data.accdb]]

=== 2021-07-05 ===

@@ 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\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.accdb]]. A backup copy exists in {{M:|Backup\Legacy TMS Data}}. Since this data is not changing, there is no backup process.
 == Tables ==
@@ Line 5: / Line 5: @@
 * '''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.
+Copy into one directory with [[Centralized_data.accdb]], [[PHI.mdb]] and [[CCMDB.accdb]]. Open program. Build and run manual queries.
 Or, access from SAS.
@@ Line 26: / Line 28: @@
 === 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]]
+* imported [[L_Dxs table]] and [[L_Como table]] in preparation of removing them from [[Centralized_data.accdb]]
 === 2021-07-05 ===