How do I use the XML file?

XML files are most commonly utilised to import into Excel spreadsheets and Access databases.

Page last updated: 29 October 2014

To do this. Save the XML file to a directory/folder/desktop on your computer where you can readily recall it. Open Excel and from the toolbar select Data, XML, then Import. This will import the XML file into a new worksheet. The XML files can be accessed from the Downloads page. This XML file has been tested with Excel XP and Excel 2003.

The following is a simplified, step by step process if you are encountering difficulties with the above method:

  • Go to the MBS Online Downloads page and click on the XML link and save the zip file to the Desktop.
  • Right click on the zipped file icon on the desktop and choose Winzip, then "Extract to here". This saves the XML file to the Desktop,
  • Open Excel then Click on Data, XML, Import and then open the XML file from the desktop - Click on Import,
  • You are asked "Where do you want to put the data" i.e Cell$A$1 - click on OK. The data will then appear in the Excel spreadsheet

If you have problems, please search the Excel help files for importing xml data.

XML Field Descriptions

Legend:
O = Optional
M = Mandatory
A = Alphanumeric
N = Numeric
D = Date
Default value for all XML elements is NULL
Printable version of XML Field Descriptions (PDF 312 KB)

XML TagsTag DescriptionMinimum occurrences of tag Maximum occurrences of tag Value Optional or MandatoryTypeLengthFormatPossible Values/Rules
ItemNum Item number11MN1 to 6Item Number
SubItemNumSub-item number for
precedent items (ie 30000
items)
11ON0NULL . This element is not populated.
ItemStartDateDate item commenced11MA10DD.MM.YYYYDate item commenced
ItemEndDateDate item ceased11OA0DD.MM.YYYYContains the item end date if there is one,
NULL otherwise
CategoryThe Category the item
relates to
11MA1 to 3The Category the item relates to
GroupThe Group the items relates
to
11OA0 to 3If the item relates to a Group then the group
code, otherwise NULL
SubGroupThe Subgroup the item
relates to
11OA0 to 3If the item relates to a SubGroup then the
SubGroup code, otherwise NULL
SubHeadingThe SubHeading the item
relates to
11OA0 to 3If the item relates to a SubHeading then the
SubHeading code, otherwise NULL
ItemTypeThe item type11MA1S - for standard,
P - for precedent or
D - item is covered under legislation under a
3C determination
FeeTypeThe Fee type11MA1N – Normal fee
D – Derived fee
ProviderTypeThe provider category
applicable to the item
11OA0 to 3If the item has a provider type then the
provider type code, otherwise NULL
AD – Accredited Dental Practitioner
AO – Accredited Orthodontist
AOS – Approved Oral Surgeon
C –Computerised facilities
G – General Practitioner
HR – Hospital Recognised
NC – Non-computerised facilities
OP – Other (non-specialist pathologist)
S – Specialist
SP – Specialist Pathologist
NewItemNew item indicator11MA1Y – This is a new item
N – This is an existing item
If Y then the ItemStartDate will be after the base report date
ItemChangeItem change indicator11MA1Y – There has been a change to the item number
N – The item number has not changed
AnaesChangeAnaesthetic change indicator11MA1Y – A change has occurred in the anaesthetic units
N – There has not been a change in the anaesthetic units
DescriptorChangeDescriptor change indicator11MA1Y – A change has occurred in the Item descriptor
N – No change has occurred to the item descriptor
FeeChangeFee change indicator11MA0 to 1Y – A change has occurred in the fee
N – The fee has not changed
Blank – The fee has not changed (this value can occur when the item is new)
EMSNChangeEMSN change indicator11OA0 to 1Y – There has been a change to the EMSN cap for the item
N – There has not been any change to the EMSN cap for this item
NULL – There is no current EMSN cap for this item
EMSNCapIndicates whether or not the item has a current EMSN cap, and what type of cap applies.11MA1N – There is no current EMSN cap for this item
P – There is a current normal fee percentage cap for this item
F – There is a current fixed cap for this item

This tag impacts all tags for EMSN.

