Table: AUCTION_REVENUE_TRACK

AUCTION_REVENUE_TRACK

Name

AUCTION_REVENUE_TRACK

Comment

AUCTION_REVENUE_TRACK supports the Settlement Residue Auction, by holding the tracking information for each evaluator’s estimates for a given quarter. The status field is dynamic and is used for selection of estimates to be published.


Description

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

Source

Updates are quarterly after SRA team updates SRIS interface.

Volume

AUCTION_REVENUE_TRACK contains a maximum of 100 records per year.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

CONTRACTYEAR

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

EFFECTIVEDATE

DATE

 

Date from which the record change is applicable

STATUS

VARCHAR2(10)

 

Internal use

DOCUMENTREF

VARCHAR2(30)

 

Reference to methodology document

AUTHORISEDDATE

DATE

 

Date of authorisation for this record

AUTHORISEDBY

VARCHAR2(15)

 

Name of person authorising this record

LASTCHANGED

DATE

 

Date and time this record was last changed