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 |
|
|
|