|
Name |
|
|
Comment |
GENCONSETINVOKE provides details of invoked and revoked generic constraints. GENCONSETINVOKE is the key table for determining what constraints are active in dispatch, predispatch and PASA. |
|
GENCONSETINVOKE is public data. All participants have access to this data. Source GENCONSETINVOKE updates each time a generic constraint is invoked or revoke time is altered. Once past the time, these times cannot be altered. Note The Replica software does not handle the deletion of GENCONSETINVOKE records. To workaround this problem, the field STARTAUTHORISEDBY indicates whether a constraint set invocation is applicable. A non-null value for the STARTAUTHORISEDBY field indicates that the constraint invocation is active. Essentially inactive invocations have a null value for the STARTAUTHORISEDBY field. To remove inactive invocations from queries on the GENCONSETINVOKE table, add the following text to the where clause "and STARTAUTHORISEDBY is not null". |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
INVOCATION_ID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
INVOCATION_ID |
NUMBER(9) |
X |
Abstract unique identifier for the record. Allows Invocations to be modified without affecting PK values |
|
STARTDATE |
DATE |
X |
Market date of start |
|
STARTPERIOD |
NUMBER(3,0) |
X |
The first dispatch interval of the invocation being the dispatch interval number starting from1 at 04:05. |
|
GENCONSETID |
VARCHAR2(20) |
X |
Unique generic constraint set identifier |
|
ENDDATE |
DATE |
|
Market date end |
|
ENDPERIOD |
NUMBER(3,0) |
|
Dispatch interval number end |
|
STARTAUTHORISEDBY |
VARCHAR2(15) |
|
User authorising invoke, indicating a constraint set invocation is applicable (i.e. non-null). A null value indicates inactive invocation. |
|
ENDAUTHORISEDBY |
VARCHAR2(15) |
|
user authorising revoke. |
|
INTERVENTION |
VARCHAR2(1) |
|
0 is not intervention, 1 is intervention and causes dispatch to solve twice. |
|
ASCONSTRAINTTYPE |
VARCHAR2(10) |
|
Constraint type (e.g. ancillary services). This also flags where a constraint is an interconnector or intra-region network limit. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
STARTINTERVALDATETIME |
DATE |
|
The settlement date and time corresponding to the first interval to which the constraint set is to be applied. |
|
ENDINTERVALDATETIME |
DATE |
|
The settlement date and time corresponding to the last interval to which the constraint set is to be applied. |
|
SYSTEMNORMAL |
VARCHAR2(1) |
|
Flag to indicate if the constraint set is a system normal (1) or an outage set (0) |
|
|
|