MTPASA_CASERESULT
MTPASA solution header table.
Package
MTPASA
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Date processing of the run begins. |
| RUN_NO |
numeric(4, 0) |
smallint |
Unique run id. |
| PLEXOS_VERSION |
varchar(20) |
varchar(20) |
Version of PLEXOS used |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_CASERESULT_PK |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MTPASA_CASERESULT |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_CASERESULT_PK |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO |