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

 

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


Table: NEGATIVE_RESIDUE

NEGATIVE_RESIDUE

Name

NEGATIVE_RESIDUE

Comment

Shows the inputs provided to the Negative Residue Constraints in the Dispatch horizon


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

DIRECTIONAL_INTERCONNECTORID

NRM_DATETIME

SETTLEMENTDATE


Index Columns

Name

SETTLEMENTDATE

NRM_DATETIME

DIRECTIONAL_INTERCONNECTORID


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

date

X

Dispatch Interval

NRM_DATETIME

date

X

The time that residue information is processed

DIRECTIONAL_INTERCONNECTORID

varchar2(30)

X

Negative residue related direction interconnector id

NRM_ACTIVATED_FLAG

number(1,0)

 

Is 1 if negative residue process is on, else is 0

CUMUL_NEGRESIDUE_AMOUNT

number(15,5)

 

Negative residue triggering amount

CUMUL_NEGRESIDUE_PREV_TI

number(15,5)

 

Previous trading interval cumulative negative residue amount

NEGRESIDUE_CURRENT_TI

number(15,5)

 

Current trading interval negative residue amount

NEGRESIDUE_PD_NEXT_TI

number(15,5)

 

The cumulative negative residue for the next trading interval (PD)

PRICE_REVISION

varchar2(30)

 

SubjectToReview, Indeterminate, Accepted or Rejected

PREDISPATCHSEQNO

varchar2(20)

 

Predispatch sequence number

EVENT_ACTIVATED_DI

date

 

The starting DI when NRM event is active

EVENT_DEACTIVATED_DI

date

 

The finishing DI when NRM event stops being active.

DI_NOTBINDING_COUNT

number(2,0)

 

Count of the number of DIs not binding by this constraint

DI_VIOLATED_COUNT

number(2,0)

 

Count of the number of DIs violated by this constraint

NRMCONSTRAINT_BLOCKED_FLAG

number(1,0)

 

1 if constraint is blocked, else 0