STPASA_FNM_DUIDAVAILABILITY
STPASA_FNM_DUIDAVAILABILITY shows Available Capacity, PASA Availability and given Recall Period for all scheduled.
Package
STPASA_SOLUTION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
| INTERVAL_DATETIME |
datetime(3) |
datetime2(0) |
End date time of the interval |
| DUID |
varchar(20) |
varchar(20) |
NEM Dispatchable Unit Identifier |
| BID_TRADINGDATE |
datetime(3) |
datetime2(0) |
Trading Date of the energy bid |
| BID_OFFERDATETIME |
datetime(3) |
datetime2(0) |
Date Time that the energy bid was received |
| GENERATION_MAX_AVAILABILITY |
numeric(12, 3) |
numeric(12, 3) |
Available Capacity for a scheduled generating unit, semi-scheduled generating unit, BDU (Gen side), WDR or MNSP |
| GENERATION_PASA_AVAILABILITY |
numeric(12, 3) |
numeric(12, 3) |
PASA Availability for a scheduled generating unit, BDU (Gen side), WDR or MNSP. Null for a semi-scheduled generating unit (MW) |
| 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 (Hours) |
| LOAD_MAX_AVAILABILITY |
numeric(12, 3) |
numeric(12, 3) |
Available Capacity for a scheduled load or BDU (Load side) (MW) |
| LOAD_PASA_AVAILABILITY |
numeric(12, 3) |
numeric(12, 3) |
PASA Availability for a scheduled load or BDU (Load side) (MW) |
| LOAD_RECALL_PERIOD |
numeric(8, 3) |
numeric(8, 3) |
Recall Period associated with the PASA Availability for a scheduled load or BDU (Load side) (Hours) |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date time this record was created |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| STPASA_FNM_DUIDAVAILABILITY_PK |
clustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME, DUID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| STPASA_FNM_DUIDAVAILABILITY_PK |
clustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME, DUID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| STPASA_FNM_DUIDAVAILABILITY_PK |
clustered, unique, primary key |
RUN_DATETIME, INTERVAL_DATETIME, DUID |