Data Structures

NZMT

NZ Medicines Terminology tables

NZMT – Individual Table Structures

The NZMT – A Visual Map

NZMT Relationships

The NZMT Explained

Pharmac

Pharmac tables

Pharmac – Individual Table Structures

Pharmac – A Visual Map

Pharmac Data in the NZULM Explained

Medsafe

Medsafe tables

Medafe – Individual Table Structures

Medafe – A Visual Map

Medafe Data in the NZULM Explained

Linking the Datasets

Stiching it all together

Pre-coordinated Index Tables

Joining the NZMT data to the Pharmac data

Joining the NZMT data to the Medafe data