• 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.

    GovernmentGeneratedIdentifier.External Link

    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.

    AddressDetails.Usage.CodeExternal Link

    Location Start Date

    Locn_Strt_Dt

    varchar(8)1

     

    The date when the address began to be associated with the party.

    AddressDetailsStartDateExternal Link

    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.

    AddressDetails.Line1.TextExternal Link

    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.

    AddressDetails.Line2.TextExternal Link

    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.

    AddressDetails.LocalityName.TexthExternal Link

    Business Location Address State Code

    Bus_Locn_Stt

    varchar(3)

     

    The code that is assigned to each Australian State or Territory

    AddressDetails.StateOrTerritory.CodehExternal Link

    Business Location Address Postcode

    Bus_Locn_Pc

    varchar(12)

     

    The Australian descriptor for a postal delivery area, aligned with locality, suburb or place

    AddressDetails.Postcode.TextExternal Link

    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

    AddressDetails.Country.CodeExternal Link

    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.

    AddressDetails.DeliveryPoint.IdentifierExternal Link

    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.

    AddressDetails.GeocodeLatitude.NumberExternal Link

    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.

    AddressDetails.GeocodeLongitude.NumberExternal Link

    Mesh Block

    Bus_Locn_Msh_Blk

    varchar(11)

     

    This is a code that is defined using 2011 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.

    AddressDetails.MeshBlock.CodeExternal LinkExternal Link

     

    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 telephone service.

    ElectronicContact.Telephone.Minimal.NumberExternal Link

    Mobile Area Code

    Bus_Locn_Ph_Area_Cd_Mbl

    varchar(4)

     

     

    Mobile Number

    Bus_Locn_Ph_Num_Mbl

    varchar(15)

     

    This is a mobile telephone service number for a crisis management contact. Telephone.Mobile.NumberExternal Link

    Email

    Bus_Locn_Eml

    varchar(200)

     

    Denotes the address of an electronic mail service.

    ElectronicContact.ElectronicMail.Address.TextExternal Link

    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.

    OrganisationIndustry2006.CodeExternal Link

    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.

    OrganisationIndustry2006.DescriptionExternal Link

    # - Please Note: Field names are not contained in the ABR bulk data files downloaded from the Data Transfer Facility. 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.

    1. Date fields are supplied in character format (YYYYMMDD). You may need to change the date format to one that suits your applications.

    2. 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.

    3. 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.

    • Last modified: 16 Mar 2015QC 580