Table: INTERMITTENT_GEN_FCST

INTERMITTENT_GEN_FCST

Name

INTERMITTENT_GEN_FCST

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


Description

Source

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

Volume

~18,000 rows per generator per year


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

DUID

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.

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