Table: DISPATCH_PRICE_REVISION

DISPATCH_PRICE_REVISION

Name

DISPATCH_PRICE_REVISION

Comment

An audit trail of price changes on the DISPATCHPRICE table (i.e. for 5 minute dispatch prices for energy and FCAS).


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

BIDTYPE

INTERVENTION

REGIONID

RUNNO

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Market date and time starting at 04:05

RUNNO

NUMBER(3,0)

X

Dispatch run no; always 1

INTERVENTION

NUMBER(2,0)

X

Manual intervention flag; always 0

REGIONID

VARCHAR2(10)

X

Affected Region Identifier

BIDTYPE

VARCHAR2(10)

X

Affected Bid Type Identifier

VERSIONNO

NUMBER(3)

X

Version No of price revision for this settlement date

RRP_NEW

NUMBER(15,5)

 

New RRP in DISPATCHPRICE table

RRP_OLD

NUMBER(15,5)

 

Old RRP from DISPATCHPRICE table

LASTCHANGED

DATE

 

The datetime the record was last changed