|
Name |
|
|
Comment |
STPASA_REGIONSOLUTION shows the results of the regional capacity, maximum surplus reserve and maximum spare capacity evaluations for each period of the study. |
|
STPASA_REGIONSOLUTION is public so is available to all participants. Source STPASA_REGIONSOLUTION is updated each STPASA run (i.e every 2 hours). Volume Rows per day: 480 Mb per month: 8 |
|
Name |
|
INTERVAL_DATETIME |
|
REGIONID |
|
RUN_DATETIME |
|
RUNTYPE |
|
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 |
|
DEMAND10 |
NUMBER(12,2) |
|
Input value for 10% probability demand |
|
DEMAND50 |
NUMBER(12,2) |
|
Input value for 50% probability demand |
|
DEMAND90 |
NUMBER(12,2) |
|
Input value for 90% probability demand |
|
RESERVEREQ |
NUMBER(12,2) |
|
Input reserve requirement |
|
CAPACITYREQ |
NUMBER(12,2) |
|
Demand + Reserve Requirement |
|
ENERGYREQDEMAND50 |
NUMBER(12,2) |
|
Sum of: (Region Period Demand - given Demand50)/Period (sum by trading day, entered in first period of trading day, GWh) |
|
UNCONSTRAINEDCAPACITY |
NUMBER(12,0) |
|
In a Region, capacity from generation/Load with no Daily Energy Constraint, subject to network security constraints |
|
CONSTRAINEDCAPACITY |
NUMBER(12,0) |
|
In a Region, capacity from generation/Load with non-zero Daily Energy Constraint, subject to network security constraints |
|
NETINTERCHANGEUNDERSCARCITY |
NUMBER(12,2) |
|
Net export in MW out of this region in the capacity adequacy evaluation. Export if > 0, Import if < 0. |
|
SURPLUSCAPACITY |
NUMBER(12,2) |
|
Regional surplus capacity MW, +/- values indicate surplus/deficit capacity respectively |
|
SURPLUSRESERVE |
NUMBER(12,2) |
|
Regional reserve surplus. +/- values indicate surplus/deficit reserve respectively |
|
RESERVECONDITION |
NUMBER(1,0) |
|
The regional reserve condition: 0 Adequate, 1 LRC |
|
MAXSURPLUSRESERVE |
NUMBER(12,2) |
|
The Maximum Surplus Reserve evaluated for this region in this period. Calculated for each region in turn. |
|
MAXSPARECAPACITY |
NUMBER(12,2) |
|
The Maximum Spare Capacity evaluated for this region in this period. Calculated for each region in turn. |
|
LORCONDITION |
NUMBER(1,0) |
|
The LOR Condition determined from the Maximum Spare Capacity value: 0 - no condition, 1 - LOR1 condition, 2 - LOR2 condition, 3 - LOR3 condition |
|
AGGREGATECAPACITYAVAILABLE |
NUMBER(12,2) |
|
Sum of MAXAVAIL quantities offered by all Scheduled units and Availability of all semi-scheduled units limited by MAXAVAIL in a given Region for a given PERIODID |
|
AGGREGATESCHEDULEDLOAD |
NUMBER(12,2) |
|
Sum of MAXAVAIL quantities bid by of all Scheduled Loads in a given Region for a given PERIODID. |
|
LASTCHANGED |
DATE |
|
Last changed date of this record |
|
AGGREGATEPASAAVAILABILITY |
NUMBER(12,0) |
|
Sum of PASAAVAILABILITY for all scheduled generating units and the Unconstrained Intermittent Generation Forecasts (UIGF) for all semi-scheduled generating units in a given Region for a given PERIODID. |
|
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Values are RELIABILITY_LRC, OUTAGE_LRC and LOR. |
|
ENERGYREQDEMAND10 |
NUMBER(12,2) |
|
Energy (GWh) required for this energy block based on the 10% probability of exceedance demand. Listed in the first interval of the energy block |
|
CALCULATEDLOR1LEVEL |
NUMBER(16,6) |
|
Region Reserve Level for LOR1 used. Can be static value or calculated value if an interconnector is a credible contingency |
|
CALCULATEDLOR2LEVEL |
NUMBER(16,6) |
|
Region Reserve Level for LOR2 used. Can be static value or calculated value if an interconnector is a credible contingency |
|
MSRNETINTERCHANGEUNDERSCARCITY |
NUMBER(12,2) |
|
Net interconnector flow from the region for this interval from the MSR assessment |
|
LORNETINTERCHANGEUNDERSCARCITY |
NUMBER(12,2) |
|
Net interconnector flow from the region for this interval from the LOR assessment |
|
TOTALINTERMITTENTGENERATION |
NUMBER(15,5) |
|
Allowance made for non-scheduled generation in the demand forecast (MW). |
|
DEMAND_AND_NONSCHEDGEN |
NUMBER(15,5) |
|
Sum of Cleared Scheduled generation, imported generation (at the region boundary) and allowances made for non-scheduled generation (MW). |
|
UIGF |
NUMBER(12,2) |
|
Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW). |
|
SEMISCHEDULEDCAPACITY |
NUMBER(12,2) |
|
Constrained generation forecast for semi-scheduled units for the region. For RELIABILITY_LRC run semi-scheduled generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run semi-scheduled generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
LOR_SEMISCHEDULEDCAPACITY |
NUMBER(12,2) |
|
Constrained generation forecast for semi-scheduled units for the region for the LOR run type. Semi-scheduled generation is constrained by both System Normal and Outage constraints, and incorporate MAXAVAIL limits. |
|
LCR |
NUMBER(16,6) |
|
Largest Credible Risk. MW value for highest credible contingency |
|
LCR2 |
NUMBER(16,6) |
|
Two Largest Creditable Risks. MW value for highest two credible contingencies. |
|
FUM |
NUMBER(16,6) |
|
Forecasting Uncertainty Measure. MW value of reserve calculated as defined in the Reserve Level Declaration Guidelines |
|
SS_SOLAR_UIGF |
Number(12,2) |
|
Unconstrained Intermittent Generation Forecast for solar for the region. For RELIABILITY_LRC and OUTAGE_LRC run this is the POE90 forecast (determined by LRCUIGFOption in CaseSolution). For LOR run this is the POE50 forecast |
|
SS_WIND_UIGF |
Number (12,2) |
|
Unconstrained Intermittent Generation Forecast for wind for the region. For RELIABILITY_LRC and OUTAGE_LRC run this is the POE90 forecast (determined by LRCUIGFOption in CaseSolution). For LOR run this is the POE50 forecast |
|
SS_SOLAR_CAPACITY |
Number (12,2) |
|
Constrained generation forecast for solar for the region. For RELIABILITY_LRC run solar generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run solar generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
SS_WIND_CAPACITY |
Number (12,2) |
|
Constrained generation forecast for wind for the region. For RELIABILITY_LRC run wind generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run wind generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
SS_SOLAR_CLEARED |
Number (12,2) |
|
Constrained generation forecast for solar for the region. For RELIABILITY_LRC run solar generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run solar generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
SS_WIND_CLEARED |
Number (12,2) |
|
Constrained generation forecast for wind for the region. For RELIABILITY_LRC run wind generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run wind generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
WDR_AVAILABLE |
NUMBER(12,2) |
|
Regional aggregated Wholesale Demand Response (WDR) availability in MW. |
|
WDR_PASAAVAILABLE |
NUMBER(12,2) |
|
Regional aggregated Wholesale Demand Response (WDR) PASA availability in MW. |
|
WDR_CAPACITY |
NUMBER(12,2) |
|
Regional aggregated Wholesale Demand Response (WDR) capacity in MW. |
|
|
|