Skip to content

SETTLEMENT_CONFIG

Configuration and input data for the Settlements Process

Tables

This package contains the following tables:

Name Description
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).
MARKET_FEE_CAT_EXCL Market fee exclusions for participant categories.
MARKET_FEE_CAT_EXCL_TRK Tracking table for market fee exclusions for participant categories.
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.
MARKET_FEE_EXCLUSIONTRK MARKET_FEE_EXCLUSIONTRK shows authorisation details of participant market fee exclusion data sets.
MARKETFEE MARKETFEE sets out fee type and period for each market fee.
MARKETFEEDATA MARKETFEEDATA sets out actual fee rates, as adjusted from time to time.
MARKETFEETRK MARKETFEETRK sets out versions of each market fee used and its effective date.
PARTICIPANT_BANDFEE_ALLOC PARTICIPANT_BANDFEE_ALLOC shows the market fee for each Participant/Participant Category over time.
REALLOCATION The REALLOCATION table shows the financial transactions agreed between two participants that are settled through the AEMO pool settlements process.
REALLOCATIONINTERVAL 30-minute or (5-minute for 5MS) data comprising a single reallocation transaction.
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.
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.
SETCFG_SAPS_SETT_PRICE The Settlement Price for SAPS Energy in each Region
SETCFG_WDR_REIMBURSE_RATE Settlements WDR transactions
SETCFG_WDRRR_CALENDAR Wholesale Demand Response Reimbursement Rate Calendar

Diagram

SETTLEMENT_CONFIG

Package Documentation