|
Name |
|
|
Comment |
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 is public data, and is available to all participants. Source GENERICCONSTRAINTRHS updates whenever a new generic constraint RHS or expression is created or modified Volume Approximately 70,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. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
EFFECTIVEDATE |
|
GENCONID |
|
SCOPE |
|
TERMID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
GENCONID |
VARCHAR2(20) |
X |
Generic Constraint Identifier |
|
EFFECTIVEDATE |
DATE |
X |
Effective date of this record |
|
VERSIONNO |
NUMBER(22,0) |
X |
Version no of this record for the effective date |
|
SCOPE |
VARCHAR2(2) |
X |
Scope of RHS term (DS, PD, ST or EQ) |
|
TERMID |
NUMBER(4,0) |
X |
The unique identifier for the a constraint 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 |
|
|
|