Table: PREDISPATCHPRICESENSITIVITIES

PREDISPATCHPRICESENSITIVITIES

Name

PREDISPATCHPRICESENSITIVITIES

Comment

PREDISPATCHPRICESENSITIVITIES sets out the sensitivity prices for each region by period.


Description

Source

The plan is to provide this data every half-hour.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

DATETIME

REGIONID


Index Columns

Name

PREDISPATCHSEQNO


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.

REGIONID

VARCHAR2(10)

X

Unique region 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

RRPEEP1

NUMBER(15,5)

 

Regional Energy Price for scenario 1

RRPEEP2

NUMBER(15,5)

 

Regional Energy Price for scenario 2

RRPEEP3

NUMBER(15,5)

 

Regional Energy Price for scenario 3

RRPEEP4

NUMBER(15,5)

 

Regional Energy Price for scenario 4

RRPEEP5

NUMBER(15,5)

 

Regional Energy Price for scenario 5

RRPEEP6

NUMBER(15,5)

 

Regional Energy Price for scenario 6

RRPEEP7

NUMBER(15,5)

 

Regional Energy Price for scenario 7

RRPEEP8

NUMBER(15,5)

 

Regional Energy Price for scenario 8

RRPEEP9

NUMBER(15,5)

 

Regional Energy Price for scenario 9

RRPEEP10

NUMBER(15,5)

 

Regional Energy Price for scenario 10

RRPEEP11

NUMBER(15,5)

 

Regional Energy Price for scenario 11

RRPEEP12

NUMBER(15,5)

 

Regional Energy Price for scenario 12

RRPEEP13

NUMBER(15,5)

 

Regional Energy Price for scenario 13

RRPEEP14

NUMBER(15,5)

 

Regional Energy Price for scenario 14

RRPEEP15

NUMBER(15,5)

 

Regional Energy Price for scenario 15

RRPEEP16

NUMBER(15,5)

 

Regional Energy Price for scenario 16

RRPEEP17

NUMBER(15,5)

 

Regional Energy Price for scenario 17

RRPEEP18

NUMBER(15,5)

 

Regional Energy Price for scenario 18

RRPEEP19

NUMBER(15,5)

 

Regional Energy Price for scenario 19

RRPEEP20

NUMBER(15,5)

 

Regional Energy Price for scenario 20

RRPEEP21

NUMBER(15,5)

 

Regional Energy Price for scenario 21

RRPEEP22

NUMBER(15,5)

 

Regional Energy Price for scenario 22

RRPEEP23

NUMBER(15,5)

 

Regional Energy Price for scenario 23

RRPEEP24

NUMBER(15,5)

 

Regional Energy Price for scenario 24

RRPEEP25

NUMBER(15,5)

 

Regional Energy Price for scenario 25

RRPEEP26

NUMBER(15,5)

 

Regional Energy Price for scenario 26

RRPEEP27

NUMBER(15,5)

 

Regional Energy Price for scenario 27

RRPEEP28

NUMBER(15,5)

 

Regional Energy Price for scenario 28

LASTCHANGED

DATE

 

Last date and time record changed

DATETIME

DATE

X

Period date and time

RRPEEP29

NUMBER(15,5)

 

Regional Energy Price for scenario 29

RRPEEP30

NUMBER(15,5)

 

Regional Energy Price for scenario 30

RRPEEP31

NUMBER(15,5)

 

Regional Energy Price for scenario 31

RRPEEP32

NUMBER(15,5)

 

Regional Energy Price for scenario 32

RRPEEP33

NUMBER(15,5)

 

Regional Energy Price for scenario 33

RRPEEP34

NUMBER(15,5)

 

Regional Energy Price for scenario 34

RRPEEP35

NUMBER(15,5)

 

Regional Energy Price for scenario 35

INTERVENTION_ACTIVE

NUMBER(1,0)

 

Flag to indicate if this period has an active intervention constraint: 0= No, 1= Yes

RRPEEP36

NUMBER(15,5)

 

Regional Energy Price for scenario 36

RRPEEP37

NUMBER(15,5)

 

Regional Energy Price for scenario 37

RRPEEP38

NUMBER(15,5)

 

Regional Energy Price for scenario 38

RRPEEP39

NUMBER(15,5)

 

Regional Energy Price for scenario 39

RRPEEP40

NUMBER(15,5)

 

Regional Energy Price for scenario 40

RRPEEP41

NUMBER(15,5)

 

Regional Energy Price for scenario 41

RRPEEP42

NUMBER(15,5)

 

Regional Energy Price for scenario 42


2