|
Name |
|
|
Comment |
These tables are no longer used |
|
Name |
Comment |
Visibility |
|
APCCOMP is to set out Administered Price Cap (APC) compensation periods for a participant. |
Private |
|
|
APCCOMPAMOUNT shows the Administered Price Cap (APC) compensation amount. |
Private |
|
|
APCCOMPAMOUNTTRK sets out the relevant Administered Price Cap (APC) period for compensation purposes. Use the APCCOMPAMOUNTTRK table in conjunction with APCAMOUNT. |
Private |
|
|
BIDPEROFFER shows period-based Energy and Ancillary Service bid data. BIDPEROFFER is a child table of BIDDAYOFFER. |
Private & Public Next-Day |
|
|
|
Private |
|
|
CSP derogation amounts with respect to participant allocated payment |
Public |
|
|
BILLING_MR_PAYMENT shows aggregate payments on a dispatchable unit/MR Event basis for accepted MR capacity |
Private |
|
|
BILLING_MR_RECOVERY shows aggregate recovery charges on a dispatchable unit / MR Event basis for spot market income from dispatch of MR capacity. |
Private |
|
|
BILLING_MR_SHORTFALL shows aggregate MR shortfall payments (or recovery charges) to each participant in the region for the MR event. |
Private |
|
|
BILLING_MR_SUMMARY shows aggregate payment/recovery and shortfall figures for an MR Event. |
Public |
|
|
Billing result table for reserve trader contract payments |
Private |
|
|
Billing result table for reserve trader contract recovery |
Private |
|
|
BILLINGCPDATA shows energy quantity and $ value purchased per participant connection point. |
Private |
|
|
BILLINGCPSUM shows adjustments for a billing run by participant. |
Private |
|
|
BILLINGCUSTEXCESSGEN shows excess generation payments for each participant cutover. |
Private |
|
|
BILLINGEXCESSGEN shows the excess generation cost by period for each participant. |
Private |
|
|
BILLINGGENDATA shows the total energy sold and purchased per participant transmission connection point for a billing period. |
Private |
|
|
BILLINGINTERVENTION shows billing intervention recovery details. |
Private |
|
|
BILLINGINTERVENTIONREGION shows recovery charges for region intervention. |
Private |
|
|
BILLINGRESERVERECOVERY shows Market Reserve recovery details for each participant in a bill run. |
Private |
|
|
BILLINGRESERVEREGIONRECOVERY shows Billing Region Reserve region recovery details for each participant (by region). |
Private |
|
|
BILLINGRESERVETRADER shows Billing Market Reserve TRADER payment details to Generators. |
Private |
|
|
BILLINGRESERVETRADERREGION shows Billing Region Reserve Trader payment details. |
Private |
|
|
BILLINGSMELTERREDUCTION shows the smelter reduction payment (only applies to participants with Victorian customer connection points). |
Private |
|
|
BILLINTERVENTIONRECOVERY shows billing market intervention recovery details for each participant. |
Private |
|
|
BILLINTERVENTIONREGIONRECOVERY shows billing region intervention recovery details for each participant by region. |
Private |
|
|
BILLSMELTERRATE is standing data, setting out the rates used in smelter reduction calculations. |
Public |
|
|
CONNECTIONPOINT shows all valid connection points and their type. Transmission loss factors are available for all connection points in TRANSMISSIONLOSSFACTOR. |
Public |
|
|
CONNECTIONPOINTDETAILS is obsolete, since it was never populated by Participants accessing AEMO's Oracle Interface. |
Public |
|
|
CONNECTIONPOINTOPERATINGSTA shows whether a connection point is active or not. |
Public |
|
|
CONTRACTGOVERNOR became unused when Ancillary Services Review was implemented in 2001. For more details, see Change Notice 126. |
Private |
|
|
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. |
Private |
|
|
CONTRACTRESERVETHRESHOLD shows reserve contract threshold details for enabling, usage and availability thresholds and rates for reserve trader contracts. |
Private |
|
|
CONTRACTRESERVETRADER shows reserve trader contract details. Version numbers do not apply as contracts exist for specified purposes. |
Private |
|
|
CONTRACTUNITLOADING became unused when Ancillary Services Review was implemented in 2001. For more details, see Change Notice 126. |
Private |
|
|
CONTRACTUNITUNLOADING shows Ancillary Service contract data for rapid generator unit unloading. |
Private |
|
|
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). |
Private & Public Next-Day |
|
|
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). |
Public |
|
|
DEFAULTDAYOFFER shows day-based details of participants’ default bids unit for the same day. |
Private |
|
|
DEFAULTOFFERTRK shows the file names of default offers submitted for each unit. |
Private |
|
|
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. |
Private |
|
|
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. |
Public |
|
|
DISPATCH_FCAS_REQ shows Dispatch Constraint tracking for Regional FCAS recovery. |
Public |
|
|
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. |
Private & Public Next-Day |
|
|
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. |
Public |
|
|
DISPATCHCASESOLUTION shows information relating to the complete dispatch run. The fields in DISPATCHCASESOLUTION provide an overview of the dispatch run results allowing immediate identification of conditions such as energy or FCAS deficiencies. |
Public |
|
|
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. |
Public |
|
|
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. |
Private & Public Next-Day |
|
|
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. |
Public |
|
|
FORCEMAJEURE used to set out the start and end dates / periods of any force majeure event. FORCEMAJEURE is not used. |
Public |
|
|
|