Table: GSH_PARTICIPANTS

GSH_PARTICIPANTS

Name

GSH_PARTICIPANTS

Comment

The report contains the registration details of all participants currently registered in the GSH market.


Primary Key Columns

Name

MARKET_ID

PARTICIPANT_ID


Content

Name

Data Type

Mandatory

Comment

PARTICIPANT_ID

VARCHAR2(20)

X

The unique identifier of the participant

PARTICIPANT_CODE

VARCHAR2(20)

 

The participant code

ORGANISATION_NAME

VARCHAR2(80)

 

Name of the organisation who has the ABN

ORGANISATION_CODE

VARCHAR2(20)

 

Unique code of the organisation

TRADING_NAME

VARCHAR2(80)

 

Trading name of the organisation

HEAD_OFFICE_ADDRESS_LINE_1

VARCHAR2(80)

 

The head office address of the organisation

HEAD_OFFICE_ADDRESS_LINE_2

VARCHAR2(80)

 

The head office address of the organisation

HEAD_OFFICE_ADDRESS_LINE_3

VARCHAR2(80)

 

The head office address of the organisation

HEAD_OFFICE_ADDRESS_LINE_4

VARCHAR2(80)

 

The head office address of the organisation

PHONE_NUMBER

VARCHAR2(80)

 

The phone number of the organisation

FAX_NUMBER

VARCHAR2(80)

 

The fax number for the organisation

ABN

VARCHAR2(20)

 

ABN of the organisation

ARBN

VARCHAR2(20)

 

ARBN of the organisation

ACN

VARCHAR2(20)

 

ACN of the organisation

CLASSIFICATIONS

VARCHAR2(255)

 

The classification of the company in the GSH market, for example trading, view-only, etc.

LASTCHANGED

DATE

 

The date and time the report is generated

MARKET_ID

VARCHAR2(20)

X

The market in which the company is a participant, for example GSH, DAA, ALL.

AGENT_ID

VARCHAR2(20)

 

The unique participant identifier of the agent appointed to trade on the participant’s behalf.

AGENT_NAME

VARCHAR2(80)

 

Name of the agent organisation