CSO_RPT_CLICKTHROUGHS
This table contains the same data as the cso_stg_clickthroughs table. The difference is that this table is not truncated hourly. This table may contain up to several months worth of data.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CSO_RPT_CLICKTHROUGHS_PK |
RPT_CLICKTHROUGH_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
RPT_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. | ||
STAT_DATE | DATE | Yes | The date on which the stat occurred for the clickthrough. | ||
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_RPT_CLICKTHROUGHS_U1 | Unique | Default | RPT_CLICKTHROUGH_ID |