Electricity Data Model Report

Table: CONSTRAINTRELAXATION_OCD

CONSTRAINTRELAXATION_OCD

Name	CONSTRAINTRELAXATION_OCD
Comment	CONSTRAINTRELAXATION_OCD contains details of interconnector constraints and unit ancillary service constraints relaxed in the over-constrained dispatch (OCD) re-run for this interval (if there was one). Note: INTERVENTION is not included in CONSTRAINTRELAXATION_OCD, since the relaxation of the same constraint is the same amount in both intervened and non-intervened cases.

Description

Source

The occurrences of Over-Constrained Dispatch (OCD) re-runs are ad hoc, with significant dependencies on the configuration or events in the physical power system.

Over-constrained dispatch (OCD) re-run (if there was one).

Volume

Rows per day: ~2

Mb per month: <1

The estimates on the number of rows are based on a 1% occurrence rate for OCD runs.

Primary Key Columns

CONSTRAINTID

RUNNO

SETTLEMENTDATE

VERSIONNO

Content

SETTLEMENTDATE

DATE

End date and time of the dispatch interval

RUNNO

NUMBER(3,0)

Dispatch run no

CONSTRAINTID

VARCHAR2(20)

Constraint identifier

RHS

NUMBER(16,6)

Relaxed RHS used in attempt to avoid constraint violation

LASTCHANGED

DATE

Last date and time record changed

VERSIONNO

NUMBER(3,0)

Version Number

Table: DISPATCH_CONSTRAINT_FCAS_OCD

DISPATCH_CONSTRAINT_FCAS_OCD

Name	DISPATCH_CONSTRAINT_FCAS_OCD
Comment	FCAS constraint solution from OCD re-run.

Primary Key Columns

CONSTRAINTID

INTERVENTION

RUNNO

SETTLEMENTDATE

VERSIONNO

Content

SETTLEMENTDATE

DATE

Dispatch interval that the prices were loaded to

RUNNO

NUMBER(3)

Dispatch run no; always 1

INTERVENTION

NUMBER(2)

Intervention 0/1

CONSTRAINTID

VARCHAR2(20)

ConstraintID/GenconID

VERSIONNO

NUMBER(3)

VersionNo

LASTCHANGED

DATE

The datetime that the record was last changed

RHS

NUMBER(15,5)

RHS from OCD re-run

MARGINALVALUE

NUMBER(15,5)

marginalvalue from OCD re-run

VIOLATIONDEGREE

NUMBER(15,5)

The violation degree of this constraint in the solution result

Table: DISPATCH_FCAS_REQ

DISPATCH_FCAS_REQ

Name	DISPATCH_FCAS_REQ
Comment	DISPATCH_FCAS_REQ shows Dispatch Constraint tracking for Regional FCAS recovery.

Description

DISPATCH_FCAS_REQ is public data and is available to all participants.

Source

DISPATCH_FCAS_REQ updates with each dispatch run (5 minutes).

Volume

Approximately 10,000 rows per day

Primary Key Columns

BIDTYPE

GENCONID

INTERVENTION

REGIONID

RUNNO

SETTLEMENTDATE

Content

SETTLEMENTDATE

DATE

Settlement date and time of Dispatch Interval

RUNNO

NUMBER(3,0)

Dispatch run no; always 1

INTERVENTION

NUMBER(2,0)

Intervention Flag

GENCONID

VARCHAR2(20)

Generic Constraint ID - Join to table GenConData

REGIONID

VARCHAR2(10)

BIDTYPE

VARCHAR2(10)

DUID offered type

GENCONEFFECTIVEDATE

DATE

Generic Constraint EffectiveDate - Join to table GenConData

GENCONVERSIONNO

NUMBER(3,0)

Generic Constraint Version number - Join to table GenConData

MARGINALVALUE

NUMBER(16,6)

LASTCHANGED

DATE

Date record is changed

BASE_COST

NUMBER(18,8)

The base cost of the constraint for this service, before the regulation/contingency split

ADJUSTED_COST

NUMBER(18,8)

The adjusted cost of the constraint for this service, before the regulation/contingency split

ESTIMATED_CMPF

