Table: MMS_DATA_MODEL_AUDIT

MMS_DATA_MODEL_AUDIT

Name

MMS_DATA_MODEL_AUDIT

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.


Description

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


Primary Key Columns

Name

INSTALL_TYPE

INSTALLATION_DATE

MMSDM_VERSION


Content

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