Table: MTPASA_CASE_SET

MTPASA_CASE_SET

Name

MTPASA_CASE_SET

Comment

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.


Description

Source

Update weekly.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

RUN_DATETIME

RUN_NO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

Date processing of the run begins. Generated from the solution file CASEID.

RUN_NO

NUMBER(3,0)

X

Unique run id. Generated from the solution file CASEID.

CASESETID

NUMBER(3,0)

 

Unique id to link a set of cases run from the same inputs

RUNTYPEID

NUMBER(1,0)

 

Unique id for type of run, being either

LASTCHANGED

DATE

 

Date the solution was loaded