| 
 Name  | 
|
| 
 Comment  | 
 PD7DAY case solution table  | 
| 
 Name  | 
 Comment  | 
 Value  | 
| 
 Visibility  | 
 
  | 
 Public  | 
| 
 Name  | 
| 
 RUN_DATETIME  | 
| 
 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  | 
| 
 Name  | 
|
| 
 Comment  | 
 PD7DAY constraint solution  | 
| 
 Name  | 
 Comment  | 
 Value  | 
| 
 Visibility  | 
 
  | 
 Public  | 
| 
 Name  | 
| 
 CONSTRAINTID  | 
| 
 INTERVAL_DATETIME  | 
| 
 INTERVENTION  | 
| 
 RUN_DATETIME  | 
| 
 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  | 
| 
 Name  | 
|
| 
 Comment  | 
 PD7DAY intereconnector solution  | 
| 
 Name  | 
 Comment  | 
 Value  | 
| 
 Visibility  | 
 
  | 
 Public  | 
| 
 Name  | 
| 
 INTERCONNECTORID  | 
| 
 INTERVAL_DATETIME  | 
| 
 INTERVENTION  | 
| 
 RUN_DATETIME  | 
| 
 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  | 
| 
 Name  | 
|
| 
 Comment  | 
 PD7DAY market summary showing calculated gas fuel forecasts  | 
| 
 Name  | 
 Comment  | 
 Value  | 
| 
 Visibility  | 
 
  | 
 Public  | 
| 
 Name  | 
| 
 INTERVAL_DATETIME  | 
| 
 RUN_DATETIME  | 
| 
 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  | 
| 
 Name  | 
|
| 
 Comment  | 
 PD7DAY price solution  | 
| 
 Name  | 
 Comment  | 
 Value  | 
| 
 Visibility  | 
 
  | 
 Public  | 
| 
 Name  | 
| 
 INTERVAL_DATETIME  | 
| 
 INTERVENTION  | 
| 
 REGIONID  | 
| 
 RUN_DATETIME  | 
| 
 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  | 
| 
 BDU_INITIAL_ENERGY_STORAGE  | 
 NUMBER(15,5)  | 
 
  | 
 Energy Storage for BDU at the start of the interval(MWh) - Region Aggregated  | 
| 
 DECGEN_INITIAL_ENERGY_STORAGE  | 
 NUMBER(15,5)  | 
 
  | 
 Energy storage for Daily Energy Constrained Scheduled Generating Units at the start of the interval(MWh) - Region Aggregated  | 
  | 
  | 
  |