INTCONTRACTAMOUNT (Historical table)

INTCONTRACTAMOUNT shows intervention contract amounts.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
CONTRACTID	varchar(10)	varchar(10)	Intervention Contract Identifier
VERSIONNO	numeric(3, 0)	smallint	Intervention Contract Version
PERIODID	numeric(3, 0)	smallint	Period Identifier based on calendar settlement date - YYYYMMDDPP.
AMOUNT	numeric(16, 6)	numeric(16, 6)	Intervention Amount for Trading Interval
RCF	char(1)	char(1)	Regional Recovery Flag
LASTCHANGED	datetime(3) (not nullable)	datetime2(0) (not nullable)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
INTCONTRACTAMOUNT_LCX	nonclustered	LASTCHANGED
INTCONTRACTAMOUNT_PK	clustered, unique, primary key	CONTRACTID, VERSIONNO, PERIODID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_INTCONTRACTAMOUNT_LASTCHANGED	nonclustered	LASTCHANGED
PK_INTCONTRACTAMOUNT	clustered, unique, primary key	CONTRACTID, VERSIONNO, PERIODID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
INTCONTRACTAMOUNT_LCX	nonclustered	LASTCHANGED
INTCONTRACTAMOUNT_PK	clustered, unique, primary key	CONTRACTID, VERSIONNO, PERIODID