Table: RESIDUE_BID_TRK

RESIDUE_BID_TRK

Name

RESIDUE_BID_TRK

Comment

RESIDUE_BID_TRK supports the Settlement Residue Auction, by detailing which bid was used for which SRA Contract run.


Description

Source

RESIDUE_BID_TRK updates are usually quarterly from participants before an Auction.

RESIDUE_BID_TRK data is confidential to the relevant participant.

RESIDUE_BID_TRK excludes contracts and versions without a valid publication date (i.e invalid bids are ignored).

Volume

Assuming monthly contracts, RESIDUE_BID_TRK shows a maximum of 500 records per year.


Primary Key Columns

Name

AUCTIONID

PARTICIPANTID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(30)

 

SRA Contract unique identifier

VERSIONNO

NUMBER(3,0)

X

Version of Bid used

PARTICIPANTID

VARCHAR2(10)

X

Identifier of participant

BIDLOADDATE

DATE

 

Date and time bid used

LASTCHANGED

DATE

 

Date and time this record was last changed

AUCTIONID

VARCHAR2(30)

X

Unique id for each auction date. (new in March 2003 to support SRA Inter-Temporal Linking)