|
Name |
|
|
Comment |
An audit trail of price changes on the DISPATCHPRICE table (i.e. for 5 minute dispatch prices for energy and FCAS). |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
BIDTYPE |
|
INTERVENTION |
|
REGIONID |
|
RUNNO |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
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 |
|
|
|