Table: RESIDUE_TRK

RESIDUE_TRK

Name

RESIDUE_TRK

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.


Description

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.


Primary Key Columns

Name

AUCTIONID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

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)