Table: AUCTION_IC_ALLOCATIONS

AUCTION_IC_ALLOCATIONS

Name

AUCTION_IC_ALLOCATIONS

Comment

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.


Description

AUCTION_IC_ALLOCATIONS is public data, and is available to all participants.

Source

Updates are usually quarterly as auctions are held from Settlement Residue Auction team's SRIS interface.

Volume

AUCTION_IC_ALLOCATIONS contains a maximum of 100 records per year.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

CONTRACTYEAR

FROMREGIONID

INTERCONNECTORID

QUARTER

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

SRA Contracted Year

QUARTER

NUMBER(1,0)

X

SRA Contracted Quarter

VERSIONNO

NUMBER(3,0)

X

Version of data for other key data - a higher version for same key data takes precedence

INTERCONNECTORID

VARCHAR2(10)

X

Contracted Interconnector Identifier

FROMREGIONID

VARCHAR2(10)

X

Nominated source region for Interconnector

MAXIMUMUNITS

NUMBER(5,0)

 

Number of units on the interconnector

PROPORTION

NUMBER(8,5)

 

Percentage of the total residue for each Unit

AUCTIONFEE

NUMBER(17,5)

 

Daily auction fee

CHANGEDATE

DATE

 

Authorisation date

CHANGEDBY

VARCHAR2(15)

 

Name of person authorising this data set

LASTCHANGED

DATE

 

Last date and time record changed

AUCTIONFEE_SALES

Number(18,8)

 

Fees for Cancelled Units.