Document Version

NZULM Data Overview

1What is the NZULM? 5

1.1Overview 5

1.2Glossary 5

1.3The Logical Relationship Diagram 6

2The NZMT Data Model 8

2.1Overview 8

2.2SNOMED ID Codes (sctids) 8

2.3The “Seven Box” Model 9

3Where to begin? 11

3.1The prescribing_term_index and the charting_term_index 11

4Obtaining data from elsewhere in the NZULM 14

4.1Linking to SNOMED-CT 14

4.2Linking to Medsafe Data 15

4.3Linking to PHARMAC Subsidy Data 16

4.4Items not covered 17

6The NZMT Primary Concepts 18

6.1Overview 18

6.2CTPP – Containered Trade Product Pack 18

6.3TPP – Trade Product Pack 19

6.4TPUU – Trade Product Unit of Use 20

6.5TP – Trade Product 21

6.6MPP – Medicinal Product Pack 22

6.7MPUU – Medicinal Product Unit of Use 23

6.8MP – Medicinal Product 25

6.9substance 25

6.10Descriptions 26