|
Name |
|
|
Comment |
MMS_DATA_MODEL_AUDIT shows the audit trail of scripts applied to this installation of MMS Data Model. Participants should ensure that if a database is cloned the content of this table is copied to the target database. |
|
Source Delivered within scripts comprising install or updates to the MMS Data Model schema. Volume 1 record is inserted per release of MMS Data Model managed product |
|
Name |
|
INSTALL_TYPE |
|
INSTALLATION_DATE |
|
MMSDM_VERSION |
|
Name |
Data Type |
Mandatory |
Comment |
|
INSTALLATION_DATE |
DATE |
X |
The date in which the changes to the MMS Data Model were installed |
|
MMSDM_VERSION |
VARCHAR2(20) |
X |
The version of MMS Data Model after the script has been applied |
|
INSTALL_TYPE |
VARCHAR2(10) |
X |
The type of the patch applied. Valid entries are: FULL, UPGRADE, DML |
|
SCRIPT_VERSION |
VARCHAR2(20) |
|
The version of the patch set to the MMS Data Model |
|
NEM_CHANGE_NOTICE |
VARCHAR2(20) |
|
The NEM Change notice for which this MMS Data Model applies |
|
PROJECT_TITLE |
VARCHAR2(200) |
|
The name of the business project for which these changes to the MMS Data Model apply |
|
USERNAME |
VARCHAR2(40) |
|
The USER applying this script |
|
STATUS |
VARCHAR2(10) |
|
The status of the upgrade. Valid entries are STARTED, FAILED, SUCCESS |
|
|
|