Table: GAS_SEC_CAP_TRADES

GAS_SEC_CAP_TRADES

Name

GAS_SEC_CAP_TRADES

Comment

Information related to summary trading data, which is derived from a secondary pipeline capacity trading platform.


Primary Key Columns

Name

TradeId


Index Columns

Name

SubmittingCompanyId

VersionDateTime


Index Columns

Name

GasDate


Content

Name

Data Type

Mandatory

Comment

TradeId

VARCHAR2(40)

X

Unique identifier for the trade

SubmittingCompanyId

NUMBER(10,0)

 

Name of the company submitting the data to AEMO

VersionDateTime

DATE

 

Version timestamp of the record

FacilityId

NUMBER(10,0)

 

Unique facility Identifier

GasDate

DATE

 

Gas date

ReceiptLocation

NUMBER(10,0)

 

Connection Point ID that best represents the Receipt location

DeliveryLocation

NUMBER(10,0)

 

Connection Point ID that best represents the Delivery Location

NameplateCapacity

NUMBER(18,3)

 

Official pipeline capacity expressed in GJ

DailyNominations

NUMBER(18,3)

 

Daily aggregate quantity of gas (expressed in GJ) nominated for delivery from the pipeline

DailyUtilisationPercent

NUMBER(18,2)

 

Percentage of the pipeline capacity that is utilised per day

AvailableCapacity

NUMBER(18,3)

 

Operational capacity minus nominations each day. Expressed in GJ

CapacityOnOffer

NUMBER(18,3)

 

Sum of total capacity offered for sale expressed in GJ

DailyCapacityTraded

NUMBER(18,3)

 

Sum of total daily sold capacity expressed in GJ

DailyCapacity

NUMBER(18,3)

 

Operational capacity

ContractedCapacity

NUMBER(18,3)

 

Firm-forward, contracted pipeline capacity expressed in GJ.

AverageAnnualCapacityTraded

NUMBER(18,3)

 

Sum of total annual sold capacity divided by number of days, year to date. Expressed in GJ.

LastChanged

DATE

 

Last changed date for the record