|
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 |
|
|
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 |
|
|
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_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 |
|
|
FORCEMAJEUREREGION used to set out regions impacted by a force majeure event. This table is not used. |
Public |
|
|
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. |
Private |
|
|
INTCONTRACT shows intervention contract details. These are specific to each intervention. |
Private |
|
|
|