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

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

This toolkit provides a short introduction or ‘quick start’ reference for developers wishing to work with SNOMED CT-AU Reference Sets (Refsets). It includes sample applications built on Oracle’s Java platform and built on the Microsoft .NET Framework that demonstrate importing and using reference sets.

Contained within this release is a collection of SQL scripts that are intended to provide a starting point for loading and working with AMT v3 in a relational database environment (MySQL).

Note: These scripts are not a suggested implementation or a base for implementation. They are 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 use the AMT v3 model to retrieve the necessary data to implement the primary AMT v3 use cases.