|
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 |
|
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. |
|
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) |
|
10% probability of exceedance forecast value in MW at the interval end |
|
POWERPOEHIGH |
NUMBER(9,3) |
|
90% probability of exceedance forecast value in MW at the interval end |
|
LASTCHANGED |
DATE |
|
Date Time record was created |
|
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 |
|
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 |
|
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 |
|
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 |
Regional forecasts of Rooftop Solar generation across the half-hour intervals over 8 days |
|
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) |
|
10% probability of exceedance forecast value in MW at the interval end |
|
POWERPOEHIGH |
NUMBER(12,3) |
|
90% probability of exceedance forecast value in MW at the interval end |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
|
|