Table: AUCTION_REVENUE_ESTIMATE

AUCTION_REVENUE_ESTIMATE

Name

AUCTION_REVENUE_ESTIMATE

Comment

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.


Description

AUCTION_REVENUE_ESTIMATE is public data, and is available to all participants.

Source

Updates are quarterly from SRA team via SRIS interface

Volume

AUCTION_REVENUE_ESTIMATE contains a maximum of 300 records per year.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

CONTRACTYEAR

FROMREGIONID

INTERCONNECTORID

MONTHNO

QUARTER

VALUATIONID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

SRA Contracted Year

QUARTER

NUMBER(1,0)

X

SRA Contracted Quarter

VALUATIONID

VARCHAR2(15)

X

Identifier of the estimator

VERSIONNO

NUMBER(3,0)

X

Version of data for other key data - a higher version for same key data will take precedence

INTERCONNECTORID

VARCHAR2(10)

X

Contracted Interconnector

FROMREGIONID

VARCHAR2(10)

X

Nominated source region for Interconnector

MONTHNO

NUMBER(1,0)

X

Month number within quarter (1..3)

STARTDATE

DATE

 

First day of month as date

ENDDATE

DATE

 

Last day of month as date

REVENUE

NUMBER(17,5)

 

Estimated Revenue

LASTCHANGED

DATE

 

Last date and time record changed