Text Extracts - Version 1.5

13 October 2020

This XSL stylesheet produces all text extract files from a v3.0 PBS XML document. The files created are as follows:

The source document must be a v3.0 (or later) PBS XML document.

There are multiple result documents. The main result document is a manifest.

Global Parameters

Display Codes

The display parameter uses the following codes. These are also displayed as column headers when the header row is enabled.

Modules

Produce Control File – control.txt

Produces the control file

Version 3.0.1

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the Control extract file (CONTROL.TXT) from a v3.0 PBS XML document.

The control extract file gives information about the Standard Extract of data, specifying the date it was extracted from the Australian Department of Health and Ageing's database and its date of effect.

The source document must be a v3.0 PBS XML document.

The result document is a text file.

AMT Extract File – amt.txt, deprecated_amt.txt

Produces the amt.txt, deprecated_amt.txt files

Note: deprecated_amt.txt - Replicates the original amt.txt file. For use only in systems that cannot upgrade to the new amt.txt file.

Version 3.1.1

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the extract file (amt yyyymmdd.txt) from a v3.0 PBS XML document containing details of AMT identifiers for PBS items.

The source document must be a v3.0 PBS XML document.

The result document is a text file.

The default field delimiter in this file is the exclamation mark (!).

AMT2 Extract File – amt2.csv

Produces the amt2 file

Version 4.0.1

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces an extract file (amt yyyymmdd.txt) from a v3.0 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 v3.0 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.

Extract ATC File – atc.txt

Produces the atc file

Version 4.0.2

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the ATC extract file (ATC yyyymmdd.txt) from a v3.0 PBS XML document.

The ATC extract file provides information on ATC codes and their meanings. The ATC codes are used to provide the sort order for the drugs in the Schedule.

The source document must be a PBS XML document.

The result document is a text file.

The default field delimeter in this file is the exclamation mark (!).

Extract Cautions File – cautions.txt

Produces the cautions file

Version 4.0.2

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the Cautions ANS extract file (CautionExtract yyyymmdd.txt) from a v3.0 PBS XML document.

The Caution extract lists all Caution Ids and their descriptions. It is used for linking to values in the LinkExtract and PBS Item Table extract files.

The source document must be a PBS XML document.

The result document is a text file.

The field delimiter in this file is the tab character.

Extract continued dispensing file – cont-disp.txt 

Produces the cont-disp file

Version 3.1

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the continued dispensing extract file (cd_yyyymmdd.txt) from a v3.0 PBS XML document.

The source document must be a PBS XML document.

The result document is a text file.

The default field delimiter is the tab character.

Drug Extract File – drug.txt

Produces the drug file

Version 4.2

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the Drug extract file (Drug yyyymmdd.txt) from a v3.0 PBS XML document. Only ready prepared and infusible items are extracted.

The source document must be a v3.x PBS XML document.

The result document is a text file.

The default field delimiter in this file is the exclamation mark (!).

Extract fee-only items – fee-only.xml

Produces the fee-only file

Version 2.1

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the Fee-only extract file (fee-only-yyyymmdd.xml) from a v3.1 PBS XML document.

The source document must be a PBS XML document, schema-valid against version 3.1 (or later) of the PBS XML Schema.

The result is an XML document. The result document contains pricing information for items that have a fee-only pricing arrangement.

Extract Fees File – fees.txt

Produces the fees file

Version 4.0.1

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the Fees extract file (Fees yyyymmdd.txt) from a v3.0 PBS XML document.

The fees extract file contains details of patient contributions, mark-ups and fees that are relevant to the prices of drugs shown in the file Drug yyyymmdd.txt.

The source document must be a v3.x PBS XML document.

The result document is a text file.

It is a free format text file containing the fields listed below.

Patient Contribution

Container Fee

Dispensing Fees

Markups

PBS Item Table Extract File – item.txt

Produces the item file

Version 5.1

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the PBS Item Table ANS extract file (PBS Item Table yyyymmdd.txt) from a v3.0 PBS XML document.

The Item extract file provides information on the availability of items through the eAuthorities system, and also links Notes and Cautions to the PBS item codes.

