Table: GSH_CONTRACT_DETAILS

GSH_CONTRACT_DETAILS

Name

GSH_CONTRACT_DETAILS

Comment

Provides participants with a list of all the facility operator service references and STTM contract references that are available to them for capacity trading


Primary Key Columns

Name

FACILITY_ID

PARTICIPANT_ID

SERVICE_REFERENCE


Content

Name

Data Type

Mandatory

Comment

PARTICIPANT_ID

VARCHAR2(20)

X

The unique AEMO defined GSH Participant identifier.

PARTICIPANT_NAME

VARCHAR2(80)

 

The descriptive name of the participant.

PARTICIPANT_CODE

VARCHAR2(20)

 

The participant code used in the ETS.

FACILITY_ID

NUMBER(8,0)

X

The unique facility identifier as defined in the Transportation Facility Register.

FACILITY_NAME

VARCHAR2(100)

 

The descriptive name of the facility as defined in the Transportation Facility Register.

SERVICE_REFERENCE

VARCHAR2(255)

X

The service reference issued by the facility operator.

SERVICE_REFERENCE_DESCRIPTION

VARCHAR2(255)

 

Brief description of the service reference.

STTM_CONTRACT_REFERENCE

VARCHAR2(255)

 

The STTM registered facility service identifier (CRN) associated with the service reference if applicable.

CONTRACT_TYPE

VARCHAR2(20)

 

Indicates if a contract can be used for capacity trades, auctions or both. For example, Trade, Auction or All.

START_DATE

DATE

 

Effective start date of the contract. Disregard the time component as this is not applicable.

END_DATE

DATE

 

Effective end date of the contract. Disregard the time component as this is not applicable.

LASTCHANGED

DATE

 

The date and time the report was generated.