Skip to content

TRADINGREGIONSUM (Historical table)

TRADINGREGIONSUM sets out the half-hourly average regional demand and frequency control services. TRADINGREGIONSUM includes fields for the Raise Regulation and Lower Regulation Ancillary Services plus improvements to demand calculations.

Package

HISTORICAL_TABLES

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
SETTLEMENTDATE datetime(3) 🔑 datetime2(0) 🔑 Date that this data applies to
REGIONID varchar(10) 🔑 varchar(10) 🔑 Region Identifier
PERIODID numeric(3, 0) 🔑 smallint (not nullable) Trading interval identifier within settlement day.
TOTALDEMAND numeric(15, 5) numeric(15, 5) Total demand for region
AVAILABLEGENERATION numeric(15, 5) numeric(15, 5) The available generation in the Region for the interval
AVAILABLELOAD numeric(15, 5) numeric(15, 5) Not used
DEMANDFORECAST numeric(15, 5) numeric(15, 5) Forecast demand for region
DISPATCHABLEGENERATION numeric(15, 5) numeric(15, 5) Averaged generation dispatched in region
DISPATCHABLELOAD numeric(15, 5) numeric(15, 5) Averaged load dispatched in region
NETINTERCHANGE numeric(15, 5) numeric(15, 5) Average energy transferred over interconnector
EXCESSGENERATION numeric(15, 5) numeric(15, 5) Average excess generation in region
LOWER5MINDISPATCH numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 5 min MW dispatch
LOWER5MINIMPORT numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 5 min MW imported
LOWER5MINLOCALDISPATCH numeric(15, 5) numeric(15, 5) Lower 5 min local dispatch
LOWER5MINLOCALPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Local price of lower 5 min
LOWER5MINLOCALREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 5 min local requirement
LOWER5MINPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Regional price of lower 5 min
LOWER5MINREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 5 min total requirement
LOWER5MINSUPPLYPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Supply price of lower 5 min
LOWER60SECDISPATCH numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 60 sec MW dispatch
LOWER60SECIMPORT numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 60 sec MW imported
LOWER60SECLOCALDISPATCH numeric(15, 5) numeric(15, 5) Lower 60 sec local dispatch
LOWER60SECLOCALPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Local price of lower 60 sec
LOWER60SECLOCALREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 60 sec local requirement
LOWER60SECPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Regional price of lower 60 sec
LOWER60SECREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 60 sec total requirement
LOWER60SECSUPPLYPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Supply price of lower 60 sec
LOWER6SECDISPATCH numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 6 sec MW dispatch
LOWER6SECIMPORT numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 6 sec MW imported
LOWER6SECLOCALDISPATCH numeric(15, 5) numeric(15, 5) Lower 6 sec local dispatch
LOWER6SECLOCALPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Local price of lower 6 sec
LOWER6SECLOCALREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 6 sec local requirement
LOWER6SECPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Regional price of lower 6 sec
LOWER6SECREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 6 sec total requirement
LOWER6SECSUPPLYPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Supply price of lower 6 sec
RAISE5MINDISPATCH numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 5 min MW dispatch
RAISE5MINIMPORT numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 5 min MW imported
RAISE5MINLOCALDISPATCH numeric(15, 5) numeric(15, 5) Raise 5 min local dispatch
RAISE5MINLOCALPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Local price of raise 5 min
RAISE5MINLOCALREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 5 min local requirement
RAISE5MINPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Regional price of raise 5 min
RAISE5MINREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 5 min total requirement
RAISE5MINSUPPLYPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Supply price of raise 5 min
RAISE60SECDISPATCH numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 60 sec MW dispatch
RAISE60SECIMPORT numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 60 sec MW imported
RAISE60SECLOCALDISPATCH numeric(15, 5) numeric(15, 5) Raise 60 sec local dispatch
RAISE60SECLOCALPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Local price of raise 60 sec
RAISE60SECLOCALREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 60 sec local requirement
RAISE60SECPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Regional price of raise 60 sec
RAISE60SECREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 60 sec total requirement
RAISE60SECSUPPLYPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Supply price of raise 60 sec
RAISE6SECDISPATCH numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 6 sec MW dispatch
RAISE6SECIMPORT numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 6 sec MW imported
RAISE6SECLOCALDISPATCH numeric(15, 5) numeric(15, 5) Raise 6 sec local dispatch
RAISE6SECLOCALPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Local price of raise 6 sec
RAISE6SECLOCALREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 6 sec local requirement
RAISE6SECPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Regional price of raise 6 sec
RAISE6SECREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 6 sec total requirement
RAISE6SECSUPPLYPRICE numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Supply price of raise 6 sec
LASTCHANGED datetime(3) datetime2(0) Last date and time record changed
INITIALSUPPLY numeric(15, 5) numeric(15, 5) Sum of initial generation and import for region
CLEAREDSUPPLY numeric(15, 5) numeric(15, 5) Sum of cleared generation and import for region
LOWERREGIMPORT numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower Regulation MW imported
LOWERREGLOCALDISPATCH numeric(15, 5) numeric(15, 5) Lower Regulation local dispatch
LOWERREGLOCALREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower Regulation local requirement
LOWERREGREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower Regulation total requirement
RAISEREGIMPORT numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise Regulation MW imported
RAISEREGLOCALDISPATCH numeric(15, 5) numeric(15, 5) Raise Regulation local dispatch
RAISEREGLOCALREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise Regulation local requirement
RAISEREGREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise Regulation total requirement
RAISE5MINLOCALVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Raise 5 min local requirement
RAISEREGLOCALVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Raise Reg local requirement
RAISE60SECLOCALVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Raise 60 sec local requirement
RAISE6SECLOCALVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Raise 6 sec local requirement
LOWER5MINLOCALVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Lower 5 min local requirement
LOWERREGLOCALVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Lower Reg local requirement
LOWER60SECLOCALVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Lower 60 sec local requirement
LOWER6SECLOCALVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Lower 6 sec local requirement
RAISE5MINVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Raise 5 min requirement
RAISEREGVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Raise Reg requirement
RAISE60SECVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Raise 60 seconds requirement
RAISE6SECVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Raise 6 seconds requirement
LOWER5MINVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Lower 5 min requirement
LOWERREGVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Lower Reg requirement
LOWER60SECVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Lower 60 seconds requirement
LOWER6SECVIOLATION numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Violation (MW) of Lower 6 seconds requirement
TOTALINTERMITTENTGENERATION numeric(15, 5) numeric(15, 5) Allowance made for non-scheduled generation in the demand forecast (MW).
DEMAND_AND_NONSCHEDGEN numeric(15, 5) numeric(15, 5) Sum of Cleared Scheduled generation, imported generation (at the region boundary) and allowances made for non-scheduled generation (MW).
UIGF numeric(15, 5) numeric(15, 5) Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW).
RUNNO numeric(3, 0) 🔑 - -

Official MMS data model indexes

Index name Index type Index columns (in order)
PK_TRADNGREGIONSUM clustered, unique, primary key SETTLEMENTDATE, RUNNO, REGIONID, PERIODID
TRADINGREGIONSUM_LCX nonclustered LASTCHANGED

GR-MMS data model indexes

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

Historical-MMS data model indexes

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