Name |
|
Comment |
RESIDUE_TRK supports the Settlement Residue Auction, by showing the tracking records for different residue auction runs. RESIDUE_TRK joins to RESIDUE_PUBLIC_DATA and RESIDUE_CON_DATA. |
Source RESIDUE_TRK updates whenever Settlement Residue Auctions are run and the results published (i.e. quarterly). The RESIDUE_TRK data is available to all participants post the associated auction date. Volume Assuming quarterly contracts, RESIDUE_TRK shows a maximum of 50 records per year. |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Public |
Name |
AUCTIONID |
VERSIONNO |
Name |
LASTCHANGED |
Name |
Data Type |
Mandatory |
Comment |
CONTRACTID |
VARCHAR2(30) |
|
SRA Contract identifier |
VERSIONNO |
NUMBER(3,0) |
X |
Contract run version |
RUNDATE |
DATE |
|
Date auction results determined |
AUTHORISEDDATE |
DATE |
|
Date results published |
AUTHORISEDBY |
VARCHAR2(15) |
|
Authorising officer or process |
POSTDATE |
DATE |
|
Date the run is authorised |
POSTEDBY |
VARCHAR2(15) |
|
Name of authorising officer or process |
LASTCHANGED |
DATE |
|
Last date and time record changed |
STATUS |
VARCHAR2(15) |
|
Load status [SUCCESSFUL/CORRUPT] |
AUCTIONID |
VARCHAR2(30) |
X |
Unique id for each auction date. (new in March 2003 to support SRA Inter-Temporal Linking) |
|
|
|