NUMBER(18,8)

An estimated value for the constraint CMPF, based on dispatched data

ESTIMATED_CRMPF

NUMBER(18,8)

An estimated value for the constraint CRMPF, based on dispatched data

RECOVERY_FACTOR_CMPF

NUMBER(18,8)

Estimated recovery factor for CMPF based recovery

RECOVERY_FACTOR_CRMPF

NUMBER(18,8)

Estimated recovery factor for CRMPF based recovery

Table: DISPATCH_FCAS_REQ_CONSTRAINT

The constraint level FCAS cost / price details for constraint FCAS processor runs. This enhanced output table format is established for the constraint FCAS processor release required for the Frequency Performance Payments (FPP) release. This enhanced output is hierarchical in nature, with the parent *_FCAS_REQ_RUN table holding the details about the triggering case run and time, and the child *_FCAS_REQ_CONSTRAINT table holding the constraint level details of FCAS costs / prices.

Notes

Visibility

Public

Primary Key Columns

BIDTYPE

CONSTRAINTID

INTERVAL_DATETIME

REGIONID

RUN_DATETIME

RUNNO

Content

RUN_DATETIME

DATE

The run date and time of the dispatch case that triggers the constraint FCAS processor run

RUNNO

NUMBER(5)

The dispatch case run number that has triggers the constraint FCAS processor run

INTERVAL_DATETIME

DATE

The trading interval date and time of the dispatch interval that was processed by the constraint FCAS processor

CONSTRAINTID

VARCHAR2(20)

ConstraintID join to table GenConData

REGIONID

VARCHAR2(20)

Region identifier

BIDTYPE

VARCHAR2(10)

DUID offered type

LHS

NUMBER(15,5)

Constraints summed LHS - aggregate LHS Solution values from the physical run from the DISPATCHCONSTRAINT table

RHS

NUMBER(15,5)

Constraints RHS value used in the solution - may be either dynamic (calculated) or static from the physical run from the DISPATCHCONSTRAINT table

MARGINALVALUE

NUMBER(15,5)

Shadow price of constraint from the DISPATCHCONSTRAINT table from the physical run.

RRP

NUMBER(15,5)

Bid type prices for the region coming from the pricing run of the DISPATCHREGIONSUM table

REGIONAL_ENABLEMENT

NUMBER(15,5)

The dispatched MW for the bid type inside the region from the physical run of the DISPATCHREGIONSUM table

CONSTRAINT_ENABLEMENT

NUMBER(15,5)

MW enabled for this bid type within the constraint

REGION_BASE_COST

NUMBER(18,8)

The regional payment allocated to the constraint for the interval pro-rated based on marginal value ratios over the binding constraints for that service in that region (this is an intermediate calculation to get to the base cost)

BASE_COST

NUMBER(18,8)

The base cost of the constraint, before the regulation/contingency split

ADJUSTED_COST

NUMBER(18,8)

The adjusted cost of the constraint for this service, after the regulation/contingency split

P_REGULATION

NUMBER(18,8)

The adjusted marginal value of the constraint for FPP recovery (blank for constraints without REG terms)

Table: DISPATCH_FCAS_REQ_RUN

DISPATCH_FCAS_REQ_RUN

The constraint FCAS processor run details. This enhanced output table format is established for the constraint FCAS processor release required for the Frequency Performance Payments (FPP) release. This enhanced output is hierarchical in nature, with the parent *_FCAS_REQ_RUN table holding the details about the triggering case run and time, and the child *_FCAS_REQ_CONSTRAINT table holding the constraint level details of FCAS costs / prices.

Notes

Visibility

Public

Primary Key Columns

RUN_DATETIME

RUNNO

Content

RUN_DATETIME

DATE

The run date and time of the dispatch case that triggers the constraint FCAS processor run

RUNNO

NUMBER(5)

The dispatch case run number that has triggers the constraint FCAS processor run

LASTCHANGED

DATE

The last time the constraint FCAS processor was executed for this case run time.

Table: DISPATCH_INTERCONNECTION

DISPATCH_INTERCONNECTION

