|
Name |
Comment |
Visibility |
|
INTCONTRACTAMOUNTTRK shows the latest valid version of each intervention contract. |
Private |
|
|
INTERCONNMWFLOW shows Metered Interconnector flow data. INTERCONNMWFLOW shows the meter data provided by Meter Data Providers to MSATS. |
Public |
|
|
MARKETSUSPENSION is obsolete from 2017 End of Year DM4.27 Release. |
Public |
|
|
MARKETSUSREGION is obsolete from 2017 End of Year DM4.27 Release. |
Public |
|
|
MAS_CP_CHANGE records pending changes to the current MAS configuration. |
Private |
|
|
MAS_CP_MASTER shows the current MAS configuration. |
Private |
|
|
METERDATA sets out a meter data for each customer connection point. METERDATA covers market load. Use the field METERRUNNO to match the meter data version for each settlement run. |
Private |
|
|
Recorded actual generation of non-scheduled units where SCADA data is available. |
Public |
|
|
Tracking table for the publication of wholesale settlement data associated with BILLING run |
Public |
|
|
METERDATATRK records meter data files submitted for each connection point on a daily basis. The same data is provided in METERDATA period by period (i.e. 48 records), whereas METERDATATRK shows one record per day for each file submitted for a connection point. |
Private |
|
|
MNSP_FILETRK shows all MNSPOFFERS transmitted to the MMS system. |
Private |
|
|
MNSP_OFFERTRK records all valid MNSPOFFERS loaded into the MMS system. The authorised date reflects the date and time of the load. MNSP_OFFERTRK is key for tracking MNSP bid submission. |
Private & Public Next-Day |
|
|
MNSP_PEROFFER shows period by period availability and other period data pertaining to a specific bid and LinkID for the given Settlement Date. |
Private & Public Next-Day |
|
|
MR_DAYOFFER_STACK defines the Stack order for each version of the Acceptance Schedule, including all units submitting MR offers for that event. MR_DAYOFFER_STACK is the child to MR_EVENT_SCHEDULE, and parent to MR_PEROFFER_STACK. |
Private & Public Next-Day |
|
|
MR_EVENT defines an MR Event for a given region on a specific trading date. |
Public |
|
|
MR_EVENT_SCHEDULE defines the Stack version of the Acceptance Schedule and is the parent table to MR_DayOffer_Stack and MR_PerOffer_Stack. |
Public |
|
|
MR_PEROFFER_STACK defines the accepted capacity on a period basis for the Acceptance Schedule, is a child table to MR_DayOffer_Stack and only includes records or units with accepted_capacity > 0 for the specific period. |
Private & Public Next-Day |
|
|
MTPASA_CASE_SET is obsolete from 2005 End of Year Release. The RUNTYPE added to the primary key of the detail tables for MTPASA allows for the different types of runs for each case. |
Public |
|
|
MTPASA_CASESOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
Public |
|
|
MTPASA_CONSTRAINTSOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
Public |
|
|
MTPASA_INTERCONNECTORSOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
Public |
|
|
MTPASA_CASESOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
Public |
|
|
MTPASA_RESERVELIMITSOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
Public |
|
|
MTPASACONSTRAINTSOLUTION_D sets out MT PASA constraint solution results, where constraints are binding. |
Public |
|
|
MTPASAINTERCONNECTORSOLUTION_D shows interconnector results for MT PASA, shown region by region. |
Public |
|
|
MTPASAREGIONSOLUTION_D shows region results for MT PASA, showing predicted demand and any capacity limits. |
Public |
|
|
OARTRACK shows an audit trail of bids for a particular settlement day. Corrupt bids do not update OARTRACK, but are just in OFFERFILETRK. |
Private & Public Next-Day |
|
|
OFFERFILETRK shows an audit trail of all bid files submitted containing energy bids, including corrupt bids/rebids. |
Private |
|
|
OFFERGOVDATA sets out reoffers of governor (6 and 60 second FCAS) availability. |
Private |
|
|
OFFERULOADINGDATA shows reoffers of rapid unit loading capability. |
Private |
|
|
OFFERUNLOADINGDATA shows reoffers of rapid unit unloading capability. |
Private |
|
|
PASACASESOLUTION sets out ST PASA case listing providing details of each STPASA case run. |
Public |
|
|
PASACONSTRAINTSOLUTION records the latest binding STPASA constraint details for each period. For each solution, the latest recalculation for each period overwrites the previous entry. |
Public |
|
|
PASAINTERCONNECTORSOLUTION records ST PASA interconnector solutions for the latest period. |
Public |
|
|
PASAREGIONSOLUTION shows the Regional solution for ST PASA showing reserves for each half-hour period. This table (PASAREGIONSOLUTION_D) shows the latest calculated result for each period. |
Public |
|
|
PEROFFER contains the half-hourly period details of daily bids and rebids, to be used in conjunction with DAYOFFER. These views provide period varying details such as rate of change up (ROCUP), rate of change down (ROCDOWN) and band quantities (BANDAVAIL from 1 to 10). |
Private & Public Next-Day |
|
|
PEROFFER_D contains the half-hourly period details of daily bids and rebids, to be used in conjunction with DAYOFFER_D. These views provide period varying details such as rate of change up (ROCUP), rate of change down (ROCDOWN) and band quantities (BANDAVAIL from 1 to 10). |
Public |
|
|
PREDISPATCHBIDTRK contains an audit trail of bids used in each predispatch run. Where predispatch is over 2 days, two bids are listed. |
Private & Public Next-Day |
|
|
REALLOCATIONDETAILS sets out specific reallocation agreements. |
Private |
|
|
REALLOCATIONINTERVALS identifies the the reallocation agreement and provides the corresponding reallocation profiles submitted by the participant and accepted by AEMO |
Private |
|
|
REALLOCATIONS shows reallocation agreement identifiers with corresponding start and end dates of submitted reallocations as accepted by AEMO. |
Private |
|
|
REGIONFCASRELAXATION_OCD contains details of regional FCAS requirements relaxed in the over-constrained dispatch (OCD) re-run (if there was one). |
Public |
|
|
A settlement table for the publication of Snowy CSP derogation amounts. |
Public |
|
|
A settlements table for the publication of support data for the Snowy CSP derogation amounts. This table publishes the constraint-level information for each five minute interval in the settlement run |
Public |
|
|
A settlements table for the publication of support data for the Snowy CSP derogation amounts. This table publishes energy differential information for each half-hour interval in the settlement run |
Public |
|
|
A settlements table for the publication of support data for the Snowy CSP derogation amounts. This table publishes substitution price information for each five minute interval in the settlement run |
Public |
|
|
SET_MR_PAYMENT shows trading interval payments on a dispatchable unit basis for accepted MR capacity. |
Private |
|
|
SET_MR_RECOVERY shows the trading interval recovery charges on a dispatchable unit basis for spot market income from dispatch of MR capacity. |
Private |
|
|
SETAGCPAYMENT sets out specific payment details for Automatic Generation Control (AGC) services by period. |
Private |
|
|
SETAGCRECOVERY shows reimbursements for Automatic Generation Control (AGC) Ancillary Services to be recovered from participants. |
Private |
|
|
|