CSO_STG_CLICKTHROUGHS

This table is a temporary table needed for ETL. The table will contain only an hour or two worth of clickthrough data copied over from the svc_req_action_capture table.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CSO_STG_CLICKTHROUGHS_PK	STG_CLICKTHROUGH_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
STG_CLICKTHROUGH_ID	NUMBER		18	Yes	This column is the primary key for this table. It is an auto-generated number.
ANSWER_ID	NUMBER			Yes	This is the answerId of the corresponding answer that was clicked on.
CLICKTHROUGH_POSITION	NUMBER		10	Yes	The sum of positions of each answer clicked against a question.
REQUEST_DATE	TIMESTAMP			Yes	The date the request occurred for the clickthrough.
SEARCH_TRANSACTION_ID	NUMBER		18	Yes	The Search Transaction ID is associated with a particular question. The Search Transaction ID helps to identify the question that is associated with the clickthrough.
SOURCE_TYPE	VARCHAR2	50			Whether the clickthrough is associated with a document, an attachment or external content.
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.
SESSION_ID	VARCHAR2	200		Yes	Knowledge Interaction ID or session ID associated with a question.

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_STG_CLICKTHROUGHS_U1	Unique	Default	STG_CLICKTHROUGH_ID