Associates file

Data file for associates details

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.

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.

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.

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.

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.

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.

Associate Family Name

Assoc_Fmly_Nm

varchar(40)

 

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

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.

# - 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
8 Jan 2018
ID
91