|
Name |
|
|
Comment |
Consolidated list of all secondary capacity trades which includes GSH trades (screen traded and off-market trades) and Bilateral trades submitted into the GBB |
|
Name |
|
TRANSACTION_ID |
|
VERSION_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
TRANSACTION_ID |
VARCHAR2(50) |
X |
Unique capacity transaction id |
|
VERSION_DATETIME |
DATE |
X |
Updated version within transaction id |
|
TRADE_DATE |
DATE |
|
The date the trade was made. Disregard the time component as this is not applicable. |
|
FROM_GAS_DATE |
DATE |
|
The effective start date of the trade. Disregard the time component as this is not applicable. |
|
TO_GAS_DATE |
DATE |
|
The effective end date of the trade. Disregard the time component as this is not applicable. |
|
TRADE_TYPE |
VARCHAR2(30) |
|
The type of trade |
|
FACILITY_ID |
NUMBER(10,0) |
|
The unique identifier of the Part 24 facility. Mandatory for facilities registered under Part 24 of the rules. |
|
FACILITY_NAME |
VARCHAR2(100) |
|
The descriptive name of the facility. |
|
TRANSPORTATION_SERVICE_TYPE |
VARCHAR2(12) |
|
The transportation service type |
|
FLOW_DIRECTION |
VARCHAR2(20) |
|
The direction of the flow for non-Part 24 facilities, relative to the general physical direction of the facility. Valid values are:NORTHNORTH_EASTNORTH_WESTEASTSOUTH_EASTSOUTHSOUTH_WESTWEST |
|
RECEIPT_ZONE_ID |
NUMBER(10,0) |
|
The unique identifier of the Part 24 Receipt Zone. This is the zone in which the receipt point that was reported to AEMO is specified. Mandatory for service points registered under Part 24 of the rules. |
|
RECEIPT_ZONE_NAME |
VARCHAR2(255) |
|
The descriptive name of the Receipt Zone. |
|
DELIVERY_ZONE_ID |
NUMBER(10,0) |
|
The unique identifier of the Part 24 Delivery Zone. This is the zone in which the delivery point that was reported to AEMO is specified. Mandatory for service points registered under Part 24 of the rules. |
|
DELIVERY_ZONE_NAME |
VARCHAR2(255) |
|
The descriptive name of the Delivery Zone. |
|
PARK_LOAN_POINT_ID |
NUMBER(10,0) |
|
The unique identifier of the Part 24 Park and Loan service point. Mandatory for service points registered under Part 24 of the rules. |
|
PARK_LOAN_POINT_NAME |
VARCHAR2(255) |
|
The descriptive name of the service point. |
|
STANDARD_OTSA |
VARCHAR2(255) |
|
Flag to indicate whether a standard OTSA was used |
|
PRIORITY |
VARCHAR2(255) |
|
The priority of the traded capacity. Mandatory for GBB bilateral trades. Null for GSH trades. |
|
MAX_DAILY_QUANTITY |
NUMBER(10,0) |
|
The traded maximum daily quantity (MDQ) (GJ/day). |
|
MAX_HOURLY_QUANTITY |
NUMBER(10,0) |
|
The traded maximum hourly quantity (GJ/hour). Null for GSH trades. |
|
PRICE |
NUMBER(18,8) |
|
The price of the traded capacity ($/GJ/day). |
|
PRICE_STRUCTURE |
VARCHAR2(255) |
|
The price structure applied over the term of the trade. Mandatory for GBB bilateral trades. Null for GSH trades. |
|
PRICE_ESCALATION_MECHANISM |
VARCHAR2(255) |
|
The price escalation mechanism applied over the term of the trade. Null for GSH trades. |
|
LASTCHANGED |
DATE |
|
The date and time the report was generated. |
|
|
|