AUCTION_REVENUE_ESTIMATE
AUCTION_REVENUE_ESTIMATE supports the Settlement Residue Auction, by holding the evaluator's estimates of revenue for each month of 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 will take precedence |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Contracted Interconnector |
| FROMREGIONID |
varchar(10) |
varchar(10) |
Nominated source region for Interconnector |
| MONTHNO |
numeric(1, 0) |
tinyint |
Month number within quarter (1..3) |
| STARTDATE |
datetime(3) |
datetime2(0) |
First day of month as date |
| ENDDATE |
datetime(3) |
datetime2(0) |
Last day of month as date |
| REVENUE |
numeric(17, 5) |
numeric(17, 5) |
Estimated Revenue |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AUCTION_REVENUE_ESTIMATE_LCX |
nonclustered |
LASTCHANGED |
| AUCTION_REVENUE_ESTIMATE_PK |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, VALUATIONID, VERSIONNO, INTERCONNECTORID, FROMREGIONID, MONTHNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_AUCTION_REVENUE_ESTIMATE_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_AUCTION_REVENUE_ESTIMATE |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, VALUATIONID, VERSIONNO, INTERCONNECTORID, FROMREGIONID, MONTHNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AUCTION_REVENUE_ESTIMATE_LCX |
nonclustered |
LASTCHANGED |
| AUCTION_REVENUE_ESTIMATE_PK |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, VALUATIONID, VERSIONNO, INTERCONNECTORID, FROMREGIONID, MONTHNO |