Table: SRA_PRUDENTIAL_EXPOSURE

SRA_PRUDENTIAL_EXPOSURE

Name

SRA_PRUDENTIAL_EXPOSURE

Comment

Records details of the Prudential Exposure of an SRA Auction Participant


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

FROMREGIONID

INTERCONNECTORID

PARTICIPANTID

PRUDENTIAL_DATE

PRUDENTIAL_RUNNO

SRA_QUARTER

SRA_YEAR


Content

Name

Data Type

Mandatory

Comment

PRUDENTIAL_DATE

DATE

X

The prudential date of the run.

PRUDENTIAL_RUNNO

NUMBER(8)

X

The run number for the prudential date.

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

SRA_YEAR

NUMBER(4)

X

AEMO Contract Year number starting the week beginning 1 January

SRA_QUARTER

NUMBER(3)

X

Contract Relevant Quarter

INTERCONNECTORID

VARCHAR2(10)

X

The identifier for the Directional Interconnector

FROMREGIONID

VARCHAR2(10)

X

The source Region identifier for the Directional Interconnector

MAX_TRANCHE

NUMBER(2)

 

The largest Tranche where the Unit was either sold or offered. Used in the calculation of the Average Purchase Price for the Trading Position of the Product. The most recent Tranche where Units were cancelled or offered (if the Offer is below the Average Purchase Price)

AUCTIONID

VARCHAR2(30)

 

Unique identifier for the Auction having the Offer. Has a null value when no Offer is made for the Relevant Quarter

OFFER_SUBMISSIONTIME

DATE

 

Timestamp of the Offer File submitted by the Auction Participant. Has a null value when no Offer is made for the Relevant Quarter

AVERAGE_PURCHASE_PRICE

NUMBER(18,8)

 

Calculated Average Purchase Price for the Product

AVERAGE_CANCELLATION_PRICE

NUMBER(18,8)

 

Calculated average cancellation price for product.

CANCELLATION_VOLUME

NUMBER(18,8)

 

Calculated cancellation volume for product.

TRADING_POSITION

NUMBER(18,8)

 

Calculated trading position for product.