RESIDUECONTRACTPAYMENTS

RESIDUECONTRACTPAYMENTS shows Settlement Residue Auction payment Participant notifications.

Package

IRAUCTION

Visibility

Private

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTID	varchar(30)	varchar(30)	SRA Contract ID
PARTICIPANTID	varchar(10)	varchar(10)	Participant Identifier
LASTCHANGED	datetime(3)	datetime2(0)	Date and time this record was last changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
RESIDUECONTRACTPAYMENTS_LCX	nonclustered	LASTCHANGED
RESIDUECONTRACTPAYMENTS_PK	clustered, unique, primary key	CONTRACTID, PARTICIPANTID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_RESIDUECONTRACTPAYMENTS_LASTCHANGED	nonclustered	LASTCHANGED
PK_RESIDUECONTRACTPAYMENTS	clustered, unique, primary key	CONTRACTID, PARTICIPANTID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
RESIDUECONTRACTPAYMENTS_LCX	nonclustered	LASTCHANGED
RESIDUECONTRACTPAYMENTS_PK	clustered, unique, primary key	CONTRACTID, PARTICIPANTID