What is the NZULM? Overview

What is the NZULM?

1. Overview

• 
  The PHARMAC Pharmaceutical Schedule;
  
• 
  Medsafe Licensing; and
  
• 
  The New Zealand Medicines Terminology (NZMT) (based on the SNOMED CT international medicines terminology).
  

Within the NZULM are three primary sources of data: the NZMT, the Pharmaceutical Schedule and the Medsafe Registration database. These three data sources provide four sets of data as the Pharmaceutical Schedule includes both the Community Schedule and the Hospital Medicines List (HML). These four datasets have relationships at the lowest level. In the NZMT this is the CTPP (Containered Trade Product Pack) table. In the Community Schedule this is the ps_pack table. In the HML this is the hml_pack table. In the Medsafe files this is the ms_package table.

2. Glossary

3. The Logical Relationship Diagram

This diagram shows the various relationships between the various tables (CTPP, MPUU, ps_pack, hml_pack, ms_package, ms_substance and substance). CTPP and ps_pack have a relationship through the pharmacode via the ctpp_pharmacodes table. CTPP and ms_package have a relationship through the CTPP id and the ms_package nzmt_sctid columns. Both CTPP and MPUU have a relationship with hml_pack through the pharmacy_subsidy_code via the nzmt_pharmac_subsidy_codes table. Substance and ms_substance have a relationship via the ms_substance_sct table.

The relationship between nzmt_pharmac_subsidy_codes and CTPP and MPUU is illustrative of the logical relationship. Nzmt_pharmac_subsidy_-codes is able to link any NZMT table to an hml_pack.pharmac_subsidy_code. While almost all of the hml_pack.pharmac_subsidy_codes are at either CTPP or MPUU level, there are some relationships with MPP records, where the subsidy code applies to a specific generic pack size. The pharmacy_subsidy_code is unique within nzmt_pharmac_subsidy_codes – a subsidy code links to only one NZMT record (at whatever level is appropriate). Multiple subsidy codes can link to the same NZMT sctid – this is likely to occur at MPUU level only, where the NZMT generic is less specific than the PHARMAC chemical/formulation combination.

2. 
   
   Download 196.51 Kb.
   
   Share with your friends: