MCHP Export.accdb

From CCMDB Wiki

Revision as of 17:31, 2019 August 13 by Ttenbergen (talk | contribs) (→‎Password)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

The file MCHP Export.mdb contains and is used to generate data for Manitoba Centre for Health Policy export. See Instructions for exporting data using MCHP Export.mdb for info on how to use it.

file location

X:\CCMDB_Special_Projects\MCHP\<most recent date>

Password

Located: M:\Passwords_mainoffice\

Change log

2017-04-12

Starting review

updated importer to work with current file structure
added code to remove columns we are not sending, eg. Notes , *_complete, and others no longer used.

2015-04-27

added "Comfort Care" to query "Create_Tmp" Ttenbergen 09:54, 2015 April 27 (CDT)
removed several components from 1Main that don't need to be in there Ttenbergen 14:56, 2015 April 27 (CDT)

2015-04-23

copied to master directory

code to generate export file when "generate output" is clicked
make-table queries

2015-04-20

re-conect for relevant files
initial file (is a modified clone of Legacy_TMS_Data.mdb)

Retrieved from "https://ccmdb.kuality.ca/index.php?title=MCHP_Export.accdb&oldid=138712"