MSC_REQUEST_JOURNAL

This is to keep track of requests served during Fault Tolerance active time.

Details

• Schema: FUSION

• Object owner: MSC

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MSC_REQUEST_JOURNAL_PK	SERVED_TIME, GOP_REQUEST_ID

Columns

Name	Datatype	Length	Not-null	Comments
GOP_REQUEST_NAME	VARCHAR2	50	Yes	REQUEST_NAME is the name of the scheduling / cancel request.
GOP_REQUEST_ID	VARCHAR2	50	Yes	Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
SERVED_TIME	VARCHAR2	20	Yes	This is the time when the request was served.
CALLINGMODULE	VARCHAR2	20	Yes	The is CALLINGMODULE of the request.
CALLINGINSTANCE	VARCHAR2	50		This is CALLINGINSTANCE passed in the request.
XML_REQUEST	XMLTYPE		Yes	This the request in XMLType for XML REQUEST replay.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
MSC_REQUEST_JOURNAL_U1	Unique	Default	SERVED_TIME, GOP_REQUEST_ID