|
Name |
|
|
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. |
|
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:
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):
|
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
DISPATCHINTERVAL |
|
INTERVENTION |
|
REGIONID |
|
RUNNO |
|
SETTLEMENTDATE |
|
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 |
|
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 |
|
|
|