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.