|
Name |
|
|
Comment |
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. |
|
GENERICEQUATIONRHS data is public to all participants. Source GENERICEQUATIONRHS updates whenever a generic equation is created or modified. Volume Approximately 1,000 records per year Note GENERICEQUATIONRHS and GENERICEQUATIONDESC allow commonly used constraint right hand side formulations to be defined as a generic equation. Once defined, the generic equation can be referenced from any Generic constraint RHS formulation defined in GENERICCONSTRAINTRHS. To reference a generic equation from a generic constraint RHS definition, specify a SPD_TYPE of ‘X’ and the SPD_ID equivalent to the EQUATIONID field in GENERICEQUATIONRHS. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
EFFECTIVEDATE |
|
EQUATIONID |
|
TERMID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EQUATIONID |
VARCHAR2(20) |
X |
Generic Equation Identifier |
|
EFFECTIVEDATE |
DATE |
X |
Effective date of this record |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no of this record for the effective date |
|
TERMID |
NUMBER(3,0) |
X |
The unique identifier for the a equation RHS term |
|
GROUPID |
NUMBER(3,0) |
|
ID of super-term, if this is a sub-term |
|
SPD_ID |
VARCHAR2(21) |
|
ID defining data source |
|
SPD_TYPE |
VARCHAR2(1) |
|
ID describing type of data source |
|
FACTOR |
NUMBER(16,6) |
|
Multiplier applied to operator result |
|
OPERATION |
VARCHAR2(10) |
|
Unitary operator to apply to data value |
|
DEFAULTVALUE |
NUMBER(16,6) |
|
Default value if primary source given by SPD_ID and SPD_TYPE not available. |
|
PARAMETERTERM1 |
VARCHAR2(12) |
|
The unique identifier for the first term (logic expression) to use in a Branch term |
|
PARAMETERTERM2 |
VARCHAR2(12) |
|
The unique identifier for the second term (logic<=0 result) to use in a Branch term |
|
PARAMETERTERM3 |
VARCHAR2(12) |
|
The unique identifier for the third term (logic>0 result) to use in a Branch term |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|