Name |
|
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. |
Name |
GAS_DATE |
ORGANISATION_CODE |
PRODUCT_LOCATION |
PRUDENTIAL_DATETIME |
PRUDENTIAL_RUN_ID |
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 |
|
|
|