If EMSNCap = N, then all other EMSN tags will have NULL values.

If EMSNCap = P or F, the relevant EMSN
tags will contain the EMSN details (see
individual tags for details of EMSN values)
BenefitTypeBenefit indicator11OA0 to 1A – benefit paid at 75% only
B - benefit paid at 85% only
C - benefit paid at 75% & 85%
D - benefit paid at 75% & 100%
E - benefit paid at 100%
NULL – No benefit applicable

The value in this field will affect which of the benefit tags Benefit75, Benefit85 and Benefit100 will be included (see individual fields below for details)
BenefitStartDateDate which benefit level/s changed11OA0 to 10DD.MM.YYYYDate the current level of Benefit Type
commenced
FeeStartDateDate current Schedule fee commenced01MA0 to 10DD.MM.YYYYThis tag only appears if the item FeeType = N. It contains the date the current Schedule fee commenced
ScheduleFeeThe Schedule fee 01MN1 to 5.2This tag only appears if the item FeeType = N. It contains the current Schedule fee
Benefit75The 75% benefit01MN1 to 5.2This tag only appears if the item FeeType = N and the BenefitType = A or C or D. In this circumstance it will contain the 75% benefit amount
Benefit85The 85% benefit01MN1 to 5.2This tag only appears if the item FeeType = N and the BenefitType = B or C. In this circumstance it will contain the 85% benefit
amount.
Benefit100The 100% benefit01MN1 to 5.2This tag only appears if the item FeeType = N and the BenefitType = D or E. In this circumstance it will contain the 100% benefit amount.
Basic UnitsThe Anaesthetic Basic Unit11ON0 to 3Values only occur in the item range 20100 to 25020.
EMSNStartDateDate EMSN cap commenced11OA0 to 10DD.MM.YYYYIf the item has a current EMSN cap then the date on which the current EMSN cap commenced, otherwise NULL
EMSNEndDateDate the EMSN cap ended11OA0 to 10DD.MM.YYYYIf the item has an EMSN cap that ends in the future then this is the date on which the EMSN cap ends, otherwise NULL. EMSN caps that have an end date that is before the report date will not be reported.
EMSNFixedCapAmountEMSN Fixed Cap amount for normal and derived fees11ON0 to 7.2N/AIf the item has a current Fixed EMSN cap then the cap amount, otherwise NULL.
EMSNPercentageCap EMSN Percentage cap amount for normal and derived fees11ON0 to 7.2N/AIf the item has a current Percentage EMSN cap then the cap percentage, otherwise NULL.
EMSNMaximumCapEMSN Maximum cap amount for Percentage cap only (normal and derived fees)11ON0 to 7.2N/AIf the item has a current EMSN Maximum cap for a Percent cap then the cap amount, otherwise NULL.
EMSNDescriptionEMSN Percentage cap description for Derived fee only11OAUnlimitedN/AIf the item has a current derived fee percentage cap then the EMSN derived cap description, otherwise NULL.
EMSNChangeDateEMSN Cap change date11OA0 to 10DD.MM.YYYYIf the item has an EMSN cap and the cap has changed, then the date on which the change became effective, otherwise NULL.
DerivedFeeStartDateDate current derived fee commenced01MA10DD.MM.YYYYIf the item FeeType = D then the date the current derived fee commenced
DerivedFeeThe derived fee description01OAUnlimitedThis tag only appears if the item FeeType = D.
AnaesAnaesthetic indicator01MA1This tag only appears if the item attracts an anaesthetic. In this case the value will be Y.
DescriptionStartDateDate current description commenced11MA10DD.MM.YYYYDate current description commenced.
DescriptionThe item description11OAUnlimitedThe item description.
QFEStartDateDate the Time Limited Listing commenced11OA0 to 10DD.MM.YYYYCommencement date that the time limited listing evaluation commenced or NULL if this is not a time limited listing
QFEEndDate Date the Time Limited Listing ended11OA0 to 10DD.MM.YYYYEnd date that the time limited listing evaluation finishes or NULL if this is not a time limited listing