Table: AUCTION_RP_ESTIMATE

AUCTION_RP_ESTIMATE

Name

AUCTION_RP_ESTIMATE

Comment

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.


Description

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

Source

Updates are quarterly by SRA team via SRIS interface.

Volume

This view contains a maximum of 100 records per year.


Primary Key Columns

Name

CONTRACTYEAR

FROMREGIONID

INTERCONNECTORID

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 takes precedence

INTERCONNECTORID

VARCHAR2(10)

X

Contracted Interconnector

FROMREGIONID

VARCHAR2(10)

X

Nominated source region for Interconnector

RPESTIMATE

NUMBER(17,5)

 

Estimate of reserve price

LASTCHANGED

DATE

 

Last date and time record was changed