SETCFG_PARTICIPANT_MPFTRK

SETCFG_PARTICIPANT_MPFTRK is the tracking table for Market Participation Factors (MPF) data stored in the SETCFG_PARTICIPANT_MPF table for each participant.

Package

SETTLEMENT_CONFIG

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
PARTICIPANTID	varchar(10)	varchar(10)	Participant identifier
EFFECTIVEDATE	datetime(3)	datetime2(0)	Effective date of the MPF data
VERSIONNO	numeric(3, 0)	smallint	Version number of the MPF data
AUTHORISEDBY	varchar(15)	varchar(15)	Authorising user
AUTHORISEDDATE	datetime(3)	datetime2(0)	Authorised date and time
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
SETCFG_PARTI_MPFTRK_LCHD_IDX	nonclustered	LASTCHANGED
SETCFG_PARTICIPANT_MPFTRK_PK	clustered, unique, primary key	PARTICIPANTID, EFFECTIVEDATE, VERSIONNO

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_SETCFG_PARTICIPANT_MPFTRK_LASTCHANGED	nonclustered	LASTCHANGED
PK_SETCFG_PARTICIPANT_MPFTRK	clustered, unique, primary key	PARTICIPANTID, EFFECTIVEDATE, VERSIONNO

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
SETCFG_PARTI_MPFTRK_LCHD_IDX	nonclustered	LASTCHANGED
SETCFG_PARTICIPANT_MPFTRK_PK	clustered, unique, primary key	PARTICIPANTID, EFFECTIVEDATE, VERSIONNO