Table: STPASA_REGIONSOLUTION

STPASA_REGIONSOLUTION

Name

STPASA_REGIONSOLUTION

Comment

STPASA_REGIONSOLUTION shows the results of the regional capacity, maximum surplus reserve and maximum spare capacity evaluations for each period of the study.


Description

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


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

INTERVAL_DATETIME

REGIONID

RUN_DATETIME

RUNTYPE


Index Columns

Name

LASTCHANGED


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

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)

 

Region energy unconstrained MW capacity subject to energy and network security constraints

CONSTRAINEDCAPACITY

NUMBER(12,0)

 

Available capacity (MW) in this region energy constrained MW capacity subject to energy and 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 Generators 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 quantities offered by all Scheduled Generators 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)

 

Aggregate Regional UIGF availability

LOR_SemiScheduledCapacity

NUMBER(12,2)

 

Aggregate Regional UIGF availability for LOR

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)

 

Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW) where the primary fuel source is solar

SS_WIND_UIGF

Number (12,2)

 

Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW) where the primary fuel source is wind

SS_SOLAR_CAPACITY

Number (12,2)

 

Regional aggregated Semi-scheduled UIGF availability where the primary fuel source is solar

SS_WIND_CAPACITY

Number (12,2)

 

Regional aggregated Semi-scheduled UIGF availability where the primary fuel source is wind

SS_SOLAR_CLEARED

Number (12,2)

 

Regional aggregated Semi-scheduled cleared MW where the primary fuel source is solar and StudyRegion = Region

SS_WIND_CLEARED

Number (12,2)

 

Regional aggregated Semi-scheduled cleared MW where the primary fuel source is wind and StudyRegion = Region

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.