Name |
|
Comment |
TRADINGPRICE sets out half-hourly spot market price, including fields to handle the Ancillary Services functionality. If prices are adjusted, the final price is recorded in the regional reference price (RRP) field with price before adjustment recorded in the regional original price (ROP) field. |
TRADINGPRICE data is public, so is available to all participants. Source TRADINGPRICE updates every 30 minutes. Notes INVALIDFLAG The INVALIDFLAG field is used to indicate whether the Trading interval price has been adjusted after the trading interval was completed. On a very restricted set of events, the market rules allow a dispatch price (5 min) to be adjusted on the next business day, and, when this occurs, the corresponding trading interval price for that region is also adjusted and marked as adjusted with INVALIDFLAG of 'A'. The INVALIDFLAG = 'Y' only applies to historical periods when not all six of the 5-minute dispatch intervals were run in the trading interval. System changes implemented on 30 September 2001 mean this situation no longer occurs since missing dispatch intervals are automatically populated from a previous interval. If the INVALIDFLAG field = '0', the price was not adjusted and all six dispatch intervals are present. Prices There is no field in the TRADINGPRICE table (or the MMS data model anywhere) telling you that the price is provisional or final. The only reliable method is to ensure that the trading date is at least 2 business days old. |
Name |
Comment |
Value |
Visibility |
Data in this table is: |
Public |
Name |
PERIODID |
REGIONID |
RUNNO |
SETTLEMENTDATE |
Name |
LASTCHANGED |
Name |
Data Type |
Mandatory |
Comment |
SETTLEMENTDATE |
DATE |
X |
Date that this data applies to |
RUNNO |
NUMBER(3,0) |
X |
Run No |
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
PERIODID |
NUMBER(3,0) |
X |
Trading Interval Period |
RRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
EEP |
NUMBER(15,5) |
|
Excess energy price where negative average |
INVALIDFLAG |
VARCHAR2(1) |
|
Indicates when the Trading interval price has been adjusted after the trading interval was completed |
LASTCHANGED |
DATE |
|
Last date and time record changed |
ROP |
NUMBER(15,5) |
|
Regional Original Price. The price before any adjustments were made |
RAISE6SECRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
RAISE6SECROP |
NUMBER(15,5) |
|
Original regional price - prior to APC or VoLL overrides applied |
RAISE60SECRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
RAISE60SECROP |
NUMBER(15,5) |
|
Original regional price - prior to APC or VoLL overrides applied |
RAISE5MINRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
RAISE5MINROP |
NUMBER(15,5) |
|
Original regional price - prior to APC or VoLL overrides applied |
RAISEREGRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
RAISEREGROP |
NUMBER(15,5) |
|
Original regional price - prior to APC or VoLL overrides applied |
LOWER6SECRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
LOWER6SECROP |
NUMBER(15,5) |
|
Original regional price - prior to APC or VoLL overrides applied |
LOWER60SECRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
LOWER60SECROP |
NUMBER(15,5) |
|
Original regional price - prior to APC or VoLL overrides applied |
LOWER5MINRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
LOWER5MINROP |
NUMBER(15,5) |
|
Original regional price - prior to APC or VoLL overrides applied |
LOWERREGRRP |
NUMBER(15,5) |
|
Regional reference price for this dispatch period |
LOWERREGROP |
NUMBER(15,5) |
|
Original regional price - prior to APC or VoLL overrides applied |
PRICE_STATUS |
VARCHAR2(20) |
|
Status of regional prices for this dispatch interval "NOT FIRM" or "FIRM" |
|
|
|