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.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


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)