Manitoba Centre for Health Policy export

From CCMDB Wiki

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.mdb that has been processed as per Instructions for exporting data using MCHP Export.mdb.

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.

Splitting Multi-use L_TmpV2

Our L_TmpV2 table contains data from a number of temporary projects. We will only send a subset of longer-term data. The filtered data will be in

It contains a subset of Category:All_Projects

L_TmpV2 table itself will not be sent.