Package: HISTORICAL TABLES

Name

HISTORICAL TABLES

Comment

These tables are no longer used


List of tables

Name

Comment

APCCOMP

APCCOMP is to set out Administered Price Cap (APC) compensation periods for a participant.

APCCOMPAMOUNT

APCCOMPAMOUNT shows the Administered Price Cap (APC) compensation amount.

APCCOMPAMOUNTTRK

APCCOMPAMOUNTTRK sets out the relevant Administered Price Cap (APC) period for compensation purposes. Use the APCCOMPAMOUNTTRK table in conjunction with APCAMOUNT.

BIDPEROFFER

BIDPEROFFER shows period-based Energy and Ancillary Service bid data. BIDPEROFFER is a child table of BIDDAYOFFER.

BILLADJUSTMENTS

 

BILLING_CSP_DEROGATION_AMOUNT

CSP derogation amounts with respect to participant allocated payment

BILLING_MR_PAYMENT

BILLING_MR_PAYMENT shows aggregate payments on a dispatchable unit/MR Event basis for accepted MR capacity

BILLING_MR_RECOVERY

BILLING_MR_RECOVERY shows aggregate recovery charges on a dispatchable unit / MR Event basis for spot market income from dispatch of MR capacity.

BILLING_MR_SHORTFALL

BILLING_MR_SHORTFALL shows aggregate MR shortfall payments (or recovery charges) to each participant in the region for the MR event.

BILLING_MR_SUMMARY

BILLING_MR_SUMMARY shows aggregate payment/recovery and shortfall figures for an MR Event.

BILLING_RES_TRADER_PAYMENT

Billing result table for reserve trader contract payments

BILLING_RES_TRADER_RECOVERY

Billing result table for reserve trader contract recovery

BILLINGCPSUM

BILLINGCPSUM shows adjustments for a billing run by participant.

BILLINGCUSTEXCESSGEN

BILLINGCUSTEXCESSGEN shows excess generation payments for each participant cutover.

BILLINGEXCESSGEN

BILLINGEXCESSGEN shows the excess generation cost by period for each participant.

BILLINGINTERVENTION

BILLINGINTERVENTION shows billing intervention recovery details.

BILLINGINTERVENTIONREGION

BILLINGINTERVENTIONREGION shows recovery charges for region intervention.

BILLINGRESERVERECOVERY

BILLINGRESERVERECOVERY shows Market Reserve recovery details for each participant in a bill run.

BILLINGRESERVEREGIONRECOVERY

BILLINGRESERVEREGIONRECOVERY shows Billing Region Reserve region recovery details for each participant (by region).

BILLINGRESERVETRADER

BILLINGRESERVETRADER shows Billing Market Reserve TRADER payment details to Generators.

BILLINGRESERVETRADERREGION

BILLINGRESERVETRADERREGION shows Billing Region Reserve Trader payment details.

BILLINGSMELTERREDUCTION

BILLINGSMELTERREDUCTION shows the smelter reduction payment (only applies to participants with Victorian customer connection points).

BILLINTERVENTIONRECOVERY

BILLINTERVENTIONRECOVERY shows billing market intervention recovery details for each participant.

BILLINTERVENTIONREGIONRECOVERY

BILLINTERVENTIONREGIONRECOVERY shows billing region intervention recovery details for each participant by region.

BILLSMELTERRATE

BILLSMELTERRATE is standing data, setting out the rates used in smelter reduction calculations.

CONNECTIONPOINT

CONNECTIONPOINT shows all valid connection points and their type. Transmission loss factors are available for all connection points in TRANSMISSIONLOSSFACTOR.

CONNECTIONPOINTDETAILS

CONNECTIONPOINTDETAILS is obsolete, since it was never populated by Participants accessing AEMO's Oracle Interface.
CONNECTIONPOINTDETAILS was designed to show relevant details for each connection point including the responsible party, loss factor and relevant MDAs.

CONNECTIONPOINTOPERATINGSTA

CONNECTIONPOINTOPERATINGSTA shows whether a connection point is active or not.

CONTRACTGOVERNOR

CONTRACTGOVERNOR became unused when Ancillary Services Review was implemented in 2001. For more details, see Change Notice 126.
CONTRACTGOVERNOR shows Governor contract details used in the settlement and dispatch of this service. Note services are dispatched as 6 and 60 raise and lower Frequency Control Ancillary Services (FCAS). Lower and raise 6 and 60 second fields are used in dispatch of services. Deadband and Droop details are used in settlements.

