|
Name |
|
|
Comment |
Table for tracking evolving Aggregate Dispatch Group attributes |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
ADG_ID |
|
EFFECTIVEDATE |
|
VERSION_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
ADG_ID |
VARCHAR2(20) |
X |
Identifies the Aggregate Dispatch Group |
|
EFFECTIVEDATE |
DATE |
X |
Effective calendar date of record |
|
VERSION_DATETIME |
DATE |
X |
Date and time of the version of Dispatchable Unit details |
|
ADG_TYPE |
VARCHAR2(20) |
|
Conformance Type for the Aggregate Dispatch Group. One of the following: CAP, MIXED, TARGET |
|
AUTHORISEDDATE |
DATE |
|
Date record authorised |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
Entity allowing for compliance monitoring over grouped DUIDs |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
ADG_ID |
|
Name |
Data Type |
Mandatory |
Comment |
|
ADG_ID |
VARCHAR2(20) |
X |
Aggregate Dispatch Group ID |
|
COMMENTS |
VARCHAR2(100) |
|
A participant provided comment |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BIDDUIDDETAILS and the associated tracking object BIDDUIDDETAILSTRK define the registration data for each ancillary service a dispatchable unit is registered to provide. The registration data is required to validate a dispatchable unit bid submitted for that ancillary service. |
|
BIDDUIDDETAILS data is public to participants. Source BIDDUIDDETAILS updates as dispatchable unit registration details are modified. Volume Approximately 1000 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BIDTYPE |
|
DUID |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit identifier |
|
EFFECTIVEDATE |
DATE |
X |
Market date starting at 04:30 inclusive |
|
VERSIONNO |
NUMBER(3,0) |
X |
Record version number |
|
BIDTYPE |
VARCHAR2(10) |
X |
Bid Type Identifier |
|
MAXCAPACITY |
NUMBER(22,0) |
|
Maximum Capacity of this DUID for this BIDTYPE |
|
MINENABLEMENTLEVEL |
NUMBER(22,0) |
|
Minimum Energy Output (MW) at which this ancillary service becomes available (AS Only) |
|
MAXENABLEMENTLEVEL |
NUMBER(22,0) |
|
Maximum Energy Output (MW) at which this ancillary service can be supplied (AS Only) |
|
MAXLOWERANGLE |
NUMBER(3,0) |
|
Maximum Angle at the lower end of the ancillary service profile (Degrees) |
|
MAXUPPERANGLE |
NUMBER(3,0) |
|
Maximum Angle at the upper end of the ancillary service profile (Degrees) |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BIDDUIDDETAILSTRK shows the tracking for the associated object BIDDUIDDETAILS. Together, BIDDUIDDETAILSTRK and BIDDUIDDETAILS define the registration data for each ancillary service a dispatchable unit is registered to provide. The registration data is required to validate a dispatchable unit bid submitted for that ancillary service. |
|
BIDDUIDDETAILSTRK data is public to participants. Source BIDDUIDDETAILSTRK updates as dispatchable unit registration details are modified. Volume Approximately 200 records per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DUID |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit identifier |
|
EFFECTIVEDATE |
DATE |
X |
Market date starting at 04:30 inclusive |
|
VERSIONNO |
NUMBER(3,0) |
X |
Record version number |
|
AUTHORISEDDATE |
DATE |
|
Date of record authorisation. A NULL value indicates the record is not authorised. |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User that authorised record. A NULL value indicates the record is not authorised. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
DISPATCHABLEUNIT sets out the unit name and type of each dispatchable unit in the market. |
|
DISPATCHABLEUNIT data is public data, and is available to all participants. Source DISPATCHABLEUNIT pdates as new units added or names changed. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DUID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit Identifier |
|
DUNAME |
VARCHAR2(20) |
|
Dispatchable Unit full description |
|
UNITTYPE |
VARCHAR2(20) |
|
Identifies LOAD, GENERATOR or BIDIRECTIONAL |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
DUALLOC cross references dispatch unit identifier to genset ID for each participant. |
|
Source DUALLOC updates where changed. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DUID |
|
EFFECTIVEDATE |
|
GENSETID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
DUID |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Effective calendar date of record |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no of record |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit identifier |
|
GENSETID |
VARCHAR2(20) |
X |
Physical unit identifier |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
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 |
Comment |
Value |
|
Visibility |
|
Public |
|
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, the 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) |
|
AGGREGATED |
NUMBER(1,0) |
|
Identifies if a unit is aggregated. This flag was initially added in GENUNITS_UNIT table which is now deprecated with IESS release. |
|
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 |
|
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(20) |
|
Identifies LOAD, GENERATOR or BIDIRECTIONAL. 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) |
|
Used in Bidding, Dispatch and Settlements. For Bidding and Dispatch, where the DUID is a BDU with DISPATCHTYPE of BIDIRECTIONAL, the TLF for the load component of the BDU. For Settlements, where dual TLFs apply, the primary TLF is applied to all energy (load and generation) when the Net Energy Flow of the ConnectionPointID in the interval is negative (net load). |
|
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 |
|
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. Group into which the DUID is aggregated for Conformance. Null if DUID not aggregated for Conformance |
|
LOAD_MINIMUM_ENERGY_PRICE |
NUMBER(9,2) |
|
BDU only. Floored Offer/Bid Energy Price adjusted for TLF, DLF and MPF for energy imports |
|
LOAD_MAXIMUM_ENERGY_PRICE |
NUMBER(9,2) |
|
BDU only. Capped Offer/Bid Energy Price adjusted for TLF, DLF and VoLL for energy imports |
|
LOAD_MIN_RAMP_RATE_UP |
NUMBER(6,0) |
|
BDU only. MW/Min. Calculated Minimum Ramp Rate Up value accepted for Energy Offers or Bids with explanation for energy imports |
|
LOAD_MIN_RAMP_RATE_DOWN |
NUMBER(6,0) |
|
BDU only. MW/Min. Calculated Minimum Ramp Rate Down value accepted for Energy Offers or Bids with explanation for energy imports |
|
LOAD_MAX_RAMP_RATE_UP |
NUMBER(6,0) |
|
BDU only. MW/Min. Registered Maximum Ramp Rate Up value accepted for Energy Offers or Bids for energy imports |
|
LOAD_MAX_RAMP_RATE_DOWN |
NUMBER(6,0) |
|
BDU only. MW/Min. Registered Maximum Ramp Rate Down value accepted for Energy Offers or Bids for energy imports |
|
SECONDARY_TLF |
NUMBER(18,8) |
|
Used in Bidding, Dispatch and Settlements, only populated where Dual TLFs apply. For Bidding and Dispatch, the TLF for the generation component of a BDU, when null the TRANSMISSIONLOSSFACTOR is used for both the load and generation components. For Settlements, the secondary TLF is applied to all energy (load and generation) when the Net Energy Flow of the ConnectionPointID in the interval is positive (net generation). |
|
Name |
|
|
Comment |
GENMETER shows details of generator meter sets. |
|
GENMETER is a public table, and is available to all participants. Source GENMETER updates only when meter details change. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
APPLYDATE |
|
METERID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
STATIONID |
|
Name |
Data Type |
Mandatory |
Comment |
|
METERID |
VARCHAR2(12) |
X |
Meter Id |
|
GENSETID |
VARCHAR2(20) |
|
Generator Set ID |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
|
Not used |
|
STATIONID |
VARCHAR2(10) |
|
Station Identifier |
|
METERTYPE |
VARCHAR2(20) |
|
LOAD |
|
METERCLASS |
VARCHAR2(10) |
|
WATT or AUXILARY |
|
VOLTAGELEVEL |
NUMBER(6,0) |
|
Voltage |
|
APPLYDATE |
DATE |
X |
Application date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no of the record for the given effective date |
|
AUTHORISEDBY |
VARCHAR2(10) |
|
AEMO user authorising |
|
AUTHORISEDDATE |
DATE |
|
Date authorised |
|
COMDATE |
DATE |
|
Not used |
|
DECOMDATE |
DATE |
|
Not used |
|
ENDDATE |
DATE |
|
Not used |
|
STARTDATE |
DATE |
|
Not used |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
GENUNITS shows Genset details for each physical unit with the relevant station. |
|
GENUNITS is a public table, and is available to all participants. Source GENUNITS updates whenever plant details change. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
GENSETID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
GENSETID |
VARCHAR2(20) |
X |
Physical Unit identifier |
|
STATIONID |
VARCHAR2(10) |
|
Station Identifier |
|
SETLOSSFACTOR |
NUMBER(16,6) |
|
Not used |
|
CDINDICATOR |
VARCHAR2(10) |
|
Centrally dispatched Indicator |
|
AGCFLAG |
VARCHAR2(2) |
|
AGC Available flag |
|
SPINNINGFLAG |
VARCHAR2(2) |
|
Not used |
|
VOLTLEVEL |
NUMBER(6,0) |
|
Voltage level |
|
REGISTEREDCAPACITY |
NUMBER(6,0) |
|
Registered capacity |
|
DISPATCHTYPE |
VARCHAR2(20) |
|
Identifies LOAD, GENERATOR or BIDIRECTIONAL. This will likely expand to more generic models as new technology types are integrated into the NEM. |
|
STARTTYPE |
VARCHAR2(20) |
|
Fast / Slow / Not Dispatched |
|
MKTGENERATORIND |
VARCHAR2(10) |
|
Market Generator Indicator Flag |
|
NORMALSTATUS |
VARCHAR2(10) |
|
On / Off for load |
|
MAXCAPACITY |
NUMBER(6,0) |
|
Maximum capacity |
|
GENSETTYPE |
VARCHAR2(15) |
|
Genset type |
|
GENSETNAME |
VARCHAR2(40) |
|
Genset name |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
CO2E_EMISSIONS_FACTOR |
NUMBER(18,8) |
|
The emissions factor for the generating unit, as calculated by Settlements staff members |
|
CO2E_ENERGY_SOURCE |
VARCHAR2(100) |
|
The energy source for the generating unit, as used in the calculation of the CO2-e emissions factor. Distinct from the Energy Source for a generating unit published as part of the Registration Master List |
|
CO2E_DATA_SOURCE |
VARCHAR2(20) |
|
An indicator as to the source of the emission factor used in the calculation of the index. The applicable values for this field would be NTNDP which indicates the emission factor is quoted from the National Transmission Network Development Plan or Estimated to indicate the emission factor has been calculated using an internal AEMO procedure based upon the Department of Climate Change and Energy Efficiency NGA factors |
|
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) |
|
MAXSTORAGECAPACITY |
NUMBER(15,5) |
|
The rated storage capacity (MWh), information only |
|
Name |
|
|
Comment |
Physical units within a Gen Unit Set |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
GENSETID |
|
UNIT_GROUPING_LABEL |
|
VERSIONNO |
|
Name |
|
GENSETID |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
UNIT_GROUPING_LABEL |
|
Name |
Data Type |
Mandatory |
Comment |
|
GENSETID |
VARCHAR2(20) |
X |
System wide unique Generating Set ID |
|
EFFECTIVEDATE |
DATE |
X |
Effective Date of this detail record |
|
VERSIONNO |
NUMBER(6,0) |
X |
Version with respect to the effective date |
|
UNIT_GROUPING_LABEL |
VARCHAR2(20) |
X |
Label of Physical Units within the station |
|
UNIT_COUNT |
NUMBER(10,0) |
|
Number of units in this Gen Unit grouping |
|
UNIT_SIZE |
NUMBER(8,3) |
|
Nameplate Capacity for each unit in this grouping |
|
UNIT_MAX_SIZE |
NUMBER(8,3) |
|
Maximum Capacity for each unit in this grouping |
|
AGGREGATION_FLAG |
NUMBER(1,0) |
|
Deprecated as this flag is moved to DUDETAIL table with IESS release. |
|
LASTCHANGED |
DATE |
|
Date/Time when record was changed |
|
UNITMINSIZE |
NUMBER(8,3) |
|
Only applicable for the LOAD side of BDU (MW) |
|
MAXSTORAGECAPACITY |
NUMBER(15,5) |
|
The rated storage capacity (MWh), information only |
|
REGISTEREDCAPACITY |
NUMBER(8,3) |
|
Registered capacity for normal operations |
|
REGISTEREDMINCAPACITY |
NUMBER(8,3) |
|
Only applicable for the LOAD side of BDU (MW) |
|
Name |
|
|
Comment |
MNSP_INTERCONNECTOR sets out attributes of each interconnector. |
|
MNSP_INTERCONNECTOR data is public, so is available to all participants. Source MNSP_INTERCONNECTOR changes infrequently, typically annually. Volume Twice the number of MNSPs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
LINKID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
LINKID |
VARCHAR2(10) |
X |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. |
|
EFFECTIVEDATE |
DATE |
X |
Date when Interconnector becomes effective |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of data for other key data - a higher version for same key data will take precedence |
|
INTERCONNECTORID |
VARCHAR2(10) |
|
Interconnector Identifier |
|
FROMREGION |
VARCHAR2(10) |
|
Nominated source region for Interconnector |
|
TOREGION |
VARCHAR2(10) |
|
Nominated destination region for Interconnector |
|
MAXCAPACITY |
NUMBER(5,0) |
|
Maximum capacity |
|
TLF |
NUMBER(12,7) |
|
Transmission Loss Factor (redundant from May 2012) |
|
LHSFACTOR |
NUMBER(12,7) |
|
Factor applied to the LHS of constraint equations; set by AEMO |
|
METERFLOWCONSTANT |
NUMBER(12,7) |
|
Obsolete; no longer applied. Ignore. |
|
AUTHORISEDDATE |
DATE |
|
Date of authorisation. Nominal date but required to enable Interconnector. |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
Authorising officer |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
FROM_REGION_TLF |
NUMBER(12,7) |
|
Transmission Loss Factor for Link "From Region" end |
|
TO_REGION_TLF |
NUMBER(12,7) |
|
Transmission Loss Factor for Link at "To Region" end |
|
Name |
|
|
Comment |
MNSP_PARTICIPANT registers MNSP ownership. |
|
MNSP_PARTICIPANT data is public, so is available to all participants. Source MNSP_PARTICIPANT updates infrequently, typically annually. Volume Number of MNSPs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Interconnector Identifier |
|
EFFECTIVEDATE |
DATE |
X |
Calendar date when Interconnector ownership becomes effective |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of data for other key data - a higher version for same key data takes precedence |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
PARTICIPANT sets out Participant ID, name and class for all participants. |
|
PARTICIPANT is public data, so is available to all participants. Source PARTICIPANT updates as new participants register or existing participants change details. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
PARTICIPANTCLASSID |
VARCHAR2(20) |
|
Class of participant |
|
NAME |
VARCHAR2(80) |
|
Full name of participant |
|
DESCRIPTION |
VARCHAR2(64) |
|
Not used |
|
ACN |
VARCHAR2(9) |
|
Australian Company Number; Nine Numbers XXX-XXX-XXX |
|
PRIMARYBUSINESS |
VARCHAR2(40) |
|
Identifies primary business activity of participant |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
PARTICIPANTACCOUNT shows financial details on participants. |
|
PARTICIPANTACCOUNT data is confidential to the relevant participant. Source PARTICIPANTACCOUNT updates as new participants register or existing participants change details. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
ACCOUNTNAME |
VARCHAR2(80) |
|
Name of the account |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
ACCOUNTNUMBER |
VARCHAR2(16) |
|
Account number |
|
BANKNAME |
VARCHAR2(16) |
|
Bank name |
|
BANKNUMBER |
NUMBER(10,0) |
|
Bank number |
|
BRANCHNAME |
VARCHAR2(16) |
|
Branch name |
|
BRANCHNUMBER |
NUMBER(10,0) |
|
Branch number |
|
BSBNUMBER |
VARCHAR2(20) |
|
BSB number |
|
NEMMCOCREDITACCOUNTNUMBER |
NUMBER(10,0) |
|
AEMO credit account number |
|
NEMMCODEBITACCOUNTNUMBER |
NUMBER(10,0) |
|
AEMO debit account number |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
|
AUTHORISEDDATE |
DATE |
|
Authorised date |
|
EFFECTIVEDATE |
DATE |
|
Date record authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
ABN |
VARCHAR2(20) |
|
Australian Business Number |
|
Name |
|
|
Comment |
PARTICIPANTCATEGORY sets out valid participant categories. |
|
PARTICIPANTCATEGORY is public data, so is available to all participants. Source PARTICIPANTCATEGORY updates as categories change. PARTICIPANTCATEGORY changes infrequently. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PARTICIPANTCATEGORYID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTCATEGORYID |
VARCHAR2(10) |
X |
Participant category identifier |
|
DESCRIPTION |
VARCHAR2(64) |
|
Category description |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
PARTICIPANTCATEGORYALLOC sets out the assignment of participants to particular categories. |
|
PARTICIPANTCATEGORYALLOC data is public, so is available to all participants. Source PARTICIPANTCATEGORYALLOC updates for new participants or when categories change. PARTICIPANTCATEGORYALLOC changes infrequently. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PARTICIPANTCATEGORYID |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTCATEGORYID |
VARCHAR2(10) |
X |
Category unique identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
PARTICIPANTCLASS sets out valid participant classifications. |
|
PARTICIPANTCLASS data is public, so is available to all participants. Source PARTICIPANTCLASS updates only if classifications change. This table changes infrequently. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PARTICIPANTCLASSID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTCLASSID |
VARCHAR2(20) |
X |
Class of participant |
|
DESCRIPTION |
VARCHAR2(64) |
|
Description of participant class |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
|
|
PARTICIPANTCREDITDETAIL data is confidential to each participant. Source PARTICIPANTCREDITDETAIL updates infrequently. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
EFFECTIVEDATE |
|
PARTICIPANTID |
|
Name |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
|
|
PARTICIPANTID |
VARCHAR2(10) |
X |
|
|
CREDITLIMIT |
NUMBER(10,0) |
|
|
|
AUTHORISEDBY |
VARCHAR2(15) |
|
|
|
AUTHORISEDDATE |
DATE |
|
|
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
Entity table for group |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
GROUPID |
|
Name |
Data Type |
Mandatory |
Comment |
|
GROUPID |
NUMBER(20,0) |
X |
Abstract identifier for the group |
|
CREATEDDATE |
TIMESTAMP(3) |
|
Date record was created |
|
LASTCHANGED |
TIMESTAMP(3) |
|
Date record was last changed |
|
Name |
|
|
Comment |
Describe the NMIs that a group uses to provide its service |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
GROUPNMIID |
|
Name |
|
GROUPID |
|
NMI |
|
Name |
Data Type |
Mandatory |
Comment |
|
GROUPNMIID |
NUMBER(20,0) |
X |
Record Identifier of the NMI within a Group. When data is updated, existing record identifier is terminated, and new record identifier(s) are allocated. |
|
GROUPID |
NUMBER(20,0) |
|
Group id of the Group which the NMI belongs in. |
|
VERSIONFROM |
TIMESTAMP(3) |
|
Date for which this version is effective from |
|
VERSIONTO |
TIMESTAMP(3) |
|
Date for which this version is effective to. Will be set to current day plus one if it is the current active record or past date if the record has been superseded/ended. |
|
STARTDATE |
TIMESTAMP(3) |
|
Effective date of when this service started operation |
|
ENDDATE |
TIMESTAMP(3) |
|
Date for which this version is effective to. Will be set to current day plus one if it is the current active record or past date if the record has been superseded/ended. |
|
NMI |
VARCHAR2(20) |
|
National Meter Identifier linked to the group. |
|
SITENAME |
VARCHAR2(50) |
|
Site name |
|
NERRGROUPPREMISES |
NUMBER(1,0) |
|
Specifies whether NMI is in a NERR aggregated premises (TRUE = 1/FALSE = 0) |
|
BASELINEMETHODOLOGYID |
VARCHAR2(50) |
|
Baseline methodology to be used for the PoL and Baseline assessment of the NMI |
|
MRC |
NUMBER(10,3) |
|
Maximum responsive component for the NMI |
|
MRCREASON |
VARCHAR2(500) |
|
Reason for the MRC |
|
RETAILCUSTOMER |
VARCHAR2(50) |
|
Retail customer of the NMI |
|
SUSPENDED |
NUMBER(1,0) |
|
Indicates whether the NMI has been suspended from use. (TRUE = 1/FALSE = 0) |
|
UNAVAILABLE |
NUMBER(1,0) |
|
Indicates whether the NMI is unavailable for use. (TRUE = 1/FALSE = 0) |
|
APPROVEDDATE |
TIMESTAMP(3) |
|
Date which this record was approved |
|
LASTCHANGED |
TIMESTAMP(3) |
|
Date time which record was last changed |
|
Name |
|
|
Comment |
Describe the services a group provides and its relation to a market |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
GROUPSERVICEID |
|
Name |
|
ENTITYID |
|
GROUPID |
|
Name |
Data Type |
Mandatory |
Comment |
|
GROUPSERVICEID |
NUMBER(20,0) |
X |
Record identifier of the Service allocated to the Group. When data is updated, existing record identifier is terminated, and new record identifier(s) are allocated. |
|
GROUPID |
NUMBER(20,0) |
|
Group id of the Group where the Service is attached to. |
|
VERSIONFROM |
TIMESTAMP(3) |
|
Date for which this version is effective from. |
|
VERSIONTO |
TIMESTAMP(3) |
|
Date for which this version is effective to. Will be set to max date 9999/12/31 23:59:59.999 until this version ends or a change to the version is required. |
|
STARTDATE |
TIMESTAMP(3) |
|
Effective date of when this service started operation |
|
ENDDATE |
TIMESTAMP(3) |
|
Effective date of when this service ended operation. Will be set to max date 9999/12/31 23:59:59.999 until its service ends or a change to the service is required. |
|
MARKET |
VARCHAR2(50) |
|
Market that this group is operating its service in. Will only be NEM initially. |
|
SERVICETYPE |
VARCHAR2(50) |
|
Service that this group is operating. Will be only be ENERGY initially |
|
ENTITYTYPE |
VARCHAR2(50) |
|
Describes the entity that is operating. Will only be WDRU initially. |
|
ENTITYID |
VARCHAR2(50) |
|
Describe the entity ID in the market that it will be operating in. Will only contain the DUID of the group initially. |
|
MRC |
NUMBER(10,3) |
|
Maximum responsive component for the service offering |
|
MRCREASON |
VARCHAR2(500) |
|
Reason for the MRC. |
|
MAXIMUMRAMPRATEPERMIN |
NUMBER(10,0) |
|
Maximum ramp rate MW per minute of the service. |
|
REGION |
VARCHAR2(20) |
|
Region the group is operating this service in One of NSW1, QLD1, VIC1, SA1 or TAS1 |
|
APPROVEDDATE |
TIMESTAMP(3) |
|
Date which this record was approved |
|
LASTCHANGED |
TIMESTAMP(3) |
|
Date time which record was last changed |
|
Name |
|
|
Comment |
STADUALLOC sets out details on the allocation of dispatchable units to particular sites or stations. |
|
STADUALLOC is public data, and is available to all participants. Source STADUALLOC is updated whenever there is a station configuration change or new unit registration. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DUID |
|
EFFECTIVEDATE |
|
STATIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
STATIONID |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
|
DUID |
|
Name |
Data Type |
Mandatory |
Comment |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit Identifier |
|
EFFECTIVEDATE |
DATE |
X |
Effective date of this record |
|
STATIONID |
VARCHAR2(10) |
X |
Station Identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no of this record for the effective date |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
STATION sets out valid station identifiers. |
|
STATION is public data, and is available to all participants. Source STATION updates whenever there is a station configuration change or new unit registration. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
STATIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
STATIONID |
VARCHAR2(10) |
X |
Station Identifier |
|
STATIONNAME |
VARCHAR2(80) |
|
Full name of station |
|
ADDRESS1 |
VARCHAR2(80) |
|
Station Address |
|
ADDRESS2 |
VARCHAR2(80) |
|
Station Address |
|
ADDRESS3 |
VARCHAR2(80) |
|
Station Address |
|
ADDRESS4 |
VARCHAR2(80) |
|
Station Address |
|
CITY |
VARCHAR2(40) |
|
City |
|
STATE |
VARCHAR2(10) |
|
State of Australia |
|
POSTCODE |
VARCHAR2(10) |
|
Post Code |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
|
Not used. Do not use as the Connection Point Identifier for station load |
|
Name |
|
|
Comment |
STATIONOPERATINGSTATUS sets out the operating status of each station. |
|
STATIONOWNER is public data, and is available to all participants. Source STATIONOWNER is updated whenever there is a change in the station owner or new units are registered. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
STATIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Effective date of this record |
|
STATIONID |
VARCHAR2(10) |
X |
Unique station identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no of record within the effective date |
|
STATUS |
VARCHAR2(20) |
|
The operating status of this station, valid values are COMMISSIONED and DECOMMISSIONED |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
|
AUTHORISEDDATE |
DATE |
|
Date record authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
STATIONOWNER sets out the owner details of each station. |
|
STATIONOWNER is public data, and is available to all participants. Source STATIONOWNER is updated whenever there is a change in the station owner or new units are registered. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
PARTICIPANTID |
|
STATIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
STATIONID |
|
EFFECTIVEDATE |
|
VERSIONNO |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Effective date of this record |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
STATIONID |
VARCHAR2(10) |
X |
Station Identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no of record within the effective date |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
STATIONOWNERTRK shows the tracking for the associated object STATIONOWNER. Together, STATIONOWNERTRK and STATIONOWNER sets out the owner details of each station. |
|
STATIONOWNER is public data, and is available to all participants. Source STATIONOWNER is updated whenever there is a change in the station owner or new units are registered. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
PARTICIPANTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Effective date of this record |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no of record within the effective date |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
|
AUTHORISEDDATE |
DATE |
|
Date record authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|