Legacy TMS Data.mdb: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "[[Centralized_data.accdb]]" to "Centralized_data.accdb" |
||
| (9 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{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 == | == Tables == | ||
| Line 5: | Line 5: | ||
* '''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. | Copy into one directory with [[Centralized_data.accdb]], [[PHI.mdb]] and [[CCMDB.accdb]]. Open program. Build and run manual queries. | ||
Or, access from SAS. | Or, access from SAS. | ||
| Line 24: | Line 26: | ||
== Log == | == Log == | ||
=== 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.accdb]] | |||
=== 2021-07-05 === | === 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? | * 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? | ||