MTPASA_CASE_SET (Historical table)
MTPASA_CASE_SET is obsolete from 2005 End of Year Release. The RUNTYPE added to the primary key of the detail tables for MTPASA allows for the different types of runs for each case. MTPASA_CASE_SET allows a MT PASA scenario to be linked across runs.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| RUN_DATETIME |
datetime(3)  |
datetime2(0) |
Date processing of the run begins. Generated from the solution file CASEID. |
| RUN_NO |
numeric(3, 0) |
smallint |
Unique run id. Generated from the solution file CASEID. |
| CASESETID |
numeric(3, 0) |
smallint |
Unique id to link a set of cases run from the same inputs |
| RUNTYPEID |
numeric(1, 0) |
tinyint |
Unique id for type of run, being either |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date the solution was loaded |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_CASE_SET_LCX |
nonclustered |
LASTCHANGED |
| MTPASA_CASE_SET_PK |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_MTPASA_CASE_SET_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_MTPASA_CASE_SET |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MTPASA_CASE_SET_LCX |
nonclustered |
LASTCHANGED |
| MTPASA_CASE_SET_PK |
clustered, unique, primary key |
RUN_DATETIME, RUN_NO |