|
Name |
|
|
Comment |
PREDISPATCHPRICESENSITIVITIES sets out the sensitivity prices for each region by period. |
|
Source The plan is to provide this data every half-hour. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
DATETIME |
|
REGIONID |
|
Name |
|
PREDISPATCHSEQNO |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|