INTERMITTENT_GEN_LIMIT_DAY
Summary record for an Upper MW Limit submission for an intermittent generating unit for a Trading Day.
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 |
| PARTICIPANTID |
varchar(20) |
varchar(20) |
Unique participant identifier |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| 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) |
| INTERMITTENT_GEN_LIMIT_DAY_PK |
clustered, unique, primary key |
TRADINGDATE, DUID, OFFERDATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_INTERMITTENT_GEN_LIMIT_DAY |
clustered, unique, primary key |
TRADINGDATE, DUID, OFFERDATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| INTERMITTENT_GEN_LIMIT_DAY_PK |
clustered, unique, primary key |
TRADINGDATE, DUID, OFFERDATETIME |