Table: DISPATCHCASESOLUTION

DISPATCHCASESOLUTION

Name

DISPATCHCASESOLUTION

Comment

DISPATCHCASESOLUTION shows information relating to the complete dispatch run. The fields in DISPATCHCASESOLUTION provide an overview of the dispatch run results allowing immediate identification of conditions such as energy or FCAS deficiencies.


Description

The DISPATCHCASESOLUTION data is public.

Source

DISPATCHCASESOLUTION updates every 5 minutes.

Volume

Approximately 288 records per day.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

RUNNO

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Date and time of the dispatch interval (e.g. five minute dispatch interval ending 28/09/2000 16:35)

RUNNO

NUMBER(3,0)

X

Dispatch run no; always 1

INTERVENTION

NUMBER(2,0)

X

Intervention flag - refer to package documentation for definition and practical query examples

CASESUBTYPE

VARCHAR2(3)

 

Overconstrained dispatch indicator:
* OCD = detecting over-constrained dispatch
* null = no special condition

SOLUTIONSTATUS

NUMBER(2,0)

 

If non-zero indicated one of the following conditions:
* 1 = Supply Scarcity, Excess generation or constraint violations
* X = Model failure

SPDVERSION

VARCHAR2(20)

 

Current version of SPD

NONPHYSICALLOSSES

NUMBER(1,0)

 

Non-Physical Losses algorithm invoked occurred during this run

TOTALOBJECTIVE

NUMBER(27,10)

 

The Objective function from the LP

TOTALAREAGENVIOLATION

NUMBER(15,5)

 

Total Region Demand violations

TOTALINTERCONNECTORVIOLATION

NUMBER(15,5)

 

Total interconnector violations

TOTALGENERICVIOLATION

NUMBER(15,5)

 

Total generic constraint violations

TOTALRAMPRATEVIOLATION

NUMBER(15,5)

 

Total ramp rate violations

TOTALUNITMWCAPACITYVIOLATION

NUMBER(15,5)

 

Total unit capacity violations

TOTAL5MINVIOLATION

NUMBER(15,5)

 

Total of 5 minute ancillary service region violations

TOTALREGVIOLATION

NUMBER(15,5)

 

Total of Regulation ancillary service region violations

TOTAL6SECVIOLATION

NUMBER(15,5)

 

Total of 6 second ancillary service region violations

TOTAL60SECVIOLATION

NUMBER(15,5)

 

Total of 60 second ancillary service region violations

TOTALASPROFILEVIOLATION

NUMBER(15,5)

 

Total of ancillary service trader profile violations

TOTALFASTSTARTVIOLATION

NUMBER(15,5)

 

Total of fast start trader profile violations

TOTALENERGYOFFERVIOLATION

NUMBER(15,5)

 

Total of unit summated offer band violations

LASTCHANGED

DATE

 

Last date and time record changed

SWITCHRUNINITIALSTATUS

NUMBER(1,0)

 

Flag indicating the SCADA status for FCAS Interconnector dead-band. "0" if SCADA Status or requesting Constraint not invoked. "1" if SCADA Status AND requesting Constraint is invoked

SWITCHRUNBESTSTATUS

NUMBER(1,0)

 

Flag indicating which Switch run was used for the Solution – from PeriodSolution

SWITCHRUNBESTSTATUS_INT

NUMBER(1,0)

 

Flag indicating which Switch run was used for the Intervention Physical Solution - from PeriodSolution