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

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

    Field description

    Field name

    Data type

    ABR bulk data file 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.

    Entity Type Code

    Ent_Typ_Cd

    varchar(3)

    ABR data value for this field is C.

    C = Charity

    Identifies the type of the ACNC Status - Charity.

    Status Code1

    Sts_Typ_Cd

    varchar(4)

    ABR data value for this field is R.

    REG = Registered

    Identifies the status of the organisations charitable status.

    Registration Date of Effect

    Regn_Dt

    varchar(8)2

    Registration Date of Effect

    Date when the organisation registration becomes effective.

    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. Data is only supplied for an entity’s ACNC status if the ABN is active and the ACNC status code is registered.

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

    • Last modified: 08 Jan 2018QC 579