STPASA_DUIDAVAILABILITY
This report delivers available capacity, PASA availability and given recall period for all scheduled resources. Note that for an MNSP, DUID = LINKID in the MNSP_INTERCONNECTOR table.
Package
STPASA_SOLUTION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
STPASA run, identified by the nominal start time of the run. |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
Half hour ended interval |
| DUID |
varchar(20) |
varchar(10) |
NEM Dispatchable Unit Identifier |
| GENERATION_MAX_AVAILABILITY |
numeric(12, 6) |
numeric(12, 6) |
Available Capacity for a scheduled generating unit, semi-scheduled generating unit, BDU (Gen side), WDR or MNSP. |
| GENERATION_PASA_AVAILABILITY |
numeric(12, 0) |
smallint |
PASA Availability for a scheduled generating unit, BDU (Gen side), WDR or MNSP. Null for a semi-scheduled generating unit. |
| GENERATION_RECALL_PERIOD |
numeric(8, 3) |
numeric(8, 3) |
Recall Period associated with the PASA Availability for a scheduled generating unit, BDU (Gen side), WDR or MNSP. Null for a semi-scheduled generating unit. |
| LOAD_MAX_AVAILABILITY |
numeric(12, 6) |
numeric(12, 6) |
Available Capacity for a scheduled load or BDU(Load side). |
| LOAD_PASA_AVAILABILITY |
numeric(12, 0) |
smallint |
PASA Availability for a scheduled load or BDU(Load side). |
| LOAD_RECALL_PERIOD |
numeric(8, 3) |
numeric(8, 3) |
Recall Period associated with the PASA Availability for a scheduled load or BDU(Load side). |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Report Creation Date Time. |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| STPASA_DUIDAVAILABILITY_PK |
clustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME, DUID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_STPASA_DUIDAVAILABILITY |
clustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME, DUID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_STPASA_DUIDAVAILABILITY |
nonclustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME, DUID |
| STPASA_DUIDAVAILABILITY_CCI |
clustered, columnstore |
n/a |