STPASA_FNM_CASESOLUTION
STPASA_FNM_CASESOLUTION shows the case run details, including the available run types, LOR and Deficit condition for each case.
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 |
| LORCONDITION |
numeric(1, 0) |
tinyint |
LORCONDITION is only set if supply deficit exists in a Zone that contains the Regional Reference Node LORCONDITION indicates the most severe condition for the case: LORCONDITION = 3 if deficit in BASE run, else = 2 if deficit in RELIABILITY run, else = 1 if deficit in WARNING run, else 0 |
| DEFICITCONDITION |
numeric(1, 0) |
tinyint |
DEFICITCONDITION is only set if supply deficit exists in a Zone that does NOT contain the Regional Reference Node DEFICITCONDITION indicates the most severe condition for the case: DEFICITCONDITION = 3 if deficit in BASE run, else = 2 if deficit in RELIABILITY run, else = 1 if deficit in WARNING run, else 0 |
| BASE_RUN_AVAILABLE |
varchar(10) |
varchar(10) |
YES = Available, NO = Not Available |
| RELIABILITY_RUN_AVAILABLE |
varchar(10) |
varchar(10) |
YES = Available, NO = Not Available |
| WARNING_RUN_AVAILABLE |
varchar(10) |
varchar(10) |
YES = Available, NO = Not Available |
| PASAVERSION |
varchar(30) |
varchar(30) |
Version of the PASA solver used to solve this case |
| 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_CASESOLUTION_PK |
clustered, unique, primary key |
RUN_DATETIME |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| STPASA_FNM_CASESOLUTION_PK |
clustered, unique, primary key |
RUN_DATETIME |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| STPASA_FNM_CASESOLUTION_PK |
clustered, unique, primary key |
RUN_DATETIME |