GENERICEQUATIONDESC
GENERICEQUATIONDESC defines a generic equation identifier with a description. The formulation of the generic equation is detailed in GENERICEQUATIONRHS.
Package
GENERIC_CONSTRAINT
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| EQUATIONID |
varchar(20)  |
varchar(20)  |
Generic Equation Identifier |
| DESCRIPTION |
varchar(256) |
varchar(256) |
Generic Equation Description |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| IMPACT |
varchar(64) |
varchar(64) |
The device(s) affected by the constraint (e.g. Interconnector, Generator(s) or Cutset) |
| SOURCE |
varchar(128) |
varchar(128) |
The source of the constraint formulation |
| LIMITTYPE |
varchar(64) |
varchar(64) |
The limit type of the constraint e.g. Transient Stability, Voltage Stability |
| REASON |
varchar(256) |
varchar(256) |
The contingency or reason for the constraint |
| MODIFICATIONS |
varchar(256) |
varchar(256) |
Details of the changes made to this version of the generic equation RHS |
| ADDITIONALNOTES |
varchar(256) |
varchar(256) |
Extra notes on the constraint |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENERICEQUATIONDESC_PK |
clustered, unique, primary key |
EQUATIONID |
| GENERICEQUATIONDS_LCHD_IDX |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_GENERICEQUATIONDESC_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_GENERICEQUATIONDESC |
clustered, unique, primary key |
EQUATIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENERICEQUATIONDESC_PK |
clustered, unique, primary key |
EQUATIONID |
| GENERICEQUATIONDS_LCHD_IDX |
nonclustered |
LASTCHANGED |