GENCONSETINVOKE
GENCONSETINVOKE provides details of invoked and revoked generic constraints. GENCONSETINVOKE is the key table for determining what constraints are active in dispatch, predispatch and PASA. GENCONSETINVOKE also indicates whether constraints are for interconnector limits, ancillary services, etc.
Package
GENERIC_CONSTRAINT
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| INVOCATION_ID |
numeric(9, 0)  |
int |
Abstract unique identifier for the record. Allows Invocations to be modified without affecting PK values |
| STARTDATE |
datetime(3) (not nullable) |
datetime2(0) (not nullable) |
Market date of start |
| STARTPERIOD |
numeric(3, 0) (not nullable) |
smallint (not nullable) |
The first dispatch interval of the invocation being the dispatch interval number starting from1 at 04:05. |
| GENCONSETID |
varchar(20) (not nullable) |
varchar(20) (not nullable) |
Unique generic constraint set identifier |
| ENDDATE |
datetime(3) |
datetime2(0) |
Market date end |
| ENDPERIOD |
numeric(3, 0) |
smallint |
Dispatch interval number end |
| STARTAUTHORISEDBY |
varchar(15) |
varchar(15) |
User authorising invoke, indicating a constraint set invocation is applicable (i.e. non-null). A null value indicates inactive invocation. |
| ENDAUTHORISEDBY |
varchar(15) |
varchar(15) |
user authorising revoke. |
| INTERVENTION |
varchar(1) |
varchar(1) |
0 is not intervention, 1 is intervention and causes dispatch to solve twice. |
| ASCONSTRAINTTYPE |
varchar(10) |
varchar(10) |
Constraint type (e.g. ancillary services). This also flags where a constraint is an interconnector or intra-region network limit. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| STARTINTERVALDATETIME |
datetime(3) |
datetime2(0) |
The settlement date and time corresponding to the first interval to which the constraint set is to be applied. |
| ENDINTERVALDATETIME |
datetime(3) |
datetime2(0) |
The settlement date and time corresponding to the last interval to which the constraint set is to be applied. |
| SYSTEMNORMAL |
varchar(1) |
varchar(1) |
Flag to indicate if the constraint set is a system normal (1) or an outage set (0) |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENCONSETINV_PK |
clustered, unique, primary key |
INVOCATION_ID |
| GENCONSETINVOKE_LCX |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_GENCONSETINVOKE_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_GENCONSETINVOKE |
clustered, unique, primary key |
INVOCATION_ID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENCONSETINVOKE_LCX |
nonclustered |
LASTCHANGED |
| PK_GENCONSETINVOKE |
clustered, unique, primary key |
INVOCATION_ID |