Skip to content

P5MIN_INTERSENSITIVITIES

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
INTERCONNECTORID varchar(20) 🔑 varchar(20) 🔑 Interconnector identifier
INTERVAL_DATETIME datetime(3) 🔑 datetime2(0) 🔑 The unique identifier for the interval within this study
INTERVENTION numeric(1, 0) (not nullable) bit (not nullable) 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)
INTERVENTION_ACTIVE numeric(1, 0) bit (not nullable) Flag to indicate if the sensitivity run contains an active intervention constraint: 0 = No, 1 = Yes
MWFLOW1 numeric(15, 5) numeric(15, 5) MW Flow value. Flow1 = MW flow for given Interconnector for Scenario 1
MWFLOW2 numeric(15, 5) numeric(15, 5) MW Flow value. Flow2 = MW flow for given Interconnector for Scenario 2
MWFLOW3 numeric(15, 5) numeric(15, 5) MW Flow value. Flow3 = MW flow for given Interconnector for Scenario 3
MWFLOW4 numeric(15, 5) numeric(15, 5) MW Flow value. Flow4 = MW flow for given Interconnector for Scenario 4
MWFLOW5 numeric(15, 5) numeric(15, 5) MW Flow value. Flow5 = MW flow for given Interconnector for Scenario 5
MWFLOW6 numeric(15, 5) numeric(15, 5) MW Flow value. Flow6 = MW flow for given Interconnector for Scenario 6
MWFLOW7 numeric(15, 5) numeric(15, 5) MW Flow value. Flow7 = MW flow for given Interconnector for Scenario 7
MWFLOW8 numeric(15, 5) numeric(15, 5) MW Flow value. Flow8 = MW flow for given Interconnector for Scenario 8
MWFLOW9 numeric(15, 5) numeric(15, 5) MW Flow value. Flow9 = MW flow for given Interconnector for Scenario 9
MWFLOW10 numeric(15, 5) numeric(15, 5) MW Flow value. Flow10 = MW flow for given Interconnector for Scenario 10
MWFLOW11 numeric(15, 5) numeric(15, 5) MW Flow value. Flow11 = MW flow for given Interconnector for Scenario 11
MWFLOW12 numeric(15, 5) numeric(15, 5) MW Flow value. Flow12 = MW flow for given Interconnector for Scenario 12
MWFLOW13 numeric(15, 5) numeric(15, 5) MW Flow value. Flow13 = MW flow for given Interconnector for Scenario 13
MWFLOW14 numeric(15, 5) numeric(15, 5) MW Flow value. Flow14 = MW flow for given Interconnector for Scenario 14
MWFLOW15 numeric(15, 5) numeric(15, 5) MW Flow value. Flow15 = MW flow for given Interconnector for Scenario 15
MWFLOW16 numeric(15, 5) numeric(15, 5) MW Flow value. Flow16 = MW flow for given Interconnector for Scenario 16
MWFLOW17 numeric(15, 5) numeric(15, 5) MW Flow value. Flow17 = MW flow for given Interconnector for Scenario 17
MWFLOW18 numeric(15, 5) numeric(15, 5) MW Flow value. Flow18 = MW flow for given Interconnector for Scenario 18
MWFLOW19 numeric(15, 5) numeric(15, 5) MW Flow value. Flow19 = MW flow for given Interconnector for Scenario 19
MWFLOW20 numeric(15, 5) numeric(15, 5) MW Flow value. Flow20 = MW flow for given Interconnector for Scenario 20
MWFLOW21 numeric(15, 5) numeric(15, 5) MW Flow value. Flow21 = MW flow for given Interconnector for Scenario 21
MWFLOW22 numeric(15, 5) numeric(15, 5) MW Flow value. Flow22 = MW flow for given Interconnector for Scenario 22
MWFLOW23 numeric(15, 5) numeric(15, 5) MW Flow value. Flow23 = MW flow for given Interconnector for Scenario 23
MWFLOW24 numeric(15, 5) numeric(15, 5) MW Flow value. Flow24 = MW flow for given Interconnector for Scenario 24
MWFLOW25 numeric(15, 5) numeric(15, 5) MW Flow value. Flow25 = MW flow for given Interconnector for Scenario 25
MWFLOW26 numeric(15, 5) numeric(15, 5) MW Flow value. Flow26 = MW flow for given Interconnector for Scenario 26
MWFLOW27 numeric(15, 5) numeric(15, 5) MW Flow value. Flow27 = MW flow for given Interconnector for Scenario 27
MWFLOW28 numeric(15, 5) numeric(15, 5) MW Flow value. Flow28 = MW flow for given Interconnector for Scenario 28
MWFLOW29 numeric(15, 5) numeric(15, 5) MW Flow value. Flow29 = MW flow for given Interconnector for Scenario 29
MWFLOW30 numeric(15, 5) numeric(15, 5) MW Flow value. Flow30 = MW flow for given Interconnector for Scenario 30
MWFLOW31 numeric(15, 5) numeric(15, 5) MW Flow value. Flow31 = MW flow for given Interconnector for Scenario 31
MWFLOW32 numeric(15, 5) numeric(15, 5) MW Flow value. Flow32 = MW flow for given Interconnector for Scenario 32
MWFLOW33 numeric(15, 5) numeric(15, 5) MW Flow value. Flow33 = MW flow for given Interconnector for Scenario 33
MWFLOW34 numeric(15, 5) numeric(15, 5) MW Flow value. Flow34 = MW flow for given Interconnector for Scenario 34
MWFLOW35 numeric(15, 5) numeric(15, 5) MW Flow value. Flow35 = MW flow for given Interconnector for Scenario 35
MWFLOW36 numeric(15, 5) numeric(15, 5) MW Flow value. Flow36 = MW flow for given Interconnector for Scenario 36
MWFLOW37 numeric(15, 5) numeric(15, 5) MW Flow value. Flow37 = MW flow for given Interconnector for Scenario 37
MWFLOW38 numeric(15, 5) numeric(15, 5) MW Flow value. Flow38 = MW flow for given Interconnector for Scenario 38
MWFLOW39 numeric(15, 5) numeric(15, 5) MW Flow value. Flow39 = MW flow for given Interconnector for Scenario 39
MWFLOW40 numeric(15, 5) numeric(15, 5) MW Flow value. Flow40 = MW flow for given Interconnector for Scenario 40
MWFLOW41 numeric(15, 5) numeric(15, 5) MW Flow value. Flow41 = MW flow for given Interconnector for Scenario 41
MWFLOW42 numeric(15, 5) numeric(15, 5) MW Flow value. Flow42 = MW flow for given Interconnector for Scenario 42
MWFLOW43 numeric(15, 5) numeric(15, 5) MW Flow value. Flow43 = MW flow for given Interconnector 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_INTERSENSITIVITIES_PK clustered, unique, primary key RUN_DATETIME, INTERCONNECTORID, INTERVAL_DATETIME

GR-MMS data model indexes

Index name Index type Index columns (in order)
PK_P5MIN_INTERSENSITIVITIES clustered, unique, primary key RUN_DATETIME, INTERCONNECTORID, INTERVAL_DATETIME

Historical-MMS data model indexes

Index name Index type Index columns (in order)
P5MIN_INTERSENSITIVITIES_CCI clustered, columnstore n/a
PK_P5MIN_INTERSENSITIVITIES nonclustered, unique, primary key RUN_DATETIME, INTERCONNECTORID, INTERVAL_DATETIME