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

    GovernmentGeneratedIdentifier.External Link

    Fund Name

    Fnd_Nm

    varchar(200)

     

    The full name by which an organisation is known.

    OrganisationNameDetails.OrganisationalName.TextExternal Link

    Role Type Code

    Role_Typ_Cd

    varchar(11)

    Refer to Appendix E for further information

    Describes the registration that an organisation may be required to acquire over time, in order to operate their business. Examples of these registration are: Examples of commonly used registrations: Goods and Services Tax (GST), Income Tax Exemption, GST Concessions, Deductible gift recipient (DGR), Charitable fund, Health Promotion Charity (HPC).

    OrganisationDetails.OrganisationRegistrationDescription.TextExternal Link

    Fund Registration Date of Effect

    DGR_Regn_Dt

    char(8)1

    The date the registration comes into effect

    Date when the organisation registration becomes effective.

    OrganisationDetails.OrganisationRegistrationStart.DateExternal Link

    Fund Cancellation Date of Effect

    DGR_Cancn_Dt

    char(8)1

    The date the registration ceases to be effective

    Date when the organisation registration becomes non effective.

    OrganisationDetails.OrganisationRegistrationEnd.DateExternal 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. You may need to change the date format to one that suits your applications.

    • Last modified: 04 Mar 2015QC 582