Name	DISPATCH_INTERCONNECTION
Comment	Inter-regional flow information common to or aggregated for regulated (i.e. not MNSP) Interconnectors spanning the From-Region and To-Region - NB only the physical run is calculated'

Notes

Visibility

Public

Primary Key Columns

FROM_REGIONID

INTERVENTION

RUNNO

SETTLEMENTDATE

TO_REGIONID

Content

SETTLEMENTDATE

DATE

Market date starting at 04:05

RUNNO

NUMBER(3,0)

Dispatch run no; always 1

INTERVENTION

NUMBER(2,0)

Intervention case or not

FROM_REGIONID

VARCHAR2(20)

Nominated RegionID from which the energy flows

TO_REGIONID

VARCHAR2(20)

Nominated RegionID to which the energy flows

DISPATCHINTERVAL

NUMBER(22,0)

Dispatch period identifier, from 001 to 288 in format YYYYMMDDPPP

IRLF

NUMBER(15,5)

Inter-Regional Loss Factor. Calculated based on the MWFLOW and the nominal From and To Region losses.

MWFLOW

NUMBER(16,6)

Summed MW flow of the parallel regulated Interconnectors

METEREDMWFLOW

NUMBER(16,6)

Summed Metered MW flow of the parallel regulated Interconnectors

FROM_REGION_MW_LOSSES

NUMBER(16,6)

Losses across the Interconnection attributable to the nominal From Region

TO_REGION_MW_LOSSES

NUMBER(16,6)

Losses across the Interconnection attributable to the nominal To Region

LASTCHANGED

DATE

The datetime that the record was last changed

Table: DISPATCH_LOCAL_PRICE

DISPATCH_LOCAL_PRICE

Name	DISPATCH_LOCAL_PRICE
Comment	Sets out local pricing offsets associated with each DUID connection point for each dispatch period. Note that from 2014 Mid year release only records with non-zero Local_Price_Adjustment values are issued

Notes

Visibility

Private & Public Next-Day

Primary Key Columns

DUID

SETTLEMENTDATE

Index Columns

SETTLEMENTDATE

DUID

Content

SETTLEMENTDATE

DATE

Market date time starting at 04:05

DUID

VARCHAR2(20)

Dispatchable unit identifier

LOCAL_PRICE_ADJUSTMENT

NUMBER(10,2)

Aggregate Constraint contribution cost of this unit: Sum(MarginalValue x Factor) for all relevant Constraints

LOCALLY_CONSTRAINED

NUMBER(1,0)

Key for Local_Price_Adjustment: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints

Table: DISPATCH_MNSPBIDTRK

DISPATCH_MNSPBIDTRK

Name	DISPATCH_MNSPBIDTRK
Comment	DISPATCH_MNSPBIDTRK shows the MNSP bid tracking, including the bid version used in each dispatch run for each MNSP Interconnector Link. The table identifies which bids from MNSP_DAYOFFER and MNSP_BIDOFFERPERIOD were applied.

Description

DISPATCH_MNSPBIDTRK shows own details for participant as they occur, with all details until close of business yesterday being available to all participants after end of day.

Source

DISPATCH_MNSPBIDTRK potentially updates every 5 minutes.

Volume

220, 000 per year

Notes

Visibility

Private & Public Next-Day

Primary Key Columns

LINKID

PARTICIPANTID

RUNNO

SETTLEMENTDATE

Index Columns

LASTCHANGED

Content

SETTLEMENTDATE

DATE

Market date starting at 04:05

RUNNO

NUMBER(3,0)

Dispatch run no; always 1

PARTICIPANTID

VARCHAR2(10)

Participant that owns unit during effective record period

LINKID

VARCHAR2(10)

Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to.

OFFERSETTLEMENTDATE

DATE

Offer date for bid

OFFEREFFECTIVEDATE

TIMESTAMP(3)

Time this bid was processed and loaded

OFFERVERSIONNO

NUMBER(3,0)

VersionNo of the bid/offer used

LASTCHANGED

DATE

Record creation timestamp

Table: DISPATCH_MR_SCHEDULE_TRK

DISPATCH_MR_SCHEDULE_TRK

