AUCTION_IC_ALLOCATIONS
AUCTION_IC_ALLOCATIONS supports the Settlement Residue Auction by providing the basis for setting up contracts for individual tranches. AUCTION_IC_ALLOCATIONS shows the default definitions for the total number of units and proportion applicable to each directional interconnector for a specified auction quarter.
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 takes precedence |
| INTERCONNECTORID |
varchar(10) |
varchar(10) |
Contracted Interconnector Identifier |
| FROMREGIONID |
varchar(10) |
varchar(10) |
Nominated source region for Interconnector |
| MAXIMUMUNITS |
numeric(5, 0) |
smallint |
Number of units on the interconnector |
| PROPORTION |
numeric(8, 5) |
numeric(8, 5) |
Percentage of the total residue for each Unit |
| AUCTIONFEE |
numeric(17, 5) |
numeric(17, 5) |
Daily auction fee |
| CHANGEDATE |
datetime(3) |
datetime2(0) |
Authorisation date |
| CHANGEDBY |
varchar(15) |
varchar(15) |
Name of person authorising this data set |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| AUCTIONFEE_SALES |
numeric(18, 8) |
numeric(18, 8) |
Fees for Cancelled Units. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AUCTION_IC_ALLOCATIONS_LCX |
nonclustered |
LASTCHANGED |
| AUCTION_IC_ALLOCATIONS_PK |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, VERSIONNO, INTERCONNECTORID, FROMREGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_AUCTION_IC_ALLOCATIONS_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_AUCTION_IC_ALLOCATIONS |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, VERSIONNO, INTERCONNECTORID, FROMREGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| AUCTION_IC_ALLOCATIONS_LCX |
nonclustered |
LASTCHANGED |
| AUCTION_IC_ALLOCATIONS_PK |
clustered, unique, primary key |
CONTRACTYEAR, QUARTER, VERSIONNO, INTERCONNECTORID, FROMREGIONID |