Table: GSH_PRD_TRADE_FWD_EXPOSURE

GSH_PRD_TRADE_FWD_EXPOSURE

Name

GSH_PRD_TRADE_FWD_EXPOSURE

Comment

The purpose of the Prudential Exposure report is to provide organisations with daily estimates of their market exposure. The report also contains details of their bank guarantees and security deposits as well as their outstanding amounts for all settlement runs included in the prudential run. The Trade Forward Exposure subreport provides a summary of forward exposure amounts for the organisation by product location by gas day.


Primary Key Columns

Name

GAS_DATE

ORGANISATION_CODE

PRODUCT_LOCATION

PRUDENTIAL_DATETIME

PRUDENTIAL_RUN_ID


Content

Name

Data Type

Mandatory

Comment

ORGANISATION_CODE

VARCHAR2(20)

X

The unique code for the organisation

PRUDENTIAL_RUN_ID

NUMBER(4,0)

X

The run number of the prudential run.

PRUDENTIAL_DATETIME

DATE

X

The date and time of the prudential run

GAS_DATE

DATE

X

The gas day

PRODUCT_LOCATION

VARCHAR2(80)

X

The product location for the Gas Supply Hub market

ORGANISATION_NAME

VARCHAR2(80)

 

The name of the organisation

TRADES_FORWARD_EXP_AMT_NET_GST

NUMBER(18,8)

 

The sum of all trades forward exposure amounts allocated to the organisation on this gas day – exclusive of the trades forward exposure GST amount

TRADES_FORWARD_EXP_GST_AMT

NUMBER(18,8)

 

The total amount of GST for the trades forward exposure

BUY_ORDER_QUANTITY

NUMBER(18,8)

 

The total quantity for positively-valued orders

BUY_TRADE_QUANTITY

NUMBER(18,8)

 

The total quantity for positively-valued trades

SELL_ORDER_QUANTITY

NUMBER(18,8)

 

The total quantity for negatively-valued orders

SELL_TRADE_QUANTITY

NUMBER(18,8)

 

The total quantity for negatively-valued trades

BUY_LOAD_WEIGHTED_AVG_PRICE

NUMBER(18,8)

 

The load weighted average price for all positively-valued orders and trades

SELL_LOAD_WEIGHTED_AVG_PRICE

NUMBER(18,8)

 

The load weighted average price for all negatively-valued trades