Table: GENERICCONSTRAINTRHS

GENERICCONSTRAINTRHS

Name

GENERICCONSTRAINTRHS

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 replaces data previously available via the "Constraint Libraryā€¯ Excel spreadsheet.


Description

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.


Primary Key Columns

Name

EFFECTIVEDATE

GENCONID

SCOPE

TERMID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

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