• Associates file

    Field desription

    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.

    GovernmentGeneratedIdentifierExternal Link

    Associate Relationship Type

    Rltnshp_Cd

    varchar(3)

    Refer to Appendix D for further information

    The position or capacity that a person associated with the name occupies when performing an (official) act. For example, a director signing a report.

    PersonNameDetails.Position.TextExternal Link

    Associate Organisation Name

    Assoc_Org_Nm

    varchar(200)

    The Names of associates – for example, public officers, directors, partners or trustees associated with the entity

    The full name by which an organisation is known.

    OrganisationNameDetails.OrganisationalName.TextExternal Link

    Associate Name Title

    Assoc_Titl_Cd

    varchar(12)

    Refer to Appendix B for further information

    A term indicating a person's status or used as a form of address or reference.

    PersonNameDetails.Title.TextExternal Link

    Associate Given Name

    Assoc_Gvn_Nm

    varchar(40)

     

    The name given to a person that is that person's identifying name within the family group or the name by which the person is uniquely socially identified; the name borne by an individual, often assigned by his or her parents shortly after birth, as opposed to the inherited surname.

    PersonNameDetails.GivenName.TextExternal Link

    Associate Other Given Name

    Assoc_Othr_Gvn_Nms

    varchar(100)

     

    The middle name given to a person that complements that person's identifying name within the family group or the name by which the person is uniquely socially identified.

    PersonNameDetails.OtherGivenName.TextExternal Link

    Associate Family Name

    Assoc_Fmly_Nm

    varchar(40)

     

    The person's last name or surname. The name by which a family group is identified.

    PersonNameDetails.FamilyName.TextExternal Link

    Associate Suffix

    Assoc_Nm_Sufx_Cd

    char(5)

    Refer to Appendix C for further information

    Awards, Honours or any other kind of denominations that may follow the name of the person.

    PersonNameDetails.NameSuffix.TextExternal 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.

    • Last modified: 24 Feb 2015QC 578