|
Name |
|
|
Comment |
Shows Actual Operational Demand for a particular date time interval. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERVAL_DATETIME |
|
REGIONID |
|
Name |
|
INTERVAL_DATETIME |
|
REGIONID |
|
Name |
Data Type |
Mandatory |
Comment |
|
INTERVAL_DATETIME |
date |
X |
Date time interval for operational demand value |
|
REGIONID |
Varchar2(20) |
X |
Region identifier |
|
OPERATIONAL_DEMAND |
number(10,0) |
|
Average 30-minute measured operational demand MW value (unadjusted) |
|
LASTCHANGED |
date |
|
Last date and time record changed |
|
OPERATIONAL_DEMAND_ADJUSTMENT |
NUMBER(10,0) |
|
Adjustment value containing the estimated amount of activated RERT and involuntary load shedding that occurred as a result of a NER 4.8.9 instruction for load shedding from AEMO. |
|
WDR_ESTIMATE |
NUMBER(10) |
|
Estimated average 30-minute MW amount of Wholesale Demand Response that occurred |
|
Name |
|
|
Comment |
Shows Forecast Operational Demand for a particular date time interval. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERVAL_DATETIME |
|
REGIONID |
|
Name |
|
INTERVAL_DATETIME |
|
REGIONID |
|
Name |
Data Type |
Mandatory |
Comment |
|
INTERVAL_DATETIME |
date |
X |
Forecast for a particular date time interval |
|
REGIONID |
Varchar2(20) |
X |
Region identifier |
|
LOAD_DATE |
date |
|
Date time this forecast was produced |
|
OPERATIONAL_DEMAND_POE10 |
number(15,2) |
|
10% probability of exceedance operational demand forecast value |
|
OPERATIONAL_DEMAND_POE50 |
number(15,2) |
|
50% probability of exceedance operational demand forecast value |
|
OPERATIONAL_DEMAND_POE90 |
number(15,2) |
|
90% probability of exceedance operational demand forecast value |
|
LASTCHANGED |
date |
|
Last date and time record changed |
|
Name |
|
|
Comment |
A submission of expected plant availability for an intermittent generating unit cluster, by Trading Day and Trading Interval. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
CLUSTERID |
|
DUID |
|
OFFERDATETIME |
|
PERIODID |
|
TRADINGDATE |
|
Name |
Data Type |
Mandatory |
Comment |
|
TRADINGDATE |
DATE |
X |
The trading day to which the availability submission applies |
|
DUID |
VARCHAR2(20) |
X |
Unique Identifier of Dispatchable Unit |
|
OFFERDATETIME |
DATE |
X |
Date and Time when this cluster availability submission was loaded |
|
CLUSTERID |
VARCHAR2(20) |
X |
Unique Cluster Identifier for this cluster within the DUID |
|
PERIODID |
NUMBER(3,0) |
X |
Trading interval number (1…48) within this TRADINGDATE for which ELEMENTS_UNAVAILABLE applies |
|
ELEMENTS_UNAVAILABLE |
NUMBER(5,0) |
|
Number of elements within this CLUSTERID (turbines for wind, or inverters for solar) that are not available for this TRADINGDATE and PERIODID (scheduled maintenance in AWEFS/ASEFS). Value between 0 and the registered Number of Cluster Elements.Value = 0 means no elements unavailable |
|
ELEMENTS_AVAILABLE |
NUMBER(5,0) |
|
Number of elements within this CLUSTERID (turbines for wind, or inverters for solar) that are available for this TRADINGDATE and PERIODID (scheduled maintenance in AWEFS/ASEFS). Value between 0 and the registered Number of Cluster Elements. Value = 0 means no elements available |
|
Name |
|
|
Comment |
Summary record for an availability submission for an intermittent generating unit cluster for a Trading Day. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
CLUSTERID |
|
DUID |
|
OFFERDATETIME |
|
TRADINGDATE |
|
Name |
Data Type |
Mandatory |
Comment |
|
TRADINGDATE |
DATE |
X |
Trading Day for which this cluster availability submission applies |
|
DUID |
VARCHAR2(20) |
X |
Unique Identifier of Dispatchable Unit |
|
OFFERDATETIME |
DATE |
X |
Date and Time when this cluster availability submission was loaded |
|
CLUSTERID |
VARCHAR2(20) |
X |
Unique Cluster Identifier for this cluster within the DUID |
|
Name |
|
|
Comment |
Unconstrained Intermittent Generation Forecasts (UIGF) for Dispatch |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
FORECAST_PRIORITY |
|
INTERVAL_DATETIME |
|
OFFERDATETIME |
|
ORIGIN |
|
RUN_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Date and Time when the forecast applies (dispatch interval ending) |
|
DUID |
VARCHAR2(20) |
X |
DUID (or Area for non-scheduled) where this forecast applies |
|
OFFERDATETIME |
DATE |
X |
Date and Time when this forecast submission was loaded |
|
INTERVAL_DATETIME |
DATE |
X |
Date and Time when the forecast applies (dispatch interval ending) |
|
ORIGIN |
VARCHAR2(20) |
X |
Origin of this forecast (PARTICIPANTID, AWEFS/ASEFS, or another vendor) |
|
FORECAST_PRIORITY |
NUMBER(10,0) |
X |
Unsuppressed forecasts with higher priority values are used in Dispatch in preference to unsuppressed forecasts with lower priority values |
|
FORECAST_MEAN |
NUMBER(18,8) |
|
Forecast MW value for this interval_DateTime |
|
FORECAST_POE10 |
NUMBER(18,8) |
|
Forecast 10% POE MW value for this interval_DateTime |
|
FORECAST_POE50 |
NUMBER(18,8) |
|
Forecast 50% POE MW value for this interval_DateTime. Used in Dispatch. |
|
FORECAST_POE90 |
NUMBER(18,8) |
|
Forecast 90% POE MW value for this interval_DateTime |
|
Name |
|
|
Comment |
Unconstrained Intermittent Generation Forecasts (UIGF) for Dispatch. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
FORECAST_PRIORITY |
|
OFFERDATETIME |
|
ORIGIN |
|
RUN_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Date and Time where the forecast applies (dispatch interval ending) |
|
DUID |
Varchar2(20) |
X |
DUID (or Area for non-scheduled) where this forecast applies |
|
OFFERDATETIME |
DATE |
X |
Date and Time when this forecast submission was loaded. |
|
ORIGIN |
Varchar2(20) |
X |
Origin of this forecast (PARTICIPANTID, AWEFS/ASEFS, or another vendor) |
|
FORECAST_PRIORITY |
NUMBER(10,0) |
X |
Unsuppressed forecasts with higher priority values are used in Dispatch in preference to unsuppressed forecasts with lower priority values. |
|
AUTHORISEDBY |
Varchar2(20) |
|
Authorising officer of this forecast (applicable for participant forecasts only). This column is not made available to the public. |
|
COMMENTS |
Varchar2(200) |
|
Comments relating to the forecast. This column is not made available to the public. |
|
LASTCHANGED |
DATE |
|
Last date and time the record changed. |
|
MODEL |
Varchar2(30) |
|
Metadata relating to the forecast. This column is not made available to the public. |
|
PARTICIPANT_TIMESTAMP |
DATE |
|
Participant can document when the forecast was created |
|
SUPPRESSED_AEMO |
NUMBER(1,0) |
|
Was this forecast suppressed by AEMO? Suppressed = 1,Not suppressed =0 |
|
SUPPRESSED_PARTICIPANT |
NUMBER(1,0) |
|
Was this forecast suppressed by the participant? Suppressed submissions may not be used, Suppressed = 1, Not suppressed =0 |
|
TRANSACTION_ID |
Varchar2(100) |
|
Uniquely identifies this interaction |
|
Name |
|
|
Comment |
Identifying record for a given forecast of an intermittent generation. This table is the version table for the INTERMITTENT_GEN_FCST_DATA table which stores the individual forecast values. AEMO plans to remove this table in a Data Model version release after 5.6. |
|
Source
INTERMITTENT_GEN_FCST_DATA updates every 30 minutes when AEMO issues a new 30-minute forecast of intermittent generation out to 8 days ahead. Volume ~18,000 rows per generator per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
RUN_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Date Time of forecast (AEST). |
|
DUID |
VARCHAR2(20) |
X |
Identifier of the intermittent generator. |
|
START_INTERVAL_DATETIME |
DATE |
X |
Date Time (AEST) of the first half-hour interval being forecast. |
|
END_INTERVAL_DATETIME |
DATE |
X |
Date Time (AEST) of the final half-hour interval being forecast. |
|
VERSIONNO |
NUMBER(10,0) |
|
Versioning information for resolution back to AEMO's wind generation forecasting system. |
|
LASTCHANGED |
DATE |
|
Date Time record was created |
|
Name |
|
|
Comment |
Stores the forecast generation (MW) for each interval within a given forecast of an intermittent generator. AEMO plans to remove this table in a Data Model version release after 5.6. |
|
Source INTERMITTENT_GEN_FCST_DATA updates every 30 minutes when AEMO issues a new 30-minute forecast of wind generation out to 8 days ahead. Volume ~1,500,000 rows per generator per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
INTERVAL_DATETIME |
|
RUN_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Date Time of forecast (AEST). |
|
DUID |
VARCHAR2(20) |
X |
Identifier of the intermittent generator |
|
INTERVAL_DATETIME |
DATE |
X |
Date Time (AEST) of the halfhour interval being forecast |
|
POWERMEAN |
NUMBER(9,3) |
|
The average forecast value in MW at the interval end |
|
POWERPOE50 |
NUMBER(9,3) |
|
50% probability of exceedance forecast value in MW at the interval end |
|
POWERPOELOW |
NUMBER(9,3) |
|
90% probability of exceedance forecast value in MW at the interval end |
|
POWERPOEHIGH |
NUMBER(9,3) |
|
10% probability of exceedance forecast value in MW at the interval end |
|
LASTCHANGED |
DATE |
|
Date Time record was created |
|
Name |
|
|
Comment |
Contains forecast predictions for intermittent wind and solar units, with a 5-minute resolution over the hour-ahead P5MIN timeframe. This is the child table of the parent table INTERMITTENT_GEN_FCST_P5_RUN, which contains the corresponding forecast runs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
FORECAST_PRIORITY |
|
FORECAST_RUN_DATETIME |
|
FORECAST_TYPE |
|
INTERVAL_DATETIME |
|
OFFERDATETIME |
|
PROVIDERID |
|
Name |
Data Type |
Mandatory |
Comment |
|
FORECAST_RUN_DATETIME |
DATE |
X |
Datetime (interval ending) when this forecast run is valid. It aligns with run_datetime in downstream processes, unless a forecast run is missed, in this case the previous run is used. |
|
DUID |
VARCHAR2(20) |
X |
Dispatchable unit identifier for which this forecast applies. |
|
OFFERDATETIME |
DATE |
X |
Datetime when this forecast submission was loaded. |
|
PROVIDERID |
VARCHAR2(20) |
X |
Forecast provider identifier |
|
FORECAST_PRIORITY |
NUMBER(10,0) |
X |
Priority of forecast run, higher number is used in preference to lower number for the same provider. |
|
INTERVAL_DATETIME |
DATE |
X |
Datetime (interval-ending) for the period that this forecast applies to, within the current forecast_run_datetime. |
|
FORECAST_TYPE |
VARCHAR2(20) |
X |
Type of forecast, for example, POE_10, POE_50, POE_90, MEAN and so on. |
|
FORECAST_VALUE |
NUMBER(18,8) |
|
Forecast value in MW. |
|
Name |
|
|
Comment |
Contains forecast runs for intermittent wind and solar units, with a 5-minute resolution over the hour-ahead P5MIN timeframe. This is the parent table to the child table INTERMITTENT_GEN_FCST_P5_PRED, which contains the corresponding forecast predictions over the full horizon. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
FORECAST_PRIORITY |
|
FORECAST_RUN_DATETIME |
|
OFFERDATETIME |
|
PROVIDERID |
|
Name |
Data Type |
Mandatory |
Comment |
|
FORECAST_RUN_DATETIME |
DATE |
X |
Datetime (interval ending) when this forecast run is valid. It aligns with run_datetime in downstream processes, unless a forecast run is missed, in this case the previous run is used. |
|
DUID |
VARCHAR2(20) |
X |
Dispatchable unit identifier for which this forecast applies. |
|
OFFERDATETIME |
DATE |
X |
Datetime when this forecast submission was loaded. |
|
PROVIDERID |
VARCHAR2(20) |
X |
Forecast provider identifier |
|
FORECAST_PRIORITY |
NUMBER(10,0) |
X |
Priority of forecast run, higher number is used in preference to lower number for the same provider. |
|
PROVIDER_TIMESTAMP |
DATE |
|
Datetime when the provider created the forecast. |
|
REMARKS |
VARCHAR2(300) |
|
Comments relating to the forecast run. This column is not made available to the public. |
|
MODEL_USED |
VARCHAR2(30) |
|
Metadata describing the model used to produce the forecast run. This column is not made available to the public. |
|
SUPPRESSED_PROVIDER |
NUMBER(1,0) |
|
Flag indicating if the forecast run was suppressed by the provider when submitted. Suppressed forecasts are not used by downstream systems. Suppressed = 1, Unsuppressed = 0. |
|
TRANSACTION_ID |
VARCHAR2(100) |
|
Transaction identifier for receiving the forecast run. |
|
LASTCHANGED |
DATE |
|
Datetime when the forecast run was written into AEMO database. |
|
Name |
|
|
Comment |
Contains forecast predictions for intermittent wind and solar units, with a 30-minute resolution over the week-ahead PD/STPASA timeframe. This is the child table of the parent table INTERMITTENT_GEN_FCST_RUN, which contains the corresponding forecast runs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
FORECAST_PRIORITY |
|
FORECAST_RUN_DATETIME |
|
FORECAST_TYPE |
|
INTERVAL_DATETIME |
|
OFFERDATETIME |
|
PROVIDERID |
|
Name |
Data Type |
Mandatory |
Comment |
|
FORECAST_RUN_DATETIME |
DATE |
X |
Datetime (interval ending) when this forecast run is valid. It aligns with run_datetime in downstream processes, unless a forecast run is missed, in this case the previous run is used. |
|
DUID |
VARCHAR2(20) |
X |
Dispatchable unit identifier for which this forecast applies. |
|
OFFERDATETIME |
DATE |
X |
Datetime when this forecast submission was loaded. |
|
PROVIDERID |
VARCHAR2(20) |
X |
Forecast provider identifier |
|
FORECAST_PRIORITY |
NUMBER(10,0) |
X |
Priority of forecast run, higher number is used in preference to lower number for the same provider. |
|
INTERVAL_DATETIME |
DATE |
X |
Datetime (interval-ending) for the period that this forecast applies to, within the current forecast_run_datetime. |
|
FORECAST_TYPE |
VARCHAR2(20) |
X |
Type of forecast, for example, POE_10, POE_50, POE_90, MEAN and so on. |
|
FORECAST_VALUE |
NUMBER(18,8) |
|
Forecast value in MW. |
|
Name |
|
|
Comment |
Contains forecast runs for intermittent wind and solar units, with a 30-minute resolution over the week-ahead PD/STPASA timeframe. This is the parent table to the child table INTERMITTENT_GEN_FCST_PRED, which contains the corresponding forecast predictions over the full horizon. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
FORECAST_PRIORITY |
|
FORECAST_RUN_DATETIME |
|
OFFERDATETIME |
|
PROVIDERID |
|
Name |
Data Type |
Mandatory |
Comment |
|
FORECAST_RUN_DATETIME |
DATE |
X |
Datetime (interval ending) when this forecast run is valid. It aligns with run_datetime in downstream processes, unless a forecast run is missed, in this case the previous run is used. |
|
DUID |
VARCHAR2(20) |
X |
Dispatchable unit identifier for which this forecast applies. |
|
OFFERDATETIME |
DATE |
X |
Datetime when this forecast submission was loaded. |
|
PROVIDERID |
VARCHAR2(20) |
X |
Forecast provider identifier |
|
FORECAST_PRIORITY |
NUMBER(10,0) |
X |
Priority of forecast run, higher number is used in preference to lower number for the same provider. |
|
PROVIDER_TIMESTAMP |
DATE |
|
Datetime when the provider created the forecast. |
|
REMARKS |
VARCHAR2(300) |
|
Comments relating to the forecast run. This column is not made available to the public. |
|
MODEL_USED |
VARCHAR2(30) |
|
Metadata describing the model used to produce the forecast run. This column is not made available to the public. |
|
SUPPRESSED_PROVIDER |
NUMBER(1,0) |
|
Flag indicating if the forecast run was suppressed by the provider when submitted. Suppressed forecasts are not used by downstream systems. Suppressed = 1, Unsuppressed = 0. |
|
TRANSACTION_ID |
VARCHAR2(100) |
|
Transaction identifier for receiving the forecast run |
|
LASTCHANGED |
DATE |
|
Datetime when the forecast run was written into AEMO database. |
|
Name |
|
|
Comment |
A submission of Upper MW Limit for an intermittent generating unit, by Trading Day and Trading Interval |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
OFFERDATETIME |
|
PERIODID |
|
TRADINGDATE |
|
Name |
Data Type |
Mandatory |
Comment |
|
TRADINGDATE |
DATE |
X |
Trading Day for which this unit availability submission applies |
|
DUID |
VARCHAR2(20) |
X |
Unique Identifier of Dispatchable Unit |
|
OFFERDATETIME |
DATE |
X |
Date and Time when this unit availability submission was loaded |
|
PERIODID |
NUMBER(3,0) |
X |
Trading interval number (1...48) within this TRADINGDATE for which UPPERMWLIMIT applies |
|
UPPERMWLIMIT |
NUMBER(6) |
|
Maximum imposed MW limit (down regulation in AWEFS/ASEFS). Value between 0 and the registered DUID Maximum Capacity. Value = -1 means no limit applies. |
|
Name |
|
|
Comment |
Summary record for an Upper MW Limit submission for an intermittent generating unit for a Trading Day |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
OFFERDATETIME |
|
TRADINGDATE |
|
Name |
Data Type |
Mandatory |
Comment |
|
TRADINGDATE |
DATE |
X |
Trading Day for which this unit availability submission applies |
|
DUID |
VARCHAR2(20) |
X |
Unique Identifier of Dispatchable Unit |
|
OFFERDATETIME |
DATE |
X |
Date and Time when this unit availability submission was loaded |
|
PARTICIPANTID |
VARCHAR2(20) |
|
Unique participant identifier |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
AUTHORISEDBYUSER |
VARCHAR2(20) |
|
User entering the unit availability submission |
|
AUTHORISEDBYPARTICIPANTID |
VARCHAR2(20) |
|
Participant entering the unit availability submission |
|
Name |
|
|
Comment |
INTERMITTENT_GEN_SCADA provides the SCADA Availability for every intermittent generating unit, including Elements Available (wind turbines/solar inverters) and Local Limit |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
RUN_DATETIME |
|
SCADA_TYPE |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Date Time of the dispatch interval (interval ending) |
|
DUID |
VARCHAR2(20) |
X |
Dispatchable Unit Identifier |
|
SCADA_TYPE |
VARCHAR2(20) |
X |
SCADA snapshot for intermittent generating unit at start of interval for a specified SCADA signal type. ELAV = Total Elements Available (# turbines for wind farms, # inverters for solar farms); LOCL = Local Limit (MW). |
|
SCADA_VALUE |
NUMBER(15,5) |
|
SCADA value snapshot for intermittent generating unit at start of interval for a specified SCADA signal type. |
|
SCADA_QUALITY |
VARCHAR2(20) |
|
SCADA quality snapshot for intermittent generating unit at start of interval for a specified SCADA signal type. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
Unconstrained Intermittent Generation Forecasts (UIGF) for 5-Minute Pre-dispatch. AEMO plans to remove this table in a Data Model version release after 5.6. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
FORECAST_PRIORITY |
|
INTERVAL_DATETIME |
|
OFFERDATETIME |
|
ORIGIN |
|
RUN_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Date and Time of the first interval of 5-Minute Predispatch where the forecast applies (dispatch interval ending) |
|
DUID |
VARCHAR2(20) |
X |
DUID (or Area for non-scheduled) where this forecast applies |
|
OFFERDATETIME |
DATE |
X |
Date and Time when this forecast submission was loaded |
|
INTERVAL_DATETIME |
DATE |
X |
Interval within the current RUN_DATETIME where this forecast applies (dispatch interval ending) |
|
ORIGIN |
VARCHAR2(20) |
X |
Origin of this forecast (PARTICIPANTID, AWEFS/ASEFS, or another vendor) |
|
FORECAST_PRIORITY |
NUMBER(10,0) |
X |
Unsuppressed forecasts with higher priority values are used in 5-Minute Predispatch in preference to unsuppressed forecasts with lower priority values |
|
FORECAST_MEAN |
NUMBER(18,8) |
|
Forecast MW value for this interval_DateTime |
|
FORECAST_POE10 |
NUMBER(18,8) |
|
Forecast 10% POE MW value for this interval_DateTime |
|
FORECAST_POE50 |
NUMBER(18,8) |
|
Forecast 50% POE MW value for this interval_DateTime. |
|
FORECAST_POE90 |
NUMBER(18,8) |
|
Forecast 90% POE MW value for this interval_DateTime |
|
Name |
|
|
Comment |
Unconstrained Intermittent Generation Forecasts (UIGF) for 5-Minute Pre-dispatch. AEMO plans to remove this table in a Data Model version release after 5.6. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
FORECAST_PRIORITY |
|
OFFERDATETIME |
|
ORIGIN |
|
RUN_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Date and Time of the first interval of 5-minute pre-dispatch where the forecast applies. |
|
DUID |
Varchar2(20) |
X |
DUID (or Area for non-scheduled) where this forecast applies |
|
OFFERDATETIME |
DATE |
X |
Date and Time when this forecast submission was loaded |
|
ORIGIN |
Varchar2(20) |
X |
Origin of this forecast (PARTICIPANTID, AWEFS/ASEFS, or another vendor) |
|
FORECAST_PRIORITY |
NUMBER(10,0) |
X |
Unsuppressed forecasts with higher priority values are used in 5-Minute Predispatch in preference to unsuppressed forecasts with lower priority values |
|
AUTHORISEDBY |
Varchar2(20) |
|
Authorising officer of this forecast |
|
COMMENTS |
Varchar2(200) |
|
Comments relating to the forecast |
|
LASTCHANGED |
DATE |
|
Last date and time the record changed. |
|
MODEL |
Varchar2(30) |
|
Metadata relating to the forecast. |
|
PARTICIPANT_TIMESTAMP |
DATE |
|
Participant can document when the forecast was created |
|
SUPPRESSED_AEMO |
NUMBER(1,0) |
|
Was this forecast suppressed by AEMO? Suppressed = 1,Not suppressed =0 |
|
SUPPRESSED_PARTICIPANT |
NUMBER(1,0) |
|
Was this forecast suppressed by the participant? Suppressed submissions may not be used, Suppressed = 1, Not suppressed =0 |
|
TRANSACTION_ID |
Varchar2(100) |
|
Uniquely identifies this interaction |
|
Name |
|
|
Comment |
A submission of expected plant availability for intermittent generators for use in MTPASA intermittent generation forecasts |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CLUSTERID |
|
DUID |
|
OFFERDATETIME |
|
TRADINGDATE |
|
Name |
Data Type |
Mandatory |
Comment |
|
TRADINGDATE |
DATE |
X |
Trading Day for which this cluster availability submission applies |
|
DUID |
VARCHAR2(20) |
X |
Unique Identifier of Dispatchable Unit |
|
OFFERDATETIME |
DATE |
X |
Date and Time when this cluster availability submission was loaded |
|
CLUSTERID |
VARCHAR2(20) |
X |
Unique Cluster Identifier for this cluster within the DUID |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
ELEMENTS_UNAVAILABLE |
NUMBER(5,0) |
|
Number of elements within this CLUSTERID (turbines for wind, or inverters for solar) that are not available for this TRADINGDATE. Value between 0 and the registered Number of Cluster Elements.Value = 0 means no elements unavailable |
|
ELEMENTS_AVAILABLE |
NUMBER(5,0) |
|
Number of elements within this CLUSTERID (turbines for wind, or inverters for solar) that are available for this TRADINGDATE. Value between 0 and the registered Number of Cluster Elements. Value = 0 means no elements available |
|
Name |
|
|
Comment |
A submission of expected maximum availability for intermittent generators for use in MTPASA intermittent generation |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
OFFERDATETIME |
|
TRADINGDATE |
|
Name |
Data Type |
Mandatory |
Comment |
|
TRADINGDATE |
DATE |
X |
Trading Day for which this unit availability submission applies |
|
DUID |
VARCHAR2(20) |
X |
Unique Identifier of Dispatchable Unit |
|
OFFERDATETIME |
DATE |
X |
Date time file processed |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
UPPERMWLIMIT |
NUMBER(6) |
|
Maximum imposed MW limit. Value between 0 and the registered DUID Maximum Capacity.Value = -1 means no limit applies. |
|
AUTHORISEDBYUSER |
VARCHAR2(20) |
|
User entering the unit availability submission |
|
AUTHORISEDBYPARTICIPANTID |
VARCHAR2(20) |
|
Participant entering the unit availability submission |
|
Name |
|
|
Comment |
PERDEMAND sets out the regional demands and MR schedule data for each half-hour period. PERDEMAND is a child table to RESDEMANDTRK. |
|
The RESDEMANDTRK and PERDEMAND tables have a parent/child relationship, and define forecast regional demands since market start. RESDEMANDTRK defines the existence and versioning information of a forecast for a specific region and trading date. PERDEMAND defines the numerical forecast values for each trading interval of a the trading day for that region. A complete trading day forecast for one region consists of one RESDEMANDTRK record and 48 PERDEMAND records. Source PERDEMAND updates whenever AEMO issues a new or revised forecast. ST PASA forecasts update seven days at a time. Predispatch updates one date. Volume 1296000 rows per year Note In the context of a mandatory restrictions event the forecast schedule (MW) of restrictions are reported through the RESDEMANDTRK and PERDEMAND tables using the new field PerDemand.MR_Schedule. The relationship between fields and mandatory restriction terms for the 50% probability of exceedence forecast are: · UnRestricted Profile = ResDemand + MR_Schedule · Restricted Profile = ResDemand |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
OFFERDATE |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
|
Market date the forecast is made for. First date of the 7 days. |
|
SETTLEMENTDATE |
DATE |
X |
Market date of forecast up to 7 days ahead. |
|
REGIONID |
VARCHAR2(10) |
X |
Differentiates this region from all other regions |
|
OFFERDATE |
DATE |
X |
Date record issued |
|
PERIODID |
NUMBER(3,0) |
X |
Half hourly trading intervals from 04:30. |
|
VERSIONNO |
NUMBER(3,0) |
X |
The version of the RESDEMAND file for this date |
|
RESDEMAND |
NUMBER(10,0) |
|
Base Demand forecast for period |
|
DEMAND90PROBABILITY |
NUMBER(10,0) |
|
Demand at 90% probability of exceedance |
|
DEMAND10PROBABILITY |
NUMBER(10,0) |
|
Demand level for a 10% probability of exceedance |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
MR_SCHEDULE |
NUMBER(6,0) |
|
MR_Schedule = Unrestricted Demand - POE |
|
Name |
|
|
Comment |
RESDEMANDTRK defines the existence and versioning information of a forecast for a specific region and trading date. |
|
RESDEMANDTRK data is public, so is available to all participants. Source RESDEMANDTRK updates are ad hoc. Volume 27000 rows per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
OFFERDATE |
|
REGIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Trading Date of the regional forecast |
|
REGIONID |
VARCHAR2(10) |
X |
Unique RegionID |
|
OFFERDATE |
DATE |
X |
Date the forecast was created |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of this forecast with respect to the Effectivedate and Offerdate |
|
FILENAME |
VARCHAR2(40) |
|
Tracking purposes only |
|
AUTHORISEDDATE |
DATE |
|
Date forecast authorised |
|
AUTHORISEDBY |
VARCHAR2(10) |
|
Identifier of authorising user |
|
LASTCHANGED |
DATE |
|
Date and time the record was last modified |
|
Name |
|
|
Comment |
Estimate of regional Rooftop Solar actual generation for each half-hour interval in a day. AEMO plans to remove this table in a Data Model version release after 5.6. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERVAL_DATETIME |
|
REGIONID |
|
TYPE |
|
Name |
|
INTERVAL_DATETIME |
|
TYPE |
|
REGIONID |
|
Name |
Data Type |
Mandatory |
Comment |
|
INTERVAL_DATETIME |
DATE |
X |
The forecast half-hour interval (time ending) |
|
TYPE |
VARCHAR2(20) |
X |
One of DAILY, MEASUREMENT or SATELLITE. DAILY- best quality estimated actuals, available day after. MEASUREMENT- best quality estimated actuals on day, delayed by 1 half hour. SATELLITE- estimated actuals using satellite imagery, delayed by 1 half hour. |
|
REGIONID |
VARCHAR2(20) |
X |
Region identifier |
|
POWER |
NUMBER(12,3) |
|
Estimated generation in MW at the interval end |
|
QI |
NUMBER(2,1) |
|
Quality indicator. Represents the quality of the estimate. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
Contains predictions for rooftop PV area estimated actuals, with a 5-minute and 30-minute resolution for different estimate types. This is the child table of the parent table ROOFTOP_PV_ACTUAL_RUN, which contains the corresponding actual prediction runs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
AREAID |
|
ESTIMATE_TYPE |
|
INTERVAL_DATETIME |
|
INTERVAL_DURATION |
|
OFFERDATETIME |
|
PREDICTION_PRIORITY |
|
PREDICTION_RUN_DATETIME |
|
PROVIDERID |
|
Name |
Data Type |
Mandatory |
Comment |
|
PREDICTION_RUN_DATETIME |
DATE |
X |
Datetime (interval ending) from which this prediction run is valid. |
|
INTERVAL_DURATION |
NUMBER(3,0) |
X |
Duration of each interval (in minutes) for this prediction, for example, 5 or 30. |
|
AREAID |
VARCHAR2(10) |
X |
Area identifier, aligning with the load forecasting areas. |
|
OFFERDATETIME |
DATE |
X |
Datetime when this prediction submission was loaded. |
|
ESTIMATE_TYPE |
VARCHAR2(20) |
X |
Type of Rooftop PV estimate, for example, MEASURED, SATELLITE and so on. |
|
PROVIDERID |
VARCHAR2(20) |
X |
Provider identifier, for example, AEMO, PROVIDER_A and so on. |
|
PREDICTION_PRIORITY |
NUMBER(10,0) |
X |
Priority of prediction run, higher number is used in preference to lower number for the same provider. |
|
INTERVAL_DATETIME |
DATE |
X |
Date and Time the forecast applies (dispatch interval ending). |
|
PREDICTION_VALUE |
NUMBER(18,8) |
|
Prediction value in MW. |
|
PREDICTION_QUALITY |
NUMBER(2,0) |
|
Prediction quality. Higher number represents better quality. |
|
Name |
|
|
Comment |
Contains prediction runs for rooftop PV area estimated actuals, with a 5-minute and 30-minute resolution for different estimate types. This is the parent table to the child table ROOFTOP_PV_ACTUAL_PRED, which contains the corresponding actual predictions. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
AREAID |
|
ESTIMATE_TYPE |
|
INTERVAL_DURATION |
|
OFFERDATETIME |
|
PREDICTION_PRIORITY |
|
PREDICTION_RUN_DATETIME |
|
PROVIDERID |
|
Name |
Data Type |
Mandatory |
Comment |
|
PREDICTION_RUN_DATETIME |
DATE |
X |
Datetime (interval ending) from which this prediction run is valid. |
|
INTERVAL_DURATION |
NUMBER(3,0) |
X |
Duration of each interval (in minutes) for this prediction, for example, 5 or 30. |
|
AREAID |
VARCHAR2(10) |
X |
Area identifier, aligning with the load forecasting areas. |
|
OFFERDATETIME |
DATE |
X |
Datetime when this prediction submission was loaded. |
|
ESTIMATE_TYPE |
VARCHAR2(20) |
X |
Type of Rooftop PV estimate, for example, MEASURED, SATELLITE and so on. |
|
PROVIDERID |
VARCHAR2(20) |
X |
Provider identifier, for example, AEMO, PROVIDER_A and so on. |
|
PREDICTION_PRIORITY |
NUMBER(10,0) |
X |
Priority of prediction run, higher number is used in preference to lower number for the same provider. |
|
PROVIDER_TIMESTAMP |
DATE |
|
Datetime when the provider created the forecast. |
|
REMARKS |
VARCHAR2(300) |
|
Comments relating to the prediction run. |
|
MODEL_USED |
VARCHAR2(30) |
|
Metadata describing the model used to produce the prediction run. |
|
SUPPRESSED_PROVIDER |
NUMBER(1,0) |
|
Flag indicating if the prediction run was suppressed by the provider when submitted. Suppressed predictions are not used by downstream forecasting systems. Suppressed = 1, Unsuppressed = 0. |
|
INSTALLED_CAPACITY |
NUMBER(18,8) |
|
Installed rooftop PV capacity used for the prediction run, in MW. |
|
LASTCHANGED |
DATE |
|
Datetime when the prediction run was written into AEMO database. |
|
Name |
|
|
Comment |
Contains forecast predictions for rooftop PV areas, with a 5-minute resolution over the hour-ahead DS/P5MIN timeframe. This is the child table of the parent table ROOFTOP_PV_FCST_P5_RUN, which contains the corresponding forecast runs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
AREAID |
|
FORECAST_PRIORITY |
|
FORECAST_RUN_DATETIME |
|
FORECAST_TYPE |
|
INTERVAL_DATETIME |
|
OFFERDATETIME |
|
PROVIDERID |
|
Name |
Data Type |
Mandatory |
Comment |
|
FORECAST_RUN_DATETIME |
DATE |
X |
Datetime (interval ending) when this forecast run is valid. It aligns with run_datetime in downstream processes, unless a forecast run is missed in which case the previous run is used. |
|
AREAID |
VARCHAR2(10) |
X |
Area identifier, aligning with the load forecasting areas. |
|
OFFERDATETIME |
DATE |
X |
Datetime when this forecast submission was loaded. |
|
PROVIDERID |
VARCHAR2(20) |
X |
Forecast provider identifier, for example, AEMO, PROVIDER_A and so on. |
|
FORECAST_PRIORITY |
NUMBER(10,0) |
X |
Priority of forecast run, higher number is used in preference to lower number for the same provider. |
|
INTERVAL_DATETIME |
DATE |
X |
Datetime (interval-ending) for the period that this forecast applies to, within the current forecast_run_datetime. |
|
FORECAST_TYPE |
VARCHAR2(20) |
X |
Type of forecast, for example, POE_10, POE_50, POE_90, MEAN and so on. |
|
FORECAST_VALUE |
NUMBER(18,8) |
|
Forecast value in MW. |
|
Name |
|
|
Comment |
Contains forecast runs for rooftop PV areas, with a 5-minute resolution over the hour-ahead DS/P5MIN timeframe. This is the parent table to the child table ROOFTOP_PV_FCST_P5_PRED, which contains the corresponding forecast predictions over the full horizon. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
AREAID |
|
FORECAST_PRIORITY |
|
FORECAST_RUN_DATETIME |
|
OFFERDATETIME |
|
PROVIDERID |
|
Name |
Data Type |
Mandatory |
Comment |
|
FORECAST_RUN_DATETIME |
DATE |
X |
Datetime (interval ending) when this forecast run is valid. It aligns with run_datetime in downstream processes, unless a forecast run is missed, in this case the previous run is used. |
|
AREAID |
VARCHAR2(10) |
X |
Area identifier, aligning with the load forecasting areas. |
|
OFFERDATETIME |
DATE |
X |
Datetime when this forecast submission was loaded. |
|
PROVIDERID |
VARCHAR2(20) |
X |
Forecast provider identifier, for example, AEMO, PROVIDER_A and so on. |
|
FORECAST_PRIORITY |
NUMBER(10,0) |
X |
Priority of forecast run, higher number is used in preference to lower number for the same provider. |
|
PROVIDER_TIMESTAMP |
DATE |
|
Datetime when the provider created the forecast. |
|
REMARKS |
VARCHAR2(300) |
|
Comments relating to the forecast run. |
|
MODEL_USED |
VARCHAR2(30) |
|
Metadata describing the model used to produce the forecast run. |
|
SUPPRESSED_PROVIDER |
NUMBER(1,0) |
|
Flag indicating if the forecast run was suppressed by the provider when submitted. Suppressed forecasts are not used by downstream systems. Suppressed = 1, Unsuppressed = 0. |
|
INSTALLED_CAPACITY |
NUMBER(18,8) |
|
Installed rooftop PV capacity that was used for the forecast run, in MW. |
|
LASTCHANGED |
DATE |
|
Datetime when the forecast run was written into AEMO database. |
|
Name |
|
|
Comment |
Contains forecast predictions for rooftop PV areas, with a 30-minute resolution over the week-ahead PD/STPASA timeframe. This is the child table of the parent table ROOFTOP_PV_FCST_RUN, which contains the corresponding forecast runs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
AREAID |
|
FORECAST_PRIORITY |
|
FORECAST_RUN_DATETIME |
|
FORECAST_TYPE |
|
INTERVAL_DATETIME |
|
OFFERDATETIME |
|
PROVIDERID |
|
Name |
Data Type |
Mandatory |
Comment |
|
FORECAST_RUN_DATETIME |
DATE |
X |
Datetime (interval ending) when this forecast run is valid. It aligns with run_datetime in downstream processes, unless a forecast run is missed, in this case the previous run is used. |
|
AREAID |
VARCHAR2(10) |
X |
Area identifier, aligning with the load forecasting areas. |
|
OFFERDATETIME |
DATE |
X |
Datetime when this forecast submission was loaded. |
|
PROVIDERID |
VARCHAR2(20) |
X |
Forecast provider identifier, for example, AEMO, PROVIDER_A and so on. |
|
FORECAST_PRIORITY |
NUMBER(10,0) |
X |
Priority of forecast run, higher number is used in preference to lower number for the same provider. |
|
INTERVAL_DATETIME |
DATE |
X |
Datetime (interval-ending) for the period that this forecast applies to, within the current forecast_run_datetime. |
|
FORECAST_TYPE |
VARCHAR2(20) |
X |
Type of forecast, for example, POE_10, POE_50, POE_90, MEAN and so on. |
|
FORECAST_VALUE |
NUMBER(18,8) |
|
Forecast value in MW. |
|
Name |
|
|
Comment |
Contains forecast runs for rooftop PV areas, with a 30-minute resolution over the week-ahead PD/STPASA timeframe. This is the parent table to the child table ROOFTOP_PV_FCST_PRED, which contains the corresponding forecast predictions over the full horizon. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
AREAID |
|
FORECAST_PRIORITY |
|
FORECAST_RUN_DATETIME |
|
OFFERDATETIME |
|
PROVIDERID |
|
Name |
Data Type |
Mandatory |
Comment |
|
FORECAST_RUN_DATETIME |
DATE |
X |
Datetime (interval ending) when this forecast run is valid. It aligns with run_datetime in downstream processes, unless a forecast run is missed, in this case the previous run is used. |
|
AREAID |
VARCHAR2(10) |
X |
Area identifier, aligning with the load forecasting areas. |
|
OFFERDATETIME |
DATE |
X |
Datetime when this forecast submission was loaded. |
|
PROVIDERID |
VARCHAR2(20) |
X |
Forecast provider identifier, for example, AEMO, PROVIDER_A and so on. |
|
FORECAST_PRIORITY |
NUMBER(10,0) |
X |
Priority of forecast run, higher number is used in preference to lower number for the same provider. |
|
PROVIDER_TIMESTAMP |
DATE |
|
Datetime when the provider created the forecast. |
|
REMARKS |
VARCHAR2(300) |
|
Comments relating to the forecast run. |
|
MODEL_USED |
VARCHAR2(30) |
|
Metadata describing the model used to produce the forecast run. |
|
SUPPRESSED_PROVIDER |
NUMBER(1,0) |
|
Flag indicating if the forecast run was suppressed by the provider when submitted. Suppressed forecasts are not used by downstream systems. Suppressed = 1, Unsuppressed = 0. |
|
INSTALLED_CAPACITY |
NUMBER(18,8) |
|
Installed rooftop PV capacity that was used for the forecast run, in MW. |
|
LASTCHANGED |
DATE |
|
Datetime when the forecast run was written into AEMO database. |
|
Name |
|
|
Comment |
Regional forecasts of Rooftop Solar generation across the half-hour intervals over 8 days. AEMO plans to remove this table in a Data Model version release after 5.6. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERVAL_DATETIME |
|
REGIONID |
|
VERSION_DATETIME |
|
Name |
|
VERSION_DATETIME |
|
INTERVAL_DATETIME |
|
REGIONID |
|
Name |
Data Type |
Mandatory |
Comment |
|
VERSION_DATETIME |
DATE |
X |
Date time this forecast was produced |
|
REGIONID |
VARCHAR2(20) |
X |
Region identifier |
|
INTERVAL_DATETIME |
DATE |
X |
The forecast half-hour interval (time ending) |
|
POWERMEAN |
NUMBER(12,3) |
|
The average forecast value in MW at the interval end |
|
POWERPOE50 |
NUMBER(12,3) |
|
50% probability of exceedance forecast value in MW at the interval end |
|
POWERPOELOW |
NUMBER(12,3) |
|
90% probability of exceedance forecast value in MW at the interval end |
|
POWERPOEHIGH |
NUMBER(12,3) |
|
10% probability of exceedance forecast value in MW at the interval end |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|