| SETTLEMENTDATE |
datetime(3)  |
datetime2(0) |
Market date and time starting at 04:05 |
| DUID |
varchar(10) |
varchar(10) |
Dispatchable unit identifier |
| INTERVENTION |
numeric(2, 0) |
bit |
Intervention flag if intervention run |
| CONNECTIONPOINTID |
varchar(12) |
varchar(12) (not nullable) |
Connection point identifier for DUID |
| DISPATCHMODE |
numeric(2, 0) |
tinyint (not nullable) |
Dispatch mode for fast start plant (0 to 4). |
| AGCSTATUS |
numeric(2, 0) |
bit (not nullable) |
AGC Status from EMS * 1 = on * 0 = off |
| INITIALMW |
numeric(15, 5) |
numeric(15, 5) (not nullable) |
Initial MW at start of period. Negative values when Bi-directional Unit start from importing power, otherwise positive. |
| TOTALCLEARED |
numeric(15, 5) |
numeric(9, 5) (not nullable) |
Target MW for end of period. Negative values when Bi-directional Unit is importing power, otherwise positive. |
| RAMPDOWNRATE |
numeric(15, 5) |
numeric(9, 4) (not nullable) |
Ramp down rate used in dispatch (lesser of bid or telemetered rate). |
| RAMPUPRATE |
numeric(15, 5) |
numeric(9, 4) (not nullable) |
Ramp up rate (lesser of bid or telemetered rate). |
| LOWER5MIN |
numeric(15, 5) |
numeric(9, 5) (not nullable) |
Lower 5 min reserve target |
| LOWER60SEC |
numeric(15, 5) |
numeric(9, 5) (not nullable) |
Lower 60 sec reserve target |
| LOWER6SEC |
numeric(15, 5) |
numeric(9, 5) (not nullable) |
Lower 6 sec reserve target |
| RAISE5MIN |
numeric(15, 5) |
numeric(9, 5) (not nullable) |
Raise 5 min reserve target |
| RAISE60SEC |
numeric(15, 5) |
numeric(9, 5) (not nullable) |
Raise 60 sec reserve target |
| RAISE6SEC |
numeric(15, 5) |
numeric(9, 5) (not nullable) |
Raise 6 sec reserve target |
| MARGINAL5MINVALUE |
numeric(15, 5) |
numeric(15, 5) |
Marginal $ value for 5 min |
| MARGINAL60SECVALUE |
numeric(15, 5) |
numeric(15, 5) |
Marginal $ value for 60 seconds |
| MARGINAL6SECVALUE |
numeric(15, 5) |
numeric(15, 5) |
Marginal $ value for 6 seconds |
| MARGINALVALUE |
numeric(15, 5) |
numeric(15, 5) |
Marginal $ value for energy |
| VIOLATION5MINDEGREE |
numeric(15, 5) |
numeric(9, 5) |
Violation MW 5 min |
| VIOLATION60SECDEGREE |
numeric(15, 5) |
numeric(9, 5) |
Violation MW 60 seconds |
| VIOLATION6SECDEGREE |
numeric(15, 5) |
numeric(9, 5) |
Violation MW 6 seconds |
| VIOLATIONDEGREE |
numeric(15, 5) |
numeric(9, 5) |
Violation MW energy |
| LASTCHANGED |
datetime(3) |
datetime2(0) (not nullable) |
Last date and time record changed |
| LOWERREG |
numeric(15, 5) |
numeric(9, 5) |
Lower Regulation reserve target |
| RAISEREG |
numeric(15, 5) |
numeric(9, 5) |
Raise Regulation reserve target |
| AVAILABILITY |
numeric(15, 5) |
numeric(9, 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 |
numeric(3, 0) |
tinyint |
Raise 6sec status flag - see |
| RAISE60SECFLAGS |
numeric(3, 0) |
tinyint |
Raise 60sec status flag - see |
| RAISE5MINFLAGS |
numeric(3, 0) |
tinyint |
- |
| RAISEREGFLAGS |
numeric(3, 0) |
tinyint |
Raise Reg status flag - see |
| LOWER6SECFLAGS |
numeric(3, 0) |
tinyint |
Lower 6sec status flag - see |
| LOWER60SECFLAGS |
numeric(3, 0) |
tinyint |
Lower 60sec status flag |
| LOWER5MINFLAGS |
numeric(3, 0) |
tinyint |
Lower 5min status flag |
| LOWERREGFLAGS |
numeric(3, 0) |
tinyint |
Lower Reg status flag - see |
| RAISEREGAVAILABILITY |
numeric(15, 5) |
numeric(9, 5) |
RaiseReg availability - minimum of bid and telemetered value |
| RAISEREGENABLEMENTMAX |
numeric(15, 5) |
numeric(9, 5) |
RaiseReg enablement max point - minimum of bid and telemetered value |
| RAISEREGENABLEMENTMIN |
numeric(15, 5) |
numeric(9, 5) |
RaiseReg Enablement Min point - maximum of bid and telemetered value |
| LOWERREGAVAILABILITY |
numeric(15, 5) |
numeric(9, 5) |
Lower Reg availability - minimum of bid and telemetered value |
| LOWERREGENABLEMENTMAX |
numeric(15, 5) |
numeric(9, 5) |
Lower Reg enablement Max point - minimum of bid and telemetered value |
| LOWERREGENABLEMENTMIN |
numeric(15, 5) |
numeric(9, 5) |
Lower Reg Enablement Min point - maximum of bid and telemetered value |
| RAISE6SECACTUALAVAILABILITY |
numeric(16, 6) |
numeric(9, 6) |
trapezium adjusted raise 6sec availability |
| RAISE60SECACTUALAVAILABILITY |
numeric(16, 6) |
numeric(9, 6) |
trapezium adjusted raise 60sec availability |
| RAISE5MINACTUALAVAILABILITY |
numeric(16, 6) |
numeric(9, 6) |
trapezium adjusted raise 5min availability |
| RAISEREGACTUALAVAILABILITY |
numeric(16, 6) |
numeric(9, 6) |
trapezium adjusted raise reg availability |
| LOWER6SECACTUALAVAILABILITY |
numeric(16, 6) |
numeric(9, 6) |
trapezium adjusted lower 6sec availability |
| LOWER60SECACTUALAVAILABILITY |
numeric(16, 6) |
numeric(9, 6) |
trapezium adjusted lower 60sec availability |
| LOWER5MINACTUALAVAILABILITY |
numeric(16, 6) |
numeric(9, 6) |
trapezium adjusted lower 5min availability |
| LOWERREGACTUALAVAILABILITY |
numeric(16, 6) |
numeric(9, 6) |
trapezium adjusted lower reg availability |
| SEMIDISPATCHCAP |
numeric(3, 0) |
bit |
Boolean representation flagging if the Target is Capped |
| DISPATCHMODETIME |
numeric(4, 0) |
smallint |
Minutes for which the unit has been in the current DISPATCHMODE. From NEMDE TRADERSOLUTION element FSTARGETMODETIME attribute. |
| CONFORMANCE_MODE |
numeric(6, 0) |
tinyint |
Mode specific to units within an aggregate. 0 - no monitoring, 1 - aggregate monitoring, 2 - individual monitoring due to constraint |
| LOWER1SEC |
numeric(15, 5) |
numeric(9, 5) |
Dispatched Lower1Sec - TraderSolution element L1Target attribute |
| LOWER1SECACTUALAVAILABILITY |
numeric(16, 6) |
numeric(9, 6) |
Trapezium adjusted Lower 1Sec Availability |
| LOWER1SECFLAGS |
numeric(3, 0) |
tinyint |
TraderSolution element L1Flags attribute |
| RAISE1SEC |
numeric(15, 5) |
numeric(9, 5) |
Dispatched Raise1Sec - TraderSolution element R1Target attribute |
| RAISE1SECACTUALAVAILABILITY |
numeric(16, 6) |
numeric(9, 6) |
Trapezium adjusted Raise 1Sec Availability |
| RAISE1SECFLAGS |
numeric(3, 0) |
tinyint |
TraderSolution element R1Flags attribute |
| UIGF |
numeric(15, 5) |
numeric(15, 5) |
For Semi-Scheduled units. Unconstrained Intermittent Generation Forecast value provided to NEMDE |
| ENERGY_STORAGE |
numeric(15, 5) |
numeric(15, 5) |
The projected energy storage based on cleared energy and regulation FCAS dispatch(MWh) |
| INITIAL_ENERGY_STORAGE |
numeric(15, 5) |
numeric(15, 5) |
The energy storage at the start of this dispatch interval(MWh) |
| MIN_AVAILABILITY |
numeric(15, 5) |
numeric(15, 5) |
BDU only. Load side availability (BidOfferPeriod.MAXAVAIL where DIRECTION = LOAD) |
| ELEMENT_CAP |
numeric(5, 0) |
smallint |
Cap on the number of turbines or inverters at a DUID. |
| RUNNO |
numeric(3, 0) |
- |
- |
| TRADETYPE |
numeric(2, 0) |
- |
- |
| DISPATCHINTERVAL |
numeric(22, 0) |
- |
- |
| DOWNEPF |
numeric(15, 5) |
- |
- |
| UPEPF |
numeric(15, 5) |
- |
- |