Skip to content

INTERMITTENT_CLUSTER_AVAIL

A submission of expected plant availability for an intermittent generating unit cluster, 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) 🔑 The trading day to which the availability submission applies
DUID varchar(20) 🔑 varchar(20) 🔑 Unique Identifier of Dispatchable Unit
OFFERDATETIME datetime(3) 🔑 datetime2(0) 🔑 Date and Time when this cluster availability submission was loaded
CLUSTERID varchar(20) 🔑 varchar(20) 🔑 Unique Cluster Identifier for this cluster within the DUID
PERIODID numeric(3, 0) 🔑 smallint 🔑 Trading interval number (1...48) within this TRADINGDATE for which ELEMENTS_UNAVAILABLE applies
ELEMENTS_UNAVAILABLE numeric(5, 0) smallint Number of elements within this CLUSTERID (turbines for wind, or inverters for solar) that are not available for this TRADINGDATE and PERIODID (scheduled maintenance in AWEFS/ASEFS). Value between 0 and the registered Number of Cluster Elements.Value = 0 means no elements unavailable
ELEMENTS_AVAILABLE numeric(5, 0) smallint Number of elements within this CLUSTERID (turbines for wind, or inverters for solar) that are available for this TRADINGDATE and PERIODID (scheduled maintenance in AWEFS/ASEFS). Value between 0 and the registered Number of Cluster Elements. Value = 0 means no elements available

Official MMS data model indexes

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

GR-MMS data model indexes

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

Historical-MMS data model indexes

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