SRA_PRUDENTIAL_EXPOSURE
Records details of the Prudential Exposure of an SRA Auction Participant.
Package
IRAUCTION
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PRUDENTIAL_DATE |
datetime(3)  |
datetime2(0) |
The prudential date of the run. |
| PRUDENTIAL_RUNNO |
numeric(8, 0) |
int |
The run number for the prudential date. |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Unique participant identifier |
| SRA_YEAR |
numeric(4, 0) |
smallint |
AEMO Contract Year number starting the week beginning 1 January |
| SRA_QUARTER |
numeric(3, 0) |
smallint |
Contract Relevant Quarter |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
The identifier for the Directional Interconnector |
| FROMREGIONID |
varchar(10) |
varchar(10) |
The source Region identifier for the Directional Interconnector |
| MAX_TRANCHE |
numeric(2, 0) |
smallint |
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 |
varchar(30) |
varchar(30) |
Unique identifier for the Auction having the Offer. Has a null value when no Offer is made for the Relevant Quarter |
| OFFER_SUBMISSIONTIME |
datetime(3) |
datetime2(0) |
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 |
numeric(18, 8) |
numeric(18, 8) |
Calculated Average Purchase Price for the Product |
| AVERAGE_CANCELLATION_PRICE |
numeric(18, 8) |
numeric(18, 8) |
Calculated average cancellation price for product. |
| CANCELLATION_VOLUME |
numeric(18, 8) |
numeric(18, 8) |
Calculated cancellation volume for product. |
| TRADING_POSITION |
numeric(18, 8) |
numeric(18, 8) |
Calculated trading position for product. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_PRUDENTIAL_EXPOSURE_PK |
clustered, unique, primary key |
PRUDENTIAL_DATE, PRUDENTIAL_RUNNO, PARTICIPANTID, SRA_YEAR, SRA_QUARTER, INTERCONNECTORID, FROMREGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SRA_PRUDENTIAL_EXPOSURE |
clustered, unique, primary key |
PRUDENTIAL_DATE, PRUDENTIAL_RUNNO, PARTICIPANTID, SRA_YEAR, SRA_QUARTER, INTERCONNECTORID, FROMREGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_PRUDENTIAL_EXPOSURE_PK |
clustered, unique, primary key |
PRUDENTIAL_DATE, PRUDENTIAL_RUNNO, PARTICIPANTID, SRA_YEAR, SRA_QUARTER, INTERCONNECTORID, FROMREGIONID |