MARKET_FEE_EXCLUSION

MARKET_FEE_EXCLUSION shows the list of market fees from which a participant is excluded from funding after a particular settlement date.

Package

SETTLEMENT_CONFIG

Visibility

Private

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
EFFECTIVEDATE	datetime(3)	datetime2(0)	Date on which this data becomes effective
VERSIONNO	numeric(3, 0)	smallint	Version of fees for this ID
MARKETFEEID	varchar(10)	varchar(10)	Identifier for Market Fee
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
MARKET_FEE_EXCLUSION_LCX	nonclustered	LASTCHANGED
MARKET_FEE_EXCLUSION_PK	clustered, unique, primary key	PARTICIPANTID, EFFECTIVEDATE, VERSIONNO, MARKETFEEID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_MARKET_FEE_EXCLUSION_LASTCHANGED	nonclustered	LASTCHANGED
PK_MARKET_FEE_EXCLUSION	clustered, unique, primary key	PARTICIPANTID, EFFECTIVEDATE, VERSIONNO, MARKETFEEID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
MARKET_FEE_EXCLUSION_LCX	nonclustered	LASTCHANGED
MARKET_FEE_EXCLUSION_PK	clustered, unique, primary key	PARTICIPANTID, EFFECTIVEDATE, VERSIONNO, MARKETFEEID