GENERICCONSTRAINTRHS
GENERICCONSTRAINTRHS sets out details of generic constraint Right Hand Side (RHS) formulations for dispatch (DS), predispatch (PD) and Short Term PASA (ST). GENERICCONSTRAINTRHS also includes general expressions (EQ) used in the dispatch, predispatch and PASA time frames. GENERICCONSTRAINTRHS replaces data previously available via the \"Constraint Library\" Excel spreadsheet.
Package
GENERIC_CONSTRAINT
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| GENCONID |
varchar(20)  |
varchar(20) |
Generic Constraint Identifier |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
Effective date of this record |
| VERSIONNO |
numeric(22, 0) |
smallint |
Version no of this record for the effective date |
| SCOPE |
varchar(2) |
varchar(2) |
Scope of RHS term (DS, PD, ST or EQ) |
| TERMID |
numeric(4, 0) |
smallint |
The unique identifier for the a constraint RHS term |
| GROUPID |
numeric(3, 0) |
smallint |
ID of super-term, if this is a sub-term |
| SPD_ID |
varchar(21) |
varchar(21) |
ID defining data source |
| SPD_TYPE |
varchar(1) |
varchar(1) |
ID describing type of data source |
| FACTOR |
numeric(16, 6) |
numeric(16, 6) |
Multiplier applied to operator result |
| OPERATION |
varchar(10) |
varchar(10) |
Unitary operator to apply to data value |
| DEFAULTVALUE |
numeric(16, 6) |
numeric(16, 6) |
Default value if primary source given by SPD_ID and SPD_TYPE not available. |
| PARAMETERTERM1 |
varchar(12) |
varchar(12) |
The unique identifier for the first term (logic expression) to use in a Branch term |
| PARAMETERTERM2 |
varchar(12) |
varchar(12) |
The unique identifier for the second term (logic<=0 result) to use in a Branch term |
| PARAMETERTERM3 |
varchar(12) |
varchar(12) |
The unique identifier for the third term (logic>0 result) to use in a Branch term |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENERICCONSTRAINTRHS_LCHD_IDX |
nonclustered |
LASTCHANGED |
| GENERICCONSTRAINTRHS_PK |
clustered, unique, primary key |
GENCONID, EFFECTIVEDATE, VERSIONNO, SCOPE, TERMID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_GENERICCONSTRAINTRHS_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_GENERICCONSTRAINTRHS |
clustered, unique, primary key |
GENCONID, EFFECTIVEDATE, VERSIONNO, SCOPE, TERMID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENERICCONSTRAINTRHS_LCHD_IDX |
nonclustered |
LASTCHANGED |
| GENERICCONSTRAINTRHS_PK |
clustered, unique, primary key |
GENCONID, EFFECTIVEDATE, VERSIONNO, SCOPE, TERMID |