INTCONTRACTAMOUNTTRK (Historical table)

INTCONTRACTAMOUNTTRK shows the latest valid version of each intervention contract.

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
AUTHORISEDBY	varchar(15)	varchar(15)	User name
AUTHORISEDDATE	datetime(3)	datetime2(0)	Date contract was authorised
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
INTCONTRACTAMOUNTTRK_LCX	nonclustered	LASTCHANGED
INTCONTRACTAMOUNTTRK_PK	clustered, unique, primary key	CONTRACTID, VERSIONNO

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_INTCONTRACTAMOUNTTRK_LASTCHANGED	nonclustered	LASTCHANGED
PK_INTCONTRACTAMOUNTTRK	clustered, unique, primary key	CONTRACTID, VERSIONNO

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
INTCONTRACTAMOUNTTRK_LCX	nonclustered	LASTCHANGED
INTCONTRACTAMOUNTTRK_PK	clustered, unique, primary key	CONTRACTID, VERSIONNO