GENCONDATA
GENCONDATA sets out the generic constraints contained within a generic constraint set invoked in PASA, predispatch and dispatch. Fields enable selective application of invoked constraints in the Dispatch, Predispatch, ST PASA or MT PASA processes.
Package
GENERIC_CONSTRAINT
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| 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 |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENCONDATA_LCX |
nonclustered |
LASTCHANGED |
| GENCONDATA_PK |
clustered, unique, primary key |
EFFECTIVEDATE, VERSIONNO, GENCONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_GENCONDATA |
clustered, unique, primary key |
GENCONID, EFFECTIVEDATE, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_GENCONDATA |
clustered, unique, primary key |
GENCONID, EFFECTIVEDATE, VERSIONNO |