Database View Reference

10.4.0
- 10.5.4
- 10.5

Back Next

MRX_SC_NONRULE_METRIC

The MRX_SC_NONRULE_METRIC view contains the information about metrics in scorecards that are not part of a rule. You can join the MRX_SC_NONRULE_METRIC view with the MRX_SC_METRIC_GROUPS view to get the information about the metric group to which a metric belongs.

The following table describes the columns in the MRX_SC_NONRULE_METRIC view:

Column		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 get information on the metric group to which a metric belongs.
METRIC_ NAME	VARCHAR(1536)	Metric name.
METRIC_WEIGHT	NUMBER	Weight assigned to a metric.
COST_TYPE	VARCHAR(3060)	Type of the metric cost, such as FIXEDCOST and VARIABLECOST.
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 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.
DATA_OBJ_PID	NUMBER	Serial ID of the data object that the Model Repository Service assigns.
DATA_OBJ_NSID	NUMBER	Namespace ID of the data object. Each design-time object belongs to the same namespace. Each deployed object belongs to a unique namespace assigned to the deployed application.
DATA_OBJ_ID	VARCHAR(3060)	Data object ID.
DATA_OBJ_CID	NUMBER	Data object container ID. A container is an object that contains other objects and child containers. For example, projects, folders, and mappings are containers.
DATA_OBJ_NAME	VARCHAR(1020)	Name of the source data object of the metric.
DATA_OBJ_TYPE	VARCHAR(56)	Type of the data object, such as relational sources, logical data objects, and flat files.
DATA_OBJ_PROJECT_NAME	VARCHAR(3060)	Name of the project that contains the data object.
DATA_OBJ_PATH	VARCHAR(4000)	Path of the data object from its root.

Rename Saved Search

Table of Contents

Database View Reference

Database View Reference

MRX_SC_NONRULE_METRIC

MRX_SC_NONRULE_METRIC