CSO_SCHML_METRICS_VALUES

This table stores the ranking metrics for the metrics defined in cso_schml_job_tracker table.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CSO_SCHML_METRICS_VALUES_PK	METRICS_VALUE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
METRICS_VALUE_ID	NUMBER		18	Yes	This is the primary key of the table.
METRICS_TYPE_ID	NUMBER		10	Yes	This is the reference to the metrics type in cso_schml_job_tracker table.
SEARCH_CONFIGURATION_ID	NUMBER		10	Yes	This refers to the algorithm used for performing search.
WINDOW	NUMBER		2	Yes	This is the time window considered for calculating the metric.
METRIC_VALUE	NUMBER		5	Yes	This is the calculated metric value.
FROM_DATE	TIMESTAMP			Yes	Indicates the start date and time of the window used for calculating the metric.
TO_DATE	TIMESTAMP			Yes	Indicates the end date and time of the window used for calculating the metric.
NUM_TXN_IDS	NUMBER		18	Yes	This gives the number of search transaction ids used for calculating the metric.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created 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.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_SCHML_METRICS_VALUES_N1	Non Unique	Default	METRICS_TYPE_ID, FROM_DATE, TO_DATE
CSO_SCHML_METRICS_VALUES_PK	Unique	Default	METRICS_VALUE_ID
CSO_SCHML_METRICS_VALUES_U1	Unique	Default	METRICS_TYPE_ID, SEARCH_CONFIGURATION_ID, FROM_DATE, TO_DATE