Skip to content

DUDETAIL

DUDETAIL sets out a records specific details for each unit including start type and whether normally on or off load. Much of this data is information only and is not used in dispatch or settlements.

Package

PARTICIPANT_REGISTRATION

Visibility

Public

Table schema

Column Official MMS Datatype GR-MMS Datatype Comment
EFFECTIVEDATE datetime(3) 🔑 date 🔑 Effective calendar date of record
DUID varchar(10) 🔑 varchar(10) 🔑 Dispatchable Unit Identifier
VERSIONNO numeric(3, 0) 🔑 smallint 🔑 version of Dispatchable Unit details for this effective date
CONNECTIONPOINTID varchar(10) varchar(10) Country wide - Unique id of a connection point
VOLTLEVEL varchar(10) varchar(10) Voltage Level
REGISTEREDCAPACITY numeric(6, 0) numeric(9, 4) Registered capacity for normal operations
AGCCAPABILITY varchar(1) varchar(1) AGC Capability flag
DISPATCHTYPE varchar(20) varchar(20) Identifies LOAD, GENERATOR or BIDIRECTIONAL.
MAXCAPACITY numeric(6, 0) numeric(9, 4) Maximum Capacity as used for bid validation
STARTTYPE varchar(20) varchar(20) Identify unit as Fast or Slow
NORMALLYONFLAG varchar(1) varchar(1) For a dispatchable load indicates that the load is normally on or off.
PHYSICALDETAILSFLAG varchar(1) varchar(1) Indicates that the physical details for this unit are to be recorded
SPINNINGRESERVEFLAG varchar(1) varchar(1) Indicates spinning reserve capability
AUTHORISEDBY varchar(15) varchar(15) User authorising record
AUTHORISEDDATE datetime(3) datetime2(0) Date record authorised
LASTCHANGED datetime(3) datetime2(0) Last date and time record changed
INTERMITTENTFLAG varchar(1) varchar(1) Indicate whether a unit is intermittent (e.g. a wind farm)
SEMISCHEDULE_FLAG varchar(1) varchar(1) Indicates if the DUID is a Semi-Scheduled Unit
MAXRATEOFCHANGEUP numeric(6, 0) smallint Maximum ramp up rate for Unit (Mw/min)
MAXRATEOFCHANGEDOWN numeric(6, 0) smallint Maximum ramp down rate for Unit (Mw/min)
DISPATCHSUBTYPE varchar(20) varchar(20) Additional information for DISPATCHTYPE. For DISPATCHTYPE = LOAD, subtype value is WDR for wholesale demand response units. For DISPATCHTYPE = LOAD, subtype value is NULL for Scheduled Loads. For DISPATCHTYPE = GENERATOR type, the subtype value is NULL.
ADG_ID varchar(20) varchar(20) Aggregate Dispatch Group to which this dispatch unit belongs
LOAD_MIN_RAMP_RATE_DOWN numeric(6, 0) smallint Calculated Minimum Ramp Rate Down value accepted for Energy Offers or Bids on BDU Load component with explanation for energy imports (MW/min)
LOAD_MIN_RAMP_RATE_UP numeric(6, 0) smallint Calculated Minimum Ramp Rate Up value accepted for Energy Offers or Bids on BDU Load component with explanation for energy imports (MW/min)
MAXRATEOFCHANGEDOWN_LOAD numeric(6, 0) smallint Lower Ramp rate applied to BDU Load component (MW/min)
MAXRATEOFCHANGEUP_LOAD numeric(6, 0) smallint Raise Ramp rate applied to BDU Load component (MW/min)
MAXSTORAGECAPACITY numeric(15, 5) numeric(15, 5) The rated storage capacity (MWh), information only
MINCAPACITY numeric(6, 0) numeric(9, 4) Minimum capacity only for load side of BDU, otherwise 0 (MW)
MIN_RAMP_RATE_DOWN numeric(6, 0) smallint Calculated Minimum Ramp Rate Down value accepted for Energy Offers or Bids with explanation for energy imports (all DUID types and BDU Generation side) (MW/min)
MIN_RAMP_RATE_UP numeric(6, 0) smallint Calculated Minimum Ramp Rate Up value accepted for Energy Offers or Bids with explanation for energy imports (all DUID types and BDU Generation side) (MW/min)
REGISTEREDMINCAPACITY numeric(6, 0) numeric(9, 4) Registered minimum capacity only for load side of BDU, otherwise 0 (MW)
STORAGEEXPORTEFFICIENCYFACTOR numeric(15, 5) numeric(15, 5) The storage energy export conversion efficiency. Number from 0 to 1 where 1 is lossless. Calculated as (decrease in exported energy / decrease in stored energy)
STORAGEIMPORTEFFICIENCYFACTOR numeric(15, 5) numeric(15, 5) The storage energy import conversion efficiency. Number from 0 to 1 where 1 is lossless. Calculated as (increase in stored energy / increase in imported energy)
AGGREGATED numeric(1, 0) bit Identifies if a unit is aggregated. This flag was initially added in GENUNITS_UNIT table which is now deprecated with IESS release.

Official MMS data model indexes

Index name Index type Index columns (in order)
DUDETAIL_LCX nonclustered LASTCHANGED
DUDETAIL_PK clustered, unique, primary key DUID, EFFECTIVEDATE, VERSIONNO

GR-MMS data model indexes

Index name Index type Index columns (in order)
IX_DUDETAIL_LASTCHANGED nonclustered LASTCHANGED
PK_DUDETAIL clustered, unique, primary key DUID, EFFECTIVEDATE, VERSIONNO

Historical-MMS data model indexes

Index name Index type Index columns (in order)
DUDETAIL_LCX nonclustered LASTCHANGED
PK_DUDETAIL clustered, unique, primary key DUID, EFFECTIVEDATE, VERSIONNO