Table: INTERMITTENT_FORECAST_TRK

INTERMITTENT_FORECAST_TRK

Name

INTERMITTENT_FORECAST_TRK

Comment

Uniquely tracks which Intermittent Generation forecast was used for the DUID in which Dispatch run


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

DUID

SETTLEMENTDATE


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

DateTime of the Dispatch run (dispatch interval ending)

DUID

VARCHAR2(20)

X

Tracks to INTERMITTENT_DS_RUN.DUID

ORIGIN

VARCHAR2(20)

 

Tracks to INTERMITTENT_DS_RUN.ORIGIN, SCADA is written to ORIGIN if no forecast is discovered.

FORECAST_PRIORITY

NUMBER(10,0)

 

Tracks to INTERMITTENT_DS_RUN.FORECAST_PRIORITY - except for -1 and 0, which denote ''Last Target'' and ''SCADA'' respectively

OFFERDATETIME

DATE

 

Tracks to INTERMITTENT_DS_RUN.OFFERDATETIME