CONTRACTRESERVEFLAG

CONTRACTRESERVEFLAG has never been or will be used. It was to show a period by period flag for regional or market recovery of reserve trading contract amounts.

CONTRACTRESERVETHRESHOLD

CONTRACTRESERVETHRESHOLD shows reserve contract threshold details for enabling, usage and availability thresholds and rates for reserve trader contracts.

CONTRACTRESERVETRADER

CONTRACTRESERVETRADER shows reserve trader contract details. Version numbers do not apply as contracts exist for specified purposes.

CONTRACTUNITLOADING

CONTRACTUNITLOADING became unused when Ancillary Services Review was implemented in 2001. For more details, see Change Notice 126.
CONTRACTUNITLOADING shows Unit Loading contract details used in the settlement and dispatch of this service.

CONTRACTUNITUNLOADING

CONTRACTUNITUNLOADING shows Ancillary Service contract data for rapid generator unit unloading.

DAYOFFER

DAYOFFER sets out the participants’ daily components of participant bid containing details applying for the whole day (such as prices, daily energy constraint and fast start profiles).
To retrieve full bid details, read in conjunction with PEROFFER.

DAYOFFER_D

DAYOFFER_D sets out the participants’ daily components of participant bid containing just the latest details (such as prices, daily energy constraint and fast start profiles).
To retrieve latest bid details, read in conjunction with PEROFFER_D.

DEFAULTDAYOFFER

DEFAULTDAYOFFER shows day-based details of participants’ default bids unit for the same day.

DEFAULTOFFERTRK

DEFAULTOFFERTRK shows the file names of default offers submitted for each unit.

DEFAULTPEROFFER

DEFAULTPEROFFER shows half hourly period-based data in the default bid for each Dispatchable Unit, such as period availability, rate of change and band quantities.

DELTAMW

DELTAMW sets out the Frequency Control Ancillary Services (FCAS) requirement to be provided locally within each region and each half-hour period in a market day. Two fields specify Frequency Controlled Ancillary Services requirements to be provided locally for the new regulation ancillary services.

DISPATCHBIDTRK

DISPATCHBIDTRK shows the bid tracking, including the bid version used in each dispatch run for each unit. DISPATCHBIDTRK is the audit trail of the bid actually used in each dispatch.

DISPATCHCASE_OCD

DISPATCHCASE_OCD shows the key data to indicate when an over-constrained dispatch (OCD) re-run actually occurred. One record per over-constrained dispatch interval.

DISPATCHCASESOLUTION_BNC

DISPATCHCASESOLUTION_BNC was discontinued on 30 September 2009. Prior: DISPATCHCASESOLUTION_BNC is the key data to indicate when a binding intra-regional network constraints (BNC) re-run actually occurred.

DISPATCHLOAD_BNC

DISPATCHLOAD_BNC was discontinued on 30 September 2009. Prior: DISPATCHLOAD_BNC gives binding intra-regional network constraints (BNC) re-run dispatch results for all scheduled generating units. DISPATCHLOAD_BNC has a similar structure to DISPATCHLOAD but does not repeat input type data (e.g. InitialMW, AGCStatus) since these values are available from DISPATCHLOAD.

DISPATCHTRK

DISPATCHTRK is no longer used. DISPATCHTRK was the cross-reference between each dispatch run and SPD case run. DISPATCHTRK may be available on the InfoServer but not replicated to participant databases as it contains data duplicated in other tables.

FORCEMAJEURE

FORCEMAJEURE used to set out the start and end dates / periods of any force majeure event. FORCEMAJEURE is not used.

FORCEMAJEUREREGION

FORCEMAJEUREREGION used to set out regions impacted by a force majeure event. This table is not used.

GENUNITMTRINPERIOD

GENUNITMTRINPERIOD shows meter reading by period for each generator meter. GENUNITMTRINPERIOD covers generated power flowing into the system. It is used to calculate settlement values.

INTCONTRACT

INTCONTRACT shows intervention contract details. These are specific to each intervention.

INTCONTRACTAMOUNT

INTCONTRACTAMOUNT shows intervention contract amounts.


2  3