CSO_STG_ANSWER

Details

Name	Columns
CSO_STG_ANSWER_PK	CSO_STG_ANSWER_ID

Name	Datatype	Length	Not-null	Comments
ANSWER_TXN	NUMBER		Yes	Unique ID within the question per user session.
A_ID	NUMBER			The unique ID number of the answer.
CREATED	TIMESTAMP			This is the time the event occurred.
CSO_STG_ANSWER_ID	NUMBER		Yes	This is the Surrogate Key for Stg_answer.
DISPLAY_ORDER	NUMBER			Each response will have a sequence number for display ordering
DOCUMENT_REF	VARCHAR2	50		The unique ID that represents the document in the content store.
DOCUMENT_TYPE	VARCHAR2	255		This is the document type, as identified during content processing. Example: HTML or PDF
INTERFACE_ID	NUMBER			The unique ID for the interface.
IS_PUBLISHED	NUMBER			The flag indicating if the document was published.
LOCALE_REF	VARCHAR2	64		The locale associated with the response.
PAGE_NUM	NUMBER			The page number associated with this response.
POSITION	NUMBER			Actual position of the response in relation to other responses.
PURPOSE	NUMBER			This is the Customer defined region of a page.
QUERY_ORIGIN	VARCHAR2	255		The description from which user questions were asked.
QUESTION_TXN_REF	NUMBER		Yes	This is the ID of a search question.
SCORE	NUMBER			The overall score for this answer.
SESSION_REF	VARCHAR2	64	Yes	A unique global ID to capture all work done by a user across various applications for a given session.
SESSION_USER_REF	VARCHAR2	64		The user associated with the session.
TEXT	VARCHAR2	255		Usually the title of a document of the response.
TYPE	VARCHAR2	255		This is the Managed Answer, Intent Response, Glossary, Unstructured or Structured.
URL	VARCHAR2	255		This is the URL to the response.

Index	Uniqueness	Columns
CSO_STG_ANSWER_U1	Unique	CSO_STG_ANSWER_ID
CSO_STG_ANSWER_N1	Non Unique	CREATED
CSO_STG_ANSWER_N2	Non Unique	INTERFACE_ID
CSO_STG_ANSWER_N3	Non Unique	SESSION_REF, ANSWER_TXN, QUESTION_TXN_REF