Table: INTERMITTENT_GEN_FCST_DATA

INTERMITTENT_GEN_FCST_DATA

Name

INTERMITTENT_GEN_FCST_DATA

Comment

Stores the forecast generation (MW) for each interval within a given forecast of an intermittent generator.


Description

Source

INTERMITTENT_GEN_FCST_DATA updates every 30 minutes when AEMO issues a new 30-minute forecast of wind generation out to 40 hours ahead.

Volume

~1,500,000 rows per generator per year


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

DUID

INTERVAL_DATETIME

RUN_DATETIME


Content

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