Table: GSH_CAPACITY_TRANSACTION

GSH_CAPACITY_TRANSACTION

Name

GSH_CAPACITY_TRANSACTION

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


Primary Key Columns

Name

TRANSACTION_ID

VERSION_DATETIME


Content

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.