PASAINTERCONNECTORSOLUTION (Historical table)

PASAINTERCONNECTORSOLUTION records ST PASA interconnector solutions for the latest period.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
INTERCONNECTORID	varchar(10)	varchar(10)	Interconnector Id
PERIODID	varchar(20)	varchar(20)	PASA Interval (48 half hours)
CASEID	varchar(20) (not nullable)	varchar(20) (not nullable)	PASA Case Identifier
CAPACITYMWFLOW	numeric(16, 6)	numeric(16, 6)	Capacity MW flow
CAPACITYMARGINALVALUE	numeric(16, 6)	numeric(16, 6)	Marginal value in capacity
CAPACITYVIOLATIONDEGREE	numeric(16, 6)	numeric(16, 6)	Violation value in capacity
EXCESSGENMWFLOW	numeric(16, 6)	numeric(16, 6)	Excess generation MW flow
EXCESSGENMARGINALVALUE	numeric(16, 6)	numeric(16, 6)	Marginal value in excess generation
EXCESSGENVIOLATIONDEGREE	numeric(16, 6)	numeric(16, 6)	Violation value in excess generation
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed
IMPORTLIMIT	numeric(15, 5)	numeric(15, 5)	Calculated import limit
EXPORTLIMIT	numeric(15, 5)	numeric(15, 5)	Calculated export limit
DATETIME	datetime(3)	datetime2(0)	Date and time of the end of the period

Official MMS data model indexes

Index name	Index type	Index columns (in order)
PASAINTERCONNECTORSOLUTIO_LCX	nonclustered	LASTCHANGED
PASAINTERCONNECTORSOLUTION_PK	clustered, unique, primary key	PERIODID, INTERCONNECTORID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_PASAINTERCONNECTORSOLUTION_LASTCHANGED	nonclustered	LASTCHANGED
PK_PASAINTERCONNECTORSOLUTION	clustered, unique, primary key	PERIODID, INTERCONNECTORID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
PASAINTERCONNECTORSOLUTIO_LCX	nonclustered	LASTCHANGED
PASAINTERCONNECTORSOLUTION_PK	clustered, unique, primary key	PERIODID, INTERCONNECTORID