|
Name |
|
|
Comment |
AUCTION_REVENUE_ESTIMATE supports the Settlement Residue Auction, by holding the evaluator’s estimates of revenue for each month of a given quarter. |
|
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. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
CONTRACTYEAR |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
MONTHNO |
|
QUARTER |
|
VALUATIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|