Business location file
Field description |
Field name# |
Data type |
ABR bulk data information |
SBR definition |
---|---|---|---|---|
Primary Identifier |
PID |
integer |
Unique identifier for linking the ABR bulk data files (primary key) |
A string of alphanumeric characters generated by the Government Agency, used to uniquely identify the Business Document contained in the exchanged message. It should be a business identifier that would be understood by the Government Agency involved in the message exchange, not a message envelope level GUID. |
Location Type |
Locn_Typ_Cd |
char(3) |
There are two different location types present in the data: 010 = Main business address 015 = Additional business address |
Implements one of the possible address types available for a Party. Many businesses have multiple addresses that include locations, mailing addresses, corporate offices and seasonal addresses. For individual clients, examples include Residential, Postal or Registered address. |
Location Start Date |
Locn_Strt_Dt |
varchar(8)1 |
|
The date when the address began to be associated with the party. |
Business Location Address Line 1 |
Bus_Locn_Addr_Ln_1 |
varchar(38) |
|
First line utilising free format, that is used to create a semi structured address. |
Business Location Address Line 2 |
Bus_Locn_Addr_Ln_2 |
varchar(38) |
|
Second line utilising free format, that is used to create a semi structured address. |
Business Location Address Suburb |
Bus_Locn_Sbrb |
varchar(46) |
|
A word or combination of words, by which a geographic locality/suburb is designated or known. |
Business Location Address State Code |
Bus_Locn_Stt |
varchar(3) |
|
The code that is assigned to each Australian State or Territory |
Business Location Address Postcode |
Bus_Locn_Pc |
varchar(12) |
|
The Australian descriptor for a postal delivery area, aligned with locality, suburb or place |
Business Location Address Country Code |
Bus_Locn_Cntry_Cd |
varchar(3) |
|
This represents the Country Code as prescribed by AS4590 and inherited from ISO 3166 |
Business Location Address DPID |
Bus_Locn_DPID |
integer |
|
Implements a unique identification number that is assigned by Australia Post for that address. This number is printed onto correspondence as a barcode and results in a discount from Australia Post. |
Geocode Latitude2 |
Bus_Locn_Ltd |
Decimal(9,6) |
|
The geographic latitude of a point on the earth is a measurement in degrees north or south of the equator reference to a prescribed datum. Latitudes south of the equator are expressed as a negative number, north of the equator as positive. |
Geocode Longitude2 |
Bus_Locn_Lngtd |
decimal(9,6) |
|
The geographic longitude of a point on the earth is a measurement in degrees east or west of the Greenwich Meridian to a prescribed datum. Longitudes east of Greenwich are expressed as a positive number, west of Greenwich as negative. |
Mesh Block |
Bus_Locn_Msh_Blk |
varchar(11) |
|
This is a code that is defined using 2016 SLA Boundaries, Dwellings, Urban and Rural, Land Use, Cadastre, Gazetted Suburbs and Localities, Topography and Shape. The 11 digits code comprises S/T (State & Territory) identifier (1 digit), Mesh Block identifier (10 digits). Mesh Blocks are the smallest geographic region in the Australian Statistical Geographic Standard (ASGS) and form the basis for the larger regions of the ASGS.
|
G-NAF Primary Identifier |
Bus_Locn_GNAF_PID |
char(14) |
GNAF unique identifier |
|
Geocode Reliability Code |
Bus_Locn_Posnl_Rlblty |
small integer |
Refers to the geocode precision. The geocode latitude and longitude is provided only for addresses with a geocode reliability code of 2 or 3 to ensure the accuracy of the geocode |
The following table lists the possible reliability codes and their descriptions for address level geocode information:
Code/Description 1 - Geocode accuracy recorded to appropriate surveying standard 2 - Geocode accuracy sufficient to place centroid within address site boundary 3 - Geocode accuracy sufficient to place centroid near (or possibly within) address site boundary 4 - Geocode accuracy sufficient to associate address site with a unique road feature 5 - Geocode accuracy sufficient to associate address site with a unique locality or neighbourhood 6 - Geocode accuracy sufficient to associate address site with a unique region |
Business Location Phone Area Code |
Bus_Locn_Ph_Area_Cd |
varchar(4) |
|
|
Business Location Phone Number |
Bus_Locn_Ph_Num |
varchar(15) |
|
The number that is associated to a unique provision of phone service. |
Mobile Area Code |
Bus_Locn_Ph_Area_Cd_Mbl |
varchar(4) |
|
|
Mobile Number |
Bus_Locn_Ph_Num_Mbl |
varchar(15) |
|
This is a mobile phone service number for a crisis management contact. |
|
Bus_Locn_Eml |
varchar(200) |
|
Denotes the address of an electronic mail service. |
ANZSIC Code |
Bus_Locn_Indy_Clsn |
varchar(4) |
Four-digit ANZSIC code |
This is the 2006 numbering system adopted in the Australian and New Zealand Standard Industrial Classification (ANZSIC). This system is alphanumeric and has a hierarchical structure, where the leading alpha character denotes the industry division. The ANZSIC subdivision, group and class levels are denoted by numeric codes. |
ANZSIC Code Description |
Bus_Locn_Indy_Clsn_Descn |
varchar(100) |
Description of the four-digit ANZSIC code |
This is the description of the 2006 Australian and New Zealand Standard Industrial Classification (ANZSIC) code. |
# - Note: Field names are not contained in the ABR bulk data files. The field names are provided in SQL (structured query language) code available to assist you in generating the data tables with the correct data structure and field headings.
- Date fields are supplied in character format (YYYYMMDD). You may need to change the date format to one that suits your applications.
- The geocode latitude and longitude is provided only for addresses with a geocode reliability code of 2 or 3 to ensure the accuracy of the geocode.
- There will be no change to the provision of the five digit business industry code in the ‘agency file’. However the four-digit ANZSIC will now be included in the ‘business location’ file.