|
Name |
Comment |
|
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. |
|
|
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. |
|
|
MTPASA_CASESOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
|
|
MTPASA_CONSTRAINTSOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
|
|
MTPASA_INTERCONNECTORSOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
|
|
MTPASA_CASESOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
|
|
MTPASA_RESERVELIMITSOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
|
|
MTPASACONSTRAINTSOLUTION_D sets out MT PASA constraint solution results, where constraints are binding. |
|
|
MTPASAINTERCONNECTORSOLUTION_D shows interconnector results for MT PASA, shown region by region. |
|
|
MTPASAREGIONSOLUTION_D shows region results for MT PASA, showing predicted demand and any capacity limits. |
|
|
OARTRACK shows an audit trail of bids for a particular settlement day. Corrupt bids do not update OARTRACK, but are just in OFFERFILETRK. |
|
|
OFFERFILETRK shows an audit trail of all bid files submitted containing energy bids, including corrupt bids/rebids. |
|
|
OFFERGOVDATA sets out reoffers of governor (6 and 60 second FCAS) availability. |
|
|
OFFERULOADINGDATA shows reoffers of rapid unit loading capability. |
|
|
OFFERUNLOADINGDATA shows reoffers of rapid unit unloading capability. |
|
|
PASACASESOLUTION sets out ST PASA case listing providing details of each STPASA case run. |
|
|
PASACONSTRAINTSOLUTION records the latest binding STPASA constraint details for each period. For each solution, the latest recalculation for each period overwrites the previous entry. |
|
|
PASAINTERCONNECTORSOLUTION records ST PASA interconnector solutions for the latest period. |
|
|
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. |
|
|
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). |
|
|
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). |
|
|
PREDISPATCHBIDTRK contains an audit trail of bids used in each predispatch run. Where predispatch is over 2 days, two bids are listed. |
|
|
REALLOCATIONDETAILS sets out specific reallocation agreements. |
|
|
REALLOCATIONINTERVALS identifies the the reallocation agreement and provides the corresponding reallocation profiles submitted by the participant and accepted by AEMO |
|
|
REALLOCATIONS shows reallocation agreement identifiers with corresponding start and end dates of submitted reallocations as accepted by AEMO. |
|
|
REGIONFCASRELAXATION_OCD contains details of regional FCAS requirements relaxed in the over-constrained dispatch (OCD) re-run (if there was one). |
|
|
A settlement table for the publication of Snowy CSP derogation amounts. |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
SETAPCCOMPENSATION shows Administered Price Cap (APC) compensation payments for each period. |
|
|
SETAPCRECOVERY shows reimbursements for Administered Price Cap (APC) to be recovered from participants. |
|
|
SETFCASERECOVERY shows reimbursements for the Frequency Control Ancillary Services compensation. |
|
|
SETGOVPAYMENTshows specific payment details for Governor services by period. |
|
|
SETGOVRECOVERY shows reimbursements for the Governor Ancillary Services to be recovered from participants. |
|
|
SETLULOADPAYMENT shows specific payment details for rapid unit load services by period. |
|
|
SETRESERVETRADER shows reserve trader details. |
|
|
STPASA_SYSTEMSOLUTION is obsolete from 2005 End of Year Release. For solution information, see Region solution tables. |
|
|
STPASA_UNITSOLUTION shows the unit results from the capacity evaluations for each period of the study. |
|
|
|