Table: PREDISPATCHINTERSENSITIVITIES

PREDISPATCHINTERSENSITIVITIES

Name

PREDISPATCHINTERSENSITIVITIES

Comment

PREDISPATCHINTERSENSITIVITIES sets out the sensitivity flows for each interconnector by period.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

DATETIME

INTERCONNECTORID


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

PREDISPATCHSEQNO

VARCHAR2(20)

 

Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30

RUNNO

NUMBER(3,0)

 

LP Solver Predispatch run no, typically 1. It increments if the case is re-run.

INTERCONNECTORID

VARCHAR2(10)

X

Unique interconnector identifier

PERIODID

VARCHAR2(20)

 

PERIODID is just a period count, starting from 1 for each predispatch run. Use DATETIME to determine half hour period.

INTERVENTION

NUMBER(2,0)

 

Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run (INTERVENTION=1). In the event that there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0

DATETIME

DATE

X

Period date and time

INTERVENTION_ACTIVE

NUMBER(1,0)

 

Flag to indicate if the sensitivity run contains an active intervention constraint: 0 = No, 1 = Yes

MWFLOW1

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 1

MWFLOW2

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 2

MWFLOW3

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 3

MWFLOW4

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 4

MWFLOW5

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 5

MWFLOW6

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 6

MWFLOW7

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 7

MWFLOW8

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 8

MWFLOW9

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 9

MWFLOW10

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 10

MWFLOW11

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 11

MWFLOW12

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 12

MWFLOW13

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 13

MWFLOW14

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 14

MWFLOW15

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 15

MWFLOW16

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 16

MWFLOW17

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 17

MWFLOW18

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 18

MWFLOW19

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 19

MWFLOW20

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 20

MWFLOW21

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 21

MWFLOW22

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 22

MWFLOW23

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 23

MWFLOW24

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 24

MWFLOW25

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 25

MWFLOW26

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 26

MWFLOW27

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 27

MWFLOW28

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 28

MWFLOW29

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 29

MWFLOW30

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 30

MWFLOW31

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 31

MWFLOW32

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 32

MWFLOW33

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 33

MWFLOW34

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 34

MWFLOW35

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 35

MWFLOW36

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 36

MWFLOW37

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 37

MWFLOW38

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 38

MWFLOW39

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 39

MWFLOW40

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 40

MWFLOW41

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 41

MWFLOW42

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 42

MWFLOW43

NUMBER(15,5)

 

MW flow for given Interconnector for scenario 43


2