ZCA_CH_TAGGED_USER_CLICKS

This table is used to store user taggaing click data, which would be converted and inserted to zca_ch_click_mapping_b and zca_ch_click_mapping_tl eventually.

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: TABLE

• Tablespace: zca_ch_tagged_user_clicks

Primary Key

Name	Columns
ZCA_CH_TAGGED_USER_CLICKS_PK	CLICK_CONTEXT_ID

Columns

Name	Datatype	Length	Not-null	Comments
CLICK_USER_AREA	VARCHAR2	100		Identifies the area of exact UI element which was clicked.
CLICK_USER_ID	VARCHAR2	100	Yes	User associated with the Click Event.
CLICK_TEXT	VARCHAR2	500		Identifies the text of exact UI element which was clicked.
CLICK_DESC	VARCHAR2	500		Description associated with the Click Event.
CLICK_CONTEXT_ID	VARCHAR2	300	Yes	Identifies the context ID of exact UI element which was clicked.
CLICK_COMPONENT_DISPLAY_NAME	VARCHAR2	500		Identifies the display name of exact UI element which was clicked.
CLICK_TYPE	VARCHAR2	300		Identifies the action of exact UI element which was clicked.
CLICK_COMPONENT_CLIENT_ID	VARCHAR2	500		Identifies the ID of exact UI element which was clicked.
CLICK_REGION_VIEW_ID	VARCHAR2	1024		Identifies the exact taskflow and exact view on which the UI element was clicked.
REC_PROCESSED	VARCHAR2	100	Yes	Indicates if record is processed.
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
ZCA_CH_TAGGED_USER_CLICKS_PK	Unique	ZCA_CH_TAGGED_USER_CLICKS_PK	CLICK_CONTEXT_ID