|
Name |
|
|
Comment |
PREDISPATCHPRICE records predispatch prices for each region by period for each predispatch run, including fields to handle the Ancillary Services functionality. |
|
PREDISPATCHPRICE data is public, so is available to all participants. Source PREDISPATCHPRICE updates with every thirty-minute predispatch run. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
DATETIME |
|
REGIONID |
|
Name |
|
LASTCHANGED |
|
Name |
|
PREDISPATCHSEQNO |
|
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 |
|
RRP |
NUMBER(15,5) |
|
Regional Reference Price |
|
EEP |
NUMBER(15,5) |
|
Excess energy price |
|
RRP1 |
NUMBER(15,5) |
|
Not used |
|
EEP1 |
NUMBER(15,5) |
|
Not used |
|
RRP2 |
NUMBER(15,5) |
|
Not used |
|
EEP2 |
NUMBER(15,5) |
|
Not used |
|
RRP3 |
NUMBER(15,5) |
|
Not used |
|
EEP3 |
NUMBER(15,5) |
|
Not used |
|
RRP4 |
NUMBER(15,5) |
|
Not used |
|
EEP4 |
NUMBER(15,5) |
|
Not used |
|
RRP5 |
NUMBER(15,5) |
|
Not used |
|
EEP5 |
NUMBER(15,5) |
|
Not used |
|
RRP6 |
NUMBER(15,5) |
|
Not used |
|
EEP6 |
NUMBER(15,5) |
|
Not used |
|
RRP7 |
NUMBER(15,5) |
|
Not used |
|
EEP7 |
NUMBER(15,5) |
|
Not used |
|
RRP8 |
NUMBER(15,5) |
|
Not used |
|
EEP8 |
NUMBER(15,5) |
|
Not used |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
DATETIME |
DATE |
X |
Period date and time |
|
RAISE6SECRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
|
RAISE60SECRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
|
RAISE5MINRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
|
RAISEREGRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
|
LOWER6SECRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
|
LOWER60SECRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
|
LOWER5MINRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
|
LOWERREGRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
|
|
|