Skip to content

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