GENERICEQUATIONRHS
GENERICEQUATIONRHS stores the formulation of commonly used Generic Constraint Right Hand Side Equations referenced from Generic Constraint Right Hand Side definitions stored in GENERICCONSTRAINTRHS. The Generic Equation definitions are versioned and the latest effective version is applied to the dispatch process.
Package
GENERIC_CONSTRAINT
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| EQUATIONID |
varchar(20)  |
varchar(20) |
Generic Equation Identifier |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
Effective date of this record |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version no of this record for the effective date |
| TERMID |
numeric(3, 0) |
smallint |
The unique identifier for the a equation 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) |
| GENERICEQUATION_LCHD_IDX |
nonclustered |
LASTCHANGED |
| GENERICEQUATIONRHS_PK |
clustered, unique, primary key |
EQUATIONID, EFFECTIVEDATE, VERSIONNO, TERMID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_GENERICEQUATIONRHS_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_GENERICEQUATIONRHS |
clustered, unique, primary key |
EQUATIONID, EFFECTIVEDATE, VERSIONNO, TERMID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENERICEQUATION_LCHD_IDX |
nonclustered |
LASTCHANGED |
| GENERICEQUATIONRHS_PK |
clustered, unique, primary key |
EQUATIONID, EFFECTIVEDATE, VERSIONNO, TERMID |