Table: INTERMITTENT_P5_RUN

INTERMITTENT_P5_RUN

Name

INTERMITTENT_P5_RUN

Comment

Unconstrained Intermittent Generation Forecasts (UIGF) for 5-Minute Pre-dispatch


Primary Key Columns

Name

DUID

FORECAST_PRIORITY

OFFERDATETIME

ORIGIN

RUN_DATETIME


Content

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