|
Name |
|
|
Comment |
P5MIN Blocked Constraints lists any constraints that were blocked in a P5MIN run. If no constraints are blocked, there will be no rows for that 5 minute predispatch run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONSTRAINTID |
|
RUN_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
5-minute Predispatch Run |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
Generic Constraint identifier (synonymous with GenConID) |
|
Name |
|
|
Comment |
The five-minute predispatch (P5Min) is a MMS system providing projected dispatch for 12 Dispatch cycles (one hour). The 5-minute Predispatch cycle runs every 5-minutes to produce a dispatch and pricing schedule to a 5-minute resolution covering the next hour, a total of twelve periods. |
|
P5MIN_CASESOLUTION data is public, so is available to all participants. Source P5MIN_CASESOLUTION updates every 5 minutes. Volume Rows per day: 288 |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
RUN_DATETIME |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Unique Timestamp Identifier for this study |
|
STARTINTERVAL_DATETIME |
VARCHAR2(20) |
|
Date and Time of first interval in study |
|
TOTALOBJECTIVE |
NUMBER(27,10) |
|
The Objective function from the LP |
|
NONPHYSICALLOSSES |
NUMBER(1,0) |
|
Flag to indicate non-physical losses occurred in this study |
|
TOTALAREAGENVIOLATION |
NUMBER(15,5) |
|
Sum of Regional Energy balance violations |
|
TOTALINTERCONNECTORVIOLATION |
NUMBER(15,5) |
|
Sum of Interconnector violations of standing data limits |
|
TOTALGENERICVIOLATION |
NUMBER(15,5) |
|
Sum of Generic Constraint violations |
|
TOTALRAMPRATEVIOLATION |
NUMBER(15,5) |
|
Sum of Unit Ramp Rate violations |
|
TOTALUNITMWCAPACITYVIOLATION |
NUMBER(15,5) |
|
Sum of unit capacity violations |
|
TOTAL5MINVIOLATION |
NUMBER(15,5) |
|
Sum of regional 5 min FCAS violations |
|
TOTALREGVIOLATION |
NUMBER(15,5) |
|
Sum of regional regulation FCAS violations |
|
TOTAL6SECVIOLATION |
NUMBER(15,5) |
|
Sum of regional 6 sec FCAS violations |
|
TOTAL60SECVIOLATION |
NUMBER(15,5) |
|
Sum of regional 60 sec FCAS violations |
|
TOTALENERGYCONSTRVIOLATION |
NUMBER(15,5) |
|
Sum of unit energy constrained violations |
|
TOTALENERGYOFFERVIOLATION |
NUMBER(15,5) |
|
Sum of unit offer violations |
|
TOTALASPROFILEVIOLATION |
NUMBER(15,5) |
|
Sum of unit FCAS profile offer violations |
|
TOTALFASTSTARTVIOLATION |
NUMBER(15,5) |
|
Sum of unit Fast start profile violations |
|
LASTCHANGED |
DATE |
|
Last changed date and time of this record |
|
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. This field has a default value of 0 and is not nullable |
|
Name |
|
|
Comment |
The Five-Minute Pre-Dispatch (P5Min) is a MMS system providing projected dispatch for 12 Dispatch cycles (one hour). The Five-Minute Pre-dispatch cycle runs every 5-minutes to produce a dispatch and pricing schedule to a 5-minute resolution covering the next hour, a total of twelve periods. |
|
P5MIN_CONSTRAINTSOLUTION is public data, so is available to all participants. Source P5MIN_CONSTRAINTSOLUTION updates every five minutes. Volume Rows per day: ~2.3 million |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public |
|
Name |
|
CONSTRAINTID |
|
INTERVAL_DATETIME |
|
RUN_DATETIME |
|
Name |
|
LASTCHANGED |
|
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 |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
Constraint identifier (synonymous with GenConID) |
|
RHS |
NUMBER(15,5) |
|
Right Hand Side value in the capacity evaluation |
|
MARGINALVALUE |
NUMBER(15,5) |
|
Marginal cost of constraint (>0 if binding) |
|
VIOLATIONDEGREE |
NUMBER(15,5) |
|
Amount of Violation (>0 if violating) |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
DUID |
VARCHAR2(20) |
|
DUID to which the Constraint is confidential. Null denotes non-confidential |
|
GENCONID_EFFECTIVEDATE |
DATE |
|
Effective date of the Generic Constraint (ConstraintID). This field is used to track the version of this generic constraint applied in this dispatch interval |
|
GENCONID_VERSIONNO |
NUMBER(22,0) |
|
Version number of the Generic Constraint (ConstraintID). This field is used to track the version of this generic constraint applied in this dispatch interval |
|
LHS |
number(15,5) |
|
Aggregation of the constraints LHS term solution values |
|
INTERVENTION |
Number(2,0) |
|
Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run(INTERVENTION=1). In the event there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0) |
|
Name |
|
|
Comment |
The constraint level FCAS cost / price details for constraint FCAS processor runs. This enhanced output table format is established for the constraint FCAS processor release required for the Frequency Performance Payments (FPP) release. This enhanced output is hierarchical in nature, with the parent *_FCAS_REQ_RUN table holding the details about the triggering case run and time, and the child *_FCAS_REQ_CONSTRAINT table holding the constraint level details of FCAS costs / prices. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BIDTYPE |
|
CONSTRAINTID |
|
INTERVAL_DATETIME |
|
REGIONID |
|
RUN_DATETIME |
|
RUNNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
The run date and time of the 5 minute predispatch case that triggers the constraint FCAS processor run |
|
RUNNO |
NUMBER(5) |
X |
The 5 minute predispatch case run number that has triggers the constraint FCAS processor run |
|
INTERVAL_DATETIME |
DATE |
X |
The 5 minute interval date and time of the 5 minute predispatch interval that was processed by the constraint FCAS processor |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
ConstraintID join to table GenConData |
|
REGIONID |
VARCHAR2(20) |
X |
Region identifier |
|
BIDTYPE |
VARCHAR2(10) |
X |
DUID offered type |
|
LHS |
NUMBER(15,5) |
|
Constraints summed LHS - aggregate LHS Solution values from the physical run from the P5MIN_CONSTRAINTSOLUTION table |
|
RHS |
NUMBER(15,5) |
|
Constraints RHS value used in the solution - may be either dynamic (calculated) or static from the physical run from the P5MIN_CONSTRAINTSOLUTION table |
|
MARGINALVALUE |
NUMBER(15,5) |
|
Shadow price of constraint from the P5MIN_CONSTRAINTSOLUTION table from the physical run. |
|
RRP |
NUMBER(15,5) |
|
Bid type prices for the region coming from the pricing run of the P5MIN_REGIONSOLUTION table |
|
REGIONAL_ENABLEMENT |
NUMBER(15,5) |
|
The dispatched MW for the bid type inside the region from the physical run of the P5MIN_REGIONSOLUTION table |
|
CONSTRAINT_ENABLEMENT |
NUMBER(15,5) |
|
MW enabled for this bid type within the constraint |
|
REGION_BASE_COST |
NUMBER(18,8) |
|
The regional payment allocated to the constraint for the interval pro- rated based on marginal value ratios over the binding constraints for that service in that region (this is an intermediate calculation to get to the base cost) |
|
BASE_COST |
NUMBER(18,8) |
|
The base cost of the constraint, before the regulation/contingency split |
|
ADJUSTED_COST |
NUMBER(18,8) |
|
The adjusted cost of the constraint for this service, after the regulation/contingency split |
|
P_REGULATION |
NUMBER(18,8) |
|
The adjusted marginal value of the constraint for FPP recovery (blank for constraints without REG terms) |
|
Name |
|
|
Comment |
The constraint FCAS processor run details. This enhanced output table format is established for the constraint FCAS processor release required for the Frequency Performance Payments (FPP) release. This enhanced output is hierarchical in nature, with the parent *_FCAS_REQ_RUN table holding the details about the triggering case run and time, and the child *_FCAS_REQ_CONSTRAINT table holding the constraint level details of FCAS costs / prices. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
RUN_DATETIME |
|
RUNNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
The run date and time of the 5 minute predispatch case that triggers the constraint FCAS processor run |
|
RUNNO |
NUMBER(5) |
X |
The 5 minute predispatch case run number that has triggers the constraint FCAS processor run |
|
LASTCHANGED |
DATE |
|
The last time the constraint FCAS processor was executed for this case run time. |
|
Name |
|
|
Comment |
5-minute Predispatch constraint tracking for Regional FCAS recovery |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BIDTYPE |
|
CONSTRAINTID |
|
INTERVAL_DATETIME |
|
REGIONID |
|
RUN_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
First interval of the 5-minute Predispatch case |
|
INTERVAL_DATETIME |
DATE |
X |
Datetime of the 5-minute Predispatch interval |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
ConstraintID Join to table GenConData |
|
REGIONID |
VARCHAR2(20) |
X |
Region Identifier |
|
BIDTYPE |
VARCHAR2(10) |
X |
DUID offered type |
|
INTERVENTION |
NUMBER(2,0) |
|
Intervention flag |
|
CONSTRAINT_EFFECTIVEDATE |
DATE |
|
Constraint EffectiveDate Join to table GenConData |
|
CONSTRAINT_VERSIONNO |
NUMBER(3,0) |
|
Constraint Version number Join to table GenConData |
|
MARGINALVALUE |
NUMBER(18,8) |
|
Marginal $ value for energy |
|
BASE_COST |
NUMBER(18,8) |
|
The base cost of the constraint for this service, before the regulation/contingency split |
|
ADJUSTED_COST |
NUMBER(18,8) |
|
The adjusted cost of the constraint for this service, after the regulation/contingency split |
|
ESTIMATED_CMPF |
NUMBER(18,8) |
|
An estimated value for the constraint CMPF, based on 5- minute Predispatch data |
|
ESTIMATED_CRMPF |
NUMBER(18,8) |
|
An estimated value for the constraint CRMPF, based on 5-minute Predispatch data |
|
RECOVERY_FACTOR_CMPF |
NUMBER(18,8) |
|
Estimated recovery factor for CMPF based recovery |
|
RECOVERY_FACTOR_CRMPF |
NUMBER(18,8) |
|
Estimated recovery for CRMPF based recovery |
|
LASTCHANGED |
DATE |
|
Last changed date for the record |
|
Name |
|
|
Comment |
The five-minute predispatch (P5Min) is a MMS system providing projected dispatch for 12 Dispatch cycles (one hour). The 5-minute Predispatch cycle runs every 5-minutes to produce a dispatch and pricing schedule to a 5-minute resolution covering the next hour, a total of twelve periods. |
|
P5MIN_INTERCONNECTORSOLN is public data, so is available to all participants. Source P5MIN_INTERCONNECTORSOLN updates every 5 minutes. Volume Rows per day: 1440 Based on 200 interconnector/binding constraints per interval |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERCONNECTORID |
|
INTERVAL_DATETIME |
|
RUN_DATETIME |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Unique Timestamp Identifier for this study |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Interconnector identifier |
|
INTERVAL_DATETIME |
DATE |
X |
The unique identifier for the interval within this study |
|
METEREDMWFLOW |
NUMBER(15,5) |
|
SCADA MW Flow measured at Run start. For periods subsequent to the first period of a P5MIN run, this value represents the cleared target for the previous period of that P5MIN 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 |
|
MNSP |
NUMBER(1,0) |
|
Flag indicating MNSP registration |
|
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 |
|
EXPORTGENCONID |
VARCHAR2(20) |
|
Generic Constraint setting the export limit |
|
IMPORTGENCONID |
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. |
|
LASTCHANGED |
DATE |
|
Last changed date of this record |
|
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 |
|
INTERVENTION |
Number(2,0) |
|
Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run (INTERVENTION=1). In the event there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0) |
|
Name |
|
|
Comment |
Price Sensitivies for 5MinPD solution. New solution every 5 minutes. Current Scenarios defined in P5MIN_SCENARIODEMANDTRK/P5MIN_SCENARIODEMAND |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERCONNECTORID |
|
INTERVAL_DATETIME |
|
RUN_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Definitive Run from which this solution derives |
|
INTERCONNECTORID |
VARCHAR2(20) |
X |
Interconnector identifier |
|
INTERVAL_DATETIME |
DATE |
X |
The unique identifier for the interval within this study |
|
INTERVENTION |
NUMBER(1,0) |
X |
Flag to indicate if this result set was sourced from the pricing run (INTERVENTION=0) or the physical run (INTERVENTION=1). In the event there is not intervention in the market, both pricing and physical runs correspond to INTERVENTION=0) |
|
INTERVENTION_ACTIVE |
NUMBER(1,0) |
|
Flag to indicate if the sensitivity run contains an active intervention constraint: 0 = No, 1 = Yes |
|
MWFLOW1 |
NUMBER(15,5) |
|
MW Flow value. Flow1 = MW flow for given Interconnector for Scenario 1 |
|
MWFLOW2 |
NUMBER(15,5) |
|
MW Flow value. Flow2 = MW flow for given Interconnector for Scenario 2 |
|
MWFLOW3 |
NUMBER(15,5) |
|
MW Flow value. Flow3 = MW flow for given Interconnector for Scenario 3 |
|
MWFLOW4 |
NUMBER(15,5) |
|
MW Flow value. Flow4 = MW flow for given Interconnector for Scenario 4 |
|
MWFLOW5 |
NUMBER(15,5) |
|
MW Flow value. Flow5 = MW flow for given Interconnector for Scenario 5 |
|
MWFLOW6 |
NUMBER(15,5) |
|
MW Flow value. Flow6 = MW flow for given Interconnector for Scenario 6 |
|
MWFLOW7 |
NUMBER(15,5) |
|
MW Flow value. Flow7 = MW flow for given Interconnector for Scenario 7 |
|
MWFLOW8 |
NUMBER(15,5) |
|
MW Flow value. Flow8 = MW flow for given Interconnector for Scenario 8 |
|
MWFLOW9 |
NUMBER(15,5) |
|
MW Flow value. Flow9 = MW flow for given Interconnector for Scenario 9 |
|
MWFLOW10 |
NUMBER(15,5) |
|
MW Flow value. Flow10 = MW flow for given Interconnector for Scenario 10 |
|
MWFLOW11 |
NUMBER(15,5) |
|
MW Flow value. Flow11 = MW flow for given Interconnector for Scenario 11 |
|
MWFLOW12 |
NUMBER(15,5) |
|
MW Flow value. Flow12 = MW flow for given Interconnector for Scenario 12 |
|
MWFLOW13 |
NUMBER(15,5) |
|
MW Flow value. Flow13 = MW flow for given Interconnector for Scenario 13 |
|
MWFLOW14 |
NUMBER(15,5) |
|
MW Flow value. Flow14 = MW flow for given Interconnector for Scenario 14 |
|
MWFLOW15 |
NUMBER(15,5) |
|
MW Flow value. Flow15 = MW flow for given Interconnector for Scenario 15 |
|
MWFLOW16 |
NUMBER(15,5) |
|
MW Flow value. Flow16 = MW flow for given Interconnector for Scenario 16 |
|
MWFLOW17 |
NUMBER(15,5) |
|
MW Flow value. Flow17 = MW flow for given Interconnector for Scenario 17 |
|
MWFLOW18 |
NUMBER(15,5) |
|
MW Flow value. Flow18 = MW flow for given Interconnector for Scenario 18 |
|
MWFLOW19 |
NUMBER(15,5) |
|
MW Flow value. Flow19 = MW flow for given Interconnector for Scenario 19 |
|
MWFLOW20 |
NUMBER(15,5) |
|
MW Flow value. Flow20 = MW flow for given Interconnector for Scenario 20 |
|
MWFLOW21 |
NUMBER(15,5) |
|
MW Flow value. Flow21 = MW flow for given Interconnector for Scenario 21 |
|
MWFLOW22 |
NUMBER(15,5) |
|
MW Flow value. Flow22 = MW flow for given Interconnector for Scenario 22 |
|
MWFLOW23 |
NUMBER(15,5) |
|
MW Flow value. Flow23 = MW flow for given Interconnector for Scenario 23 |
|
MWFLOW24 |
NUMBER(15,5) |
|
MW Flow value. Flow24 = MW flow for given Interconnector for Scenario 24 |
|
MWFLOW25 |
NUMBER(15,5) |
|
MW Flow value. Flow25 = MW flow for given Interconnector for Scenario 25 |
|
MWFLOW26 |
NUMBER(15,5) |
|
MW Flow value. Flow26 = MW flow for given Interconnector for Scenario 26 |
|
MWFLOW27 |
NUMBER(15,5) |
|
MW Flow value. Flow27 = MW flow for given Interconnector for Scenario 27 |
|
MWFLOW28 |
NUMBER(15,5) |
|
MW Flow value. Flow28 = MW flow for given Interconnector for Scenario 28 |
|
MWFLOW29 |
NUMBER(15,5) |
|
MW Flow value. Flow29 = MW flow for given Interconnector for Scenario 29 |
|
MWFLOW30 |
NUMBER(15,5) |
|
MW Flow value. Flow30 = MW flow for given Interconnector for Scenario 30 |
|
MWFLOW31 |
NUMBER(15,5) |
|
MW Flow value. Flow31 = MW flow for given Interconnector for Scenario 31 |
|
MWFLOW32 |
NUMBER(15,5) |
|
MW Flow value. Flow32 = MW flow for given Interconnector for Scenario 32 |
|
MWFLOW33 |
NUMBER(15,5) |
|
MW Flow value. Flow33 = MW flow for given Interconnector for Scenario 33 |
|
MWFLOW34 |
NUMBER(15,5) |
|
MW Flow value. Flow34 = MW flow for given Interconnector for Scenario 34 |
|
MWFLOW35 |
NUMBER(15,5) |
|
MW Flow value. Flow35 = MW flow for given Interconnector for Scenario 35 |
|
MWFLOW36 |
NUMBER(15,5) |
|
MW Flow value. Flow36 = MW flow for given Interconnector for Scenario 36 |
|
MWFLOW37 |
NUMBER(15,5) |
|
MW Flow value. Flow37 = MW flow for given Interconnector for Scenario 37 |
|
MWFLOW38 |
NUMBER(15,5) |
|
MW Flow value. Flow38 = MW flow for given Interconnector for Scenario 38 |
|
MWFLOW39 |
NUMBER(15,5) |
|
MW Flow value. Flow39 = MW flow for given Interconnector for Scenario 39 |
|
MWFLOW40 |
NUMBER(15,5) |
|
MW Flow value. Flow40 = MW flow for given Interconnector for Scenario 40 |
|
MWFLOW41 |
NUMBER(15,5) |
|
MW Flow value. Flow41 = MW flow for given Interconnector for Scenario 41 |
|
MWFLOW42 |
NUMBER(15,5) |
|
MW Flow value. Flow42 = MW flow for given Interconnector for Scenario 42 |
|
MWFLOW43 |
NUMBER(15,5) |
|
MW Flow value. Flow43 = MW flow for given Interconnector for Scenario 43 |
|
LASTCHANGED |
DATE |
|
Timestamp when this record was last modified |
|
Name |
|
|
Comment |
Sets out local pricing offsets associated with each DUID connection point for each dispatch period |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DUID |
|
INTERVAL_DATETIME |
|
RUN_DATETIME |
|
Name |
|
RUN_DATETIME |
|
INTERVAL_DATETIME |
|
DUID |
|
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 |
|
DUID |
VARCHAR2(20) |
X |
Dispatchable unit identifier |
|
LOCAL_PRICE_ADJUSTMENT |
NUMBER(10, 2) |
|
Aggregate Constraint contribution cost of this unit: Sum(MarginalValue x Factor) for all relevant Constraints |
|
LOCALLY_CONSTRAINED |
NUMBER(1,0) |
|
Key for Local_Price_Adjustment: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints |
|
Name |
|
|
Comment |
Price Sensitivies for 5MinPD solution. New solution every 5 minutes. Current Scenarios defined in P5MIN_SCENARIODEMANDTRK/P5MIN_SCENARIODEMAND |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERVAL_DATETIME |
|
REGIONID |
|
RUN_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Definitive Run from which this solution derives |
|
REGIONID |
VARCHAR2(20) |
X |
Region |
|
INTERVAL_DATETIME |
DATE |
X |
The unique identifier for the interval within this study |
|
INTERVENTION |
NUMBER(1,0) |
X |
Whether an Intervention constraint was defined in this run |
|
INTERVENTION_ACTIVE |
NUMBER(1,0) |
|
Flag to indicate if the sensitivity run contains an active intervention constraint: 0 = No, 1 = Yes |
|
RRP1 |
NUMBER(15,5) |
|
Regional Reference price for scenario 1 |
|
RRP2 |
NUMBER(15,5) |
|
Regional Reference price for scenario 2 |
|
RRP3 |
NUMBER(15,5) |
|
Regional Reference price for scenario 3 |
|
RRP4 |
NUMBER(15,5) |
|
Regional Reference price for scenario 4 |
|
RRP5 |
NUMBER(15,5) |
|
Regional Reference price for scenario 5 |
|
RRP6 |
NUMBER(15,5) |
|
Regional Reference price for scenario 6 |
|
RRP7 |
NUMBER(15,5) |
|
Regional Reference price for scenario 7 |
|
RRP8 |
NUMBER(15,5) |
|
Regional Reference price for scenario 8 |
|
RRP9 |
NUMBER(15,5) |
|
Regional Reference price for scenario 9 |
|
RRP10 |
NUMBER(15,5) |
|
Regional Reference price for scenario 10 |
|
RRP11 |
NUMBER(15,5) |
|
Regional Reference price for scenario 11 |
|
RRP12 |
NUMBER(15,5) |
|
Regional Reference price for scenario 12 |
|
RRP13 |
NUMBER(15,5) |
|
Regional Reference price for scenario 13 |
|
RRP14 |
NUMBER(15,5) |
|
Regional Reference price for scenario 14 |
|
RRP15 |
NUMBER(15,5) |
|
Regional Reference price for scenario 15 |
|
RRP16 |
NUMBER(15,5) |
|
Regional Reference price for scenario 16 |
|
RRP17 |
NUMBER(15,5) |
|
Regional Reference price for scenario 17 |
|
RRP18 |
NUMBER(15,5) |
|
Regional Reference price for scenario 18 |
|
RRP19 |
NUMBER(15,5) |
|
Regional Reference price for scenario 19 |
|
RRP20 |
NUMBER(15,5) |
|
Regional Reference price for scenario 20 |
|
RRP21 |
NUMBER(15,5) |
|
Regional Reference price for scenario 21 |
|
RRP22 |
NUMBER(15,5) |
|
Regional Reference price for scenario 22 |
|
RRP23 |
NUMBER(15,5) |
|
Regional Reference price for scenario 23 |
|
RRP24 |
NUMBER(15,5) |
|
Regional Reference price for scenario 24 |
|
RRP25 |
NUMBER(15,5) |
|
Regional Reference price for scenario 25 |
|
RRP26 |
NUMBER(15,5) |
|
Regional Reference price for scenario 26 |
|
RRP27 |
NUMBER(15,5) |
|
Regional Reference price for scenario 27 |
|
RRP28 |
NUMBER(15,5) |
|
Regional Reference price for scenario 28 |
|
RRP29 |
NUMBER(15,5) |
|
Regional Reference price for scenario 29 |
|
RRP30 |
NUMBER(15,5) |
|
Regional Reference price for scenario 30 |
|
RRP31 |
NUMBER(15,5) |
|
Regional Reference price for scenario 31 |
|
RRP32 |
NUMBER(15,5) |
|
Regional Reference price for scenario 32 |
|
RRP33 |
NUMBER(15,5) |
|
Regional Reference price for scenario 33 |
|
RRP34 |
NUMBER(15,5) |
|
Regional Reference price for scenario 34 |
|
RRP35 |
NUMBER(15,5) |
|
Regional Reference price for scenario 35 |
|
RRP36 |
NUMBER(15,5) |
|
Regional Reference price for scenario 36 |
|
RRP37 |
NUMBER(15,5) |
|
Regional Reference price for scenario 37 |
|
RRP38 |
NUMBER(15,5) |
|
Regional Reference price for scenario 38 |
|
RRP39 |
NUMBER(15,5) |
|
Regional Reference price for scenario 39 |
|
RRP40 |
NUMBER(15,5) |
|
Regional Reference price for scenario 40 |
|
RRP41 |
NUMBER(15,5) |
|
Regional Reference price for scenario 41 |
|
RRP42 |
NUMBER(15,5) |
|
Regional Reference price for scenario 42 |
|
RRP43 |
NUMBER(15,5) |
|
Regional Reference price for scenario 43 |
|
LASTCHANGED |
DATE |
|
Timestamp when this record was last modified |
|
Name |
|
|
Comment |
The five-minute predispatch (P5Min) is a MMS system providing projected dispatch for 12 Dispatch cycles (one hour). The 5-minute Predispatch cycle runs every 5-minutes to produce a dispatch and pricing schedule to a 5-minute resolution covering the next hour, a total of twelve periods. |
|
P5MIN_REGIONSOLUTION is public data, so is available to all participants. Source P5MIN_REGIONSOLUTION updates every 5 minutes. Volume Rows per day: 1440 |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERVAL_DATETIME |
|
REGIONID |
|
RUN_DATETIME |
|
Name |
|
LASTCHANGED |
|
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 |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
RRP |
NUMBER(15,5) |
|
Region Reference Price (Energy) |
|
ROP |
NUMBER(15,5) |
|
Region Override Price (Energy) |
|
EXCESSGENERATION |
NUMBER(15,5) |
|
Total Energy Imbalance (MW) |
|
RAISE6SECRRP |
NUMBER(15,5) |
|
Region Reference Price (Raise6Sec) |
|
RAISE6SECROP |
NUMBER(15,5) |
|
Original regional price (Raise6Sec) |
|
RAISE60SECRRP |
NUMBER(15,5) |
|
Region Reference Price (Raise60Sec) |
|
RAISE60SECROP |
NUMBER(15,5) |
|
Original regional price (Raise60Sec) |
|
RAISE5MINRRP |
NUMBER(15,5) |
|
Region Reference Price (Raise5Min) |
|
RAISE5MINROP |
NUMBER(15,5) |
|
Original regional price (Raise5Min) |
|
RAISEREGRRP |
NUMBER(15,5) |
|
Region Reference Price (RaiseReg) |
|
RAISEREGROP |
NUMBER(15,5) |
|
Original regional price (RaiseReg) |
|
LOWER6SECRRP |
NUMBER(15,5) |
|
Region Reference Price (Lower6Sec) |
|
LOWER6SECROP |
NUMBER(15,5) |
|
Original regional price (Lower6Sec) |
|
LOWER60SECRRP |
NUMBER(15,5) |
|
Region Reference Price (Lower60Sec) |
|
LOWER60SECROP |
NUMBER(15,5) |
|
Original regional price (Lower60Sec) |
|
LOWER5MINRRP |
NUMBER(15,5) |
|
Region Reference Price (Lower5Min) |
|
LOWER5MINROP |
NUMBER(15,5) |
|
Original regional price (Lower5Min) |
|
LOWERREGRRP |
NUMBER(15,5) |
|
Region Reference Price (LowerReg) |
|
LOWERREGROP |
NUMBER(15,5) |
|
Original regional price (LowerReg) |
|
TOTALDEMAND |
NUMBER(15,5) |
|
Regional Demand - NB NOT net of Interconnector flows or Loads |
|
AVAILABLEGENERATION |
NUMBER(15,5) |
|
Regional Available generation |
|
AVAILABLELOAD |
NUMBER(15,5) |
|
Regional Available Load |
|
DEMANDFORECAST |
NUMBER(15,5) |
|
Predicted change in regional demand for this interval |
|
DISPATCHABLEGENERATION |
NUMBER(15,5) |
|
Regional Generation Dispatched |
|
DISPATCHABLELOAD |
NUMBER(15,5) |
|
Regional Load Dispatched |
|
NETINTERCHANGE |
NUMBER(15,5) |
|
Net interconnector Flows |
|
LOWER5MINDISPATCH |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 5 min MW dispatch |
|
LOWER5MINIMPORT |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 5 min MW imported |
|
LOWER5MINLOCALDISPATCH |
NUMBER(15,5) |
|
Lower 5 min local dispatch |
|
LOWER5MINLOCALREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 5 min local requirement |
|
LOWER5MINREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 5 min total requirement |
|
LOWER60SECDISPATCH |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 60 sec MW dispatch |
|
LOWER60SECIMPORT |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 60 sec MW imported |
|
LOWER60SECLOCALDISPATCH |
NUMBER(15,5) |
|
Lower 60 sec local dispatch |
|
LOWER60SECLOCALREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 60 sec local requirement |
|
LOWER60SECREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 60 sec total requirement |
|
LOWER6SECDISPATCH |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 6 sec MW dispatch |
|
LOWER6SECIMPORT |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 6 sec MW imported |
|
LOWER6SECLOCALDISPATCH |
NUMBER(15,5) |
|
Lower 6 sec local dispatch |
|
LOWER6SECLOCALREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 6 sec local requirement |
|
LOWER6SECREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 6 sec total requirement |
|
RAISE5MINDISPATCH |
NUMBER(15,5) |
|
Not used since Dec 2003. Total Raise 5 min MW dispatch |
|
RAISE5MINIMPORT |
NUMBER(15,5) |
|
Not used since Dec 2003. Raise 5 min MW imported |
|
RAISE5MINLOCALDISPATCH |
NUMBER(15,5) |
|
Raise 5 min local dispatch |
|
RAISE5MINLOCALREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Raise 5 min local requirement |
|
RAISE5MINREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Raise 5 min total requirement |
|
RAISE60SECDISPATCH |
NUMBER(15,5) |
|
Not used since Dec 2003. Raise 60 sec MW dispatch |
|
|
|