Table: GSH_SUPP_CAPACITY_VARIANCE

GSH_SUPP_CAPACITY_VARIANCE

Name

GSH_SUPP_CAPACITY_VARIANCE

Comment

The Delivery Variance subreport provides a breakdown of total capacity variance payments and charges included in the settlement run per gas day, note that total payments and total charges are listed separately for each gas day


Primary Key Columns

Name

GAS_DATE

PARTICIPANT_CODE

SETTLEMENT_RUN_ID

TYPE


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

X

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

TYPE

VARCHAR2(20)

X

Type of the capacity variance amount whether it is a charge or a payment.

AMOUNT

NUMBER(18,8)

 

Total amount of trading charge or payment for the gas date excluding GST.

GST_AMOUNT

NUMBER(18,8)

 

Total amount of GST on the capacity variance payment or charge for the gas date.