Table: DUDETAILSUMMARY

DUDETAILSUMMARY

Name

DUDETAILSUMMARY

Comment

DUDETAILSUMMARY sets out a single summary unit table so reducing the need for participants to use the various dispatchable unit detail and owner tables to establish generating unit specific details.


Description

DUDETAILSUMMARY is a public table, and is available to all participants.

Source

DUDETAILSUMMARY updates only when registration details change.


Primary Key Columns

Name

DUID

START_DATE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

DUID

VARCHAR2(10)

X

Dispatchable Unit Identifier

START_DATE

DATE

X

Start date for effective record

END_DATE

DATE

X

End date for effective record

DISPATCHTYPE

VARCHAR2(20)

 

Identifies LOAD or GENERATOR. This will likely expand to more generic models as new technology types are integrated into the NEM

CONNECTIONPOINTID

VARCHAR2(10)

 

Country wide - Unique id of a connection point

REGIONID

VARCHAR2(10)

 

Region identifier that unit is in

STATIONID

VARCHAR2(10)

 

Station that unit is in

PARTICIPANTID

VARCHAR2(10)

 

Participant that owns unit during effective record period

LASTCHANGED

DATE

 

Last date and time record changed

TRANSMISSIONLOSSFACTOR

NUMBER(15,5)

 

The transmission level loss factor for currently assigned connection point

STARTTYPE

VARCHAR2(20)

 

Unit start type. At this time restricted to Fast, Slow or Non Dispatched

DISTRIBUTIONLOSSFACTOR

NUMBER(15,5)

 

The distribution loss factor to the currently assigned connection point

MINIMUM_ENERGY_PRICE

NUMBER(9,2)

 

Floored Offer/Bid Energy Price adjusted for TLF, DLF and MPF

MAXIMUM_ENERGY_PRICE

NUMBER(9,2)

 

Capped Offer/Bid Energy Price adjusted for TLF, DLF and VoLL

SCHEDULE_TYPE

VARCHAR2(20)

 

Scheduled status of the unit:
'SCHEDULED'
'NON-SCHEDULED'
'SEMI-SCHEDULED'

MIN_RAMP_RATE_UP

number(6,0)

 

MW/Min. Calculated Minimum Ramp Rate Up value accepted for Energy Offers or Bids with explanation

MIN_RAMP_RATE_DOWN

number(6,0)

 

MW/Min. Calculated Minimum Ramp Rate Down value accepted for Energy Offers or Bids with explanation

MAX_RAMP_RATE_UP

number(6,0)

 

Maximum ramp up rate for Unit (Mw/min) - from DUDetail table

MAX_RAMP_RATE_DOWN

number(6,0)

 

Maximum ramp down rate for Unit (Mw/min) - from DUDetail table

IS_AGGREGATED

NUMBER(1,0)

 

Whether the DUID is classified as an "Aggregated Unit" under the rules. This impacts the Minimum Ramp Rate calculation

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.

ADG_ID

VARCHAR2(20)

 

Aggregate Dispatch Group to which this dispatch unit belongs.