Legacy TMS Data.mdb

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

• Manitoba Centre for Health Policy export
• other things Julie does in SAS, but which? Template:Discussion

Requested changes

• do we need to add anythign from TMSX MedTMS legacy data still?

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.