DISPATCHCASESOLUTION_BNC (Historical table)
DISPATCHCASESOLUTION_BNC was discontinued on 30 September 2009. Prior: DISPATCHCASESOLUTION_BNC is the key data to indicate when a binding intra-regional network constraints (BNC) re-run actually occurred.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
End date and time of the dispatch interval |
| INTERVENTION |
numeric(2, 0) |
tinyint |
Manual intervention flag |
| CASESUBTYPE |
varchar(3) |
varchar(3) |
always BNC |
| 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 |
numeric(10, 3) |
numeric(10, 3) |
Current version of SPD |
| STARTPERIOD |
varchar(20) |
varchar(20) |
Period identifier of first interval of the case (yyyymmddppp) |
| NONPHYSICALLOSSES |
numeric(1, 0) |
tinyint |
Non-Physical Losses algorithm invoked occurred 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 |
| TOTALENERGYCONSTRVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
- |
| TOTALENERGYOFFERVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total of unit summated offer band violations |
| TOTALASPROFILEVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total of ancillary service trader profile violations |
| TOTALFASTSTARTVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total of fast start trader profile violations |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| RUNNO |
numeric(3, 0) |
- |
- |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCHCASESOLUTION_BNC_LCX |
nonclustered |
LASTCHANGED |
| PK_DISPATCHCASESOLUTION_BNC |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, INTERVENTION |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_DISPATCHCASESOLUTION_BNC_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_DISPATCHCASESOLUTION_BNC |
clustered, unique, primary key |
SETTLEMENTDATE, INTERVENTION |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| DISPATCHCASESOLUTION_BNC_LCX |
nonclustered |
LASTCHANGED |
| PK_DISPATCHCASESOLUTION_BNC |
clustered, unique, primary key |
SETTLEMENTDATE, INTERVENTION |