Name	DISPATCH_MR_SCHEDULE_TRK
Comment	DISPATCH_MR_SCHEDULE_TRK records the Mandatory Restrictions Acceptance Schedule applied to this dispatch interval for this region. DISPATCH_MR_SCHEDULE_TRK is populated by the Dispatch process and records the MR Offer Stack applied in each dispatch interval. DISPATCH_MR_SCHEDULE_TRK is used by Settlements to calculate payments according to the correct MR offer stack.

Description

DISPATCH_MR_SCHEDULE_TRK data is public to all participants.

Source

DISPATCH_MR_SCHEDULE_TRK updates are ad hoc.

Volume

2 rows per year.

Notes

Visibility

Public

Primary Key Columns

REGIONID

SETTLEMENTDATE

Index Columns

LASTCHANGED

Content

SETTLEMENTDATE

DATE

Date Time of the Dispatch Interval

REGIONID

VARCHAR2(10)

Unique RegionID; Key reference to MR_Event_Schedule

MR_DATE

DATE

Mandatory Restriction date; Key reference to MR_Event_Schedule table

VERSION_DATETIME

DATE

Date Time the MR acceptance stack was created; Key reference to MR_Event_Schedule table

LASTCHANGED

DATE

Date and time the record was last inserted/modified

Table: DISPATCH_PRICE_REVISION

DISPATCH_PRICE_REVISION

Name	DISPATCH_PRICE_REVISION
Comment	An audit trail of price changes on the DISPATCHPRICE table (i.e. for 5 minute dispatch prices for energy and FCAS).

Notes

Visibility

Public

Primary Key Columns

BIDTYPE

INTERVENTION

REGIONID

RUNNO

SETTLEMENTDATE

VERSIONNO

Index Columns

LASTCHANGED

Content

SETTLEMENTDATE

DATE

Market date and time starting at 04:05

RUNNO

NUMBER(3,0)

Dispatch run no; always 1

INTERVENTION

NUMBER(2,0)

Manual intervention flag; always 0

REGIONID

VARCHAR2(10)

Affected Region Identifier

BIDTYPE

VARCHAR2(10)

Affected Bid Type Identifier

VERSIONNO

NUMBER(3)

Version No of price revision for this settlement date

RRP_NEW

NUMBER(15,5)

New RRP in DISPATCHPRICE table

RRP_OLD

NUMBER(15,5)

Old RRP from DISPATCHPRICE table

LASTCHANGED

DATE

The datetime the record was last changed

Table: DISPATCH_UNIT_CONFORMANCE

DISPATCH_UNIT_CONFORMANCE

Name	DISPATCH_UNIT_CONFORMANCE
Comment	DISPATCH_UNIT_CONFORMANCE details the conformance of a scheduled units operation with respect to a cleared target on dispatch interval basis. Data is confidential

Description

DISPATCH_UNIT_CONFORMANCE data is confidential.

Source

DISPATCH_UNIT_CONFORMANCE shows data for every 5 minutes for all scheduled units

Volume

Rows per day: 288 per scheduled unit

Notes

Visibility

Private

Primary Key Columns

DUID

INTERVAL_DATETIME

Index Columns

LASTCHANGED

Content

INTERVAL_DATETIME

DATE

Dispatch Interval that the conformance data applies to

DUID

VARCHAR2(20)

Dispatchable Unit Identifier, or Aggregate Dispatch Group identifier

TOTALCLEARED

NUMBER(16,6)

Dispatch Target - MW

ACTUALMW

NUMBER(16,6)

Unit output measured at the conclusion of the dispatch interval - MW (MWB)

ROC

NUMBER(16,6)

Rate of change in direction of error MW per minute

AVAILABILITY

NUMBER(16,6)

Offered unit capacity - MW (MWO)

LOWERREG

NUMBER(16,6)

Lower Regulation FCAS enabled - MW (FCL)

RAISEREG

NUMBER(16,6)

Raise Regulation FCAS enabled - MW (FCR)

STRIGLM

NUMBER(16,6)

Calculated small trigger error limit in MW

LTRIGLM

NUMBER(16,6)

Calculated large trigger error limit in MW

MWERROR

NUMBER(16,6)

