AUCTION_TRANCHE
AUCTION_TRANCHE supports the Settlement Residue Auction, by holding the default definitions for the percentage number of units allocated and dates applicable to each tranche for a specified auction quarter. This information provides the basis for setting up contracts for individual tranches.
Package
IRAUCTION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| CONTRACTYEAR |
numeric(4, 0)  |
smallint |
SRA Contracted Year |
| QUARTER |
numeric(1, 0) |
tinyint |
SRA Contracted Quarter |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version of data for other key data - a higher version for same key data will take precedence |
| TRANCHE |
numeric(2, 0) |
tinyint |
Label identifying the arbitrary segmented share of the Interconnector flow |
| AUCTIONDATE |
datetime(3) |
datetime2(0) |
Default date of the auction |
| NOTIFYDATE |
datetime(3) |
datetime2(0) |
Default date participants notified of details |
| UNITALLOCATION |
numeric(18, 8) |
numeric(18, 8) |
Percentage of units allocated to the tranche |
| CHANGEDATE |
datetime(3) |
datetime2(0) |
Date of changing this record |
| CHANGEDBY |
varchar(15) |
varchar(15) |
Name of person who changed this record |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date and time record was last changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AUCTION_TRANCHE_LCX |
nonclustered |
LASTCHANGED |
| AUCTION_TRANCHE_PK |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, VERSIONNO, TRANCHE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_AUCTION_TRANCHE_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_AUCTION_TRANCHE |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, VERSIONNO, TRANCHE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AUCTION_TRANCHE_LCX |
nonclustered |
LASTCHANGED |
| AUCTION_TRANCHE_PK |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, VERSIONNO, TRANCHE |