Skip to content

PD7DAY_PRICESOLUTION

PD7DAY price solution.

Package

PD7DAY

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
RUN_DATETIME datetime(3) 🔑 datetime2(0) 🔑 Unique Timestamp Identifier for this study
INTERVENTION numeric(2, 0) 🔑 tinyint 🔑 Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run.
INTERVAL_DATETIME datetime(3) 🔑 datetime2(0) 🔑 The unique identifier for the interval within this study
REGIONID varchar(20) 🔑 varchar(10) 🔑 Region Identifier
RRP numeric(15, 5) numeric(15, 5) (not nullable) Region Reference Price (Energy)
LOWER1SECRRP numeric(15, 5) numeric(15, 5) Regional Lower 1Sec Price - RegionSolution element L1Price attribute
LOWER6SECRRP numeric(15, 5) numeric(15, 5) (not nullable) Region Reference Price (Lower6Sec)
LOWER60SECRRP numeric(15, 5) numeric(15, 5) (not nullable) Region Reference Price (Lower60Sec)
LOWER5MINRRP numeric(15, 5) numeric(15, 5) (not nullable) Region Reference Price (Lower5Min)
LOWERREGRRP numeric(15, 5) numeric(15, 5) (not nullable) Region Reference Price (LowerReg)
RAISE1SECRRP numeric(15, 5) numeric(15, 5) Regional Raise 1Sec Price - R1Price attribute after capping/flooring
RAISE6SECRRP numeric(15, 5) numeric(15, 5) (not nullable) Region Reference Price (Raise6Sec)
RAISE60SECRRP numeric(15, 5) numeric(15, 5) (not nullable) Region Reference Price (Raise60Sec)
RAISE5MINRRP numeric(15, 5) numeric(15, 5) (not nullable) Region Reference Price (Raise5Min)
RAISEREGRRP numeric(15, 5) numeric(15, 5) (not nullable) Region Reference Price (RaiseReg)
LASTCHANGED datetime(3) datetime2(0) (not nullable) Last date and time record changed
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)
PD7DAY_PRICESOLUTION_PK clustered, unique, primary key RUN_DATETIME, INTERVAL_DATETIME, REGIONID, INTERVENTION

GR-MMS data model indexes

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

Historical-MMS data model indexes

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