|
Name |
|
|
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. |
|
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. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
CONTRACTYEAR |
|
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 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 |
|
|
|