DISPATCHLOAD_BNC (Historical table)
DISPATCHLOAD_BNC was discontinued on 30 September 2009. Prior: DISPATCHLOAD_BNC gives binding intra-regional network constraints (BNC) re-run dispatch results for all scheduled generating units. DISPATCHLOAD_BNC has a similar structure to DISPATCHLOAD but does not repeat input type data (e. g. InitialMW, AGCStatus) since these values are available from DISPATCHLOAD.
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 |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable unit identifier |
| INTERVENTION |
numeric(2, 0) |
tinyint |
Intervention flag if intervention run |
| CONNECTIONPOINTID |
varchar(12) |
varchar(12) |
Connection point identifier for DUID |
| DISPATCHMODE |
numeric(2, 0) |
tinyint |
Dispatch mode for fast start plant (0 to 4). |
| TOTALCLEARED |
numeric(15, 5) |
numeric(15, 5) |
Target MW for end of period |
| RAISEREG |
numeric(15, 5) |
numeric(15, 5) |
Raise Regulation reserve target |
| RAISE5MIN |
numeric(15, 5) |
numeric(15, 5) |
Raise 5 min reserve target |
| RAISE60SEC |
numeric(15, 5) |
numeric(15, 5) |
Raise 60 sec reserve target |
| RAISE6SEC |
numeric(15, 5) |
numeric(15, 5) |
Raise 6 sec reserve target |
| LOWERREG |
numeric(15, 5) |
numeric(15, 5) |
Lower Regulation reserve target |
| LOWER5MIN |
numeric(15, 5) |
numeric(15, 5) |
Lower 5 min reserve target |
| LOWER60SEC |
numeric(15, 5) |
numeric(15, 5) |
Lower 60 sec reserve target |
| LOWER6SEC |
numeric(15, 5) |
numeric(15, 5) |
Lower 6 sec reserve target |
| RAISEREGFLAGS |
numeric(3, 0) |
smallint |
Raise Reg status flag |
| RAISE5MINFLAGS |
numeric(3, 0) |
smallint |
Raise 5min status flag |
| RAISE60SECFLAGS |
numeric(3, 0) |
smallint |
Raise 60sec status flag |
| RAISE6SECFLAGS |
numeric(3, 0) |
smallint |
Raise 6sec status flag |
| LOWERREGFLAGS |
numeric(3, 0) |
smallint |
Lower Reg status flag |
| LOWER5MINFLAGS |
numeric(3, 0) |
smallint |
Lower 5min status flag |
| LOWER60SECFLAGS |
numeric(3, 0) |
smallint |
Lower 60sec status flag |
| LOWER6SECFLAGS |
numeric(3, 0) |
smallint |
Lower 6sec status flag |
| 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) |
| DISPATCHLOAD_BNC_LCX |
nonclustered |
LASTCHANGED |
| DISPATCHLOAD_BNC_NDX2 |
nonclustered |
DUID, LASTCHANGED |
| PK_DISPATCHLOAD_BNC |
clustered, unique, primary key |
SETTLEMENTDATE, RUNNO, DUID, INTERVENTION |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_DISPATCHLOAD_BNC_DUID_LASTCHANGED |
nonclustered |
DUID, LASTCHANGED |
| IX_DISPATCHLOAD_BNC_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_DISPATCHLOAD_BNC |
clustered, unique, primary key |
SETTLEMENTDATE, INTERVENTION, DUID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_DISPATCHLOAD_BNC |
clustered, unique, primary key |
SETTLEMENTDATE, INTERVENTION, DUID |