Table: DISPATCHPRICE

DISPATCHPRICE

Name

DISPATCHPRICE

Comment

DISPATCHPRICE records 5 minute dispatch prices for energy and FCAS, including whether an intervention has occurred, or price override (e.g. for Administered Price Cap). DISPATCHPRICE updates when price adjustments occur, in which case the new price is written to the RRP field, and the old price to the ROP field as an audit trail.


Description

Source

DISPATCHPRICE updates every 5 minutes.

Note

APCFLAG is a 5-bit Region-based field indicating that the original Dispatch Price (ROP) calculated by the Dispatch Algorithm for a region has undergone modification by one of more of the following processes:

Bit

Value

Description

5

16

Price Scaling via Inter-regional Loss Factor (IRLF)

4

8

Price manually overwritten

3

4

MPC or MPF binding (ROP was outside of MPC/MPF)

2

2

VoLL Override applied

1

1

APC or APF binding (ROP was outside of APC/APF)

Where:

· MPC = Market Price Cap

· MPF = Market Price Floor

· APC = Administered Price Cap

· APF = Administered Price Floor

xxxAPCFLAGs are each a 5-bit Region-based field indicating FCAS price post-processing (where "ROP" is the original NEMDE Solver price):

Bit

Cum Value

Description

5

16

Not applicable

4

8

Price manually overwritten

3

4

MPC ($VoLL) or MPF ($zero) binding (xxFCAS ROP was outside of MPC/MPF)

2

2

Not applicable

1

1

APC or APF binding (ROP was outside of APC/APF)


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

DISPATCHINTERVAL

INTERVENTION

REGIONID

RUNNO

SETTLEMENTDATE


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

REGIONID

VARCHAR2(10)

X

Region Identifier

DISPATCHINTERVAL

VARCHAR2(22)

X

Dispatch interval identifier 001 to 288 in format YYYYMMDDPPP

INTERVENTION

NUMBER(2,0)

X

Manual intervention flag

RRP

NUMBER(15,5)

 

Regional Reference Price for this dispatch period. RRP is the price used to settle the market

EEP

NUMBER(15,5)

 

Excess energy price - no longer used

ROP

NUMBER(15,5)

 

Regional Override Price, being the original price prior to any price scaling, price capping or VoLL override being applied. The APC flag allows the determination of whether capping, scaling or override occurred

APCFLAG

NUMBER(3,0)

 

APC Active flag (see note)

MARKETSUSPENDEDFLAG

NUMBER(3,0)

 

Market suspended flag

LASTCHANGED

DATE

 

Last date and time record changed

RAISE6SECRRP

NUMBER(15,5)

 

 

RAISE6SECROP

NUMBER(15,5)

 

 

RAISE6SECAPCFLAG

NUMBER(3,0)

 

 

RAISE60SECRRP

NUMBER(15,5)

 

 

RAISE60SECROP

NUMBER(15,5)

 

 

RAISE60SECAPCFLAG

NUMBER(3,0)

 

 

RAISE5MINRRP

NUMBER(15,5)

 

 

RAISE5MINROP

NUMBER(15,5)

 

 

RAISE5MINAPCFLAG

NUMBER(3,0)

 

 

RAISEREGRRP

NUMBER(15,5)

 

 

RAISEREGROP

NUMBER(15,5)

 

 

RAISEREGAPCFLAG

NUMBER(3,0)

 

 

LOWER6SECRRP

NUMBER(15,5)

 

 

LOWER6SECROP

NUMBER(15,5)

 

 

LOWER6SECAPCFLAG

NUMBER(3,0)

 

 

LOWER60SECRRP

NUMBER(15,5)

 

 

LOWER60SECROP

NUMBER(15,5)

 

 

LOWER60SECAPCFLAG

NUMBER(3,0)

 

 

LOWER5MINRRP

NUMBER(15,5)

 

 

LOWER5MINROP

NUMBER(15,5)

 

 

LOWER5MINAPCFLAG

NUMBER(3,0)

 

 

LOWERREGRRP

NUMBER(15,5)

 

 

LOWERREGROP

NUMBER(15,5)

 

 

LOWERREGAPCFLAG

NUMBER(3,0)

 

 

PRICE_STATUS

VARCHAR2(20)

 

Status of regional prices for this dispatch interval "NOT FIRM" or "FIRM"

PRE_AP_ENERGY_PRICE

NUMBER(15,5)

 

Price before ap capping or scaling - for rolling sum price monitoring

PRE_AP_RAISE6_PRICE

NUMBER(15,5)

 

Price before ap capping or scaling - for rolling sum price monitoring

PRE_AP_RAISE60_PRICE

NUMBER(15,5)

 

Price before ap capping or scaling - for rolling sum price monitoring

PRE_AP_RAISE5MIN_PRICE

NUMBER(15,5)

 

Price before ap capping or scaling - for rolling sum price monitoring

PRE_AP_RAISEREG_PRICE

NUMBER(15,5)

 

Price before ap capping or scaling - for rolling sum price monitoring

PRE_AP_LOWER6_PRICE

NUMBER(15,5)

 

Price before ap capping or scaling - for rolling sum price monitoring

PRE_AP_LOWER60_PRICE

NUMBER(15,5)

 

Price before ap capping or scaling - for rolling sum price monitoring

PRE_AP_LOWER5MIN_PRICE

NUMBER(15,5)

 

Price before ap capping or scaling - for rolling sum price monitoring

PRE_AP_LOWERREG_PRICE

NUMBER(15,5)

 

Price before ap capping or scaling - for rolling sum price monitoring

CUMUL_PRE_AP_ENERGY_PRICE

NUMBER(15,5)

 

Cumulative price that triggers administered pricing event if above the threshold

CUMUL_PRE_AP_RAISE6_PRICE

NUMBER(15,5)

 

Cumulative price that triggers administered pricing event if above the threshold

CUMUL_PRE_AP_RAISE60_PRICE

NUMBER(15,5)

 

Cumulative price that triggers administered pricing event if above the threshold

CUMUL_PRE_AP_RAISE5MIN_PRICE

NUMBER(15,5)

 

Cumulative price that triggers administered pricing event if above the threshold

CUMUL_PRE_AP_RAISEREG_PRICE

NUMBER(15,5)

 

Cumulative price that triggers administered pricing event if above the threshold


2