Table: PREDISPATCHPRICE

PREDISPATCHPRICE

Name

PREDISPATCHPRICE

Comment

PREDISPATCHPRICE records predispatch prices for each region by period for each predispatch run, including fields to handle the Ancillary Services functionality.


Description

PREDISPATCHPRICE data is public, so is available to all participants.

Source

PREDISPATCHPRICE updates with every thirty-minute predispatch run.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

DATETIME

REGIONID


Index Columns

Name

LASTCHANGED


Index Columns

Name

PREDISPATCHSEQNO


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

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