|
Name |
|
|
Comment |
DISPATCHOFFERTRK is the energy and ancillary service bid tracking table for the Dispatch process. The table identifies which bids from BIDDAYOFFER and BIDOFFERPERIOD were applied for a given unit and bid type for each dispatch interval. |
|
DISPATCHOFFERTRK data is confidential to each participant until the next trading day, when the data is public to all participants. Source DISPATCHOFFERTRK updates every 5 minutes. Volume Approximately 250,000 records per day. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
BIDTYPE |
|
DUID |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
|
DUID |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Date and time of the dispatch interval (e.g. five minute dispatch interval ending 28/09/2000 16:35) |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit identifier |
|
BIDTYPE |
VARCHAR2(10) |
X |
Bid type Identifier - the ancillary service to which the bid applies |
|
BIDSETTLEMENTDATE |
DATE |
|
Settlement date of bid applied |
|
BIDOFFERDATE |
TIMESTAMP(3) |
|
Time this bid was processed and loaded |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
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 |
|
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 |
|
|
|