MSC_AUDIT_TRAILS_METADATA

This Audit Trail Data table will be created by ROLAP as a single table per system and will hold all audit data for measures data.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
MSC_AUDIT_TRAILS_METADATA_PK	AUDIT_ID

Columns

Name	Datatype	Length	Not-null	Comments
AUDIT_ID	NUMBER		Yes	AUDIT_ID is a unique index for each record that added to this table.
PLAN_ID	NUMBER			PLAN_ID hold each plan id, for shared measures the value will be -1.
MEASURE_ID	NUMBER			MEASURE_ID hold each measure id.
PREVIOUS_VALUE	VARCHAR2	255		PREVIOUS_VALUE, can be from 3 different types: Numeric, String, and Date.
NEW_VALUE	VARCHAR2	255		NEW_VALUE, can be from 3 different types: Numeric, String, and Date.
DETAILS	CLOB			DETAILS, includes all the metadata for what he need to present on the screen.
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.
MODULE	VARCHAR2	64		MODULE, Holds Update Mode: Can include 3 update types: Manual/REST API/Import from Excel
AUDIT_SCN	NUMBER			AUDIT_SCN, Holds SYSTEM_CHANGE_NUMBER to be used in FLASHBACK query 'as of SCN'
DETAIL_SQL	CLOB			DETAIL_SQL, Holds disaggregation SELECT SQL, the inner SELECT part of MERGE DATA SQL
SAVE_SESSION_ID	NUMBER			Unique Session ID Identifier per Save action

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_AUDIT_TRAILS_METADATA_N1	Non Unique	Default	SAVE_SESSION_ID
MSC_AUDIT_TRAILS_METADATA_U1	Unique	Default	AUDIT_ID