Skip to content

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