RESIDUE_TRK
RESIDUE_TRK supports the Settlement Residue Auction, by showing the tracking records for different residue auction runs. RESIDUE_TRK joins to RESIDUE_PUBLIC_DATA and RESIDUE_CON_DATA.
Package
IRAUCTION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| VERSIONNO |
numeric(3, 0)  |
smallint |
Contract run version |
| 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 identifier |
| RUNDATE |
datetime(3) |
datetime2(0) |
Date auction results determined |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Date results published |
| AUTHORISEDBY |
varchar(15) |
varchar(15) |
Authorising officer or process |
| POSTDATE |
datetime(3) |
datetime2(0) |
Date the run is authorised |
| POSTEDBY |
varchar(15) |
varchar(15) |
Name of authorising officer or process |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| STATUS |
varchar(15) |
varchar(15) |
Load status [SUCCESSFUL/CORRUPT] |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_TRK_PK |
clustered, unique, primary key |
AUCTIONID, VERSIONNO |
| RESIDUETRK_NDX_LCHD |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_RESIDUE_TRK_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_RESIDUE_TRK |
clustered, unique, primary key |
AUCTIONID, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| RESIDUE_TRK_PK |
clustered, unique, primary key |
AUCTIONID, VERSIONNO |
| RESIDUETRK_NDX_LCHD |
nonclustered |
LASTCHANGED |