Table: GSH_PRD_AUCT_FWD_EXPOSURE

GSH_PRD_AUCT_FWD_EXPOSURE

Name

GSH_PRD_AUCT_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 Auction Forward Exposure subreport provides a summary of auction forward exposure amounts for the organisation by gas day.


Primary Key Columns

Name

GAS_DATE

ORGANISATION_CODE

PRUDENTIAL_DATETIME

PRUDENTIAL_RUN_ID


Content

Name

Data Type

Mandatory

Comment

MARKET_ID

VARCHAR2(20)

 

Unique Market ID

ORGANISATION_CODE

VARCHAR2(20)

X

The unique code for the organisation.

ORGANISATION_NAME

VARCHAR2(80)

 

The name of 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. Disregard the time component as this is not applicable.

BIDS_FORWARD_EXP_AMT_NET_GST

NUMBER(18,8)

 

The sum of all day ahead auction bids forward exposure amounts allocated to the organisation on this gas day—exclusive of the bids forward exposure GST amount.

BIDS_FORWARD_EXP_GST_AMT

NUMBER(18,8)

 

The total amount of GST for the day ahead auction bids forward exposure.

BID_QUANTITY

NUMBER(18,8)

 

The total quantity for auction bids.