METERDATATRK (Historical table)

METERDATATRK records meter data files submitted for each connection point on a daily basis. The same data is provided in METERDATA period by period (i. e. 48 records), whereas METERDATATRK shows one record per day for each file submitted for a connection point.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
SETTLEMENTDATE	datetime(3)	datetime2(0)	Settlement calendar date
METERRUNNO	numeric(6, 0)	smallint	Meter data version number
PARTICIPANTID	varchar(10)	varchar(10)	Participant identifier
CONNECTIONPOINTID	varchar(10)	varchar(10)	Transmission Node Identifier (TNI)
METERINGDATAAGENT	varchar(10)	varchar(10)	Defaults to MSATS
HOSTDISTRIBUTOR	varchar(10)	varchar(10)	Local retailer participant identifier
FILENAME	varchar(40)	varchar(40)	Meter file name (MSATS file name)
ACKFILENAME	varchar(40)	varchar(40)	Not used
AUTHORISEDDATE	datetime(3)	datetime2(0)	Date processed
AUTHORISEDBY	varchar(15)	varchar(15)	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)
METERDATATRK_LCX	nonclustered	LASTCHANGED
METERDATATRK_PK	clustered, unique, primary key	SETTLEMENTDATE, METERINGDATAAGENT, METERRUNNO, CONNECTIONPOINTID, PARTICIPANTID, HOSTDISTRIBUTOR

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_METERDATATRK_LASTCHANGED	nonclustered	LASTCHANGED
PK_METERDATATRK	clustered, unique, primary key	SETTLEMENTDATE, METERINGDATAAGENT, METERRUNNO, CONNECTIONPOINTID, PARTICIPANTID, HOSTDISTRIBUTOR

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
METERDATATRK_LCX	nonclustered	LASTCHANGED
METERDATATRK_PK	clustered, unique, primary key	SETTLEMENTDATE, METERINGDATAAGENT, METERRUNNO, CONNECTIONPOINTID, PARTICIPANTID, HOSTDISTRIBUTOR