Skip to content

P5MIN_PRICESENSITIVITIES

Price Sensitivies for 5MinPD solution. New solution every 5 minutes. Current Scenarios defined in P5MIN_SCENARIODEMANDTRK / P5MIN_SCENARIODEMAND.

Package

P5MIN

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
RUN_DATETIME datetime(3) 🔑 datetime2(0) 🔑 Definitive Run from which this solution derives
REGIONID varchar(20) 🔑 varchar(20) 🔑 Region
INTERVAL_DATETIME datetime(3) 🔑 datetime2(0) 🔑 The unique identifier for the interval within this study
INTERVENTION numeric(1, 0) (not nullable) bit (not nullable) Whether an Intervention constraint was defined in this run
INTERVENTION_ACTIVE numeric(1, 0) bit (not nullable) Flag to indicate if the sensitivity run contains an active intervention constraint: 0 = No, 1 = Yes
RRP1 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 1
RRP2 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 2
RRP3 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 3
RRP4 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 4
RRP5 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 5
RRP6 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 6
RRP7 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 7
RRP8 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 8
RRP9 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 9
RRP10 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 10
RRP11 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 11
RRP12 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 12
RRP13 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 13
RRP14 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 14
RRP15 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 15
RRP16 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 16
RRP17 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 17
RRP18 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 18
RRP19 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 19
RRP20 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 20
RRP21 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 21
RRP22 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 22
RRP23 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 23
RRP24 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 24
RRP25 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 25
RRP26 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 26
RRP27 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 27
RRP28 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 28
RRP29 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 29
RRP30 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 30
RRP31 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 31
RRP32 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 32
RRP33 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 33
RRP34 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 34
RRP35 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 35
RRP36 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 36
RRP37 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 37
RRP38 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 38
RRP39 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 39
RRP40 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 40
RRP41 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 41
RRP42 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 42
RRP43 numeric(15, 5) numeric(15, 5) Regional Reference price for scenario 43
LASTCHANGED datetime(3) datetime2(0) Timestamp when this record was last modified

Official MMS data model indexes

Index name Index type Index columns (in order)
P5MIN_PRICESENSITIVITIES_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_PRICESENSITIVITIES clustered, unique, primary key RUN_DATETIME, REGIONID, INTERVAL_DATETIME

Historical-MMS data model indexes

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