CSO_STG_ANSWERS

This table is a temporary table needed for ETL. The table will contain only an hour or two worth of answers 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_ANSWERS_PK	STG_ANSWER_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
STG_ANSWER_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 displayed against a question.
DISPLAYED_POSITION	NUMBER		10	Yes	The position of each answer displayed against a question.
REQUEST_DATE	TIMESTAMP			Yes	Indicates the date and time of the creation of the row in the request action capture table.
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 answer.
SESSION_ID	VARCHAR2	200		Yes	Knowledge Interaction ID or session ID associated with a question.
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.
SOURCE_TYPE	VARCHAR2	50			Whether the displayed article is associated with a document, an attachment or external content.

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_STG_ANSWERS_PK	Unique	Default	STG_ANSWER_ID