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