|
Name |
|
|
Comment |
PREDISPATCHINTERSENSITIVITIES sets out the sensitivity flows for each interconnector by period. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
DATETIME |
|
INTERCONNECTORID |
|
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. |
|
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 this period has 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 |
|
|
|