SVC_MCA_EVENTS

Details

Schema: FUSION
Object owner: SVC
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
SVC_MCA_EVENTS_PK	MCA_EVENT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
MCA_EVENT_ID	NUMBER		18	Yes	Auto-generated number and primary key for this table.	Active
MCA_EVENT_NUMBER	VARCHAR2	30		Yes	This is a public surrogate key which is required during creation of the row.
INTERACTION_ID	NUMBER		18		Foreign key which refers to SVC_INTERACTIONS table.
WRAPUP_ID	NUMBER		18		Foreign key which refers to SVC_INTERACT_SUMMARY table.
METHOD	VARCHAR2	32		Yes	Name of the calling event method.
AGENT_ID	NUMBER		18		Agent identifier from the parties entity.
COMM_ID	VARCHAR2	64		Yes	Communication ID represented by the API Event ID.
APPL_CLASSIFICATION_CD	VARCHAR2	32		Yes	The application classification to which this event applies.
VERSION	VARCHAR2	32		Yes	Version of the client side consumer.
CHANNEL_ID	NUMBER		18		A foreign key to the SVC_CHANNELS_B table.
TOOLBAR_NAME	VARCHAR2	64			Toolbar name being used for this event.
TOOLBAR_ID	NUMBER		18		A foreign key to the SVC_MCA_TOOLBAR table.
BO_ENTITY_ID	NUMBER		18		A foreign key to the SVC_MCA_BO_ENTITY table.
UUID	VARCHAR2	64			Client response unique identifier.
ORIGIN	VARCHAR2	250			URL representing the event initiator.
WINDOW_NAME	VARCHAR2	64			Client window identifier of the event.
NEXT_STATE	VARCHAR2	32			The next state calculated by the event processing.
RESULT	VARCHAR2	64			Returned result of event processing.
ERROR_MSG_CD	VARCHAR2	64			Error code for the event processing.
ERROR_MSG	VARCHAR2	4000			Error message of the event processing.
CONTACT_ID	NUMBER		18		Contact identifier for the event.
IN_TOKENS	VARCHAR2	4000			Input tokens of the request payload.
DIRECTION_CD	VARCHAR2	32		Yes	Direction of the event for the token values.
OUT_TOKENS	VARCHAR2	4000			Output tokens in the response payload.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
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.	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
SVC_MCA_EVENTS	svc_interactions	INTERACTION_ID
SVC_MCA_EVENTS	svc_mca_interact_summary	WRAPUP_ID
SVC_MCA_EVENTS	svc_channels_b	CHANNEL_ID
SVC_MCA_EVENTS	svc_mca_toolbar	TOOLBAR_ID
SVC_MCA_EVENTS	svc_mca_bo_entity	BO_ENTITY_ID
svc_mca_event_tokens	svc_mca_events	MCA_EVENT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
SVC_MCA_EVENTS_N1	Non Unique	Default	INTERACTION_ID
SVC_MCA_EVENTS_N2	Non Unique	Default	WRAPUP_ID
SVC_MCA_EVENTS_N3	Non Unique	Default	CHANNEL_ID
SVC_MCA_EVENTS_N4	Non Unique	Default	TOOLBAR_ID
SVC_MCA_EVENTS_N5	Non Unique	Default	BO_ENTITY_ID
SVC_MCA_EVENTS_N6	Non Unique	Default	COMM_ID
SVC_MCA_EVENTS_PK	Unique	Default	MCA_EVENT_ID
SVC_MCA_EVENTS_U1	Unique	Default	MCA_EVENT_NUMBER