SRA_FINANCIAL_AUC_RECEIPTS
Records details of the Cancelled Units and their value for the Auction Participant.
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 |
| UNITS_PURCHASED |
numeric(18, 8) |
numeric(18, 8) |
The number of units purchased |
| CLEARING_PRICE |
numeric(18, 8) |
numeric(18, 8) |
The clearing price of the auction |
| RECEIPT_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The payment amount owed to AEMO |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
The last changed date for the record |
| PROCEEDS_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
Dollar value of Cancelled Units in the Auction for the Auction Participant |
| UNITS_SOLD |
numeric(18, 8) |
numeric(18, 8) |
Units cancelled in the auction by the Auction participant. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_FINANCIAL_AUC_RECEIPTS_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_AUC_RECEIPTS |
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_AUC_RECEIPTS_PK |
clustered, unique, primary key |
SRA_YEAR, SRA_QUARTER, SRA_RUNNO, PARTICIPANTID, INTERCONNECTORID, FROMREGIONID, CONTRACTID |