Australian Medicines Terminology v3 Model - Technical Implementation Guide Scripts v1.0

A set of scripts, which import the AMT v3 beta data into a relational database (MySQL). These scripts and resultant database are intended as an AMT v3 distribution format learning aid.

Contained within this release is a collection of SQL scripts which are intended to provide a starting point for loading and working with AMT v3 in a relational database environment. Note: These scripts are not a suggested implementation or a base for implementation. Their purpose is as an aid to learning AMT v3's release format and data structures. As such the database schema mirrors the release file structure. Collectively, these scripts illustrate how to:

  • create a MySQL database schema into which the AMT v3 RF2 release files can be loaded;
  • create a set of useful database views and procedures to simplify querying the imported AMT v3 data; and
  • write queries which utilise the AMT v3 model to retrieve the necessary data to implement the primary AMT v3 use cases.
SHA256 Checksum: 
8.21 KB
Release history
Product component

All SNOMED CT-AU and AMT resources, including implementation collateral, are now available to download from the document library on the National Clinical Term

By operation of the Public Governance, Performance and Accountability (Establishing the Australian Digital Health Agency) Rule 2016, on 1 July 2016, all the assets and liabilities of NEHTA will vest in the Australian Digital Health Agency. In this website, on and from 1 July 2016, all references to "National E-Health Transition Authority" or "NEHTA" will be deemed to be references to the Australian Digital Health Agency. PCEHR means the My Health Record, formerly the "Personally Controlled Electronic Health Record", within the meaning of the My Health Records Act 2012 (Cth), formerly called the Personally Controlled Electronic Health Records Act 2012 (Cth).

Back to Top