|
Name |
|
|
Comment |
PREDISPATCHOFFERTRK is for the ancillary service bid tracking of predispatch processing. PREDISPATCHOFFERTRK identifies which bids from BIDDAYOFFER and BIDOFFERPERIOD were applied for a given unit and ancillary service for each predispatch run. |
|
Source PREDISPATCHOFFERTRK updates every 30 minutes. The data is confidential to each participant until the next trading day. Volume Approximately 45,000 records per day. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
BIDTYPE |
|
DUID |
|
PERIODID |
|
PREDISPATCHSEQNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PREDISPATCHSEQNO |
VARCHAR2(20) |
X |
Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30 |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit identifier |
|
BIDTYPE |
VARCHAR2(20) |
X |
Bid type Identifier - the ancillary service to which the bid applies |
|
PERIODID |
VARCHAR2(20) |
X |
PERIODID is just a period count, starting from 1 for each predispatch run. Use DATETIME to determine half hour period. |
|
BIDSETTLEMENTDATE |
DATE |
|
Settlement date of bid applied |
|
BIDOFFERDATE |
TIMESTAMP(3) |
|
Time this bid was processed and loaded |
|
DATETIME |
DATE |
|
Period date and time |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
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 |
|
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 |
|
RAISE1SECRRP |
NUMBER(15,5) |
|
Regional Raise 1Sec Price - R1Price attribute after capping /flooring |
|
LOWER1SECRRP |
NUMBER(15,5) |
|
Regional Lower 1Sec Price - RegionSolution element L1Price attribute |
|
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 |
|
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 the sensitivity run contains 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 |
|
|
|