Manitoba Centre for Health Policy export

This article functions as a portal for the people at MCHP who import data into their repositories from our Manitoba Centre for Health Policy export. We provide them a copy of the MCHP Export.accdb that has been processed as per Instructions for exporting data using MCHP Export.accdb.

Data

Structure is same as CCMDB Data Structure except for the following.

Splitting dual use L_Dxs

For legacy reasons we store different kinds of data in L_Dxs table. For ease of use by MCHP we split the data into the following two tables and won't send the actual L_Dxs table.

• L_DXs_MCHP table
• L_Tasks_MCHP table

Splitting Multi-use L_TmpV2

Our L_TmpV2 table contains data from a number of temporary Projects . We will only send a subset of this data, defined by which data has the MCHP field in the s_tmp table set to "true" . The filtered data will be in

• L_TmpV2_MCHP table

L_TmpV2 table itself will not be sent.