MTPASA_REGIONAVAILABILITY
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.
Package
MTPASA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PUBLISH_DATETIME |
datetime(3)  |
datetime2(0) |
Date Time the report was published. |
| DAY |
datetime(3) |
datetime2(0) |
Date on which the aggregation applies. |
| REGIONID |
varchar(20) |
varchar(20) |
NEM Region. |
| PASAAVAILABILITY_SCHEDULED |
numeric(12, 0) |
int |
Aggregate of the offered PASA Availability for all Scheduled generators in this region. |
| LATEST_OFFER_DATETIME |
datetime(3) |
datetime2(0) |
Date Time of the latest offer used in the aggregation for this region and date. |
| ENERGYUNCONSTRAINEDCAPACITY |
numeric(12, 0) |
int |
Region energy unconstrained MW capacity |
| ENERGYCONSTRAINEDCAPACITY |
numeric(12, 0) |
int |
Region energy constrained MW capacity |
| NONSCHEDULEDGENERATION |
numeric(12, 2) |
numeric(12, 2) |
Allowance made for non-scheduled generation in the demand forecast (MW) |
| DEMAND10 |
numeric(12, 2) |
numeric(12, 2) |
10% probability demand (ex non-scheduled demand) |
| DEMAND50 |
numeric(12, 2) |
numeric(12, 2) |
50% probability demand (ex non-scheduled demand) |
| ENERGYREQDEMAND10 |
numeric(12, 2) |
numeric(12, 2) |
Total weekly operational as generated consumption (POE 10) |
| ENERGYREQDEMAND50 |
numeric(12, 2) |
numeric(12, 2) |
Total weekly operational as generated consumption (POE 50) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| DEMAND10MIN |
numeric(12, 2) |
numeric(12, 2) |
Minimum of the Operational Load as Generated (OPGEN) peaks that occur in all ref years for the P10 traces (MW). |
| DEMAND10MAX |
numeric(12, 2) |
numeric(12, 2) |
Maximum of the Operational Load as Generated (OPGEN) peaks that occur in all ref years for the P10 traces (MW). |
| DEMAND50MIN |
numeric(12, 2) |
numeric(12, 2) |
Minimum of the Operational Load as Generated (OPGEN) peaks that occur in all ref years for the P50 traces (MW). |
| DEMAND50MAX |
numeric(12, 2) |
numeric(12, 2) |
Maximum of the Operational Load as Generated (OPGEN) peaks that occur in all ref years for the P50 traces (MW). |
| CARRYOVERCAPACITY |
numeric(12, 0) |
numeric(12, 0) |
Split of the CARRYOVER component of aggregate capacity vs the currently reported capacity. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_REGIONAVAILABILITY_PK |
clustered, unique, primary key |
PUBLISH_DATETIME, DAY, REGIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_REGIONAVAILABILITY |
clustered, unique, primary key |
PUBLISH_DATETIME, DAY, REGIONID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_REGIONAVAILABILITY_CCI |
clustered, columnstore |
n/a |
| PK_MTPASA_REGIONAVAILABILITY |
nonclustered, unique, primary key |
PUBLISH_DATETIME, DAY, REGIONID |