Calculated actual error

MAX_MWERROR

NUMBER(16,6)

Max of mwerror while that unit was not in a normal state

LECOUNT

NUMBER(6)

Large trigger error count. Reset when mwerror changes sign

SECOUNT

NUMBER(6)

Small trigger error count. Reset when mwerror changes sign

STATUS

VARCHAR2(20)

Unit conformance status.
NORMAL
OFF-TARGET
NOT-RESPONDING
NC-PENDING
NON-CONFORMING
SUSPENDED

PARTICIPANT_STATUS_ACTION

VARCHAR2(100)

Participant action required in response to current STATUS

OPERATING_MODE

VARCHAR2(20)

conformance operating mode
MANUAL
AUTO

LASTCHANGED

DATE

Last date and time record changed

ADG_ID

VARCHAR2(20)

Aggregate Dispatch Group to which this dispatch unit belongs

SEMIDISPATCHCAP

NUMBER(3,0)

Boolean representation flagging if the Target is capped

CONFORMANCE_MODE

NUMBER(6,0)

For an individual unit in an aggregate dispatch group (where DUID <> ADG_ID), Mode specific to that unit. 0 - no monitoring, 1 - aggregate monitoring, 2 - individual monitoring due to constraint. For the aggregate dispatch group (where DUID = ADG_ID), 0 - no aggregate monitoring, 1 - aggregate monitoring

Table: DISPATCH_UNIT_SCADA

DISPATCH_UNIT_SCADA

Name	DISPATCH_UNIT_SCADA
Comment	Dispatchable unit MW from SCADA at the start of the dispatch interval. The table includes all scheduled and semi-scheduled (and non-scheduled units where SCADA is available)

Description

DISPATCH_UNIT_SCADA data is public data, and is available to all participants.

Source

DISPATCH_UNIT_SCADA shows data for every 5 minutes for all scheduled units

Volume

Rows per day: 288 per each scheduled, semi-scheduled (and non-scheduled unit where SCADA is available)

Notes

Visibility

Public

Primary Key Columns

DUID

SETTLEMENTDATE

Index Columns

SETTLEMENTDATE

DUID

Content

SETTLEMENTDATE

Date

Date Time of the Dispatch Interval

DUID

varchar2(20)

Dispatchable Unit Identifier

SCADAVALUE

Number(16,6)

Instantaneous MW reading from SCADA at the start of the Dispatch interval

LASTCHANGED

DATE

Last date and time record changed

Table: DISPATCHBLOCKEDCONSTRAINT

DISPATCHBLOCKEDCONSTRAINT

Name	DISPATCHBLOCKEDCONSTRAINT
Comment	DISPATCH Blocked Constraints lists any constraints that were blocked in a dispatch run. If no constraints are blocked, there will be no rows for that dispatch run.

Notes

Visibility

Public

Primary Key Columns

CONSTRAINTID

RUNNO

SETTLEMENTDATE

Content

SETTLEMENTDATE

DATE

Dispatch Interval

RUNNO

NUMBER(3,0)

Dispatch run no; always 1

CONSTRAINTID

VARCHAR2(20)

Generic Constraint identifier (synonymous with GenConID)

Table: DISPATCHCASESOLUTION

DISPATCHCASESOLUTION

Name	DISPATCHCASESOLUTION
Comment	DISPATCHCASESOLUTION shows information relating to the complete dispatch run. The fields in DISPATCHCASESOLUTION provide an overview of the dispatch run results allowing immediate identification of conditions such as energy or FCAS deficiencies.

Description

The DISPATCHCASESOLUTION data is public.

Source

DISPATCHCASESOLUTION updates every 5 minutes.

Volume

Approximately 288 records per day.

Notes

Visibility

Public

Primary Key Columns

RUNNO

SETTLEMENTDATE

Index Columns

LASTCHANGED

Content

SETTLEMENTDATE

DATE

Date and time of the dispatch interval (e.g. five minute dispatch interval ending 28/09/2000 16:35)

RUNNO

NUMBER(3,0)

Dispatch run no; always 1

INTERVENTION

NUMBER(2,0)

Intervention flag - refer to package documentation for definition and practical query examples

