Table: GSH_SUPP_AUCTION_QUANTITIES

GSH_SUPP_AUCTION_QUANTITIES

Name

GSH_SUPP_AUCTION_QUANTITIES

Comment

Details of Auction Quantities won used in Settlements


Primary Key Columns

Name

AUCTION_TRANSACTION_ID

PARTICIPANT_CODE

SETTLEMENT_RUN_ID


Content

Name

Data Type

Mandatory

Comment

MARKET_ID

VARCHAR2(20)

 

Unique Market ID

SETTLEMENT_RUN_ID

NUMBER(18,0)

X

The unique identifier for the settlement run.

BILLING_PERIOD

VARCHAR2(20)

 

The billing period for the settlement run.

PARTICIPANT_CODE

VARCHAR2(20)

X

The participant code.

GAS_DATE

DATE

 

The gas date when the quantity is delivered. Disregard the time component as this is not applicable.

AUCTION_TRANSACTION_ID

NUMBER(12,0)

X

The unique identifier of the auction transaction included in the settlement run.

AUCTION_QUANTITY

NUMBER(10,0)

 

The initial capacity quantity won at auction.

REVISED_AUCTION_QUANTITY

NUMBER(10,0)

 

The actual auction quantity in GJ. This is based on the revised quantity reported by facility operators on D+1.

PRODUCT_PRICE

NUMBER(18,8)

 

The price of the auction product won at auction ($/GJ) by the participant.