MMS_DATA_MODEL_AUDIT
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.
Package
CONFIGURATION
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| INSTALLATION_DATE |
datetime(3)  |
datetime2(0) |
The date in which the changes to the MMS Data Model were installed |
| MMSDM_VERSION |
varchar(20) |
varchar(20) |
The version of MMS Data Model after the script has been applied |
| INSTALL_TYPE |
varchar(10) |
varchar(10) |
The type of the patch applied. Valid entries are: FULL, UPGRADE, DML |
| SCRIPT_VERSION |
varchar(20) |
varchar(20) |
The version of the patch set to the MMS Data Model |
| NEM_CHANGE_NOTICE |
varchar(20) |
varchar(20) |
The NEM Change notice for which this MMS Data Model applies |
| PROJECT_TITLE |
varchar(200) |
varchar(200) |
The name of the business project for which these changes to the MMS Data Model apply |
| USERNAME |
varchar(40) |
varchar(40) |
The USER applying this script |
| STATUS |
varchar(10) |
varchar(10) |
The status of the upgrade. Valid entries are STARTED, FAILED, SUCCESS |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MMS_DATA_MODEL_AUDIT_PK |
clustered, unique, primary key |
INSTALLATION_DATE, MMSDM_VERSION, INSTALL_TYPE |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_MMS_DATA_MODEL_AUDIT |
clustered, unique, primary key |
INSTALLATION_DATE, MMSDM_VERSION, INSTALL_TYPE |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| MMS_DATA_MODEL_AUDIT_PK |
clustered, unique, primary key |
INSTALLATION_DATE, MMSDM_VERSION, INSTALL_TYPE |