|
Name |
|
|
Comment |
Configuration and input data for the Settlements Process |
|
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). |
|
|
Market fee exclusions for participant categories. |
|
|
Tracking table for market fee exclusions for participant categories. |
|
|
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 shows authorisation details of participant market fee exclusion data sets. |
|
|
MARKETFEE sets out fee type and period for each market fee. |
|
|
MARKETFEEDATA sets out actual fee rates, as adjusted from time to time. |
|
|
MARKETFEETRK sets out versions of each market fee used and its effective date. |
|
|
PARTICIPANT_BANDFEE_ALLOC shows the market fee for each Participant/Participant Category over time. |
|
|
The REALLOCATION table shows the financial transactions agreed between two participants that are settled through the AEMO pool settlements process. |
|
|
Half-hour data comprising a single reallocation transaction. |
|
|
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 is the tracking table for Market Participation Factors (MPF) data stored in the SETCFG_PARTICIPANT_MPF table for each participant. |
|
|
|
|