Table: PD7DAY_CASESOLUTION

PD7DAY_CASESOLUTION

Name

PD7DAY_CASESOLUTION

Comment

PD7DAY case solution table


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

RUN_DATETIME


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

Unique Timestamp Identifier for this study

INTERVENTION

NUMBER(2,0)

 

Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run.

LASTCHANGED

DATE

 

Last date and time record changed


Table: PD7DAY_CONSTRAINTSOLUTION

PD7DAY_CONSTRAINTSOLUTION

Name

PD7DAY_CONSTRAINTSOLUTION

Comment

PD7DAY constraint solution


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

CONSTRAINTID

INTERVAL_DATETIME

INTERVENTION

RUN_DATETIME


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

Unique Timestamp Identifier for this study

INTERVENTION

NUMBER(2,0)

X

Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run.

INTERVAL_DATETIME

DATE

X

The unique identifier for the interval within this study

CONSTRAINTID

VARCHAR2(20)

X

Constraint identifier (synonymous with GenConID)

RHS

NUMBER(15,5)

 

Right Hand Side value in the capacity evaluation in MW

MARGINALVALUE

NUMBER(15,5)

 

Marginal cost of constraint (>0 if binding) in $/MW

VIOLATIONDEGREE

NUMBER(15,5)

 

Amount of Violation (>0 if violating) in MW

LHS

NUMBER(15,5)

 

Aggregation of the constraints LHS term solution values in MW

LASTCHANGED

DATE

 

Last date and time record changed


Table: PD7DAY_INTERCONNECTORSOLUTION

PD7DAY_INTERCONNECTORSOLUTION

Name

PD7DAY_INTERCONNECTORSOLUTION

Comment

PD7DAY intereconnector solution


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

INTERCONNECTORID

INTERVAL_DATETIME

INTERVENTION

RUN_DATETIME


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

Unique Timestamp Identifier for this study

INTERVENTION

NUMBER(2,0)

X

Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run.

INTERVAL_DATETIME

DATE

X

The unique identifier for the interval within this study

INTERCONNECTORID

VARCHAR2(20)

X

Interconnector identifier

METEREDMWFLOW

NUMBER(15,5)

 

SCADA MW Flow measured at Run start. For periods subsequent to the first period of a PD7DAY run, this value represents the cleared target for the previous period of that PD7DAY run.

MWFLOW

NUMBER(15,5)

 

Cleared Interconnector loading level (MW)

MWLOSSES

NUMBER(15,5)

 

Interconnector Losses at cleared flow

MARGINALVALUE

NUMBER(15,5)

 

Marginal cost of Interconnector standing data limits (if binding)

VIOLATIONDEGREE

NUMBER(15,5)

 

Violation of Interconnector standing data limits

EXPORTLIMIT

NUMBER(15,5)

 

Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit

IMPORTLIMIT

NUMBER(15,5)

 

Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit. Note unlike the input interconnector import limit this is a directional quantity and should be defined with respect to the interconnector flow.

MARGINALLOSS

NUMBER(15,5)

 

Marginal loss factor at the cleared flow

EXPORTCONSTRAINTID

VARCHAR2(20)

 

Generic Constraint setting the export limit

IMPORTCONSTRAINTID

VARCHAR2(20)

 

Generic Constraint setting the import limit

FCASEXPORTLIMIT

NUMBER(15,5)

 

Calculated export limit applying to energy + Frequency Controlled Ancillary Services.

FCASIMPORTLIMIT

NUMBER(15,5)

 

Calculated import limit applying to energy + Frequency Controlled Ancillary Services.

LOCAL_PRICE_ADJUSTMENT_EXPORT

NUMBER(10,2)

 

Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Export (Factor >= 0)

LOCALLY_CONSTRAINED_EXPORT

NUMBER(1,0)

 

Key for Local_Price_Adjustment_Export: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints

LOCAL_PRICE_ADJUSTMENT_IMPORT

NUMBER(10,2)

 

Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Import (Factor >= 0)

LOCALLY_CONSTRAINED_IMPORT

NUMBER(1,0)

 

Key for Local_Price_Adjustment_Import: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints

LASTCHANGED

DATE

 

Last date and time record changed


Table: PD7DAY_MARKET_SUMMARY

PD7DAY_MARKET_SUMMARY

Name

PD7DAY_MARKET_SUMMARY

Comment

PD7DAY market summary showing calculated gas fuel forecasts


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

INTERVAL_DATETIME

RUN_DATETIME


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

Unique Timestamp Identifier for this study

INTERVAL_DATETIME

DATE

X

The unique identifier for the interval within this study

GPG_FUEL_FORECAST_TJ

NUMBER(15,5)

 

The total gas consumption in TJ


Table: PD7DAY_PRICESOLUTION

PD7DAY_PRICESOLUTION

Name

PD7DAY_PRICESOLUTION

Comment

PD7DAY price solution


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

INTERVAL_DATETIME

INTERVENTION

REGIONID

RUN_DATETIME


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

Unique Timestamp Identifier for this study

INTERVENTION

NUMBER(2,0)

X

Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run.

INTERVAL_DATETIME

DATE

X

The unique identifier for the interval within this study

REGIONID

VARCHAR2(20)

X

Region Identifier

RRP

NUMBER(15,5)

 

Region Reference Price (Energy)

LOWER1SECRRP

NUMBER(15,5)

 

Regional Lower 1Sec Price - RegionSolution element L1Price attribute

LOWER6SECRRP

NUMBER(15,5)

 

Region Reference Price (Lower6Sec)

LOWER60SECRRP

NUMBER(15,5)

 

Region Reference Price (Lower60Sec)

LOWER5MINRRP

NUMBER(15,5)

 

Region Reference Price (Lower5Min)

LOWERREGRRP

NUMBER(15,5)

 

Region Reference Price (LowerReg)

RAISE1SECRRP

NUMBER(15,5)

 

Regional Raise 1Sec Price - R1Price attribute after capping/flooring

RAISE6SECRRP

NUMBER(15,5)

 

Region Reference Price (Raise6Sec)

RAISE60SECRRP

NUMBER(15,5)

 

Region Reference Price (Raise60Sec)

RAISE5MINRRP

NUMBER(15,5)

 

Region Reference Price (Raise5Min)

RAISEREGRRP

NUMBER(15,5)

 

Region Reference Price (RaiseReg)

LASTCHANGED

DATE

 

Last date and time record changed