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:

Private; Public Next-Day


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, except when the forecast used is either SCADA or FCST or Last Target

FORECAST_PRIORITY

NUMBER(10,0)

 

Tracks to INTERMITTENT_DS_RUN.FORECAST_PRIORITY, except for -1 which denotes SCADA or FCST, and 0 which denotes Last Target

OFFERDATETIME

DATE

 

Tracks to INTERMITTENT_DS_RUN.OFFERDATETIME