Skip to content

P5MIN_REGIONSOLUTION

The five-minute predispatch (P5Min) is a MMS system providing projected dispatch for 12 Dispatch cycles (one hour). The 5-minute Predispatch cycle runs every 5-minutes to produce a dispatch and pricing schedule to a 5-minute resolution covering the next hour, a total of twelve periods. P5MIN_REGIONSOLUTION shows the results of the regional capacity, maximum surplus reserve and maximum spare capacity evaluations for each period of the study.

Package

P5MIN

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
RUN_DATETIME datetime(3) 🔑 datetime2(0) 🔑 Unique Timestamp Identifier for this study
INTERVAL_DATETIME datetime(3) 🔑 datetime2(0) 🔑 The unique identifier for the interval within this study
REGIONID varchar(10) 🔑 varchar(10) 🔑 Region Identifier
INTERVENTION numeric(2, 0) bit 🔑 Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run (INTERVENTION=1). In the event there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0
RRP numeric(15, 5) numeric(15, 5) Region Reference Price (Energy)
ROP numeric(15, 5) numeric(15, 5) Region Override Price (Energy)
EXCESSGENERATION numeric(15, 5) numeric(15, 5) Total Energy Imbalance (MW)
RAISE6SECRRP numeric(15, 5) numeric(15, 5) Region Reference Price (Raise6Sec)
RAISE6SECROP numeric(15, 5) numeric(15, 5) Original regional price (Raise6Sec)
RAISE60SECRRP numeric(15, 5) numeric(15, 5) Region Reference Price (Raise60Sec)
RAISE60SECROP numeric(15, 5) numeric(15, 5) Original regional price (Raise60Sec)
RAISE5MINRRP numeric(15, 5) numeric(15, 5) Region Reference Price (Raise5Min)
RAISE5MINROP numeric(15, 5) numeric(15, 5) Original regional price (Raise5Min)
RAISEREGRRP numeric(15, 5) numeric(15, 5) Region Reference Price (RaiseReg)
RAISEREGROP numeric(15, 5) numeric(15, 5) Original regional price (RaiseReg)
LOWER6SECRRP numeric(15, 5) numeric(15, 5) Region Reference Price (Lower6Sec)
LOWER6SECROP numeric(15, 5) numeric(15, 5) Original regional price (Lower6Sec)
LOWER60SECRRP numeric(15, 5) numeric(15, 5) Region Reference Price (Lower60Sec)
LOWER60SECROP numeric(15, 5) numeric(15, 5) Original regional price (Lower60Sec)
LOWER5MINRRP numeric(15, 5) numeric(15, 5) Region Reference Price (Lower5Min)
LOWER5MINROP numeric(15, 5) numeric(15, 5) Original regional price (Lower5Min)
LOWERREGRRP numeric(15, 5) numeric(15, 5) Region Reference Price (LowerReg)
LOWERREGROP numeric(15, 5) numeric(15, 5) Original regional price (LowerReg)
TOTALDEMAND numeric(15, 5) numeric(15, 5) Regional Demand - NB NOT net of Interconnector flows or Loads
AVAILABLEGENERATION numeric(15, 5) numeric(15, 5) Regional Available generation
AVAILABLELOAD numeric(15, 5) numeric(15, 5) Regional Available Load
DEMANDFORECAST numeric(15, 5) numeric(15, 5) Predicted change in regional demand for this interval
DISPATCHABLEGENERATION numeric(15, 5) numeric(15, 5) Regional Generation Dispatched
DISPATCHABLELOAD numeric(15, 5) numeric(15, 5) Regional Load Dispatched
NETINTERCHANGE numeric(15, 5) numeric(15, 5) Net interconnector Flows
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
LOWER5MINLOCALREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 5 min local requirement
LOWER5MINREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 5 min total requirement
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
LOWER60SECLOCALREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 60 sec local requirement
LOWER60SECREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 60 sec total requirement
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
LOWER6SECLOCALREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 6 sec local requirement
LOWER6SECREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Lower 6 sec total requirement
RAISE5MINDISPATCH numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Total 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
RAISE5MINLOCALREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 5 min local requirement
RAISE5MINREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 5 min total requirement
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 50 sec local dispatch
RAISE60SECLOCALREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 60 sec local requirement
RAISE60SECREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 60 sec total requirement
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
RAISE6SECLOCALREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 6 sec local requirement
RAISE6SECREQ numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Raise 6 sec total requirement
AGGREGATEDISPATCHERROR numeric(15, 5) numeric(15, 5) Aggregate dispatch error applied
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
LOWERREGDISPATCH numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Total Lower Regulation dispatch
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
RAISEREGDISPATCH numeric(15, 5) numeric(15, 5) Not used since Dec 2003. Total Raise Regulation dispatch
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
LASTCHANGED datetime(3) datetime2(0) Last date and time record changed
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).
SEMISCHEDULE_CLEAREDMW numeric(15, 5) numeric(15, 5) Regional aggregated Semi-Schedule generator Cleared MW
SEMISCHEDULE_COMPLIANCEMW numeric(15, 5) numeric(15, 5) Regional aggregated Semi-Schedule generator Cleared MW where Semi-Dispatch cap is enforced
SS_SOLAR_UIGF numeric(15, 5) numeric(15, 5) Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW) where the primary fuel source is solar
SS_WIND_UIGF numeric(15, 5) numeric(15, 5) Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW) where the primary fuel source is wind
SS_SOLAR_CLEAREDMW numeric(15, 5) numeric(15, 5) Regional aggregated Semi-Schedule generator Cleared MW where the primary fuel source is solar
SS_WIND_CLEAREDMW numeric(15, 5) numeric(15, 5) Regional aggregated Semi-Schedule generator Cleared MW where the primary fuel source is wind
SS_SOLAR_COMPLIANCEMW numeric(15, 5) numeric(15, 5) Regional aggregated Semi-Schedule generator Cleared MW where Semi-Dispatch cap is enforced and the primary fuel source is solar
SS_WIND_COMPLIANCEMW numeric(15, 5) numeric(15, 5) Regional aggregated Semi-Schedule generator Cleared MW where Semi-Dispatch cap is enforced and the primary fuel source is wind
WDR_AVAILABLE numeric(15, 5) numeric(15, 5) Regional aggregated available MW for Wholesale Demand Response (WDR) units
WDR_DISPATCHED numeric(15, 5) numeric(15, 5) Regional aggregated dispatched MW for Wholesale Demand Response (WDR) units
WDR_INITIALMW numeric(15, 5) numeric(15, 5) Regional aggregated MW value at start of interval for Wholesale Demand Response (WDR) units
LOWER1SECLOCALDISPATCH numeric(15, 5) numeric(15, 5) Total Lower1Sec Dispatched in Region - RegionSolution element L1Dispatch attribute
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
RAISE1SECLOCALDISPATCH numeric(15, 5) numeric(15, 5) Total Raise1Sec Dispatched in Region - RegionSolution element R1Dispatch attribute
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
SS_SOLAR_AVAILABILITY numeric(15, 5) numeric(15, 5) For Semi-Scheduled units. Aggregate Energy Availability from Solar units in that region
SS_WIND_AVAILABILITY numeric(15, 5) numeric(15, 5) For Semi-Scheduled units. Aggregate Energy Availability from Wind units in that region
BDU_CLEAREDMW_GEN numeric(15, 5) numeric(15, 5) Regional aggregated cleared MW where the DUID type is BDU. Net of export (Generation)
BDU_CLEAREDMW_LOAD numeric(15, 5) numeric(15, 5) Regional aggregated cleared MW where the DUID type is BDU. Net of import (Load)
BDU_ENERGY_STORAGE numeric(15, 5) numeric(15, 5) Regional aggregated energy storage where the DUID type is BDU (MWh)
BDU_MAX_AVAIL numeric(15, 5) numeric(15, 5) Total available generation side BDU summated for region (MW)
BDU_MIN_AVAIL numeric(15, 5) numeric(15, 5) Total available load side BDU summated for region (MW)
BDU_INITIAL_ENERGY_STORAGE numeric(15, 5) numeric(15, 5) Energy Storage for BDU at the start of the interval(MWh) - Region Aggregated
DECGEN_INITIAL_ENERGY_STORAGE numeric(15, 5) numeric(15, 5) Energy storage for Daily Energy Constrained Scheduled Generating Units at the start of the interval(MWh) - Region Aggregated

Official MMS data model indexes

Index name Index type Index columns (in order)
P5MIN_REGIONSOLUTION_LCX nonclustered LASTCHANGED
P5MIN_REGIONSOLUTION_PK clustered, unique, primary key RUN_DATETIME, REGIONID, INTERVAL_DATETIME

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_P5MIN_REGIONSOLUTION clustered, unique, primary key RUN_DATETIME, INTERVENTION, REGIONID, INTERVAL_DATETIME

Historical-MMS data model indexes

Index name Index type Index columns (in order)
P5MIN_REGIONSOLUTION_CCI clustered, columnstore n/a
PK_P5MIN_REGIONSOLUTION nonclustered, unique, primary key REGIONID, RUN_DATETIME, INTERVAL_DATETIME, INTERVENTION