Table: PDPASA_REGIONSOLUTION

PDPASA_REGIONSOLUTION

Name

PDPASA_REGIONSOLUTION

Comment

The PDPASA region solution data


Description

PDPASA_REGIONSOLUTION is public so is available to all participants.

Source

PDPASA_REGIONSOLUTION is updated each PDPASA run (i.e. half-hourly).

Volume

Rows per day: 32000

Notes

LRC Determination

SURPLUSRESERVE is the surplus reserve in a region based on meeting the demand plus the reserve requirement in all regions simultaneously. Note that any surplus above the network restrictions and system reserve requirements is reported in the region it is generated, thus a surplus of zero can mean that a region is importing to meet a requirement or that it has exported all surplus to meet an adjacent region’s requirement.

 

The PASA processes also calculate a regionally optimised surplus called the Maximum LRC Surplus (MAXSURPLUSRESERVE) being a figure on how much generation could be brought to this region subject to meeting requirements in other regions.

 

LOR Determination

MAXSPARECAPACITY is a regionally optimised figure representing the surplus generation able to be brought to a region subject to meeting the demand in all other regions.

 

Participants are directed to the first half hour of the Predispatch PASA (PDPASA) reports as NEMMCO's latest reserve determination for a given half hour.


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

Case identifier by the time the case was run

INTERVAL_DATETIME

DATE

X

End date time of the interval

REGIONID

VARCHAR2(10)

X

Region identifier

DEMAND10

NUMBER(12,2)

 

10% Probability of Exceedance demand forecast

DEMAND50

NUMBER(12,2)

 

50% Probability of Exceedance demand forecast

DEMAND90

NUMBER(12,2)

 

90% Probability of Exceedance demand forecast

RESERVEREQ

NUMBER(12,2)

 

Region reserve requirement (MW)

CAPACITYREQ

NUMBER(12,2)

 

Capacity required to meet the demand and reserve levels in the capacity adequacy assessment.

ENERGYREQDEMAND50

NUMBER(12,2)

 

Energy (GWh) required for this energy block based on the 50% probability of exceedance demand. Listed in the first interval of the energy block.

UNCONSTRAINEDCAPACITY

NUMBER(12,0)

 

Aggregate generator capability from Non Energy Constrained plant including restrictions due to network constraints from the capacity adequacy (LRC) assessment.

CONSTRAINEDCAPACITY

NUMBER(12,0)

 

Aggregate generator capability from Energy Constrained plant including restrictions due to network constraints

NETINTERCHANGEUNDERSCARCITY

NUMBER(12,2)

 

Net interconnector flow from the region for this interval from the capacity adequacy (LRC) assessment.

SURPLUSCAPACITY

NUMBER(12,2)

 

Surplus capacity (MW) above the demand, scheduled load and net interchange in this region from the capacity adequacy (LRC) assessment.

SURPLUSRESERVE

NUMBER(12,2)

 

Surplus reserve (MW) above the demand, scheduled load, net interchange and reserve requirement in this region from the capacity adequacy (LRC) assessment.

RESERVECONDITION

NUMBER(1,0)

 

Low Reserve Condition (LRC) flag for this region in this interval (1 - LRC, 0 - No LRC)

MAXSURPLUSRESERVE

NUMBER(12,2)

 

Maximum surplus reserve (MW) above the demand + reserve requirement able to be sourced to this region while meeting demand + reserve requirements in other regions.

MAXSPARECAPACITY

NUMBER(12,2)

 

Maximum spare capacity (MW) above the demand able to be sourced to this region while meeting demands in other regions.

LORCONDITION

NUMBER(1,0)

 

Lack of Reserve Condition (LOR) flag for this region and interval (3 = LOR3, 2 = LOR2, 1 = LOR1, 0 = No LOR)

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

 

Date time the record was created or modified changed

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.