CASESUBTYPE

VARCHAR2(3)

Overconstrained dispatch indicator:
* OCD = detecting over-constrained dispatch
* null = no special condition

SOLUTIONSTATUS

NUMBER(2,0)

If non-zero indicated one of the following conditions:
* 1 = Supply Scarcity, Excess generation or constraint violations
* X = Model failure

SPDVERSION

VARCHAR2(20)

Current version of SPD

NONPHYSICALLOSSES

NUMBER(1,0)

Non-Physical Losses algorithm invoked occurred during this run

TOTALOBJECTIVE

NUMBER(27,10)

The Objective function from the LP

TOTALAREAGENVIOLATION

NUMBER(15,5)

Total Region Demand violations

TOTALINTERCONNECTORVIOLATION

NUMBER(15,5)

Total interconnector violations

TOTALGENERICVIOLATION

NUMBER(15,5)

Total generic constraint violations

TOTALRAMPRATEVIOLATION

NUMBER(15,5)

Total ramp rate violations

TOTALUNITMWCAPACITYVIOLATION

NUMBER(15,5)

Total unit capacity violations

TOTAL5MINVIOLATION

NUMBER(15,5)

Total of 5 minute ancillary service region violations

TOTALREGVIOLATION

NUMBER(15,5)

Total of Regulation ancillary service region violations

TOTAL6SECVIOLATION

NUMBER(15,5)

Total of 6 second ancillary service region violations

TOTAL60SECVIOLATION

NUMBER(15,5)

Total of 60 second ancillary service region violations

TOTALASPROFILEVIOLATION

NUMBER(15,5)

Total of ancillary service trader profile violations

TOTALFASTSTARTVIOLATION

NUMBER(15,5)

Total of fast start trader profile violations

TOTALENERGYOFFERVIOLATION

NUMBER(15,5)

Total of unit summated offer band violations

LASTCHANGED

DATE

Last date and time record changed

SWITCHRUNINITIALSTATUS

NUMBER(1,0)

Flag indicating the SCADA status for FCAS Interconnector dead-band. "0" if SCADA Status or requesting Constraint not invoked. "1" if SCADA Status AND requesting Constraint is invoked

SWITCHRUNBESTSTATUS

NUMBER(1,0)

Flag indicating which Switch run was used for the Solution – from PeriodSolution

SWITCHRUNBESTSTATUS_INT

NUMBER(1,0)

Flag indicating which Switch run was used for the Intervention Physical Solution - from PeriodSolution

Table: DISPATCHCONSTRAINT

DISPATCHCONSTRAINT

Name	DISPATCHCONSTRAINT
Comment	DISPATCHCONSTRAINT sets out details of all binding and interregion constraints in each dispatch run. Note: invoked constraints can be established from GENCONSETINVOKE. Binding constraints show as marginal value >$0. Interconnector constraints are listed so RHS (SCADA calculated limits) can be reported.

Description

DISPATCHCONSTRAINT is public data, and is available to all participants.

Source

DISPATCHCONSTRAINT updates every five minutes.

Notes

Visibility

Private & Public Next-Day

Primary Key Columns

CONSTRAINTID

DISPATCHINTERVAL

INTERVENTION

RUNNO

SETTLEMENTDATE

Index Columns

LASTCHANGED

Index Columns

SETTLEMENTDATE

Content

SETTLEMENTDATE

DATE

Market date starting at 04:05

RUNNO

NUMBER(3,0)

Dispatch run no; always 1

CONSTRAINTID

VARCHAR2(20)

Generic Constraint identifier (synonymous with GenConID)

DISPATCHINTERVAL

NUMBER(22,0)

Dispatch period identifier, from 001 to 288 in format YYYYMMDDPPP.

INTERVENTION

NUMBER(2,0)

Manual Intervention flag, which, if set (1), causes predispatch to solve twice.

RHS

NUMBER(15,5)

Right hand Side value as used in dispatch.

MARGINALVALUE

NUMBER(15,5)

$ Value of binding constraint

VIOLATIONDEGREE

NUMBER(15,5)

Degree of violation in MW

LASTCHANGED

