Table: GSH_SUPP_CAPACITY_TRANSFERS

GSH_SUPP_CAPACITY_TRANSFERS

Name

GSH_SUPP_CAPACITY_TRANSFERS

Comment

Provides a list of all individual capacity transfer records included in the settlement run.


Primary Key Columns

Name

CAPACITY_TRANSFER_ID

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)

 

The participant code.

GAS_DATE

DATE

 

The gas date for the capacity variance payment or charge. Disregard the time component as this is not applicable.

CAPACITY_TRANSFER_ID

VARCHAR2(20)

X

The unique identifier of the capacity transfer record included in the settlement run.

TRADE_SIDE

VARCHAR2(20)

 

This field specified whether the participant was the buyer or the seller in the trade.

CAPACITY_QUANTITY

NUMBER(18,8)

 

The initial capacity quantity transfer in GJ

CONFIRMED_CAPACITY_QUANTITY

NUMBER(18,8)

 

The confirmed capacity quantity in GJ.

INVALID_QUANTITY

NUMBER(18,8)

 

Invalid quantity to indicate the amount of a short sell or amount that a buyer could not accept due to incorrect contract.