MKT_CM_EVTTRIGS

This table stores header information about marketing event triggers. Marketers can register their Events in the Event Trigger Repository. Each Event Triggers can be associated to multiple Dialog Stages that they need to execute.

Details

• Schema: FUSION

• Object owner: MKT

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MKT_CM_EVTTRIGS_PK	EVTTRIG_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
EVTTRIG_ID	NUMBER		18	Yes	Event Trigger Id
EVENT_TRIGGER_NAME	VARCHAR2	240		Yes	Event Trigger Name
EVENT_TRIGGER_CODE	VARCHAR2	30		Yes	Event Trigger Code
STATUS_CD	VARCHAR2	30		Yes	Status
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated 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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
mkt_cm_evttrg_stg	mkt_cm_evttrigs	EVTTRIG_ID
mkt_cm_evttrg_exec	mkt_cm_evttrigs	EVTTRIG_ID

Indexes

Index	Uniqueness	Columns
MKT_CM_EVTTRIGS_PK	Unique	EVTTRIG_ID