INTERCONNECTORALLOC

INTERCONNECTORALLOC shows allocations of interconnector residues to Network Service Providers.

Package

MARKET_CONFIG

Visibility

Private

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
EFFECTIVEDATE	datetime(3)	datetime2(0)	Effective Date of Allocation Details
VERSIONNO	numeric(5, 0)	smallint	Version No in respect to effective date
INTERCONNECTORID	varchar(10)	varchar(10)	Interconnector identifier
REGIONID	varchar(10)	varchar(10)	Region Identifier
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
ALLOCATION	numeric(12, 5)	numeric(12, 5)	Allocation % / 100
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
INTERCONNECTORALLOC_LCX	nonclustered	LASTCHANGED
INTERCONNECTORALLOC_PK	clustered, unique, primary key	EFFECTIVEDATE, VERSIONNO, INTERCONNECTORID, REGIONID, PARTICIPANTID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_INTERCONNECTORALLOC_LASTCHANGED	nonclustered	LASTCHANGED
PK_INTERCONNECTORALLOC	clustered, unique, primary key	EFFECTIVEDATE, VERSIONNO, INTERCONNECTORID, REGIONID, PARTICIPANTID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
INTERCONNECTORALLOC_LCX	nonclustered	LASTCHANGED
INTERCONNECTORALLOC_PK	clustered, unique, primary key	EFFECTIVEDATE, VERSIONNO, INTERCONNECTORID, REGIONID, PARTICIPANTID