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