Table: DUDETAIL

DUDETAIL

Name

DUDETAIL

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.


Description

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.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

DUID

EFFECTIVEDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

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 or GENERATOR. This will likely expand to more generic models as new technology types are integrated into the NEM

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, the subtype value is NULL.