RESIDUE_BID_TRK
RESIDUE_BID_TRK supports the Settlement Residue Auction, by detailing which bid was used for which SRA Contract run.
Package
IRAUCTION
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| VERSIONNO |
numeric(3, 0)  |
smallint |
Version of Bid used |
| PARTICIPANTID |
varchar(10) |
varchar(10) |
Identifier of participant |
| 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 Contract unique identifier |
| BIDLOADDATE |
datetime(3) |
datetime2(0) |
Date and time bid used |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date and time this record was last changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_BID_TRK_PK |
clustered, unique, primary key |
AUCTIONID, VERSIONNO, PARTICIPANTID |
| RESIDUEBID_NDX_LCHD |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_RESIDUE_BID_TRK_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_RESIDUE_BID_TRK |
clustered, unique, primary key |
AUCTIONID, VERSIONNO, PARTICIPANTID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_BID_TRK_PK |
clustered, unique, primary key |
AUCTIONID, VERSIONNO, PARTICIPANTID |
| RESIDUEBID_NDX_LCHD |
nonclustered |
LASTCHANGED |