Electricity Data Model Report

Table: P5MIN_SCENARIODEMAND

P5MIN_SCENARIODEMAND

Name	P5MIN_SCENARIODEMAND
Comment	The P5Min scenario MW offsets

Primary Key Columns

EFFECTIVEDATE

REGIONID

SCENARIO

VERSION_DATETIME

Content

EFFECTIVEDATE

DATE

The effective date of this set of scenarios

VERSION_DATETIME

DATE

The version of this set of scenarios

SCENARIO

NUMBER(2,0)

The scenario identifier

REGIONID

VARCHAR2(20)

The region to which to apply the deltaMW for this SCENARIO

DELTAMW

NUMBER(4,0)

The MW offset to apply to region total demand for this SCENARIO

Table: P5MIN_SCENARIODEMANDTRK

P5MIN_SCENARIODEMANDTRK

Name	P5MIN_SCENARIODEMANDTRK
Comment	Tracks the 5Min scenario offset updates across time

Content

EFFECTIVEDATE

DATE

The effective date of this set of scenarios

VERSION_DATETIME

DATE

The version of this set of scenarios

AUTHORISEDDATE

DATE

The datetime that the scenario update was authorised

LASTCHANGED

DATE

The datetime that the record was last changed

Table: P5MIN_UNITSOLUTION

P5MIN_UNITSOLUTION

Name	P5MIN_UNITSOLUTION
Comment	The five-minute predispatch (P5Min) is a MMS system providing projected dispatch for 12 Dispatch cycles (one hour). The 5-minute Predispatch cycle runs every 5-minutes to produce a dispatch and pricing schedule to a 5-minute resolution covering the next hour, a total of twelve periods. P5MIN_UNITSOLUTION shows the Unit results from the capacity evaluations for each period of the study.

Description

P5MIN_UNITSOLUTION data is confidential, so shows own details for participant.

Source

P5MIN_UNITSOLUTION updates every 5 minutes for all units, even zero targets.

Volume

Rows per day: 57600

Based on 200 units per Interval

Note

A bitwise 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 SPD Formulation document details the logic determining whether a unit is "trapped" or "stranded". The flag is defined as follows:

Flagged Condition	Bit	Description	Field value
FCAS profile active	0	The bid profile for this service has been activated such that the unit is available to be cleared to provide this ancillary service type.	1 or 3
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.	3
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.	4

Notes

Visibility

Private

Primary Key Columns

DUID

INTERVAL_DATETIME

RUN_DATETIME

Index Columns

LASTCHANGED

Content

RUN_DATETIME

DATE

Unique Timestamp Identifier for this study

INTERVAL_DATETIME

DATE

The unique identifier for the interval within this study

DUID

VARCHAR2(10)

Dispatchable unit identifier

CONNECTIONPOINTID

VARCHAR2(12)

Connection point identifier for DUID

TRADETYPE

NUMBER(2,0)

Generator or Load

AGCSTATUS

NUMBER(2,0)

AGC Status from EMS: 1 = on, 0 = off

INITIALMW

NUMBER(15,5)

Initial MW at start of period. For periods subsequent to the first period of a P5MIN run, this value represents the cleared target for the previous period of that P5MIN 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.

RAMPDOWNRATE

NUMBER(15,5)

Ramp down rate (lessor of bid or telemetered rate).

RAMPUPRATE

NUMBER(15,5)

Ramp up rate (lessor 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

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

LASTCHANGED

DATE

Last date and time record changed

SEMIDISPATCHCAP

NUMBER(3,0)

Boolean representation flagging if the Target is Capped

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 there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0

DISPATCHMODETIME

NUMBER(4,0)

Minutes for which the unit has been in the current DISPATCHMODE. From NEMDE TRADERSOLUTION element FSTARGETMODETIME attribute.

CONFORMANCE_MODE

NUMBER(6,0)

Mode specific to units within an aggregate. 0 - no monitoring, 1 - aggregate monitoring, 2 - individual monitoring due to constraint

UIGF

NUMBER(15,5)

For Semi-Scheduled units. Unconstrained Intermittent Generation Forecast value provided to NEMDE

RAISE1SEC

NUMBER(15,5)

Dispatched Raise1Sec - TraderSolution element R1Target attribute

RAISE1SECFLAGS

NUMBER(3,0)

TraderSolution element R1Flags attribute

LOWER1SEC

NUMBER(15,5)

Dispatched Lower1Sec - TraderSolution element L1Target attribute

LOWER1SECFLAGS

NUMBER(3,0)

TraderSolution element L1Flags attribute

INITIAL_ENERGY_STORAGE

NUMBER(15,5)

BDU only. The energy storage at the start of this dispatch interval (MWh)

ENERGY_STORAGE

NUMBER(15,5)

BDU only. The projected energy storage based on cleared energy and regulation FCAS dispatch (MWh)

ENERGY_STORAGE_MIN

NUMBER(15,5)

BDU only - Minimum Energy Storage constraint limit (MWh)

ENERGY_STORAGE_MAX

NUMBER(15,5)

BDU only - Maximum Energy Storage constraint limit (MWh)

MIN_AVAILABILITY

NUMBER(15,5)

BDU only. Load side availability (BidOfferPeriod.MAXAVAIL where DIRECTION = LOAD).

Home