Skip to content

DISPATCHPRICE

DISPATCHPRICE records 5 minute dispatch prices for energy and FCAS, including whether an intervention has occurred, or price override (e. g. for Administered Price Cap). DISPATCHPRICE updates when price adjustments occur, in which case the new price is written to the RRP field, and the old price to the ROP field as an audit trail.

Package

DISPATCH

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
SETTLEMENTDATE datetime(3) 🔑 datetime2(0) 🔑 Market date and time starting at 04:05
REGIONID varchar(10) 🔑 varchar(10) 🔑 Region Identifier
INTERVENTION numeric(2, 0) 🔑 tinyint 🔑 Manual intervention flag
RRP numeric(15, 5) numeric(15, 5) Regional Reference Price for this dispatch period. RRP is the price used to settle the market
EEP numeric(15, 5) numeric(15, 5) Excess energy price - no longer used
ROP numeric(15, 5) numeric(15, 5) Regional Override Price, being the original price prior to any price scaling, price capping or VoLL override being applied. The APC flag allows the determination of whether capping, scaling or override occurred
APCFLAG numeric(3, 0) tinyint APC Active flag (see note)
MARKETSUSPENDEDFLAG numeric(3, 0) tinyint Market suspended flag
LASTCHANGED datetime(3) datetime2(0) Last date and time record changed
RAISE6SECRRP numeric(15, 5) numeric(15, 5) -
RAISE6SECROP numeric(15, 5) numeric(15, 5) -
RAISE6SECAPCFLAG numeric(3, 0) tinyint -
RAISE60SECRRP numeric(15, 5) numeric(15, 5) -
RAISE60SECROP numeric(15, 5) numeric(15, 5) -
RAISE60SECAPCFLAG numeric(3, 0) tinyint -
RAISE5MINRRP numeric(15, 5) numeric(15, 5) -
RAISE5MINROP numeric(15, 5) numeric(15, 5) -
RAISE5MINAPCFLAG numeric(3, 0) tinyint -
RAISEREGRRP numeric(15, 5) numeric(15, 5) -
RAISEREGROP numeric(15, 5) numeric(15, 5) -
RAISEREGAPCFLAG numeric(3, 0) tinyint -
LOWER6SECRRP numeric(15, 5) numeric(15, 5) -
LOWER6SECROP numeric(15, 5) numeric(15, 5) -
LOWER6SECAPCFLAG numeric(3, 0) tinyint -
LOWER60SECRRP numeric(15, 5) numeric(15, 5) -
LOWER60SECROP numeric(15, 5) numeric(15, 5) -
LOWER60SECAPCFLAG numeric(3, 0) tinyint -
LOWER5MINRRP numeric(15, 5) numeric(15, 5) -
LOWER5MINROP numeric(15, 5) numeric(15, 5) -
LOWER5MINAPCFLAG numeric(3, 0) tinyint -
LOWERREGRRP numeric(15, 5) numeric(15, 5) -
LOWERREGROP numeric(15, 5) numeric(15, 5) -
LOWERREGAPCFLAG numeric(3, 0) tinyint -
PRICE_STATUS varchar(20) varchar(20) Status of regional prices for this dispatch interval \"NOT FIRM\" or \"FIRM\"
PRE_AP_ENERGY_PRICE numeric(15, 5) numeric(15, 5) Price before ap capping or scaling - for rolling sum price monitoring
PRE_AP_RAISE6_PRICE numeric(15, 5) numeric(15, 5) Price before ap capping or scaling - for rolling sum price monitoring
PRE_AP_RAISE60_PRICE numeric(15, 5) numeric(15, 5) Price before ap capping or scaling - for rolling sum price monitoring
PRE_AP_RAISE5MIN_PRICE numeric(15, 5) numeric(15, 5) Price before ap capping or scaling - for rolling sum price monitoring
PRE_AP_RAISEREG_PRICE numeric(15, 5) numeric(15, 5) Price before ap capping or scaling - for rolling sum price monitoring
PRE_AP_LOWER6_PRICE numeric(15, 5) numeric(15, 5) Price before ap capping or scaling - for rolling sum price monitoring
PRE_AP_LOWER60_PRICE numeric(15, 5) numeric(15, 5) Price before ap capping or scaling - for rolling sum price monitoring
PRE_AP_LOWER5MIN_PRICE numeric(15, 5) numeric(15, 5) Price before ap capping or scaling - for rolling sum price monitoring
PRE_AP_LOWERREG_PRICE numeric(15, 5) numeric(15, 5) Price before ap capping or scaling - for rolling sum price monitoring
CUMUL_PRE_AP_ENERGY_PRICE numeric(15, 5) numeric(15, 5) Cumulative price that triggers administered pricing event if above the threshold
CUMUL_PRE_AP_RAISE6_PRICE numeric(15, 5) numeric(15, 5) Cumulative price that triggers administered pricing event if above the threshold
CUMUL_PRE_AP_RAISE60_PRICE numeric(15, 5) numeric(15, 5) Cumulative price that triggers administered pricing event if above the threshold
CUMUL_PRE_AP_RAISE5MIN_PRICE numeric(15, 5) numeric(15, 5) Cumulative price that triggers administered pricing event if above the threshold
CUMUL_PRE_AP_RAISEREG_PRICE numeric(15, 5) numeric(15, 5) Cumulative price that triggers administered pricing event if above the threshold
CUMUL_PRE_AP_LOWER6_PRICE numeric(15, 5) numeric(15, 5) Cumulative price that triggers administered pricing event if above the threshold
CUMUL_PRE_AP_LOWER60_PRICE numeric(15, 5) numeric(15, 5) Cumulative price that triggers administered pricing event if above the threshold
CUMUL_PRE_AP_LOWER5MIN_PRICE numeric(15, 5) numeric(15, 5) Cumulative price that triggers administered pricing event if above the threshold
CUMUL_PRE_AP_LOWERREG_PRICE numeric(15, 5) numeric(15, 5) Cumulative price that triggers administered pricing event if above the threshold
OCD_STATUS varchar(14) varchar(14) Communicates the current OCD status for this dispatch interval. Values of: ''NOT_OCD'', ''OCD_UNRESOLVED'', ''OCD_RESOLVED''.
MII_STATUS varchar(21) varchar(21) Communicates the current MII status for this dispatch interval. Values of: ''NOT_MII'', ''MII_SUBJECT_TO_REVIEW'', ''MII_PRICE_REJECTED'', ''MII_PRICE_ACCEPTED''.
CUMUL_PRE_AP_LOWER1_PRICE numeric(15, 5) numeric(15, 5) Cumulative price that triggers administered pricing event if above the threshold
CUMUL_PRE_AP_RAISE1_PRICE numeric(15, 5) numeric(15, 5) Cumulative price that triggers administered pricing event if above the threshold
LOWER1SECAPCFLAG numeric(3, 0) tinyint BitFlag field for Price adjustments - \"1\" = Voll_Override; \"4\" = Floor_VoLL; \"8\" = Manual_Override; \"16\" = Price_Scaled
LOWER1SECROP numeric(15, 5) numeric(15, 5) Lower1Sec Regional Original Price - uncapped/unfloored and unscaled
LOWER1SECRRP numeric(15, 5) numeric(15, 5) Regional Lower 1Sec Price - RegionSolution element L1Price attribute
PRE_AP_LOWER1_PRICE numeric(15, 5) numeric(15, 5) Price before AP capping or scaling - for Rolling Sum Price monitoring
PRE_AP_RAISE1_PRICE numeric(15, 5) numeric(15, 5) Price before AP capping or scaling - for Rolling Sum Price monitoring
RAISE1SECAPCFLAG numeric(3, 0) tinyint BitFlag field for Price adjustments - \"1\" = Voll_Override; \"4\" = Floor_VoLL; \"8\" = Manual_Override; \"16\" = Price_Scaled
RAISE1SECROP numeric(15, 5) numeric(15, 5) Raise1Sec Regional Original Price - uncapped/unfloored and unscaled
RAISE1SECRRP numeric(15, 5) numeric(15, 5) Regional Raise 1Sec Price - R1Price attribute after capping/flooring
RUNNO numeric(3, 0) 🔑 - -
DISPATCHINTERVAL varchar(22) 🔑 - -

Official MMS data model indexes

Index name Index type Index columns (in order)
DISPATCHPRICE_LCX nonclustered LASTCHANGED
PK_DISPATCHPRICE clustered, unique, primary key SETTLEMENTDATE, RUNNO, REGIONID, DISPATCHINTERVAL, INTERVENTION

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_DISPATCHPRICE clustered, unique, primary key SETTLEMENTDATE, INTERVENTION, REGIONID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
DISPATCHPRICE_CCI clustered, columnstore n/a
PK_DISPATCHPRICE nonclustered, unique, primary key SETTLEMENTDATE, INTERVENTION, REGIONID