|
Name |
|
|
Comment |
RESIDUEFILETRK records all Settlement Residue Auction offers submitted by participants. |
|
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). |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private |
|
Name |
|
AUCTIONID |
|
LOADDATE |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
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) |
|
|
|