Skip to content

INTERMITTENT_GEN_LIMIT

A submission of Upper MW Limit for an intermittent generating unit, by Trading Day and Trading Interval.

Package

DEMAND_FORECASTS

Visibility

Private, Public Next-Day

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
TRADINGDATE datetime(3) 🔑 datetime2(0) 🔑 Trading Day for which this unit availability submission applies
DUID varchar(20) 🔑 varchar(20) 🔑 Unique Identifier of Dispatchable Unit
OFFERDATETIME datetime(3) 🔑 datetime2(0) 🔑 Date and Time when this unit availability submission was loaded
PERIODID numeric(3, 0) 🔑 smallint 🔑 Trading interval number (1...48) within this TRADINGDATE for which UPPERMWLIMIT applies
UPPERMWLIMIT numeric(6, 0) int Maximum imposed MW limit (down regulation in AWEFS/ASEFS). Value between 0 and the registered DUID Maximum Capacity. Value = -1 means no limit applies.

Official MMS data model indexes

Index name Index type Index columns (in order)
INTERMITTENT_GEN_LIMIT_PK clustered, unique, primary key TRADINGDATE, DUID, OFFERDATETIME, PERIODID

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_INTERMITTENT_GEN_LIMIT clustered, unique, primary key TRADINGDATE, DUID, OFFERDATETIME, PERIODID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
INTERMITTENT_GEN_LIMIT_PK clustered, unique, primary key TRADINGDATE, DUID, OFFERDATETIME, PERIODID