Package: SETTLEMENT_CONFIG

Name

SETTLEMENT_CONFIG

Comment

Configuration and input data for the Settlements Process


List of tables

Name

Comment

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

Half-hour 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.


Diagram: Entities: Settlement Config

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