RESDEMANDTRK

RESDEMANDTRK defines the existence and versioning information of a forecast for a specific region and trading date. RESDEMANDTRK and PERDEMAND have a parent / child relationship, and are for defined forecast regional demands since market start. RESDEMANDTRK defines the existence and versioning information of a forecast for a specific region and trading date. PERDEMAND defines the numerical forecast values for each trading interval of a the trading day for that region. A complete trading day forecast for one region consists of one RESDEMANDTRK record and 48 PERDEMAND records.

Package

DEMAND_FORECASTS

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
EFFECTIVEDATE	datetime(3)	datetime2(0)	Trading Date of the regional forecast
REGIONID	varchar(10)	varchar(10)	Unique RegionID
OFFERDATE	datetime(3)	datetime2(0)	Date the forecast was created
VERSIONNO	numeric(3, 0)	smallint	Version of this forecast with respect to the Effectivedate and Offerdate
FILENAME	varchar(40)	varchar(40)	Tracking purposes only
AUTHORISEDDATE	datetime(3)	datetime2(0)	Date forecast authorised
AUTHORISEDBY	varchar(10)	varchar(10)	Identifier of authorising user
LASTCHANGED	datetime(3)	datetime2(0)	Date and time the record was last modified

Official MMS data model indexes

Index name	Index type	Index columns (in order)
RESDEMANDTRK_LCX	nonclustered	LASTCHANGED
RESDEMANDTRK_PK	clustered, unique, primary key	REGIONID, EFFECTIVEDATE, OFFERDATE, VERSIONNO

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_RESDEMANDTRK_LASTCHANGED	nonclustered	LASTCHANGED
PK_RESDEMANDTRK	clustered, unique, primary key	REGIONID, EFFECTIVEDATE, OFFERDATE, VERSIONNO

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
RESDEMANDTRK_LCX	nonclustered	LASTCHANGED
RESDEMANDTRK_PK	clustered, unique, primary key	REGIONID, EFFECTIVEDATE, OFFERDATE, VERSIONNO