PREDISPATCHCASESOLUTION
PREDISPATCHCASESOLUTION provides information relating to the complete predispatch run. The fields provide an overview of the dispatch run results allowing immediate identification of conditions such as energy or FCAS deficiencies.
Package
PRE_DISPATCH
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PREDISPATCHSEQNO |
varchar(20)  |
int |
Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30 |
| RUNNO |
numeric(3, 0) |
smallint |
Predispatch run no, normally 1. |
| SOLUTIONSTATUS |
numeric(2, 0) |
tinyint |
If non-zero indicated one of the following conditions: 1 = Supply Scarcity, Excess generation or constraint violations, -X = Model failure |
| SPDVERSION |
varchar(20) |
varchar(20) |
Current version of SPD |
| NONPHYSICALLOSSES |
numeric(1, 0) |
tinyint |
Non-Physical Losses algorithm invoked during this run |
| TOTALOBJECTIVE |
numeric(27, 10) |
numeric(27, 10) |
The Objective function from the LP |
| TOTALAREAGENVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total Region Demand violations |
| TOTALINTERCONNECTORVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total interconnector violations |
| TOTALGENERICVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total generic constraint violations |
| TOTALRAMPRATEVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total ramp rate violations |
| TOTALUNITMWCAPACITYVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total unit capacity violations |
| TOTAL5MINVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total of 5 minute ancillary service region violations |
| TOTALREGVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total of Regulation ancillary service region violations |
| TOTAL6SECVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total of 6 second ancillary service region violations |
| TOTAL60SECVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total of 60 second ancillary service region violations |
| TOTALASPROFILEVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total of ancillary service trader profile violations |
| TOTALENERGYCONSTRVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total of Energy Constrained unit offer violations. |
| TOTALENERGYOFFERVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total of unit summated offer band violations |
| LASTCHANGED |
datetime(3) |
datetime2(0) (not nullable) |
Last date and time record changed |
| INTERVENTION |
numeric(2, 0) |
bit |
Flag to indicate if this Pre-Dispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run. This field has a default value of 0 and is not nullable |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PREDISPATCHCASESOL_NDX_LCHD |
nonclustered |
LASTCHANGED |
| PREDISPATCHCASESOLUTION_PK |
clustered, unique, primary key |
PREDISPATCHSEQNO, RUNNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_PREDISPATCHCASESOLUTION_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_PREDISPATCHCASESOLUTION |
clustered, unique, primary key |
PREDISPATCHSEQNO, RUNNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_PREDISPATCHCASESOLUTION_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PREDISPATCHCASESOLUTION__PK |
clustered, unique, primary key |
PREDISPATCHSEQNO, RUNNO |