MSC_AUDIT_VALUES

table that stores the measure and group related changes for audit trail.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
MSC_AUDIT_VALUES_PK	AUDIT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
AUDIT_ID	NUMBER		18	Yes	This column indicates unique Audit identifier.
APPLICATION_MODULE	VARCHAR2	960			This column stores Application module name.
CHANGED_OBJECT	VARCHAR2	960		Yes	This column contains modified view object name.
KEY1	NUMBER		18	Yes	This column contains key column1 value.
KEY2	NUMBER		18		This column contains key column2 value.
KEY3	NUMBER		18		This column contains key column3 value.
CHANGED_ATTRIBUTE	VARCHAR2	320		Yes	This column contains the changed attribute name.
CHANGED_SET	NUMBER		18		This column contains change Set value
OLD_VALUE	VARCHAR2	2000			This column contains previous value before modification.
NEW_VALUE	VARCHAR2	2000			This column contains new value after modification.
OLD_KEY	NUMBER		18		Old key, if change attribute is a reference key.
NEW_KEY	NUMBER		18		New key, if change attribute is a reference key.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_AUDIT_VALUES_U1	Unique	FUSION_TS_TX_DATA	AUDIT_ID