SRA_FINANCIAL_AUCPAY_SUM
Records a summary of the Auction payment amount.
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 |
| GROSS_PROCEEDS_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The total auction proceeds allocated to the TNSP |
| TOTAL_GROSS_PROCEEDS_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The total auction proceeds allocated to all TNSPs in the SRA quarter |
| SHORTFALL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The shortfall amount for in the SRA Quarter for the TNSP |
| TOTAL_SHORTFALL_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The total shortfall amount for in the SRA Quarter for all TNSPs |
| NET_PAYMENT_AMOUNT |
numeric(18, 8) |
numeric(18, 8) |
The net payment amount owed by AEMO to the TNSP |
| 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_SUM_PK |
clustered, unique, primary key |
SRA_YEAR, SRA_QUARTER, SRA_RUNNO, PARTICIPANTID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_SRA_FINANCIAL_AUCPAY_SUM |
clustered, unique, primary key |
SRA_YEAR, SRA_QUARTER, SRA_RUNNO, PARTICIPANTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| SRA_FINANCIAL_AUCPAY_SUM_PK |
clustered, unique, primary key |
SRA_YEAR, SRA_QUARTER, SRA_RUNNO, PARTICIPANTID |