Table: RESIDUEFILETRK

RESIDUEFILETRK

Name

RESIDUEFILETRK

Comment

RESIDUEFILETRK records all Settlement Residue Auction offers submitted by participants.


Description

RESIDUEFILETRK data is confidential to each participant

Source

RESIDUEFILETRK updates are ad hoc from participants

Volume

Assuming quarterly contracts RESIDUEFILETRK contains a maximum of 5,000 records per annum.

Each bid file can contain many bids for each auction. Participants can input multiple bids (with the last acknowledged file being used in the auction).


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

AUCTIONID

LOADDATE

PARTICIPANTID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTID

VARCHAR2(30)

 

SRA ContractID

PARTICIPANTID

VARCHAR2(10)

X

Participant Identifier

LOADDATE

DATE

X

Date-Time SRA offer was loaded

FILENAME

VARCHAR2(40)

 

SRA offer file name

ACKFILENAME

VARCHAR2(40)

 

SRA acknowledgment file name

STATUS

VARCHAR2(10)

 

Load status [SUCCESSFUL/CORRUPT]

LASTCHANGED

DATE

 

Last date and time record changed

AUCTIONID

VARCHAR2(30)

X

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