MMS Data Model Report

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

Data in this table is:

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.

TOTALCLEARED

NUMBER(15,5)

Target MW for end of period

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)

Energy Availability (MW)

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

Home