|
Name |
|
|
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 |
|
Name |
Comment |
Value |
|
Visibility |
Data confidentiality of this table |
Private |
|
Name |
|
FACILITY_ID |
|
PARTICIPANT_ID |
|
SERVICE_REFERENCE |
|
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. |
|
|
|