Table: GAS_STORAGE_CAPACITY_TRANS

GAS_STORAGE_CAPACITY_TRANS

Name

GAS_STORAGE_CAPACITY_TRANS

Comment

Gas storage capacity transactions


Primary Key Columns

Name

TRADEID

VERSIONDATETIME


Content

Name

Data Type

Mandatory

Comment

TRADEID

NUMBER(20,0)

X

A unique AEMO defined Transaction Identifier

VERSIONDATETIME

DATE

X

Time a successful submission is accepted by AEMO systems

TRADEDATE

DATE

 

The date the transaction was entered into

FROMGASDATE

DATE

 

The start date of the transaction

TOGASDATE

DATE

 

The end date of the transaction

FACILITYID

NUMBER(20,0)

 

The gas storage facility ID for the facility by means of which the service is provided

PRIORITY

VARCHAR2(255)

 

The priority given to the service to which the transaction relates

MAXIMUMSTORAGEQUANTITY

NUMBER(18,3)

 

The storage capacity the subject of the transaction (in GJ)

INJECTIONCAPACITY

NUMBER(18,3)

 

The injection capacity (in GJ/day)

WITHDRAWALCAPACITY

NUMBER(18,3)

 

The withdrawal capacity (in GJ/day)

PRICE

NUMBER(18,3)

 

The transaction price (in $/GJ/day or where relevant, in $/GJ)

PRICESTRUCTURE

VARCHAR2(255)

 

The price structure applicable to the transaction

PRICEESCALATIONMECHANISM

VARCHAR2(255)

 

Any price escalation mechanism applicable to the transaction

CANCELLED

NUMBER(1,0)

 

Whether the record has been cancelled

LASTCHANGED

DATE

 

The date the record was last updated