REALLOCATIONDETAILS (Historical table)

REALLOCATIONDETAILS sets out specific reallocation agreements.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
REALLOCATIONID	varchar(20)	varchar(20)	Identification of the reallocation agreement
EFFECTIVEDATE	datetime(3)	datetime2(0)	Calendar settlement date the agreement starts from
VERSIONNO	numeric(3, 0)	smallint	Version number on the effective date, highest is the reallocation used on that date
AUTHORISEDDATE	datetime(3)	datetime2(0)	Date the entry was authorised
AUTHORISEDBY	varchar(10)	varchar(10)	User who authorised the record
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
REALLOCATIONDETAILS_LCX	nonclustered	LASTCHANGED
REALLOCATIONDETAILS_PK	clustered, unique, primary key	REALLOCATIONID, EFFECTIVEDATE, VERSIONNO

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_REALLOCATIONDETAILS_LASTCHANGED	nonclustered	LASTCHANGED
PK_REALLOCATIONDETAILS	clustered, unique, primary key	REALLOCATIONID, EFFECTIVEDATE, VERSIONNO

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
REALLOCATIONDETAILS_LCX	nonclustered	LASTCHANGED
REALLOCATIONDETAILS_PK	clustered, unique, primary key	REALLOCATIONID, EFFECTIVEDATE, VERSIONNO