| EFFECTIVEDATE |
datetime(3)  |
date |
Effective date of this constraint |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version with respect to the effective date |
| GENCONID |
varchar(20) |
varchar(20) |
Unique ID for the constraint |
| CONSTRAINTTYPE |
varchar(2) |
varchar(2) |
The logical operator (=, >=, <=) |
| CONSTRAINTVALUE |
numeric(16, 6) |
numeric(16, 6) |
the RHS value used if there is no dynamic RHS defined in GenericConstraintRHS |
| DESCRIPTION |
varchar(256) |
varchar(256) |
Detail of the plant that is not in service |
| STATUS |
varchar(8) |
varchar(8) |
Not used |
| GENERICCONSTRAINTWEIGHT |
numeric(16, 6) |
numeric(16, 6) |
The constraint violation penalty factor |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Date record authorised |
| AUTHORISEDBY |
varchar(15) |
varchar(15) |
User authorising record |
| DYNAMICRHS |
numeric(15, 5) |
numeric(15, 5) |
Not used |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| DISPATCH |
varchar(1) |
bit |
Flag: constraint RHS used for Dispatch? 1-used, 0-not used |
| PREDISPATCH |
varchar(1) |
bit |
Flag to indicate if the constraint RHS is to be used for PreDispatch, 1-used, 0-not used |
| STPASA |
varchar(1) |
bit |
Flag to indicate if the constraint RHS is to be used for ST PASA, 1-used, 0-not used |
| MTPASA |
varchar(1) |
bit |
Flag to indicate if the constraint RHS is to be used for MT PASA, 1-used, 0-not used |
| IMPACT |
varchar(64) |
varchar(64) |
The device(s) that is 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 constraint |
| ADDITIONALNOTES |
varchar(256) |
varchar(256) |
Extra notes on the constraint |
| P5MIN_SCOPE_OVERRIDE |
varchar(2) |
varchar(2) |
Extra notes on the constraint: NULL = Dispatch RHS applied in 5MPD, PD = PreDispatch RHS applied in 5MPD |
| LRC |
varchar(1) |
bit |
Flag to indicate if PASA LRC run uses the constraint; 1-used, 0-not used |
| LOR |
varchar(1) |
bit |
Flag to indicate if PASA LOR run uses the constraint; 1-used, 0-not used |
| FORCE_SCADA |
numeric(1, 0) |
bit |
Flags Constraints for which NEMDE must use \"InitialMW\" values instead of \"WhatOfInitialMW\" for Intervention Pricing runs |
| SYSTEMSECURITY |
varchar(1) |
bit |
Flags constraint is used in System Security Management (SSM) processes. 1-Used(in SSM only),0-not used |
| SSM_REGIONID |
varchar(20) |
varchar(20) |
Region constraint relates to, in the format _xxxx where xxxx is descriptive text |
| SSM_GROUPID |
varchar(40) |
varchar(40) |
Related constraints processed together in optimiser. |