MTPASA_DUIDAVAILABILITY
Offered PASA Availability of the scheduled generator DUID for each day over the Medium Term PASA period. The data in this table is input data to the MT PASA process it is not part of the MTPASA solution. The 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 PASA availability of DUID applies. |
| REGIONID |
varchar(20) |
varchar(20) |
NEM Region. |
| DUID |
varchar(20) |
varchar(20) |
NEM DUID. |
| PASAAVAILABILITY |
numeric(12, 0) |
smallint (not nullable) |
Offered PASA Availability of Scheduled generator DUID for the day. |
| LATEST_OFFER_DATETIME |
datetime(3) |
datetime2(0) |
Date Time of the latest offer used for DUID for this date. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| CARRYOVERSTATUS |
numeric(1, 0) |
tinyint |
Status of a reported capacity value (e.g. 1 for Yes, 0 for No) |
| PASARECALLTIME |
numeric(4, 0) |
smallint |
The recall time value |
| PASAUNITSTATE |
varchar(20) |
varchar(20) |
The unit state value |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_DUIDAVAILABILITY_PK |
clustered, unique, primary key |
PUBLISH_DATETIME, DAY, REGIONID, DUID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_DUIDAVAILABILITY |
clustered, unique, primary key |
PUBLISH_DATETIME, DAY, REGIONID, DUID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_DUIDAVAILABILITY_CCI |
clustered, columnstore |
n/a |
| PK_MTPASA_DUIDAVAILABILITY |
nonclustered, unique, primary key |
PUBLISH_DATETIME, DAY, REGIONID, DUID |