Legacy TMS Data.mdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m file location |
Ttenbergen (talk | contribs) m rolled |
||
| Line 6: | Line 6: | ||
* '''L_Labs_pre_2014_Aug''' - [[Legacy Labs List pre 2012]] | * '''L_Labs_pre_2014_Aug''' - [[Legacy Labs List pre 2012]] | ||
== | == Instructions == | ||
Copy into one directory with [[Centralized_data.mdb]], [[PHI.mdb]] and [[CCMDB.mdb]]. Open program. Build and run manual queries. | |||
Or, access from SAS. | |||
== Used for == | |||
* [[Manitoba Centre for Health Policy export]] | * [[Manitoba Centre for Health Policy export]] | ||
== Log == | |||
=== 2015-Apr-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. | |||
Revision as of 14:55, 16 April 2015
X:\CCMDB\Legacy Data\Legacy_TMS_Data.mdb contains the legacy data from TMSX and MedTMS that we decided to keep around, but not import into Centralized_data.mdb.
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.mdb. Open program. Build and run manual queries.
Or, access from SAS.
Used for
Log
2015-Apr-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.