SETRESERVETRADER (Historical table)

SETRESERVETRADER shows reserve trader details.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
SETTLEMENTDATE	datetime(3)	datetime2(0)	Settlement Date
VERSIONNO	numeric(3, 0)	smallint	Settlement Run No.
PERIODID	numeric(3, 0)	smallint	Period Identifier
DUID	varchar(10)	varchar(10)	Dispatchable Unit ID
CONTRACTID	varchar(10)	varchar(10)	Reserve Trader Contract Identifier
CONTRACTVERSION	numeric(3, 0)	smallint	Reserve Trader Contract Version
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
REGIONID	varchar(10)	varchar(10)	Region Identifier
RCF	char(1)	char(1)	Reserve Recovery Flag
UNITAVAIL	numeric(6, 2)	numeric(6, 2)	Offered Availability of Unit
CPA	numeric(12, 5)	numeric(12, 5)	Contract Availability Payment
CPE	numeric(12, 5)	numeric(12, 5)	Contract Enabling Payment
CPU	numeric(12, 5)	numeric(12, 5)	Contract Usage Payment
CPTOTAL	numeric(12, 5)	numeric(12, 5)	Total Payment for Contract
CAPDIFFERENCE	numeric(12, 5)	numeric(12, 5)	Spot payment applicable to the capacity above the enabling threshold
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
SETRESERVETRADER_LCX	nonclustered	LASTCHANGED
SETRESERVETRADER_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, DUID, PERIODID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_SETRESERVETRADER_LASTCHANGED	nonclustered	LASTCHANGED
PK_SETRESERVETRADER	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, DUID, PERIODID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
SETRESERVETRADER_LCX	nonclustered	LASTCHANGED
SETRESERVETRADER_PK	clustered, unique, primary key	SETTLEMENTDATE, VERSIONNO, DUID, PERIODID