SRA_FINANCIAL_AUCPAY_DETAIL
Records details of the SRA financial auction payment.
Package
IRAUCTION
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SRA_YEAR |
numeric(4, 0)  |
smallint |
Year of the Tranche |
| SRA_QUARTER |
numeric(3, 0) |
smallint |
Relevant Quarter of the Tranche |
| SRA_RUNNO |
numeric(3, 0) |
smallint |
SRA Run Number |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Unique participant identifier |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
The identifier for the Directional Interconnector |
| FROMREGIONID |
varchar(10) |
varchar(10) |
The source Region identifier for the Directional Interconnector |
| CONTRACTID |
varchar(10) |
varchar(10) |
The SRA contract identifier |
| MAXIMUM_UNITS |
numeric(18, 8) |
numeric(18, 8) |
The Maximum Units Available for purchase in the Auction |
| UNITS_SOLD |
numeric(18, 8) |
numeric(18, 8) |
The total number of Allocated Units in the Auction, including Cancelled Units by an Auction Participant |
| SHORTFALL_UNITS |
numeric(18, 8) |
numeric(18, 8) |
The total number of units unpaid for in the auction |
| RESERVE_PRICE |
numeric(18, 8) |
numeric(18, 8) |
The reserve price of the auction |
| CLEARING_PRICE |
numeric(18, 8) |
numeric(18, 8) |
The Market Clearing Price of the Auction |
| PAYMENT_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The payment amount owed by AEMO before shortfall |
| SHORTFALL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The shortfall amount |
| ALLOCATION |
numeric(18, 8) |
numeric(18, 8) |
The percentage of the auction proceeds allocated to the TNSP on the directional link |
| NET_PAYMENT_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The payment amount owed by AEMO, including shortfall |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The date and time this record was last modified |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_FINANCIAL_AUCPAY_DETAIL_PK |
clustered, unique, primary key |
SRA_YEAR, SRA_QUARTER, SRA_RUNNO, PARTICIPANTID, INTERCONNECTORID, FROMREGIONID, CONTRACTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SRA_FINANCIAL_AUCPAY_DETAIL |
clustered, unique, primary key |
SRA_YEAR, SRA_QUARTER, SRA_RUNNO, PARTICIPANTID, INTERCONNECTORID, FROMREGIONID, CONTRACTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_FINANCIAL_AUCPAY_DETAIL_PK |
clustered, unique, primary key |
SRA_YEAR, SRA_QUARTER, SRA_RUNNO, PARTICIPANTID, INTERCONNECTORID, FROMREGIONID, CONTRACTID |