MTPASA_INTERMITTENT_LIMIT
A submission of expected maximum availability for intermittent generators for use in MTPASA intermittent generation forecasts.
Package
DEMAND_FORECASTS
Visibility
Private
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 time file processed |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| UPPERMWLIMIT |
numeric(6, 0) |
smallint |
Maximum imposed MW limit. Value between 0 and the registered DUID Maximum Capacity.Value = -1 means no limit applies. |
| AUTHORISEDBYUSER |
varchar(20) |
varchar(20) |
User entering the unit availability submission |
| AUTHORISEDBYPARTICIPANTID |
varchar(20) |
varchar(20) |
Participant entering the unit availability submission |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_INTERMITTENT_LIMIT_PK |
clustered, unique, primary key |
TRADINGDATE, DUID, OFFERDATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_INTERMITTENT_LIMIT |
clustered, unique, primary key |
TRADINGDATE, DUID, OFFERDATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_INTERMITTENT_LIMIT_PK |
clustered, unique, primary key |
TRADINGDATE, DUID, OFFERDATETIME |