| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Date and time of the dispatch interval (e.g. five minute dispatch interval ending 28/09/2000 16:35) |
| INTERVENTION |
numeric(2, 0) (not nullable) |
bit (not nullable) |
Intervention flag - refer to package documentation for definition and practical query examples |
| CASESUBTYPE |
varchar(3) |
varchar(3) |
Overconstrained dispatch indicator: * OCD = detecting over-constrained dispatch * null = no special condition |
| SOLUTIONSTATUS |
numeric(2, 0) |
smallint |
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 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 |
| 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 |
| TOTALENERGYOFFERVIOLATION |
numeric(15, 5) |
numeric(15, 5) |
Total of unit summated offer band violations |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| SWITCHRUNINITIALSTATUS |
numeric(1, 0) |
tinyint |
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 |
numeric(1, 0) |
tinyint |
Flag indicating which Switch run was used for the Solution - from PeriodSolution |
| SWITCHRUNBESTSTATUS_INT |
numeric(1, 0) |
tinyint |
Flag indicating which Switch run was used for the Intervention Physical Solution - from PeriodSolution |
| DISPATCHPERIODID |
- |
smallint |
- |
| TRADINGDAY |
- |
date |
- |
| RUNNO |
numeric(3, 0) |
- |
- |