DATE

Last date and time record changed

DUID

VARCHAR2(20)

DUID to which the Constraint is confidential. Null denotes non-confidential

GENCONID_EFFECTIVEDATE

DATE

Effective date of the Generic Constraint (ConstraintID). This field is used to track the version of this generic constraint applied in this dispatch interval

GENCONID_VERSIONNO

NUMBER(22,0)

Version number of the Generic Constraint (ConstraintID). This field is used to track the version of this generic constraint applied in this dispatch interval

LHS

number(15,5)

Aggregation of the constraints LHS term solution values

Table: DISPATCHINTERCONNECTORRES

DISPATCHINTERCONNECTORRES

Name	DISPATCHINTERCONNECTORRES
Comment	DISPATCHINTERCONNECTORRES sets out MW flow and losses on each interconnector for each dispatch period, including fields for the Frequency Controlled Ancillary Services export and import limits and extra reporting of the generic constraints set the energy import and export limits.

Description

DISPATCHINTERCONNECTORRES is public data, and is available to all participants.

Source

DISPATCHINTERCONNECTORRES updates every 5 minutes.

Note

MW losses can be negative depending on the flow.

The definition of direction of flow for an interconnector is that positive flow starts from the FROMREGION in the INTERCONNECTOR table.

Notes

Visibility

Public

Primary Key Columns

DISPATCHINTERVAL

INTERCONNECTORID

INTERVENTION

RUNNO

SETTLEMENTDATE

Index Columns

LASTCHANGED

Content

SETTLEMENTDATE

DATE

Market date starting at 04:05

RUNNO

NUMBER(3,0)

Dispatch run no; always 1

INTERCONNECTORID

VARCHAR2(10)

Interconnector identifier

DISPATCHINTERVAL

NUMBER(22,0)

Dispatch period identifier, from 001 to 288 in format YYYYMMDDPPP.

INTERVENTION

NUMBER(2,0)

Intervention case or not

METEREDMWFLOW

NUMBER(15,5)

Metered MW Flow from SCADA.

MWFLOW

NUMBER(15,5)

Target MW Flow for next 5 mins.

MWLOSSES

NUMBER(15,5)

Calculated MW Losses

MARGINALVALUE

NUMBER(15,5)

Shadow price resulting from thermal or reserve sharing constraints on Interconnector import/export (0 unless binding) - NEMDE Solution InterconnectorSolution element "Price" attribute

VIOLATIONDEGREE

NUMBER(15,5)

Degree of violation on interconnector constraints

LASTCHANGED

DATE

Last changed.

EXPORTLIMIT

NUMBER(15,5)

Calculated export limit applying to energy only.

IMPORTLIMIT

NUMBER(15,5)

Calculated import limit applying to energy only.

MARGINALLOSS

NUMBER(15,5)

Marginal loss factor. Use this to adjust prices between regions.

EXPORTGENCONID

VARCHAR2(20)

Generic Constraint setting the export limit

IMPORTGENCONID

VARCHAR2(20)

Generic Constraint setting the import limit

FCASEXPORTLIMIT

NUMBER(15,5)

Calculated export limit applying to energy + FCAS.

FCASIMPORTLIMIT

NUMBER(15,5)

Calculated import limit applying to energy + FCAS.

LOCAL_PRICE_ADJUSTMENT_EXPORT

NUMBER(10,2)

Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Export (Factor >= 0)

LOCALLY_CONSTRAINED_EXPORT

NUMBER(1,0)

Key for Local_Price_Adjustment_Export: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints

LOCAL_PRICE_ADJUSTMENT_IMPORT

NUMBER(10,2)

Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Import (Factor >= 0)

LOCALLY_CONSTRAINED_IMPORT

NUMBER(1,0)

Key for Local_Price_Adjustment_Import: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints

Table: DISPATCHLOAD

DISPATCHLOAD

Name	DISPATCHLOAD
Comment	DISPATCHLOAD set out the current SCADA MW and target MW for each dispatchable unit, including relevant Frequency Control Ancillary Services (FCAS) enabling targets for each five minutes and additional fields to handle the new Ancillary Services functionality. Fast Start Plant status is indicated by dispatch mode.