The source document must be a v3.0 PBS XML document.

The result document is a text file.

The default field delimeter in this file is the tab character.

Link Extract File – links.txt

Produces the links file

Version 5.1.2

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the Link ANS extract file (LinkExtract yyyymmdd.txt) from a v3.0 PBS XML document.

A restriction is comprised of one or more indications. The Link extract file file links the Indication Id to the PBS item code. Where there are multiple indications for an item, there will be multiple records in this file for that PBS item code.

This version of the stylesheet only handles restrictions for prescribing rules. That is, it assumes all restrictions are for both the prescribing rule and increase (Increase MQ/R Flag=3). A future version of the stylesheet needs to handle increase rules.

The source document must be a v3.0 PBS XML document.

The result document is a text file.

The field delimiter in this file is the tab character.

Extract Manufacturer File – manufacturer.txt

Produces the manufacturer file

Version 2.0.2

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the Manufacturer extract file (Mnfr yyyymmdd.txt) from a v3.0 PBS XML document.

The Manufacturer extract provides name, address, telephone and facsimile number information for the sponsors of drugs listed in the schedule.

The source document must be a PBS XML document.

The result document is a text file.

The default field delimeter in this file is the exclamation mark (!).

Extract RACF medication chart file – med-chart-electronic.txt, med-chart-paper.txt

Produces the med-chart-electronic.txt, med-chart-paper.txt files

Version 4.2.1

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the Residential Aged Care Facility (RACF) medication chart extract file (med chart yyyymmdd.txt) from a v3.0 PBS XML document.

NB. this XSL stylesheet DOES NOT produce an extract for Hospital medication charts.

The source document must be a PBS XML document.

The result document is a text file.

The default field delimiter is the tab character.

Extract Notes File – notes.txt

Produces the notes file

Version 4.0.1

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the Notes ANS extract file (NoteExtract yyyymmdd.txt) from a v3.0 PBS XML document.

The Note extract lists all Note ids and their descriptions. It is used for linking to values in the LinkExtract and PBS Item Table extract files.

The source document must be a PBS XML document.

The result document is a text file.

The field delimeter in this file is the tab character.

Extract Dispensing Incentive Items – DI.txt

Produces the pfdi file

Version 3.1

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

Extract Prescriber Type – prescriber-type.txt

Produces the prescriber-type file

Version 3.1

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This stylesheet module extracts prescriber type data from the PBS XML document.

The source document is the PBS XML document, schema-valid to v3.0 (or later) of the PBS XML Schema.

The result is text. Each line lists the prescriber type applicable to an item. See parameter descriptions for further details about the format of the text output.

Extract Restrictions File – restrictions-delimited.txt, restrictions-fixed.txt

Produces the restrictions-delimited.txt, restrictions-fixed.txt files

Version 3.2

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the Restrictions ANS extract file (RestrictionExtract yyyymmdd.txt) from a v3.0 PBS XML document.

A restriction is comprised of one or more indications. The Restriction extract file lists the Indication Ids and the text of the Indications. This is the text that appears under the headings 'Restricted benefit', 'Authority Required (STREAMLINED)' and 'Authority Required' in the Schedule of Pharmaceutical Benefits.

The source document must be a v3.0 PBS XML document.

The result document is a text file.

The field delimiter in this file is the tab character. NB. In the 'fixed' format type, this file does not include a tab character after a five digit treatment-of code. In this case, the restriction text starts in position 6 (as specified below). In the 'delimited' format type, this file always includes a tab character after the treatment-of code. In this case, a five digit code will result in the text starting in position 7.

Extract SN20DR File – sn20dr.txt

Produces the sn20dr file

Version 4.1

Module Parameters

Module Description

This is a stylesheet module. It is not intended to be evaluated directly, but is included in the allextracts.xsl stylesheet.

This XSL stylesheet module produces the SN20DR extract file (sn20dr yyyymmdd.txt) from a v3.0 PBS XML document.

The source document must be a PBS XML document.

The result document is a text file.

The default field delimiter is the tab character.

Extract Streamlined Authority Items – streamlined.txt

Produces the streamlined file

Version 3.2

Module Parameters

Module Description

Revision History