EMMS Data Model Table Triggers
|
Table |
Trigger |
|---|---|
|
ADG_DETAIL |
TBC |
|
AGGREGATE_DISPATCH_GROUP |
TBC |
|
AGGREGATE_READS |
After each billing run |
|
ANCILLARY_RECOVERY_SPLIT |
Updated infrequently. Occurs when details change |
|
APCCOMP |
When a Administered Price Cap event occurs |
|
APCCOMPAMOUNT |
Updated with settlement posting |
|
APCCOMPAMOUNTTRK |
Updated with settlement posting |
|
APEVENT |
Administered pricing event |
|
APEVENTREGION |
Administered pricing event |
|
AREA |
Ad hoc when Areas are updated or added |
|
AUCTION |
Updated quarterly |
|
AUCTION_CALENDAR |
Updated quarterly |
|
AUCTION_IC_ALLOCATIONS |
Usually quarterly after each settlement residue auction |
|
AUCTION_REVENUE_ESTIMATE |
Updated quarterly |
|
AUCTION_REVENUE_TRACK |
Updated quarterly |
|
AUCTION_RP_ESTIMATE |
Updated quarterly |
|
AUCTION_TRANCHE |
Updated quarterly |
|
AVERAGEPRICE30 |
Every 30 minutes on price update |
|
AVERAGEPRICE30 |
Every 30 minutes on price update |
|
BANK_GUARANTEE |
On change |
|
BIDDAYOFFER |
Data is published whenever new bid data arrives |
|
BIDDAYOFFER_D |
Data is published daily |
|
BIDDUIDDETAILS |
When dispatchable unit registration details are modified |
|
BIDDUIDDETAILSTRK |
When dispatchable unit registration details are modified |
|
BIDOFFERFILETRK |
As bids are processed |
|
BIDOFFERPERIOD |
Data is published whenever new bid data arrives |
|
BIDPEROFFER |
When energy and ancillary service bids are processed |
|
BIDPEROFFER_D |
Data is published daily |
|
BIDTYPES |
When the ancillary service type static data is modified |
|
BIDTYPESTRK |
When the ancillary service type static data is modified |
|
BILLADJUSTMENTS |
Ad hoc |
|
BILLING_APC_COMPENSATION |
Generated when a billing run is posted |
|
BILLING_APC_RECOVERY |
Populated by the posting of a billing run, being several times each week |
|
BILLING_CASHSEC_INTEREST_PAY |
On change |
|
BILLING_CO2E_PUBLICATION |
Generated when a billing run is posted |
|
BILLING_CO2E_PUBLICATION_TRK |
Generated when a billing run is posted |
|
BILLING_CSP_DEROGATION_AMOUNT |
Generated when a billing run is posted |
|
BILLING_DAILY_ENERGY_SUMMARY |
Populated by the posting of a billing run, being several times each week |
|
BILLING_DIRECTION_RECON_OTHER |
Populated by the posting of a billing run, being several times each week |
|
BILLING_DIRECTION_RECONCILIATN |
Generated when a billing run is posted |
|
BILLING_EFTSHORTFALL_AMOUNT |
Authorisation of a billing shortfall run |
|
BILLING_EFTSHORTFALL_DETAIL |
Authorisation of a billing shortfall run |
|
BILLING_ENERGY_GENSET_DETAIL |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
BILLING_FCAS_REG_AMT |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
BILLING_FCAS_REG_RESIDAMT |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
BILLING_FPP |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
BILLING_GST_DETAIL |
Generated when a billing run is posted |
|
BILLING_GST_SUMMARY |
Generated when a billing run is posted |
|
BILLING_IRSR_NSP_ALLOCATION |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
BILLING_MR_PAYMENT |
Ad hoc, when there is a MR event |
|
BILLING_MR_RECOVERY |
Ad hoc, when there is a MR event |
|
BILLING_MR_SHORTFALL |
Ad hoc, when there is a MR event |
|
BILLING_MR_SUMMARY |
Ad hoc, when there is a MR event |
|
BILLING_NMAS_MANUAL_PAYMENT |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
BILLING_NMAS_MANUAL_RECOVERY |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
BILLING_NMAS_TST_PAYMENTS |
Posting of a billing run |
|
BILLING_NMAS_TST_RECOVERY |
Populated by the posting of a billing run, being several times each week |
|
BILLING_NMAS_TST_RECVRY_RBF |
Posting of a billing run |
|
BILLING_NMAS_TST_RECVRY_TRK |
Posting of a billing run |
|
BILLING_RES_TRADER_PAYMENT |
When there is a reserve trader contract payment |
|
BILLING_RES_TRADER_RECOVERY |
When there is a reserve trader contract recovery |
|
BILLING_SECDEP_INTEREST_PAY |
After posting a billing run (final and revision) |
|
BILLING_SECDEP_INTEREST_RATE |
After posting a billing run (final and revision) |
|
BILLING_SECDEPOSIT_APPLICATION |
After posting a billing run (final and revision) |
|
BILLING_SUBST_DEMAND |
Posting of a billing run |
|
BILLING_SUBST_RUN_VERSION |
Posting of a billing run |
|
BILLING_WDR |
Posting of a billing run |
|
BILLING_WDR_DETAIL |
Posting of a billing run |
|
BILLINGAPCCOMPENSATION |
Updated when a billing run is posted |
|
BILLINGAPCRECOVERY |
Updated when a billing run is posted |
|
BILLINGASPAYMENTS |
Updated when a billing run is posted |
|
BILLINGASRECOVERY |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
BILLINGCALENDAR |
When inserting billing weeks for a future AEMO Contract Year |
|
BILLINGCPDATA |
After posting of a billing run (several times each week) |
|
BILLINGCPSUM |
Weekly with the billing run |
|
BILLINGDAYTRK |
After posting of a billing run (several times each week) |
|
BILLINGFEES |
After posting of a billing run (several times each week) |
|
BILLINGFINANCIALADJUSTMENTS |
After posting of a billing run (several times each week) |
|
BILLINGGENDATA |
After posting of a billing run (several times each week) |
|
BILLINGINTERVENTION |
When reserve trading occurs in a billing run |
|
BILLINGINTERVENTIONREGION |
When there are recovery charges for region intervention |
|
BILLINGINTRARESIDUES |
Posting of a billing run |
|
BILLINGIRAUCSURPLUSSUM |
After posting of a billing run where there are unpurchased auction units |
|
BILLINGIRFM |
Updated in the billing run as required |
|
BILLINGIRNSPSURPLUS |
After posting of a billing run where derogated payments apply |
|
BILLINGIRNSPSURPLUSSUM |
After posting of a billing run where the participant has purchased auction units relating to that billing run |
|
BILLINGIRPARTSURPLUS |
Posting of a billing run |
|
BILLINGIRPARTSURPLUSSUM |
Posting of a billing run |
|
BILLINGPRIORADJUSTMENTS |
After posting of a final billing run |
|
BILLINGREALLOC |
Posting of a billing run |
|
BILLINGREALLOC_DETAIL |
Posting of a billing run |
|
BILLINGREGIONEXPORTS |
Posting of a billing run |
|
BILLINGREGIONFIGURES |
Posting of a billing run |
|
BILLINGREGIONIMPORTS |
Posting of a billing run |
|
BILLINGRESERVERECOVERY |
When reserve trading occurs in a billing run |
|
BILLINGRESERVEREGIONRECOVERY |
After posting a billing run (preliminary, final, or revised) |
|
BILLINGRESERVETRADER |
When reserve trading occurs in a billing run |
|
BILLINGRESERVETRADERREGION |
When reserve trading occurs in a billing run |
|
BILLINGRUNTRK |
Posting of a billing run |
|
BILLINGSMELTERREDUCTION |
After posting a billing run |
|
BILLINTERVENTIONRECOVERY |
When reserve trading occurs in a billing run |
|
BILLINTERVENTIONREGIONRECOVERY |
When reserve trading occurs in a billing run |
|
BILLRESERVETRADERPAYMENT |
After posting a billing run (preliminary, final, or revised) |
|
BILLRESERVETRADERPAYMENT |
After posting a billing run (final and revision) |
|
BILLRESERVETRADERRECOVERY |
Populated by the posting of a billing run, being several times each week |
|
BILLSMELTERRATE |
Infrequently, when inserting new annual rates |
|
CASETRK |
After each billing run |
|
CASH_SECURITY |
On change |
|
CONNECTIONPOINT |
When there are new connection points |
|
CONNECTIONPOINTDETAILS |
Periodically with changes to connection point details |
|
CONNECTIONPOINTOPERATINGSTA |
Periodically with changes to connection point status |
|
CONSTRAINTRELAXATION_OCD |
Ad hoc |
|
CONTRACTAGC |
When there is a contract variation |
|
CONTRACTLOADSHED |
When there is a contract variation |
|
CONTRACTREACTIVEPOWER |
When there is a contract variation |
|
CONTRACTRESERVEFLAG |
When entering a reserve contract |
|
CONTRACTRESERVETHRESHOLD |
When reserve contracts are created or updated |
|
CONTRACTRESERVETRADER |
When reserve trader activities occur |
|
CONTRACTRESTARTSERVICES |
When there is a restart contract |
|
CONTRACTRESTARTUNITS |
When there is a restart contract |
|
DATASTREAM_STATS |
After posting of a billing run |
|
DAYOFFER |
Daily |
|
DAYTRACK |
After posting of a billing run |
|
DELTAMW |
When there is an action by operational control staff |
|
DEMANDOPERATIONALACTUAL |
Ad hoc |
|
DEMANDOPERATIONALFORECAST |
Ad hoc |
|
DISPATCH_AGC_DATA |
Every 5 minutes |
|
DISPATCH_CONSTRAINT_FCAS_OCD |
TBC |
|
DISPATCH_ELEMENT_CAP |
Every 5 minutes when a new dispatch run is published |
|
DISPATCH_FCAS_REQ |
Each dispatch run (5 minutes) |
|
DISPATCH_FCAS_REQ_CONSTRAINT |
Public at the completion of a constraint FCAS processor run for a dispatch run |
|
DISPATCH_FCAS_REQ_RUN |
Public at the completion of a constraint FCAS processor run for a dispatch run |
|
DISPATCH_INTERCONNECTION |
Every 5 minutes |
|
DISPATCH_LOCAL_PRICE |
Every 5 minutes |
|
DISPATCH_MNSPBIDTRK |
Every 5 minutes |
|
DISPATCH_MR_SCHEDULE_TRK |
Ad hoc |
|
DISPATCH_PRICE_REVISION |
Every 5 minutes |
|
DISPATCH_ROOFTOP_PV_FCST_TRK |
Every 5 minutes when a new dispatch run is published |
|
DISPATCH_UNIT_CONFORMANCE |
Every 5 minutes |
|
DISPATCH_UNIT_SCADA |
Every 5 minutes |
|
DISPATCHABLEUNIT |
When new units are added or names are changed |
|
DISPATCHBIDTRK |
Each dispatch run |
|
DISPATCHBLOCKEDCONSTRAINT |
Each dispatch run (5 minutes) |
|
DISPATCHCASE_OCD |
Adhoc, potentially every 5 minutes |
|
DISPATCHCASESOLUTION |
Every 5 minutes |
|
DISPATCHCASESOLUTION_BNC |
Adhoc, potentially every 5 minutes |
|
DISPATCHCONSTRAINT |
Every 5 minutes |
|
DISPATCHINTERCONNECTORRES |
Every 5 minutes |
|
DISPATCHLOAD |
Every 5 minutes for all units, even zero targets |
|
DISPATCHOFFERTRK |
Every 5 minutes |
|
DISPATCHPRICE |
Every 5 minutes |
|
DISPATCHREGIONSUM |
Every 5 minutes |
|
DUALLOC |
When the dispatch unit identifier to genset ID cross reference is changed |
|
DUDETAIL |
When registration details change |
|
DUDETAILSUMMARY |
When registration details change |
|
EMSMASTER |
TBC |
|
FCAS_REGU_USAGE_FACTORS |
Updates whenever FCAS_REGU_USAGE_FACTORS data is updated |
|
FCAS_REGU_USAGE_FACTORS_TRK |
Updates whenever FCAS_REGU_USAGE_FACTORS data is updated |
|
FORCEMAJEURE |
When force majeure event is recorded |
|
FORCEMAJEUREREGION |
When force majeure event is recorded |
|
FPP_CONSTRAINT_FREQ_MEASURE |
At the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes): At the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes) |
|
FPP_CONTRIBUTION_FACTOR |
The private report will be delivered at the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes) The public report is delivered the next market day (at 4 am) |
|
FPP_EST_COST |
At the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes) |
|
FPP_EST_PERF_COST_RATE |
At the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes) |
|
FPP_EST_RESIDUAL_COST_RATE |
At the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes) |
|
FPP_FCAS_SUMMARY |
At the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes) |
|
FPP_FORECAST_DEFAULT_CF |
Approval of an FPP historical default contribution factor calculation run (i.e. every week) |
|
FPP_FORECAST_RESIDUAL_DCF |
Approval of an FPP historical default contribution factor calculation run (i.e. every week) |
|
FPP_HIST_PERFORMANCE |
Approval of an FPP historical performance calculation run (i.e. every week) |
|
FPP_HIST_REGION_PERFORMANCE |
Approval of an FPP historical performance calculation run (i.e. every week) |
|
FPP_P5_FWD_EST_COST |
At the completion of a P5MIN estimation calculation run (i.e. every 5 mins) |
|
FPP_P5_FWD_EST_RESIDUALRATE |
At the completion of a P5MIN estimation calculation run (i.e. every 5 mins) |
|
FPP_PD_FWD_EST_COST |
At the completion of a PREDISPATCH estimation calculation run (i.e. every 30 minutes) |
|
FPP_PD_FWD_EST_RESIDUALRATE |
At the completion of a PREDISPATCH estimation calculation run (i.e. every 30 minutes) |
|
FPP_PERFORMANCE |
The private report delivers at the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes) The public report delivers the next market day (at a time after 4 am market time) |
|
FPP_RCR |
At the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes) |
|
FPP_REGION_FREQ_MEASURE |
At the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes) |
|
FPP_RESIDUAL_CF |
The public report will be delivered at the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes) |
|
FPP_RESIDUAL_PERFORMANCE |
The public report delivers at the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes) |
|
FPP_RUN |
At the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes) |
|
FPP_UNIT_MW |
The private report delivers at the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes) The public report delivers the next market day (at 4 am) |
|
FPP_USAGE |
At the completion of an FPP calculation run for a closed trading interval (i.e. every 5 minutes) |
|
GDINSTRUCT |
On instruction issued by AEMO |
|
GENCONDATA |
Dispatch run |
|
GENCONSET |
When updated by AEMO |
|
GENCONSETINVOKE |
When a generic constraint is invoked or the revoke time is altered |
|
GENCONSETTRK |
Ad hoc |
|
GENERICCONSTRAINTRHS |
When a new generic constraint RHS or expression is created or modified |
|
GENERICEQUATIONDESC |
When new a generic equation is created |
|
GENERICEQUATIONRHS |
When a generic equation is created or modified |
|
GENMETER |
When meter details change |
|
GENUNITMTRINPERIOD |
When new meter reading files are submitted by MDAs |
|
GENUNITS |
When plant details change |
|
GENUNITS_UNIT |
When plant details change |
|
GST_BAS_CLASS |
TBC |
|
GST_RATE |
TBC |
|
GST_TRANSACTION_CLASS |
When new transactions are introduced to the NEM |
|
GST_TRANSACTION_TYPE |
When new transactions are introduced to the NEM |
|
INSTRUCTIONSUBTYPE |
Ad hoc |
|
INSTRUCTIONTYPE |
Ad hoc |
|
INTCONTRACTAMOUNT |
When there is contract creation or changes |
|
INTCONTRACTAMOUNTTRK |
When there is contract creation or changes |
|
INTERCONNECTOR |
Usually annually |
|
INTERCONNECTORALLOC |
Usually annually |
|
INTERCONNECTORCONSTRAINT |
Usually annually |
|
INTERCONNMWFLOW |
Weekly |
|
INTERMITTENT_CLUSTER_AVAIL |
On participant data submission |
|
INTERMITTENT_CLUSTER_AVAIL_DAY |
On participant data submission |
|
INTERMITTENT_DS_FCST_CASE |
Publication of Dispatch solution. Data includes all valid forecasts for that interval |
|
INTERMITTENT_DS_PRED |
Publication of Dispatch solution. Data includes all valid forecasts for that interval |
|
INTERMITTENT_DS_RUN |
Publication of Dispatch solution. Data includes all valid forecasts for that interval |
|
INTERMITTENT_FORECAST_TRK |
Dispatch run |
|
INTERMITTENT_GEN_FCST |
Every 30 minutes when AEMO issues a new 30-minute forecast of intermittent generation out to 8 days ahead |
|
INTERMITTENT_GEN_FCST_DATA |
Every 30 minutes when AEMO issues a new 30-minute forecast of wind generation out to 8 days ahead |
|
INTERMITTENT_GEN_FCST_P5_PRED |
Every 5 minutes when a new intermittent generator forecast is available, covering the 2 hours ahead horizon with 5-minute resolution |
|
INTERMITTENT_GEN_FCST_P5_RUN |
Every 5 minutes when a new intermittent generator forecast is available, covering the 2 hours ahead horizon with 5-minute resolution |
|
INTERMITTENT_GEN_FCST_PRED |
Every 30 minutes when a new intermittent generator forecast is available, covering the 8 days ahead horizon with 30-minute resolution |
|
INTERMITTENT_GEN_FCST_RUN |
Every 30 minutes when a new intermittent generator forecast is available, covering the 8 days ahead horizon with 30-minute resolution |
|
INTERMITTENT_GEN_LIMIT |
On participant data submission |
|
INTERMITTENT_GEN_LIMIT_DAY |
On participant data submission |
|
INTERMITTENT_GEN_SCADA |
Shows data for every 5 minutes for all Intermittent Generating Units |
|
INTERMITTENT_P5_FCST_CASE |
Publication of 5-Minute Pre-dispatch solution. Data includes all valid forecasts for that interval |
|
INTERMITTENT_P5_PRED |
Publication of 5-Minute Pre-dispatch solution. Data includes all valid forecasts for that interval |
|
INTERMITTENT_P5_RUN |
Publication of 5-Minute Predispatch solution. Data includes all valid forecasts for that 5-Minute Predispatch ru |
|
INTRAREGIONALLOC |
Infrequently |
|
IRFMEVENTS |
When there is a Industrial Relations Forced Majeure event |
|
LOCALAREA_REGO |
After each billing run |
|
LOSSFACTORMODEL |
Annually, when there is a change in the interconnector |
|
LOSSMODEL |
Annually, when there is a change in the interconnector |
|
MARKET_FEE_CAT_EXCL |
When there is a market fee exclusion |
|
MARKET_FEE_CAT_EXCL_TRK |
When there is a market fee exclusion |
|
MARKET_FEE_EXCLUSION |
When there is a participant configuration change |
|
MARKET_FEE_EXCLUSIONTRK |
When there is a participant configuration change |
|
MARKET_PRICE_THRESHOLDS |
When there is a market price threshold change |
|
MARKET_SUSPEND_REGIME_SUM |
Market suspension |
|
MARKET_SUSPEND_REGION_SUM |
Creation of market suspension |
|
MARKET_SUSPEND_SCHEDULE |
Weekly and ad hoc |
|
MARKET_SUSPEND_SCHEDULE_TRK |
Market suspension |
|
MARKETFEE |
When fees change |
|
MARKETFEEDATA |
When fees change |
|
MARKETFEETRK |
When new annual rates are added. |
|
MARKETNOTICEDATA |
When a Market Notice is issued. |
|
MARKETNOTICETYPE |
When market notice types change |
|
MARKETSUSPENSION |
When the market is suspended |
|
MARKETSUSREGION |
When the market is suspended |
|
MAS_CP_CHANGE |
Daily |
|
MAS_CP_MASTER |
Daily |
|
MCC_CASESOLUTION |
Each dispatch run |
|
MCC_CONSTRAINTSOLUTION |
Each MCC dispatch rerun |
|
METERDATA |
When meter files are processed from MSATS |
|
METERDATA_AGGREGATE_READS |
TBC |
|
METERDATA_GEN_DUID |
When there is generation of non-scheduled units |
|
METERDATA_INDIVIDUAL_READS |
TBC |
|
METERDATA_INTERCONNECTOR |
TBC |
|
METERDATA_SAPS |
TBC |
|
METERDATA_TRK |
Posting of a billing run |
|
METERDATA_WDR_READS |
Posting of a billing run |
|
METERDATATRK |
Updates whenever meter files are processed |
|
MMS_DATA_MODEL_AUDIT |
When scripts are used to install or update the MMS Data Model |
|
MNSP_BIDOFFERPERIOD |
Generated as submissions are processed in next-day reports |
|
MNSP_DAYOFFER |
Generated as submissions are processed in next-day reports |
|
MNSP_FILETRK |
A submitted MNSP bid |
|
MNSP_INTERCONNECTOR |
Infrequently, typically annually |
|
MNSP_OFFERTRK |
As bids are processed |
|
MNSP_PARTICIPANT |
Infrequently, typically annually |
|
MNSP_PEROFFER |
As bids are processed |
|
MR_DAYOFFER_STACK |
Ad hoc |
|
MR_EVENT |
Ad hoc |
|
MR_EVENT_SCHEDULE |
Ad hoc |
|
MR_PEROFFER_STACK |
Ad hoc |
|
MTPASA_CASE_SET |
Every MTPASA run (weekly) |
|
MTPASA_CASERESULT |
On MTPASA solution published to the market (usually weekly) |
|
MTPASA_CASESOLUTION |
On MTPASA solution published to the market (usually once per week) |
|
MTPASA_CONSTRAINTRESULT |
On MTPASA solution published to the market (usually weekly) |
|
MTPASA_CONSTRAINTSUMMARY |
On MTPASA solution published to the market (usually weekly) |
|
MTPASA_DUIDAVAILABILITY |
On MTPASA solution published to the market (usually weekly) |
|
MTPASA_INTERCONNECTORRESULT |
On MTPASA solution published to the market (usually weekly) |
|
MTPASA_INTERCONNECTORSOLUTION |
On MTPASA solution published to the market (usually once per week) |
|
MTPASA_INTERMITTENT_AVAIL |
On participant data submission |
|
MTPASA_INTERMITTENT_LIMIT |
On participant data submission |
|
MTPASA_LOLPRESULT |
On MTPASA solution published to the market (usually weekly) |
|
MTPASA_OFFERDATA |
When a participant MTPASA bid is processed |
|
MTPASA_OFFERFILETRK |
When a participant MTPASA bid is processed |
|
MTPASA_REGIONAVAIL_TRK |
After each MT PASA run (every 3 hours during market business hours) |
|
MTPASA_REGIONAVAILABILITY |
After each MT PASA run (every 3 hours during market business hours) |
|
MTPASA_REGIONITERATION |
On MTPASA solution published to the market (usually once per week) |
|
MTPASA_REGIONRESULT |
On MTPASA solution published to the market (usually once per week) |
|
MTPASA_REGIONSOLUTION |
On MTPASA solution published to the market (usually once per week) |
|
MTPASA_REGIONSUMMARY |
On MTPASA solution published to the market (usually once per week) |
|
MTPASA_RESERVELIMIT |
Ad hoc, when a new Reserve Requirement is published |
|
MTPASA_RESERVELIMIT_REGION |
Ad hoc, when a new Reserve Requirement is published |
|
MTPASA_RESERVELIMIT_SET |
Ad hoc, when a new Reserve Requirement is published |
|
MTPASA_RESERVELIMITSOLUTION |
On MTPASA solution published to the market (usually once per week) |
|
MTPASACONSTRAINTSOLUTION_D |
On MTPASA solution published to the market (usually once per week) |
|
MTPASAINTERCONNECTORSOLUTION_D |
On MTPASA solution published to the market (usually once per week) |
|
MTPASAREGIONSOLUTION_D |
On MTPASA solution published to the market (usually once per week) |
|
NEGATIVE_RESIDUE |
TBC |
|
NETWORK_EQUIPMENTDETAIL |
When equipment details are added or changed |
|
NETWORK_OUTAGECONSTRAINTSET |
TBC |
|
NETWORK_OUTAGEDETAIL |
TBC |
|
NETWORK_OUTAGESTATUSCODE |
TBC |
|
NETWORK_RATING |
TBC |
|
NETWORK_REALTIMERATING |
TBC |
|
NETWORK_STATICRATING |
TBC |
|
NETWORK_SUBSTATIONDETAIL |
When subtation details are created or added |
|
NMI_STATS |
After each billing run |
|
OFFERAGCDATA |
On participant Automatic Generation Control (AGC) reoffers submission |
|
OFFERASTRK |
When ancillary service reoffers are successfully acknowledged |
|
OFFERFILETRK |
As bids are processed |
|
OFFERGOVDATA |
Updated as reoffers are processed |
|
OFFERLSHEDDATA |
On participant reoffers submission |
|
OFFERRESTARTDATA |
On system restart availability reoffers |
|
OFFERRPOWERDATA |
On reactive power capability and settlement measurements reoffers submission |
|
OFFERULOADINGDATA |
Updated as reoffers are processed |
|
OFFERUNLOADINGDATA |
Updated as reoffers are processed |
|
OVERRIDERRP |
Every five minutes when override prices apply for the period. |
|
P5MIN_BLOCKEDCONSTRAINT |
Every 5 minutes |
|
P5MIN_CASESOLUTION |
Every 5 minutes |
|
P5MIN_CONSTRAINTSOLUTION |
Every 5 minutes |
|
P5MIN_FCAS_REQ_CONSTRAINT |
Public at the completion of a constraint FCAS processor run for a 5 minute predispatch run |
|
P5MIN_FCAS_REQ_RUN |
Public at the completion of a constraint FCAS processor run for a 5 minute predispatch run |
|
P5MIN_FCAS_REQUIREMENT |
Every 5 minutes |
|
P5MIN_INTERCONNECTORSOLN |
Every 5 minutes |
|
P5MIN_INTERMITTENT_FCST_TRK |
Every 5 minutes when a new 5-Minute Pre-dispatch run is published |
|
P5MIN_INTERSENSITIVITIES |
Every 5 minutes |
|
P5MIN_LOCAL_PRICE |
Every 5 minutes |
|
P5MIN_PRICESENSITIVITIES |
Every 5 minutes |
|
P5MIN_REGIONSOLUTION |
Every 5 minutes |
|
P5MIN_ROOFTOP_PV_FCST_TRK |
Every 5 minutes when a new 5-Minute Pre-dispatch run is published |
|
P5MIN_SCENARIODEMAND |
On update of P5MIN scenarios |
|
P5MIN_SCENARIODEMANDTRK |
On update of P5MIN scenarios |
|
P5MIN_UNITSOLUTION |
Every 5 minutes for all units, even zero targets |
|
PARTICIPANT |
When new participants register or existing participants details are changed |
|
PARTICIPANT_BANDFEE_ALLOC |
When there is a participant configuration change |
|
PARTICIPANTACCOUNT |
When new participants register or existing participants details are changed |
|
PARTICIPANTCATEGORY |
When categories change |
|
PARTICIPANTCATEGORYALLOC |
Updates for new participants or when categories change |
|
PARTICIPANTCLASS |
When classifications change |
|
PARTICIPANTCREDITDETAIL |
When participant credit details are created or updated |
|
PARTICIPANTNOTICETRK |
When a participant notice is issued |
|
PASA_CONTINGENCY_DEFINITION |
On Change |
|
PASA_DUID_SUBSTATION_MAPPING |
On Change |
|
PASA_INTERCONNECTOR_BOUNDARY |
On Change |
|
PASA_INTERCONNECTOR_MAPPING |
On Change |
|
PASA_INTERZONAL_BOUNDARY |
On Change |
|
PASA_INTERZONAL_MAPPING |
On Change |
|
PASA_SUBSTATION_ZONE_MAPPING |
On Change |
|
PASA_ZONE_REGION_MAPPING |
On Change |
|
PD_ELEMENT_CAP |
Every 30 minutes when a new Pre-dispatch run is published |
|
PD_FCAS_REQ_CONSTRAINT |
Public at the completion of a constraint FCAS processor run for a 30 minute predispatch run |
|
PD_FCAS_REQ_RUN |
Public at the completion of a constraint FCAS processor run for a 30 minute predispatch run |
|
PD_INTERMITTENT_FCST_TRK |
Every 30 minutes when a new Pre-dispatch run is published |
|
PD_ROOFTOP_PV_FCST_TRK |
Every 30 minutes when a new Pre-dispatch run is published |
|
PD7DAY_CASESOLUTION |
Publishes few times per day |
|
PD7DAY_CONSTRAINTSOLUTION |
Publishes few times per day |
|
PD7DAY_INTERCONNECTORSOLUTION |
Publishes few times per day |
|
PD7DAY_MARKET_SUMMARY |
Publishes few times per day |
|
PD7DAY_PRICESOLUTION |
Publishes few times per day |
|
PDPASA_CASESOLUTION |
After each PDASA run (half-hourly) |
|
PDPASA_FNM_CASESOLUTION |
Every 30 minutes |
|
PDPASA_CONSTRAINTSOLUTION |
After each PDASA run (half-hourly) |
|
PDPASA_FNM_CONSTRAINTSOLUTION |
Every 30 minutes |
|
PDPASA_DUIDAVAILABILITY |
The start of PDPASA run or near to |
|
PDPASA_FNM_DUIDAVAILABILITY |
Every 30 minutes |
|
PDPASA_INTERCONNECTORSOLN |
After each PDASA run (half-hourly) |
|
PDPASA_FNM_INTERCONNECTORSOLN |
Every 30 minutes |
|
PDPASA_FNM_INTERZONALSOLUTION |
Every 30 minutes |
|
PDPASA_REGIONSOLUTION |
After each PDASA run (half-hourly) |
|
PDPASA_FNM_REGIONSOLUTION |
Every 30 minutes |
|
PDPASA_FNM_REGIONSUMMARY |
Every 30 minutes |
|
PDPASA_FNM_ZONESOLUTION |
Every 30 minutes |
|
PDPASA_FNM_ZONESUMMARY |
Every 30 minutes |
|
PERDEMAND |
When AEMO issues a new or revised forecast. ST PASA forecasts update seven days at a time. Predispatch updates one date. |
|
PMS_GROUP |
When the record is created or updated |
|
PMS_GROUPNMI |
When the NMIs are created or updated |
|
PMS_GROUPSERVICE |
When the group service data is created or updated |
|
PREDISPATCH_FCAS_REQ |
Every thirty-minute pre-dispatch run |
|
PREDISPATCH_LOCAL_PRICE |
Every 30 minutes |
|
PREDISPATCH_MNSPBIDTRK |
After a pre-dispatch run |
|
PREDISPATCHBIDTRK |
Updated daily |
|
PREDISPATCHBLOCKEDCONSTRAINT |
Every 30 minutes |
|
PREDISPATCHCASESOLUTION |
Every 30 minutes |
|
PREDISPATCHCONSTRAINT |
Every 30 minutes |
|
PREDISPATCHINTERCONNECTORRES |
Every thirty-minute pre-dispatch run |
|
PREDISPATCHINTERSENSITIVITIES |
Every 5 minutes |
|
PREDISPATCHLOAD |
Every 30 minutes, with whole market data for the day before available as part of next day market data |
|
PREDISPATCHOFFERTRK |
Every 30 minutes |
|
PREDISPATCHPRICE |
Every thirty-minute pre-dispatch run |
|
PREDISPATCHPRICESENSITIVITIES |
Every 30 minutes |
|
PREDISPATCHREGIONSUM |
Every 30 minutes |
|
PREDISPATCHSCENARIODEMAND |
When the predispatch scenario offset is updated |
|
PREDISPATCHSCENARIODEMANDTRK |
When the predispatch scenario offset is updated |
|
PRUDENTIALCOMPANYPOSITION |
Each prudential run |
|
PRUDENTIALRUNTRK |
Each prudential run |
|
REALLOCATION |
When two participants have settled through the AEMO pool settlements process |
|
REALLOCATIONINTERVAL |
30-minute or (5-minute for 5MS) data |
|
REALLOCATIONINTERVALS |
When a reallocation contract has been submitted and accepted by AEMO |
|
REGION |
When there is change to a region |
|
REGION_AREA |
Ad hoc when Area-Region mappings are updated or added |
|
REGIONAPC |
When an Administered Price Cap occurs |
|
REGIONAPCINTERVALS |
When an Administered Price Cap occurs |
|
REGIONFCASRELAXATION_OCD |
Ad hoc, when there are occurrences of Over-constrained dispatch (OCD) re-runs |
|
REGIONSTANDINGDATA |
When there is change to a region |
|
RESDEMANDTRK |
Ad hoc |
|
RESERVE |
Daily when AEMO updates forecasts |
|
RESIDUE_BID_TRK |
Updated quarterly before an auction |
|
RESIDUE_CON_DATA |
On auction completion |
|
RESIDUE_CON_ESTIMATES_TRK |
Updated quarterly |
|
RESIDUE_CON_FUNDS |
Updated quarterly |
|
RESIDUE_CONTRACTS |
Updated quarterly |
|
RESIDUE_FUNDS_BID |
TBC |
|
RESIDUE_PRICE_BID |
Upon participants making a bid |
|
RESIDUE_PRICE_FUNDS_BID |
Updated after an auction |
|
RESIDUE_PUBLIC_DATA |
Updated quarterly |
|
RESIDUE_TRK |
Updated after an auction |
|
RESIDUECONTRACTPAYMENTS |
Ad hoc |
|
RESIDUEFILETRK |
Ad hoc |
|
ROOFTOP_PV_ACTUAL |
Event timing – every 30 minutes |
|
ROOFTOP_PV_ACTUAL_PRED |
Every 5 or 30 minutes when a new rooftop PV estimated actual is available, covering the most recent 5 or 30-minute interval that is available |
|
ROOFTOP_PV_ACTUAL_RUN |
Every 5 or 30 minutes when a new rooftop PV estimated actual is available, covering the most recent 5 or 30-minute interval that is available |
|
ROOFTOP_PV_FCST_P5_PRED |
Every 5 minutes when a new rooftop PV forecast is available, covering the 2 hours ahead horizon with 5-minute resolution |
|
ROOFTOP_PV_FCST_P5_RUN |
Every 5 minutes when a new rooftop PV forecast is available, covering the 2 hours ahead horizon with 5-minute resolution |
|
ROOFTOP_PV_FCST_PRED |
Every 30 minutes when a new rooftop PV forecast is available, covering the 8 days ahead horizon with 30-minute resolution |
|
ROOFTOP_PV_FCST_RUN |
Every 30 minutes when a new rooftop PV forecast is available, covering the 8 days ahead horizon with 30-minute resolution |
|
ROOFTOP_PV_FORECAST |
Every 30 minutes over 8 days |
|
SECDEPOSIT_INTEREST_RATE |
Upon entering and authorising the security deposit provision and interest rate |
|
SECDEPOSIT_PROVISION |
Upon entering and authorising the security deposit provision and interest rate |
|
SET_ANCILLARY_SUMMARY |
After posting of a billing run |
|
SET_APC_COMPENSATION |
After posting of a billing run |
|
SET_APC_RECOVERY |
After posting of a billing run |
|
SET_CSP_DEROGATION_AMOUNT |
At the posting of a billing run |
|
SET_CSP_SUPPORTDATA_CONSTRAINT |
At the posting of a billing run |
|
SET_CSP_SUPPORTDATA_SUBPRICE |
At the posting of a billing run |
|
SET_ENERGY_GENSET_DETAIL |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_ENERGY_REGION_SUMMARY |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_ENERGY_TRAN_SAPS |
After posting of a billing run |
|
SET_ENERGY_TRANSACTIONS |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_FCAS_CLAWBACK_REQ |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_FCAS_CLAWBACK_RUN_TRK |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_FCAS_CLAWBACK_UNITSOLN |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_FCAS_PAYMENT |
After posting of a billing run |
|
SET_FCAS_RECOVERY |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_FCAS_REG_AMOUNT |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_FCAS_REG_DEF_AMT |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_FCAS_REG_DEF_RESIDAMT |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_FCAS_REG_RESIDAMT |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_FCAS_REGULATION_TRK |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_FPP |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_IRSR_DIRECTIONAL_LINK |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_IRSR_LOOP_NETTRADE_AMOUNT |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_IRSR_LOOP_NSP_ALLOCATION |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_IRSR_LOOP_REGION_SUMMARY |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_MR_PAYMENT |
Ad hoc, when there are MR events |
|
SET_MR_RECOVERY |
Ad hoc, when there are MR events |
|
SET_NMAS_MANUAL_PAYMENT |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_NMAS_RECOVERY |
Settlement Run |
|
SET_NMAS_RECOVERY_RBF |
Settlement Run |
|
SET_RECOVERY_ENERGY |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SET_RUN_PARAMETER |
Posting a billing run |
|
SET_SUBST_RUN_VERSION |
Posting a billing run |
|
SET_SUBSTITUTE_DEMAND |
Posting a billing run |
|
SET_WDR_RECON_DETAIL |
Posting a billing run |
|
SET_WDR_TRANSACT |
Posting a billing run |
|
SETAGCPAYMENT |
Each settlement run |
|
SETAGCRECOVERY |
Each settlement run |
|
SETAPCCOMPENSATION |
Each settlement run |
|
SETAPCRECOVERY |
Each settlement run |
|
SETCFG_PARTICIPANT_MPF |
When Market Participation Factors (MPF) data is updated |
|
SETCFG_PARTICIPANT_MPFTRK |
When Market Participation Factors (MPF) data is updated |
|
SETCFG_SAPS_SETT_PRICE |
When records for Settlement Price for SAPS Energy in each region are added or modified |
|
SETCFG_WDR_REIMBURSE_RATE |
Generated quarterly |
|
SETCFG_WDRRR_CALENDAR |
When records are added or modified |
|
SETCPDATA |
After each settlement run |
|
SETCPDATAREGION |
After each settlement run |
|
SETFCASCOMP |
Each settlement run |
|
SETFCASRECOVERY |
Each settlement run |
|
SETFCASREGIONRECOVERY |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SETGENDATA |
After each settlement run |
|
SETGENDATAREGION |
After each settlement run |
|
SETGOVPAYMENT |
Each settlement run |
|
SETGOVRECOVERY |
Each settlement run |
|
SETINTERVENTION |
Not used |
|
SETINTERVENTIONRECOVERY |
Not used |
|
SETINTRAREGIONRESIDUES |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SETIRAUCSURPLUS |
After each settlement run |
|
SETIRFMRECOVERY |
Each settlement run |
|
SETIRNSPSURPLUS |
After each settlement run |
|
SETIRPARTSURPLUS |
After each settlement run |
|
SETIRSURPLUS |
Daily at 8 am |
|
SETLOCALAREAENERGY |
After each settlement run |
|
SETLOCALAREATNI |
After each settlement run |
|
SETLSHEDPAYMENT |
After each settlement run |
|
SETLSHEDRECOVERY |
After each settlement run |
|
SETLULOADPAYMENT |
Each settlement run |
|
SETLULOADRECOVERY |
Each settlement run |
|
SETLUNLOADPAYMENT |
Each settlement run |
|
SETLUNLOADRECOVERY |
Each settlement run |
|
SETMARKETFEES |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
SETREALLOCATIONS |
Updates by the posting of a billing run |
|
SETRESERVERECOVERY |
When reserve recovery occurred in a billing run |
|
SETRESERVETRADER |
When a reserve trading occurs in a billing run |
|
SETRESTARTPAYMENT |
After each settlement run |
|
SETRESTARTRECOVERY |
After each settlement run |
|
SETRPOWERPAYMENT |
After each settlement run |
|
SETRPOWERRECOVERY |
After each settlement run |
|
SETSMALLGENDATA |
When there is a change to the metering data and associated settlement values to a participant's registered Small Generator Aggregator |
|
SETVICBOUNDARYENERGY |
The posting of a billing run |
|
SETVICENERGYFIGURES |
Daily with settlements |
|
SETVICENERGYFLOW |
Daily with settlements |
|
SPDCONNECTIONPOINTCONSTRAINT |
When a new connection point constraint is created |
|
SPDINTERCONNECTORCONSTRAINT |
When a new connection point constraint is created |
|
SPDREGIONCONSTRAINT |
When AEMO creates new regional constraints |
|
SRA_CASH_SECURITY |
On record authorisation |
|
SRA_FINANCIAL_AUC_MARDETAIL |
On successful posting of an SRA financials run |
|
SRA_FINANCIAL_AUC_MARGIN |
On successful posting of an SRA financials run |
|
SRA_FINANCIAL_AUC_RECEIPTS |
On successful posting of an SRA financials run |
|
SRA_FINANCIAL_AUCPAY_DETAIL |
On successful posting of an SRA financials run |
|
SRA_FINANCIAL_AUCPAY_SUM |
On successful posting of an SRA financials run |
|
SRA_FINANCIAL_RUNTRK |
On successful posting of an SRA financials run |
|
SRA_OFFER_PRODUCT |
On successful submission of an SRA offer file |
|
SRA_OFFER_PROFILE |
On successful submission of an SRA offer file |
|
SRA_PRUDENTIAL_CASH_SECURITY |
On authorisation of a cash security |
|
SRA_PRUDENTIAL_COMP_POSITION |
On successful completion of a prudential run |
|
SRA_PRUDENTIAL_EXPOSURE |
After each settlement run |
|
SRA_PRUDENTIAL_RUN |
After each settlement run |
|
SSM_CONTRACT_UNIT_AVAIL |
On change of the Contract Availability |
|
SSM_ENABLEMENT_COSTS |
Timed trigger once per day for previous day |
|
SSM_ENABLEMENT_PERIOD |
Timed trigger once per day for previous day |
|
SSM_INDICATIVE_ROLLING_DUID |
SSM Post Processing completion |
|
SSM_INDIC_ROLLING_RGN |
SSM Post Processing completion |
|
SSM_INSTRUCTION |
On enablement of a contract to provide System Security Services |
|
SSM_SCHEDULE |
Timed trigger once per day for previous day |
|
SSM_SCHEDULED_AVAILABILITY |
Timed trigger once per week for the previous week |
|
STADUALLOC |
When there is a station configuration change or new unit registration |
|
STATION |
When there is a station configuration change or new unit registration |
|
STATIONOPERATINGSTATUS |
When there is a station owner change or new unit registration |
|
STATIONOWNER |
When there is a station owner change or new unit registration |
|
STATIONOWNERTRK |
When there is a station owner change or new unit registration |
|
STPASA_CASESOLUTION |
After each STPASA run (every 2 hours) |
|
STPASA_FNM_CASESOLUTION |
Every 60 minutes |
|
STPASA_CONSTRAINTSOLUTION |
After each STPASA run (every 2 hours) |
|
STPASA_FNM_CONSTRAINTSOLUTION |
Every 60 minutes |
|
STPASA_DUIDAVAILABILITY |
Start of each STPASA run (every hour) |
|
STPASA_FNM_DUID_AVAILABILITY |
Every 60 minutes |
|
STPASA_INTERCONNECTORSOLN |
After each STPASA run (every 2 hours) |
|
STPASA_FNM_INTERCONNECTORSOLN |
Every 60 minutes |
|
STPASA_FNM_INTERZONALSOLUTION |
Every 60 minutes |
|
STPASA_REGIONSOLUTION |
After each STPASA run (every 2 hours) |
|
STPASA_FNM_REGIONSOLUTION |
Every 60 minutes |
|
STPASA_FNM_REGIONSUMMARY |
Every 60 minutes |
|
STPASA_FNM_ZONESOLUTION |
Every 60 minutes |
|
STPASA_FNM_ZONESUMMARY |
Every 60 minutes |
|
STPASA_SYSTEMSOLUTION |
Each ST PASA run |
|
STPASA_UNITSOLUTION |
Each ST PASA run |
|
TRADINGINTERCONNECT |
Every 30 minutes on price update |
|
TRADINGLOAD |
Every 30 minutes |
|
TRADINGPRICE |
Every 30 minutes on price update |
|
TRADINGREGIONSUM |
Every 30 minutes |
|
TRANSMISSIONLOSSFACTOR |
When new connection points are created or loss factors change |
|
UFE |
After each billing run |
|
VALUATIONID |
Updated quarterly |
|
VOLTAGE_INSTRUCTION |
Signal or instructions issued |
|
VOLTAGE_INSTRUCTION_TRK |
Signal or instructions issued |
|
WDR_BASELINE_ADJ_WINDOW |
Posting of a billing run |
|
WDR_BASELINE_ADJ_WINDOW_DATA |
Posting of a billing run |
|
WDR_BASELINE_ADJ_WINDOW_SELECDAYS_DATA |
Posting of a billing run |
|
WDR_BASELINE_CALC_PARAM |
Posting of a billing run |
|
WDR_BASELINE_EVENT_DATA |
Posting of a billing run |
|
WDR_BASELINE_EVENT_RESULTS |
Posting of a billing run |
|
WDR_BASELINE_EVENT_SELECTDAY_DATA |
Posting of a billing run |