|
Name |
|
|
Comment |
ANCILLARY_RECOVERY_SPLIT holds the actual customer portion for each service and payment type. A single EFFECTIVEDATE/VERSIONNO combination applies to all services (i.e. the latest EFFECTIVEDATE/VERSIONNO is not retrieved for a single service, but applies to a data set). |
|
ANCILLARY_RECOVERY_SPLIT is public data, and is available to all participants. Source This table is updated infrequently. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
PAYMENTTYPE |
|
SERVICE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Calendar settlement date record becomes effective. |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number of the record for the given date. |
|
SERVICE |
VARCHAR2(10) |
X |
Ancillary service name (e.g. AGC, FCASCOMP) |
|
PAYMENTTYPE |
VARCHAR2(20) |
X |
A payment type associated with the service (can be ENABLING, AVAILABILITY, USAGE, or COMPENSATION). |
|
CUSTOMER_PORTION |
NUMBER(8,5) |
|
The percentage value of the recovery funded by market customers. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
ACE_PORTION |
NUMBER(18,8) |
|
The percentage value of the recovery funded using the ACE MWh Values. This field is only used for Settlement post IESS rule effective date. |
|
Name |
|
|
Comment |
Market fee exclusions for participant categories. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
MARKETFEEID |
|
PARTICIPANT_CATEGORYID |
|
VERSION_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
MARKETFEEID |
VARCHAR2(20) |
X |
The excluded market fee |
|
EFFECTIVEDATE |
DATE |
X |
The date the exclusion is effective from |
|
VERSION_DATETIME |
DATE |
X |
The version information for this record |
|
PARTICIPANT_CATEGORYID |
VARCHAR2(20) |
X |
Participant category to be excluded from this market fee |
|
Name |
|
|
Comment |
Tracking table for market fee exclusions for participant categories. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
MARKETFEEID |
|
VERSION_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
MARKETFEEID |
VARCHAR2(20) |
X |
The excluded market fee |
|
EFFECTIVEDATE |
DATE |
X |
The date the exclusion is effective from |
|
VERSION_DATETIME |
DATE |
X |
The version information for this record |
|
LASTCHANGED |
DATE |
|
Last date and time the record changed |
|
Name |
|
|
Comment |
MARKET_FEE_EXCLUSION shows the list of market fees from which a participant is excluded from funding after a particular settlement date. |
|
MARKET_FEE_EXCLUSION data is confidential to the relevant participant. Source MARKET_FEE_EXCLUSION updates only on change of participant configuration. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
EFFECTIVEDATE |
|
MARKETFEEID |
|
PARTICIPANTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
EFFECTIVEDATE |
DATE |
X |
Date on which this data becomes effective |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of fees for this ID |
|
MARKETFEEID |
VARCHAR2(10) |
X |
Identifier for Market Fee |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
MARKET_FEE_EXCLUSIONTRK shows authorisation details of participant market fee exclusion data sets. |
|
MARKET_FEE_EXCLUSIONTRK is confidential to the participant. Source MARKET_FEE_EXCLUSIONTRK updates only on change of participant configuration. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
EFFECTIVEDATE |
|
PARTICIPANTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
EFFECTIVEDATE |
DATE |
X |
Date on which this data becomes effective |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of fees for this ID |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
|
AUTHORISEDDATE |
DATE |
|
Date record authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
MARKETFEE sets out fee type and period for each market fee. |
|
MARKETFEE data is public, so is available to all participants. Source MARKETFEE updates when fees change. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
MARKETFEEID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
MARKETFEEID |
VARCHAR2(10) |
X |
Identifier for Market Fee |
|
MARKETFEEPERIOD |
VARCHAR2(20) |
|
Period type - PERIOD, DAILY, WEEKLY |
|
MARKETFEETYPE |
VARCHAR2(12) |
|
Type - MW or $ |
|
DESCRIPTION |
VARCHAR2(64) |
|
Description of market fee |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
GL_TCODE |
VARCHAR2(15) |
|
|
|
GL_FINANCIALCODE |
VARCHAR2(10) |
|
|
|
FEE_CLASS |
VARCHAR2(40) |
|
|
|
METER_TYPE |
VARCHAR2(20) |
|
The Energy Type for the Market Fees Calculation. E.g of Meter Types are CUSTOMER, GENERATOR, NREG, BDU etc. If Meter Type is mentioned as ALL then all the Meter Types for that Participant Category will be used in the Fee calculation |
|
METER_SUBTYPE |
VARCHAR2(20) |
|
The Meter Sub Type values are ACE, ASOE or ALL. ACE represent ACE_MWH value , ASOE represent ASOE_MWH value and ALL represent sum of ACE_MWh and ASOE_MWh |
|
Name |
|
|
Comment |
MARKETFEEDATA sets out actual fee rates, as adjusted from time to time. |
|
MARKETFEEDATA is public data, and is available to all participants. Source MARKETFEEDATA updates whenever fee rates change. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
MARKETFEEID |
|
MARKETFEEVERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
MARKETFEEID |
VARCHAR2(10) |
X |
Identifier for Market Fee |
|
MARKETFEEVERSIONNO |
NUMBER(3,0) |
X |
Version of fees for this id |
|
EFFECTIVEDATE |
DATE |
X |
Date on which this data becomes effective |
|
MARKETFEEVALUE |
NUMBER(22,8) |
|
Market fee rate/MWh, a dollar amount |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
MARKETFEETRK sets out versions of each market fee used and its effective date. |
|
MARKETFEETRK data is public, so is available to all participants. Source MARKETFEETRK updated infrequently, when new annual rates must be inserted. Volume One record inserted per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
MARKETFEEVERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
MARKETFEEVERSIONNO |
NUMBER(3,0) |
X |
Version of fees for this ID |
|
EFFECTIVEDATE |
DATE |
X |
Effective Date of Market notice |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User authorising record |
|
AUTHORISEDDATE |
DATE |
|
Date record authorised |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
PARTICIPANT_BANDFEE_ALLOC shows the market fee for each Participant/Participant Category over time. |
|
Source This view updates only on change of participant configuration. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
EFFECTIVEDATE |
|
MARKETFEEID |
|
PARTICIPANTCATEGORYID |
|
PARTICIPANTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
MARKETFEEID |
VARCHAR2(10) |
X |
Identifier for Market Fee |
|
EFFECTIVEDATE |
DATE |
X |
Date on which this data becomes effective. |
|
VERSIONNO |
NUMBER(3,0) |
X |
Period identifier |
|
PARTICIPANTCATEGORYID |
VARCHAR2(10) |
X |
The participant category that the market fee recovery amount pertains to. |
|
MARKETFEEVALUE |
NUMBER(15,5) |
|
The value of this market fee |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
The REALLOCATION table shows the financial transactions agreed between two participants that are settled through the AEMO pool settlements process. |
|
Note The column REALLOCATION_TYPE can be used in conjunction with CREDITPARTICIPANT or DEBITPARTICIPANT to determine who submitted a reallocation. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
REALLOCATIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REALLOCATIONID |
VARCHAR2(20) |
X |
Reallocation identifier |
|
CREDITPARTICIPANTID |
VARCHAR2(10) |
|
The participant to be credited for the reallocation |
|
DEBITPARTICIPANTID |
VARCHAR2(10) |
|
The participant to be debited for the reallocation |
|
REGIONID |
VARCHAR2(10) |
|
Region identifier, being the spot price reference node for this reallocation |
|
AGREEMENTTYPE |
VARCHAR2(10) |
|
$, (Quantity) Mwh, SWAP, CAP or FLOOR |
|
CREDITREFERENCE |
VARCHAR2(400) |
|
Optional reference detail for credit participant |
|
DEBITREFERENCE |
VARCHAR2(400) |
|
Optional reference detail for debit participant |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
STARTDATE |
DATE |
|
First day of the Reallocation contract |
|
ENDDATE |
DATE |
|
Last day of the Reallocation contract |
|
CURRENT_STEPID |
VARCHAR2(20) |
|
Reallocation state. One of SUBMITTED, AUTHORISED, CANCELLED. |
|
DAYTYPE |
VARCHAR2(20) |
|
The day type profile for which the reallocation applies over the start and end date range. Valid entries are BUSINESS, NON_BUSINESS or FLAT. |
|
REALLOCATION_TYPE |
VARCHAR2(1) |
|
Denotes a Credit or Debit reallocation with a value of "C" or "D" respectively |
|
CALENDARID |
VARCHAR2(30) |
|
Unique ID of the calendar for which data is requested |
|
INTERVALLENGTH |
NUMBER(3,0) |
|
The length of settlement intervals (in minutes) in the reallocation profile |
|
Name |
|
|
Comment |
30-minute or (5-minute for 5MS) data comprising a single reallocation transaction. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PERIODID |
|
REALLOCATIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REALLOCATIONID |
VARCHAR2(20) |
X |
Reallocation identifier |
|
PERIODID |
NUMBER(3) |
X |
Trading Interval |
|
VALUE |
NUMBER(15,5) |
|
Reallocation value in the units of the agreement type |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
NRP |
NUMBER(15,5) |
|
Nominated Reallocation Price, only used in agreement types of SWAP, CAP and FLOOR, being the contract strike price in $/MWh |
|
Name |
|
|
Comment |
SETCFG_PARTICIPANT_MPF shows the Market Participation Factors (MPF) for each participant for each connection point. The MPF values are used to determine recovery amounts for regulation FCAS. |
|
SETCFG_PARTICIPANT_MPF data is available to all participants. Volume Approximately 20,000 records per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONNECTIONPOINTID |
|
EFFECTIVEDATE |
|
PARTICIPANTCATEGORYID |
|
PARTICIPANTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant identifier |
|
EFFECTIVEDATE |
DATE |
X |
Effective date of the MPF data |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number of the MPF data |
|
PARTICIPANTCATEGORYID |
VARCHAR2(10) |
X |
Participant Category |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Connection point identifier |
|
MPF |
NUMBER(15,5) |
|
Market Participation Factor |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
SETCFG_PARTICIPANT_MPFTRK is the tracking table for Market Participation Factors (MPF) data stored in the SETCFG_PARTICIPANT_MPF table for each participant. |
|
SETCFG_PARTICIPANT_MPFTRK data is public, so is available to all participants. Volume Approximately 2,000 records per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
PARTICIPANTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant identifier |
|
EFFECTIVEDATE |
DATE |
X |
Effective date of the MPF data |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number of the MPF data |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
Authorising user |
|
AUTHORISEDDATE |
DATE |
|
Authorised date and time |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
The Settlement Price for SAPS Energy in each Region |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
FROMDATE |
|
REGIONID |
|
TODATE |
|
VERSION_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
FROMDATE |
DATE |
X |
The From Date of the SAPS Pricing Application Period |
|
TODATE |
DATE |
X |
The To Date of the SAPS Pricing Application Period |
|
REGIONID |
VARCHAR2(20) |
X |
The Region ID for which the calculated SAPS Price is applicable |
|
VERSION_DATETIME |
DATE |
X |
The Date time of the record generation |
|
SAPS_RRP |
NUMBER(18,8) |
|
The Region Reference Price for SAPS in the Region |
|
ISFIRM |
NUMBER(3,0) |
|
Whether the SAPS Price is Firm or Non-Firm |
|
LASTCHANGED |
DATE |
|
The Last Changed Date time of the record |
|
Name |
|
|
Comment |
Settlements WDR transactions |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
REGIONID |
|
VERSION_DATETIME |
|
WDRRRPERIOD |
|
Name |
Data Type |
Mandatory |
Comment |
|
WDRRRPERIOD |
VARCHAR2(20) |
X |
Unique identifier for the period to which the WDRRR applies. For quarter-based periods, this will be equal to YYYY[Q]NN, e.g. 2020Q3 for 2020 Quarter 3. |
|
REGIONID |
VARCHAR2(20) |
X |
Unique identifier for the region |
|
VERSION_DATETIME |
TIMESTAMP(3) |
X |
The Version Date time of the latest changes. |
|
WDRRR |
NUMBER(18,8) |
|
WDRRR value for the period and region ($/MWh) |
|
ISFIRM |
NUMBER(3,0) |
|
A flag to indicate that the WDRRR value is FIRM for the period and region, i.e. it is based on a complete set of firm prices from dispatch. Possible Values are 1 and 0 |
|
LASTCHANGED |
TIMESTAMP(3) |
|
Last changed date for the record |
|
Name |
|
|
Comment |
Wholesale Demand Response Reimbursement Rate Calendar |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
REGIONID |
|
VERSION_DATETIME |
|
WDRRRPERIOD |
|
Name |
Data Type |
Mandatory |
Comment |
|
WDRRRPERIOD |
VARCHAR2(20) |
X |
Unique identifier for the period to which the WDRRR applies. For quarter-based periods, this will be equal to YYYY[Q]NN, for example,2020Q3 for 2020 Quarter 3. |
|
REGIONID |
VARCHAR2(20) |
X |
Unique Identifier for the region id |
|
VERSION_DATETIME |
TIMESTAMP(3) |
X |
The Version Date time of the latest changes. |
|
STARTDATE |
DATE |
|
Start Date of Period (Inclusive). |
|
ENDDATE |
DATE |
|
End Date of Period (Inclusive). |
|
LASTCHANGED |
TIMESTAMP(3) |
|
Last changed date for the record. |
|
|
|