Table: MTPASA_REGIONAVAILABILITY

MTPASA_REGIONAVAILABILITY

Name

MTPASA_REGIONAVAILABILITY

Comment

Stores the Region-aggregate offered PASA Availability of scheduled generators for each day over the Medium Term PASA period. The data in this table is an aggregate of input data to the MT PASA process it is not part of the MTPASA solution. The aggregate availability does not reflect any energy limitations in the MT PASA offers.


Description

MTPASA_REGIONAVAILABILITY is public data.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

DAY

PUBLISH_DATETIME

REGIONID


Content

Name

Data Type

Mandatory

Comment

PUBLISH_DATETIME

DATE

X

Date Time the report was published.

DAY

DATE

X

Date on which the aggregation applies.

REGIONID

VARCHAR2(20)

X

NEM Region.

PASAAVAILABILITY_SCHEDULED

NUMBER(12,0)

 

Aggregate of the offered PASA Availability for all Scheduled generators in this region.

LATEST_OFFER_DATETIME

DATE

 

Date Time of the latest offer used in the aggregation for this region and date.

ENERGYUNCONSTRAINEDCAPACITY

NUMBER(12,0)

 

Region energy unconstrained MW capacity

ENERGYCONSTRAINEDCAPACITY

NUMBER(12,0)

 

Region energy constrained MW capacity

NONSCHEDULEDGENERATION

NUMBER(12,2)

 

Allowance made for non-scheduled generation in the demand forecast (MW)

DEMAND10

NUMBER(12,2)

 

10% probability demand (ex non-scheduled demand)

DEMAND50

NUMBER(12,2)

 

50% probability demand (ex non-scheduled demand)

ENERGYREQDEMAND10

NUMBER(12,2)

 

Total weekly operational as generated consumption (POE 10)

ENERGYREQDEMAND50

NUMBER(12,2)

 

Total weekly operational as generated consumption (POE 50)

LASTCHANGED

DATE

 

Last date and time record changed