Database View Reference

10.5
- 10.5.4
- 10.4.0

Back Next

MRX_SC_RULE_METRICS

The MRX_SC_RULE_METRICS view contains information about rule metrics in scorecards. You can join the MRX_SC_RULE_METRICS view with MRX_SC_METRIC_GROUPS view to find information about the metric group to which a metric belongs.

The following table describes the columns in the MRX_SC_RULE_METRICS view:

Column	Datatype	Description
PID	NUMBER	Serial ID of the metric that the Model Repository Service assigns.
NSID	NUMBER	Namespace ID of the metric. Each design-time object belongs to the same namespace. Each deployed object belongs to a unique namespace assigned to the deployed application.
METRIC _ID	VARCHAR(3060)	Metric ID.
CID	NUMBER	Metric container ID. A container is an object that contains other objects and child containers. For example, projects, folders, and mappings are containers.
METRIC_GRP_ID	NUMBER	Serial ID of the metric group that the Model Repository Service assigns. You can join the METRIC_GRP_ID column with the PID column of the MRX_SC_METRIC_GROUPS view to find information about the metric group to which a metric belongs.
METRIC_ NAME	VARCHAR(1536)	Metric name.
METRIC_WEIGHT	NUMBER	Weight assigned to the metric.
COST_TYPE	VARCHAR(3060)	Type of cost assigned to the metric, such as fixed cost and variable cost.
INVALID_ROW_COST	BINARY_DOUBLE	Cost associated with the metric if the COST_TYPE is FIXEDCOST. If the COST_TYPE is VARIABLECOST, the value is NULL.
VARIABLE_COST_FIELD	VARCHAR(3060)	Cost associated with the metric if the COST_TYPE is VARIABLECOST. If the COST_TYPE is FIXEDCOST, the value is NULL.
THSLD_RANGE_FROM_VAL	NUMBER	Starting value of the metric threshold range.
THSLD_RANGE_TO_VAL	NUMBER	Ending value of the metric threshold range.
THSLD_RANGE_TYPE	VARCHAR(24)	Threshold range type. The value is NULL.
RULE_NAME	VARCHAR(3060)	Rule name.
RULE_PROJECT	VARCHAR(3060)	Name of the project that contains the rule. The value is NULL if RULE_TYPE is EXPRESSION.
RULE_PATH	VARCHAR(4000)	Path of the rule from its root. The value is NULL if RULE_TYPE is EXPRESSION.
RULE_TYPE	VARCHAR(40)	Type of the rule, such as mapplet rule and expression rule.
RULE_EXPR	CLOB	Rule expression. The value is NULL if RULE_TYPE is MAPPLET.
RULE_DESC	CLOB	Rule description.

Rename Saved Search

Table of Contents

Database View Reference

Database View Reference

MRX_SC_RULE_METRICS

MRX_SC_RULE_METRICS