Table: PREDISPATCHLOAD

PREDISPATCHLOAD

Name

PREDISPATCHLOAD

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.


Description

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:

Flag Name

Bit

Description

Enabled

0

The unit is enabled to provide this ancillary service type.

Trapped

1

The unit is enabled to provide this ancillary service type, however the profile for this service type is causing the unit to be trapped in the energy market.

Stranded

2

The unit is bid available to provide this ancillary service type, however, the unit is operating in the energy market outside of the profile for this service type and is stranded from providing this service.

Interpretation of the bit-flags as a number gives the following possibilities (i.e. other combinations are not possible):

Numeric Value

Bit (2,1,0)

Meaning

0

000

Not stranded, not trapped, not enabled.

1

001

Not stranded, not trapped, is enabled.

3

011

Not stranded, is trapped, is enabled.

4

100

Is stranded, not trapped, not enabled.

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.


Primary Key Columns

Name

DATETIME

DUID


Index Columns

Name

LASTCHANGED


Index Columns

Name

DUID

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)

 

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. Negative values when Bi-directional Unit start from importing power, otherwise positive.

TOTALCLEARED

NUMBER(15,5)

 

Target MW for end of period. Negative values when Bi-directional Unit is importing power, otherwise positive.

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)

 

For Scheduled units, this is the MAXAVAIL bid availability For Semi-scheduled units, this is the lower of MAXAVAIL bid availability and UIGF

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


2