Skip to content

DISPATCH_UNIT_CONFORMANCE

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

Package

DISPATCH

Visibility

Private

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
INTERVAL_DATETIME datetime(3) 🔑 datetime2(0) 🔑 Dispatch Interval that the conformance data applies to
DUID varchar(20) 🔑 varchar(20) 🔑 Dispatchable Unit Identifier, or Aggregate Dispatch Group identifier
TOTALCLEARED numeric(16, 6) numeric(16, 6) Dispatch Target - MW
ACTUALMW numeric(16, 6) numeric(16, 6) Unit output measured at the conclusion of the dispatch interval - MW (MWB)
ROC numeric(16, 6) numeric(16, 6) Rate of change in direction of error MW per minute
AVAILABILITY numeric(16, 6) numeric(16, 6) Offered unit capacity - MW (MWO)
LOWERREG numeric(16, 6) numeric(16, 6) Lower Regulation FCAS enabled - MW (FCL)
RAISEREG numeric(16, 6) numeric(16, 6) Raise Regulation FCAS enabled - MW (FCR)
STRIGLM numeric(16, 6) numeric(16, 6) Calculated small trigger error limit in MW
LTRIGLM numeric(16, 6) numeric(16, 6) Calculated large trigger error limit in MW
MWERROR numeric(16, 6) numeric(16, 6) Calculated actual error
MAX_MWERROR numeric(16, 6) numeric(16, 6) Max of mwerror while that unit was not in a normal state
LECOUNT numeric(6, 0) smallint Large trigger error count. Reset when mwerror changes sign
SECOUNT numeric(6, 0) smallint Small trigger error count. Reset when mwerror changes sign
STATUS varchar(20) varchar(20) Unit conformance status. NORMAL OFF-TARGET NOT-RESPONDING NC-PENDING NON-CONFORMING SUSPENDED
PARTICIPANT_STATUS_ACTION varchar(100) varchar(100) Participant action required in response to current STATUS
OPERATING_MODE varchar(20) varchar(20) conformance operating mode MANUAL AUTO
LASTCHANGED datetime(3) datetime2(0) Last date and time record changed
ADG_ID varchar(20) varchar(20) Aggregate Dispatch Group to which this dispatch unit belongs
CONFORMANCE_MODE numeric(6, 0) tinyint 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
SEMIDISPATCHCAP numeric(3, 0) bit Boolean representation flagging if the Target is capped

Official MMS data model indexes

Index name Index type Index columns (in order)
DISPATCH_UNIT_CONFORMANCE_LCX nonclustered LASTCHANGED
PK_DISPATCH_UNIT_CONFORMANCE clustered, unique, primary key INTERVAL_DATETIME, DUID

GR-MMS data model indexes

Index name Index type Index columns (in order)
IX_DISPATCH_UNIT_CONFORMANCE_LASTCHANGED nonclustered LASTCHANGED
PK_DISPATCH_UNIT_CONFORMANCE clustered, unique, primary key INTERVAL_DATETIME, DUID

Historical-MMS data model indexes

Index name Index type Index columns (in order)
DISPATCH_UNIT_CONFORMANCE_LCX nonclustered LASTCHANGED
PK_DISPATCH_UNIT_CONFORMANCE clustered, unique, primary key INTERVAL_DATETIME, DUID