|
Name |
|
|
Comment |
PREDISPATCHLOAD shows pre-dispatch targets for each dispatchable unit, including additional fields to handle the Ancillary Services functionality. No record is written where a unit is not dispatched. PREDISPATCHLOAD shows all the results for each period. |
|
Source Own (confidential) data updates every thirty minutes, with whole market data for the day before available as part of next day market data. Note ** A flag exists for each ancillary service type such that a unit trapped or stranded in one or more service type can be immediately identified. The flag is defined using the low 3 bits as follows:
Interpretation of the bit-flags as a number gives the following possibilities (i.e. other combinations are not possible):
For example, testing for availability can be done by checking for odd (=available) or even (=unavailable) number (e.g. mod(flag,2) results in 0 for unavailable and 1 for available). *** "Actual FCAS availability" is determined in a post-processing step based on the energy target (TotalCleared) and bid FCAS trapezium for that interval. However, if the unit is outside the bid FCAS trapezium at the start of the interval (InitialMW), the "Actual FCAS availability" is set to zero. For regulation services, the trapezium is the most restrictive of the bid/SCADA trapezium values. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Private; Public Next-Day |
|
Name |
|
DATETIME |
|
DUID |
|
Name |
|
LASTCHANGED |
|
Name |
|
DUID |
|
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) |
|
SPD Predispatch run no, typically 1. It increments if the case is re-run. |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit identifier for fast start |
|
TRADETYPE |
NUMBER(2,0) |
|
Not used |
|
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 |
|
CONNECTIONPOINTID |
VARCHAR2(12) |
|
Connection point identifier |
|
AGCSTATUS |
NUMBER(2,0) |
|
AGC Status from EMS |
|
DISPATCHMODE |
NUMBER(2,0) |
|
Dispatch mode of unit for fast start (1-4) |
|
INITIALMW |
NUMBER(15,5) |
|
Initial MW at start of first period. For periods subsequent to the first period of a Pre-Dispatch run, this value represents the cleared target for the previous period of that Pre-Dispatch run. |
|
TOTALCLEARED |
NUMBER(15,5) |
|
Target MW at end of period |
|
LOWER5MIN |
NUMBER(15,5) |
|
Lower 5 min MW target in period |
|
LOWER60SEC |
NUMBER(15,5) |
|
Lower 60 sec MW target in period |
|
LOWER6SEC |
NUMBER(15,5) |
|
Lower 6 sec MW target in period |
|
RAISE5MIN |
NUMBER(15,5) |
|
Raise 5 min MW target in period |
|
RAISE60SEC |
NUMBER(15,5) |
|
Raise 60 sec MW target in period |
|
RAISE6SEC |
NUMBER(15,5) |
|
Raise 6 sec MW target in period |
|
RAMPDOWNRATE |
NUMBER(15,5) |
|
Ramp down rate in period in MW/minute |
|
RAMPUPRATE |
NUMBER(15,5) |
|
Ramp up rate in period in MW/minute |
|
DOWNEPF |
NUMBER(15,5) |
|
Not used in Pre-Dispatch |
|
UPEPF |
NUMBER(15,5) |
|
Not used in Pre-Dispatch |
|
MARGINAL5MINVALUE |
NUMBER(15,5) |
|
Marginal $ value for 5 min from LP Solver |
|
MARGINAL60SECVALUE |
NUMBER(15,5) |
|
Marginal $ value for 60 seconds from LP Solver |
|
MARGINAL6SECVALUE |
NUMBER(15,5) |
|
Marginal $ value for 6 seconds from LP Solver |
|
MARGINALVALUE |
NUMBER(15,5) |
|
Marginal $ value for energy from LP Solver |
|
VIOLATION5MINDEGREE |
NUMBER(15,5) |
|
Violation MW 5 min |
|
VIOLATION60SECDEGREE |
NUMBER(15,5) |
|
Violation MW 60 seconds |
|
VIOLATION6SECDEGREE |
NUMBER(15,5) |
|
Violation MW 6 seconds |
|
VIOLATIONDEGREE |
NUMBER(15,5) |
|
Violation MW energy |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
DATETIME |
DATE |
X |
Period date and time |
|
LOWERREG |
NUMBER(15,5) |
|
Lower Regulation reserve target |
|
RAISEREG |
NUMBER(15,5) |
|
Raise Regulation reserve target |
|
AVAILABILITY |
NUMBER(15,5) |
|
Bid energy availability |
|
RAISE6SECFLAGS |
NUMBER(3,0) |
|
Raise 6sec status flag |
|
RAISE60SECFLAGS |
NUMBER(3,0) |
|
Raise 60sec status flag |
|
RAISE5MINFLAGS |
NUMBER(3,0) |
|
Raise 5min status flag |
|
RAISEREGFLAGS |
NUMBER(3,0) |
|
Raise reg status flag |
|
LOWER6SECFLAGS |
NUMBER(3,0) |
|
Lower 6sec status flag |
|
LOWER60SECFLAGS |
NUMBER(3,0) |
|
Lower 60sec status flag |
|
LOWER5MINFLAGS |
NUMBER(3,0) |
|
Lower 5min status flag |
|
LOWERREGFLAGS |
NUMBER(3,0) |
|
Lower Reg status flag |
|
RAISE6SECACTUALAVAILABILITY |
NUMBER(16,6) |
|
trapezium adjusted raise 6sec availability |
|
RAISE60SECACTUALAVAILABILITY |
NUMBER(16,6) |
|
trapezium adjusted raise 60sec availability |
|
RAISE5MINACTUALAVAILABILITY |
NUMBER(16,6) |
|
trapezium adjusted raise 5min availability |
|
RAISEREGACTUALAVAILABILITY |
NUMBER(16,6) |
|
trapezium adjusted raise reg availability |
|
LOWER6SECACTUALAVAILABILITY |
NUMBER(16,6) |
|
trapezium adjusted lower 6sec availability |
|
LOWER60SECACTUALAVAILABILITY |
NUMBER(16,6) |
|
trapezium adjusted lower 60sec availability |
|
LOWER5MINACTUALAVAILABILITY |
NUMBER(16,6) |
|
trapezium adjusted lower 5min availability |
|
LOWERREGACTUALAVAILABILITY |
NUMBER(16,6) |
|
trapezium adjusted lower reg availability |
|
|
|