AMT2 Extract File

Version 2.2.2

This XSL stylesheet produces an extract file (amt yyyymmdd.txt) from a PBS XML document containing details of AMT identifiers for PBS items. Only ready-prepared and infusible items are included in the extract.

The source document must be a PBS XML document.

The result document is a text file.

The default field delimiter in this file is the exclamation mark (!) (see 'delimiter' parameter, below).

Column values and their order are configurable using the 'display' parameter, see below.

NB. the order of the descriptions of field names below does not necessarily reflect their order in the output.

Field Name Format Indicative Length Description
program-code Character 2 As per Section 10 Drug Type Codes.
item-code Character 6 Alphanumeric characters in format (n)nnnna.
manufacturer-code Character Two character alphabetic, refer to file Mnfr yyyymmdd.txt. Two character alphabetic code in the Schedule Book.
brand-name Character TPP's 'Brand Name' as used in the PBS.
unit-of-measure Character E.g. Milligram, Micrograms, International Units.
mp-id Character AMT Medicinal Product SNoMED-CT Code.
mp-pt Character AMT Medicinal Product preferred term.
mpp-id Character AMT Medicinal Product Pack SNoMED-CT Code.
mpp-pt Character AMT Medicinal Product Pack preferred term.
tpuu-id Character AMT Trade Product Unit-of-use SNoMED-CT Code.
tpuu-pt Character AMT Trade Product Unit-of-use preferred term.
tpp-id Character AMT Trade Product Pack SNoMED-CT Code.
tpp-pt Character AMT Trade Product Pack preferred term.
vial-content Character The number of UOM's in the TPUU (ie. a single vial).
mq-pack Character For ready-prepared items the maximum quantity (in terms of pack). Infusible items leave this field blank.
mq-uu Character For ready-prepared items the maximum quantity (in terms of unit-of-use). For infusible items the maximum amount of Medicinal Product in terms of UOM.
cemp-tpp Character Commonwealth's 'Ex-Manufacturer Price' for a manufacturer's pack.
cemp-tpuu Character Commonwealth's 'Ex-Manufacturer Price' for a manufacturer's unit-of-use.
memp-tpp Character Manufacturer's 'Ex-Manufacturer Price' for a manufacturer's pack.
memp-tpuu Character Manufacturer's 'Ex-Manufacturer Price' for a manufacturer's unit-of-use.
pfdi Character Value of Premium Free Dispensing Incentive.
NOT INCLUDED IN DISPLAY DEFAULT -------------------------------------------
moa Character Manner of Administration
mpuu-id Character AMT Medicinal Product Unit-of-use SNoMED-CT Code.
mpuu-pt Character AMT Medicinal Product Unit-of-use preferred term.
pack-content Character The number of UOM's in the TPP.
mq Character For ready-prepared items the maximum quantity (in terms of unit-of-use). For infusible items the maximum amount of Medicinal Product in terms of UOM.
mp-int Character Internal description of MP. Selects shortest description if there are multiple available.
pr-int Character Internal description of prescribing rule.

Parameters

Parameter: "display"

Default value: "'program-code,item-code,manufacturer-code,brand-name,unit-of-measure,mp-id,mp-pt,mpp-id,mpp-pt,tpuu-id,tpuu-pt,tpp-id,tpp-pt,vial-content,mq-pack,mq-uu,cemp-tpp,cemp-tpuu,memp-tpp,memp-tpuu,pfdi'"

Fields to be included, in order. Delimited by comma.

Parameter: "include-header"

Default value: "0"

Whether to display header.

Parameter: "delimiter"

Default value: ""!""

What character to use to separate the data fields.

Parameter: "quote"

Default value: """"

What character to use to quote the data fields.

Parameter: "eom"

Default value: "" ""

What character to use to separate the data records.

Revision History

Version Release date Changes
2.2.2 27 November 2013 Add MOA, improve documentation.
2.2.1 23 September 2013 Improve documentation.
2.2 28 August 2013 Added mp-int, pr-int.
2.1 21 November 2012 Added mq-pack. Added mq-uu as a synonym for mq. Change default to display mq-pack.
2.0 14 November 2012 Create a branch to provide different format.
1.41 07 November 2012 Added documentation on the output format.
1.4 31 October 2012 Updated to PBS XML Schema v2.8.1
1.3 14 November 2011 Modified keys to address performance issues
1.2 19 October 2011 Updated to PBS XML v2.6.
1.1 02 June 2011 Updated to new specification.
1.0 09 May 2011 Initial version.