|
Name |
|
|
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. |
|
DUDETAILSUMMARY is a public table, and is available to all participants. Source DUDETAILSUMMARY updates only when registration details change. |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
Public |
|
Name |
|
DUID |
|
START_DATE |
|
Name |
|
LASTCHANGED |
|
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(10) |
|
Either Generator or Load |
|
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: |
|
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 |
|
|
|