• ABR bulk data files

    ABR bulk data can be downloaded from the Data Transfer Facility and incorporated into your own internal systems or accessed and utilised via a database solution used by your agency. Consultation with your internal IT area is recommended as support may be required to assist with importing, querying and managing the bulk data.

    Within each of the bulk data files available for downloading, there are ten tab delimited text files. Additional information regarding the structure and meaning of each of the data file fields is available in the ABR Data Dictionary.

    Data File Name

    ABR Data Dictionary Reference

    allyymmdd_ABR_Startdates.txt

    Start dates file

    allyymmdd_ABR_Contacts.txt

    Authorised contacts

    allyymmdd_ABR_RetMailIndicator.txt

    Returned mail file

    sttyymmdd _ABR_Agency_Data.txt

    Agency file

    sttyymmdd _ABR_Associates.txt

    Associates

    sttyymmdd _ABR_ACNC.txt

    Australian Charities and Not-for-profits Commission (ACNC) file

    sttyymmdd _ABR_Businesslocation.txt

    Business location

    sttyymmdd_ABR_Businessname.txt

    Business name

    sttyymmdd _ABR_Funds.txt

    Funds

    sttyymmdd _ABR_Othtrdnames.txt

    Other trading names file

    sttyymmdd _ABR_Replacedabn.txt

    Replaced ABN

    sttyymmdd _ABR Entity Mapping File.txt *

     

    sttyymmdd _Summary.txt #

     

    #sttyymmdd provides details regarding which state the extract is for and the date the bulk data file was generated eg. QLD141027. Allyymmdd refers to a national data file.

    To assist you with loading the ABR bulk data files, we have provided SQL (structured query language) code to generate the data tables with the correct data structure and field headings.

    To view the code click hereExternal Link

    Each file contains a primary identifier also known as the PID (with the exceptions of the ABR Entity Mapping File.txt and the ABR Division Mapping File.txt) for linking the files as shown in the following relationship diagram below.

    Agency data relationship diagram - START_RET_CONT_DIVMAP

    * The ABR Entity Mapping File.txt should be linked to the xxxxx_ABR_Agency_Data.txt file using the Entity Type Code.* The ABR Division Mapping File.txt should be linked to the to the xxxxx_ABR_Agency_Data.txt file using the ANZSIC.

    # The sttyymmdd_Summary.txt files is not shown in the relationship diagram above as this file in an information file only, it provides details regarding the date and time each of the .txt files were generated including the size of each of the files.

    • Last modified: 02 May 2016QC 891