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


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