NEGATIVE_RESIDUE
Shows the inputs provided to the Negative Residue Constraints in the Dispatch horizon.
Package
DISPATCH
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| SETTLEMENTDATE |
datetime(3)  |
datetime2(0)  |
Dispatch Interval |
| NRM_DATETIME |
datetime(3)  |
datetime2(0)  |
The time that residue information is processed |
| DIRECTIONAL_INTERCONNECTORID |
varchar(30)  |
varchar(30)  |
Negative residue related direction interconnector id |
| NRM_ACTIVATED_FLAG |
numeric(1, 0) |
tinyint |
Is 1 if negative residue process is on, else is 0 |
| CUMUL_NEGRESIDUE_AMOUNT |
numeric(15, 5) |
numeric(15, 5) |
Negative residue triggering amount |
| CUMUL_NEGRESIDUE_PREV_TI |
numeric(15, 5) |
numeric(15, 5) |
Previous trading interval cumulative negative residue amount |
| NEGRESIDUE_CURRENT_TI |
numeric(15, 5) |
numeric(15, 5) |
Current trading interval negative residue amount |
| NEGRESIDUE_PD_NEXT_TI |
numeric(15, 5) |
numeric(15, 5) |
The cumulative negative residue for the next trading interval (PD) |
| PRICE_REVISION |
varchar(30) |
varchar(30) |
SubjectToReview, Indeterminate, Accepted or Rejected |
| PREDISPATCHSEQNO |
varchar(20) |
int |
Predispatch sequence number |
| EVENT_ACTIVATED_DI |
datetime(3) |
datetime2(0) |
The starting DI when NRM event is active |
| EVENT_DEACTIVATED_DI |
datetime(3) |
datetime2(0) |
The finishing DI when NRM event stops being active. |
| DI_NOTBINDING_COUNT |
numeric(2, 0) |
tinyint |
Count of the number of DIs not binding by this constraint |
| DI_VIOLATED_COUNT |
numeric(2, 0) |
tinyint |
Count of the number of DIs violated by this constraint |
| NRMCONSTRAINT_BLOCKED_FLAG |
numeric(1, 0) |
tinyint |
1 if constraint is blocked, else 0 |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| NEGATIVE_RESIDUE_PK |
clustered, unique, primary key |
SETTLEMENTDATE, NRM_DATETIME, DIRECTIONAL_INTERCONNECTORID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_NEGATIVE_RESIDUE |
clustered, unique, primary key |
SETTLEMENTDATE, NRM_DATETIME, DIRECTIONAL_INTERCONNECTORID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| NEGATIVE_RESIDUE_PK |
clustered, unique, primary key |
SETTLEMENTDATE, NRM_DATETIME, DIRECTIONAL_INTERCONNECTORID |