Description

DISPATCHLOAD data is confidential for the current day, showing own details for participant and becomes public after close of business yesterday, and is available to all participants.

Source

DISPATCHLOAD shows data for every 5 minutes for all units, even zero targets.

Volume

Expect 40-50,000 records per day. All units are repeated, even zero targets.

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.

Notes

Visibility

Private & Public Next-Day

Primary Key Columns

DUID

INTERVENTION

RUNNO

SETTLEMENTDATE

Index Columns

LASTCHANGED

Index Columns

DUID

LASTCHANGED

Content

SETTLEMENTDATE

DATE

Market date and time starting at 04:05

RUNNO

NUMBER(3,0)

Dispatch run no; always 1

DUID

VARCHAR2(10)

Dispatchable unit identifier

TRADETYPE

NUMBER(2,0)

Not used

DISPATCHINTERVAL

NUMBER(22,0)

Dispatch period identifier, from 001 to 288 in format YYYYMMDDPPP.

INTERVENTION

NUMBER(2,0)

Intervention flag if intervention run

CONNECTIONPOINTID

VARCHAR2(12)

Connection point identifier for DUID

DISPATCHMODE

NUMBER(2,0)

Dispatch mode for fast start plant (0 to 4).

AGCSTATUS

NUMBER(2,0)

AGC Status from EMS
* 1 = on
* 0 = off

INITIALMW

NUMBER(15,5)

Initial MW at start of period. 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.

RAMPDOWNRATE

NUMBER(15,5)

Ramp down rate used in dispatch (lesser of bid or telemetered rate).

RAMPUPRATE

NUMBER(15,5)

Ramp up rate (lesser of bid or telemetered rate).

LOWER5MIN

NUMBER(15,5)

Lower 5 min reserve target

LOWER60SEC

NUMBER(15,5)

Lower 60 sec reserve target

LOWER6SEC

NUMBER(15,5)

Lower 6 sec reserve target

RAISE5MIN

NUMBER(15,5)

Raise 5 min reserve target

RAISE60SEC

NUMBER(15,5)

Raise 60 sec reserve target

RAISE6SEC

NUMBER(15,5)

Raise 6 sec reserve target

DOWNEPF

NUMBER(15,5)

Not Used

UPEPF

NUMBER(15,5)

Not Used

MARGINAL5MINVALUE

NUMBER(15,5)

Marginal $ value for 5 min

MARGINAL60SECVALUE

NUMBER(15,5)

Marginal $ value for 60 seconds

MARGINAL6SECVALUE

NUMBER(15,5)

Marginal $ value for 6 seconds

MARGINALVALUE

NUMBER(15,5)

Marginal $ value for energy

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

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 - see

RAISE60SECFLAGS

NUMBER(3,0)

Raise 60sec status flag - see

RAISE5MINFLAGS

NUMBER(3,0)

RAISEREGFLAGS

NUMBER(3,0)

Raise Reg status flag - see

LOWER6SECFLAGS

NUMBER(3,0)

Lower 6sec status flag - see

LOWER60SECFLAGS

NUMBER(3,0)

Lower 60sec status flag

LOWER5MINFLAGS

NUMBER(3,0)

Lower 5min status flag

LOWERREGFLAGS

NUMBER(3,0)

Lower Reg status flag - see

RAISEREGAVAILABILITY

NUMBER(15,5)

RaiseReg availability - minimum of bid and telemetered value

RAISEREGENABLEMENTMAX

NUMBER(15,5)

RaiseReg enablement max point - minimum of bid and telemetered value

RAISEREGENABLEMENTMIN

NUMBER(15,5)

RaiseReg Enablement Min point - maximum of bid and telemetered value

LOWERREGAVAILABILITY

NUMBER(15,5)

Lower Reg availability - minimum of bid and telemetered value

LOWERREGENABLEMENTMAX

NUMBER(15,5)

Lower Reg enablement Max point - minimum of bid and telemetered value

LOWERREGENABLEMENTMIN

NUMBER(15,5)

Lower Reg Enablement Min point - maximum of bid and telemetered value

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

1 2

Home