Package: SETTLEMENT_CONFIG

Name

SETTLEMENT_CONFIG

Comment

Configuration and input data for the Settlements Process


List of tables

Name

Comment

Visibility

ANCILLARY_RECOVERY_SPLIT

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).

Public

MARKET_FEE_CAT_EXCL

Market fee exclusions for participant categories.

Public

MARKET_FEE_CAT_EXCL_TRK

Tracking table for market fee exclusions for participant categories.

Public

MARKET_FEE_EXCLUSION

MARKET_FEE_EXCLUSION shows the list of market fees from which a participant is excluded from funding after a particular settlement date.

Private

MARKET_FEE_EXCLUSIONTRK

MARKET_FEE_EXCLUSIONTRK shows authorisation details of participant market fee exclusion data sets.

Private

MARKETFEE

MARKETFEE sets out fee type and period for each market fee.

Public

MARKETFEEDATA

MARKETFEEDATA sets out actual fee rates, as adjusted from time to time.

Public

MARKETFEETRK

MARKETFEETRK sets out versions of each market fee used and its effective date.

Public

PARTICIPANT_BANDFEE_ALLOC

PARTICIPANT_BANDFEE_ALLOC shows the market fee for each Participant/Participant Category over time.

Private

REALLOCATION

The REALLOCATION table shows the financial transactions agreed between two participants that are settled through the AEMO pool settlements process.

Private

REALLOCATIONINTERVAL

30-minute or (5-minute for 5MS) data comprising a single reallocation transaction.

Private

SETCFG_PARTICIPANT_MPF

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.

Public

SETCFG_PARTICIPANT_MPFTRK

SETCFG_PARTICIPANT_MPFTRK is the tracking table for Market Participation Factors (MPF) data stored in the SETCFG_PARTICIPANT_MPF table for each participant.

Public

SETCFG_SAPS_SETT_PRICE

The Settlement Price for SAPS Energy in each Region

Public

SETCFG_WDR_REIMBURSE_RATE

Settlements WDR transactions

Public

SETCFG_WDRRR_CALENDAR

Wholesale Demand Response Reimbursement Rate Calendar

Public


Diagram: Entities: Settlement Config

Table: MARKETFEE Table: REALLOCATION Table: MARKETFEETRK Table: MARKETFEEDATA Table: REALLOCATIONINTERVAL Table: SETCFG_WDRRR_CALENDAR Table: MARKET_FEE_CAT_EXCL_TRK Table: MARKET_FEE_CAT_EXCL Table: MARKET_FEE_EXCLUSIONTRK Table: MARKET_FEE_EXCLUSION Table: SETCFG_PARTICIPANT_MPFTRK Table: SETCFG_WDR_REIMBURSE_RATE Table: SETCFG_SAPS_SETT_PRICE Table: ANCILLARY_RECOVERY_SPLIT Table: SETCFG_PARTICIPANT_MPF Table: PARTICIPANT_BANDFEE_ALLOC
Entities: Settlement Config