RESIDUEFILETRK
RESIDUEFILETRK records all Settlement Residue Auction offers submitted by participants.
Package
IRAUCTION
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PARTICIPANTID |
varchar(10)  |
varchar(10) |
Participant Identifier |
| LOADDATE |
datetime(3) |
datetime2(0) |
Date-Time SRA offer was loaded |
| AUCTIONID |
varchar(30) |
varchar(30) |
Unique id for each auction date. (new in March 2003 to support SRA Inter-Temporal Linking) |
| CONTRACTID |
varchar(30) |
varchar(30) |
SRA ContractID |
| FILENAME |
varchar(40) |
varchar(40) |
SRA offer file name |
| ACKFILENAME |
varchar(40) |
varchar(40) |
SRA acknowledgment file name |
| STATUS |
varchar(10) |
varchar(10) |
Load status [SUCCESSFUL/CORRUPT] |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUEFILETRK_NDX_LCHD |
nonclustered |
LASTCHANGED |
| RESIDUEFILETRK_PK |
clustered, unique, primary key |
AUCTIONID, PARTICIPANTID, LOADDATE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_RESIDUEFILETRK_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_RESIDUEFILETRK |
clustered, unique, primary key |
AUCTIONID, PARTICIPANTID, LOADDATE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUEFILETRK_NDX_LCHD |
nonclustered |
LASTCHANGED |
| RESIDUEFILETRK_PK |
clustered, unique, primary key |
AUCTIONID, PARTICIPANTID, LOADDATE |