METERDATA (Historical table)

METERDATA sets out a meter data for each customer connection point. METERDATA covers market load. Use the field METERRUNNO to match the meter data version for each settlement run.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
PARTICIPANTID	varchar(10)	varchar(10)	Unique participant identifier
PERIODID	numeric(3, 0)	smallint	Settlement period identifier (half hour period)
SETTLEMENTDATE	datetime(3)	datetime2(0)	Settlement date
METERRUNNO	numeric(6, 0)	smallint	Data version no
CONNECTIONPOINTID	varchar(10)	varchar(10)	Transmission Node Identifier (TNI). Identifies a Transmission NetworkConnection Point.
HOSTDISTRIBUTOR	varchar(10)	varchar(10)	Local Retailer participant identifier
MDA	varchar(10)	varchar(10)	Defaults to MSATS
IMPORTENERGYVALUE	numeric(9, 6)	numeric(9, 6)	Imported energy value (MWh)
EXPORTENERGYVALUE	numeric(9, 6)	numeric(9, 6)	Exported energy value (MWh)
IMPORTREACTIVEVALUE	numeric(9, 6)	numeric(9, 6)	Not used
EXPORTREACTIVEVALUE	numeric(9, 6)	numeric(9, 6)	Not used
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
METERDATA_LCX	nonclustered	LASTCHANGED
METERDATA_PK	clustered, unique, primary key	SETTLEMENTDATE, MDA, METERRUNNO, CONNECTIONPOINTID, PARTICIPANTID, HOSTDISTRIBUTOR, PERIODID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_METERDATA_LASTCHANGED	nonclustered	LASTCHANGED
PK_METERDATA	clustered, unique, primary key	SETTLEMENTDATE, MDA, METERRUNNO, CONNECTIONPOINTID, PARTICIPANTID, HOSTDISTRIBUTOR, PERIODID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
METERDATA_LCX	nonclustered	LASTCHANGED
METERDATA_PK	clustered, unique, primary key	SETTLEMENTDATE, MDA, METERRUNNO, CONNECTIONPOINTID, PARTICIPANTID, HOSTDISTRIBUTOR, PERIODID