SETIRPARTSURPLUS

This view supports the Settlements Residue Auction, holding the participant allocations of IRSurplus.

Package

SETTLEMENT_DATA

Private

Column	Official MMS Datatype	GR-MMS Datatype	Comment
SETTLEMENTDATE	datetime(3)	datetime2(0)	Settlement date
SETTLEMENTRUNNO	numeric(3, 0)	smallint	Settlement run number
CONTRACTID	varchar(10)	varchar(10)	Ancillary Service Contract
PERIODID	numeric(3, 0)	smallint	Settlements Trading Interval.
PARTICIPANTID	varchar(10)	varchar(10)	Participant unique identifier
INTERCONNECTORID	varchar(10)	varchar(10)	Identifier of the Contracted Interconnector
FROMREGIONID	varchar(10)	varchar(10)	Nominated source region for Interconnector
TOTALSURPLUS	numeric(15, 5)	numeric(15, 5)	Total value of surplus before allocation
CONTRACTALLOCATION	numeric(8, 5)	numeric(8, 5)	Allocated percentage to participant
SURPLUSVALUE	numeric(15, 5)	numeric(15, 5)	Amount NSP is paid for Inter/intra-Regional surplus energy produced
LASTCHANGED	datetime(3)	datetime2(0)	Date and time this record was last updated
CSP_DEROGATION_AMOUNT	numeric(18, 8)	numeric(18, 8)	The CSP derogation amount applied as an adjustment to SRA
UNADJUSTED_IRSR	numeric(18, 8)	numeric(18, 8)	The SRA amount unadjusted by CSP

Index name	Index type	Index columns (in order)
SETIRPARTSURPLUS_LCX	nonclustered	LASTCHANGED
SETIRPARTSURPLUS_PK	clustered, unique, primary key	SETTLEMENTDATE, SETTLEMENTRUNNO, CONTRACTID, INTERCONNECTORID, FROMREGIONID, PARTICIPANTID, PERIODID

Index name	Index type	Index columns (in order)
IX_SETIRPARTSURPLUS_LASTCHANGED	nonclustered	LASTCHANGED
PK_SETIRPARTSURPLUS	clustered, unique, primary key	SETTLEMENTDATE, SETTLEMENTRUNNO, CONTRACTID, INTERCONNECTORID, FROMREGIONID, PARTICIPANTID, PERIODID

Index name	Index type	Index columns (in order)
SETIRPARTSURPLUS_LCX	nonclustered	LASTCHANGED
SETIRPARTSURPLUS_PK	clustered, unique, primary key	SETTLEMENTDATE, SETTLEMENTRUNNO, CONTRACTID, INTERCONNECTORID, FROMREGIONID, PARTICIPANTID, PERIODID