AUCTION_RP_ESTIMATE
AUCTION_RP_ESTIMATE supports the Settlement Residue Auction, by holding the evaluator's estimates of revenue prices for a given quarter. Since reserve prices are no longer applicable from the end of 2001, zero is used as a default to avoid rewriting the system.
Package
IRAUCTION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
SRA Contracted Year |
| QUARTER |
numeric(1, 0) |
tinyint |
SRA Contracted Quarter |
| VALUATIONID |
varchar(15) |
varchar(15) |
Identifier of the estimator |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version of data for other key data - a higher version for same key data takes precedence |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Contracted Interconnector |
| FROMREGIONID |
varchar(10) |
varchar(10) |
Nominated source region for Interconnector |
| RPESTIMATE |
numeric(17, 5) |
numeric(17, 5) |
Estimate of reserve price |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record was changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AUCTION_RP_ESTIMATE_LCX |
nonclustered |
LASTCHANGED |
| AUCTION_RP_ESTIMATE_PK |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, VALUATIONID, VERSIONNO, INTERCONNECTORID, FROMREGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_AUCTION_RP_ESTIMATE_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_AUCTION_RP_ESTIMATE |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, VALUATIONID, VERSIONNO, INTERCONNECTORID, FROMREGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AUCTION_RP_ESTIMATE_LCX |
nonclustered |
LASTCHANGED |
| AUCTION_RP_ESTIMATE_PK |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, VALUATIONID, VERSIONNO, INTERCONNECTORID, FROMREGIONID |