Name |
|
Comment |
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. |
DUDETAIL is public data, and is available to all participants. Source DUDETAIL updates only when registration details change. Note To find the current set of details for selected dispatchable units, query the participant's local database as follows. Select du.* from dudetail du where (du.EFFECTIVEDATE, du.VERSIONNO) = ( select effectivedate, max(versionno) from dudetail where EFFECTIVEDATE = (select max(effectivedate) from dudetail where EFFECTIVEDATE <= sysdate and duid = du.duid and authoriseddate is not null) and duid = du.duid and authoriseddate is not null group by effectivedate ) and du.duid in ('UNIT1', 'UNIT2') ; The following notes apply to this SQL code: · This table is specific to dispatch units only. · If you wish to query details for a different date, substitute a date expression for "sysdate" in the "where EFFECTIVEDATE <= sysdate" clause. · If you wish to list all the units, remove the line "and du.duid in ('UNIT1', 'UNIT2')" · The DUDETAIL table does not indicate if a unit is active; this is done through ownership (STADUALLOC) by an active station owned by an active participant (STATIONOWNER ) · If you wish to query Station details refer to STATION, STATIONOWNER and STADUALLOC. · If you wish to look at connection point loss factors, refer to TRANSMISSIONLOSSFACTOR. |
Name |
DUID |
EFFECTIVEDATE |
VERSIONNO |
Name |
LASTCHANGED |
Name |
Data Type |
Mandatory |
Comment |
EFFECTIVEDATE |
DATE |
X |
Effective calendar date of record |
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit Identifier |
VERSIONNO |
NUMBER(3,0) |
X |
version of Dispatchable Unit details for this effective date |
CONNECTIONPOINTID |
VARCHAR2(10) |
|
Country wide - Unique id of a connection point |
VOLTLEVEL |
VARCHAR2(10) |
|
Voltage Level |
REGISTEREDCAPACITY |
NUMBER(6,0) |
|
Registered capacity for normal operations |
AGCCAPABILITY |
VARCHAR2(1) |
|
AGC Capability flag |
DISPATCHTYPE |
VARCHAR2(20) |
|
Identifies LOAD, GENERATOR or BIDIRECTIONAL. |
MAXCAPACITY |
NUMBER(6,0) |
|
Maximum Capacity as used for bid validation |
STARTTYPE |
VARCHAR2(20) |
|
Identify unit as Fast or Slow |
NORMALLYONFLAG |
VARCHAR2(1) |
|
For a dispatchable load indicates that the load is normally on or off. |
PHYSICALDETAILSFLAG |
VARCHAR2(1) |
|
Indicates that the physical details for this unit are to be recorded |
SPINNINGRESERVEFLAG |
VARCHAR2(1) |
|
Indicates spinning reserve capability |
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
AUTHORISEDDATE |
DATE |
|
Date record authorised |
LASTCHANGED |
DATE |
|
Last date and time record changed |
INTERMITTENTFLAG |
VARCHAR(1) |
|
Indicate whether a unit is intermittent (e.g. a wind farm) |
SemiSchedule_Flag |
VARCHAR2(1) |
|
Indicates if the DUID is a Semi-Scheduled Unit |
MAXRATEOFCHANGEUP |
Number(6,0) |
|
Maximum ramp up rate for Unit (Mw/min) |
MAXRATEOFCHANGEDOWN |
Number(6,0) |
|
Maximum ramp down rate for Unit (Mw/min) |
DISPATCHSUBTYPE |
VARCHAR2(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, subtype value is NULL. For DISPATCHTYPE = BIDIRECTIONAL type, subtype value is NULL. |
ADG_ID |
VARCHAR2(20) |
|
Aggregate Dispatch Group to which this dispatch unit belongs |
MINCAPACITY |
NUMBER(6,0) |
|
Minimum capacity only for load side of BDU, otherwise 0 (MW) |
REGISTEREDMINCAPACITY |
NUMBER(6,0) |
|
Registered minimum capacity only for load side of BDU, otherwise 0 (MW) |
MAXRATEOFCHANGEUP_LOAD |
NUMBER(6,0) |
|
Raise Ramp rate applied to BDU Load component (MW/min) |
MAXRATEOFCHANGEDOWN_LOAD |
NUMBER(6,0) |
|
Lower Ramp rate applied to BDU Load component (MW/min) |
MAXSTORAGECAPACITY |
NUMBER(15,5) |
|
The rated storage capacity (MWh), information only |
STORAGEIMPORTEFFICIENCYFACTOR |
NUMBER(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) |
STORAGEEXPORTEFFICIENCYFACTOR |
NUMBER(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) |
MIN_RAMP_RATE_UP |
NUMBER(6,0) |
|
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) |
MIN_RAMP_RATE_DOWN |
NUMBER(6,0) |
|
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) |
LOAD_MIN_RAMP_RATE_UP |
NUMBER(6,0) |
|
Calculated Minimum Ramp Rate Up value accepted for Energy Offers or Bids on BDU Load component with explanation for energy imports (MW/min) |
LOAD_MIN_RAMP_RATE_DOWN |
NUMBER(6,0) |
|
Calculated Minimum Ramp Rate Down value accepted for Energy Offers or Bids on BDU Load component with explanation for energy imports (MW/min) |
|
|
|