Database View Reference

Database View Reference

MRX_SC_METRIC_GROUPS

MRX_SC_METRIC_GROUPS

The MRX_SC_METRIC_GROUPS view contains the information about metric groups in scorecards. Join the MRX_SC_METRIC_GROUPS view with the MRX_SCORECARD_INFO view to find information about the scorecard to which a metric group belongs.
The following table describes the columns in the MRX_SC_METRIC_GROUPS view:
Column
Datatype
Description
PID
NUMBER
Serial ID of the metric group that the Model Repository Service assigns.
NSID
NUMBER
Namespace ID of the metric group. Each design-time object belongs to the same namespace. Each deployed object belongs to a unique namespace assigned to the deployed application.
METRIC_GRP_ID
VARCHAR(3060)
Metric group ID.
CID
NUMBER
Metric group container ID. A container is an object that contains other objects and child containers. For example, projects, folders, and mappings are containers.
SC_PID
NUMBER
Serial ID of the scorecard that the Model Repository Service assigns.
Join the SC_PID column with the PID column of the MRX_SCORECARD_INFO view to get information about the scorecard to which a metric group belongs.
METRIC_GRP_NAME
VARCHAR(1536)
Metric group name.
THSLD_RANGE_FROM_VAL
NUMBER
Starting value of the metric group threshold range.
THSLD_RANGE_TO_VAL
NUMBER
Ending value of the metric group threshold range.
THSLD_RANGE_TYPE
VARCHAR(240)
Type of threshold range.
METRIC_GRP_DESC
CLOB
Metric group description.

0 COMMENTS

We’d like to hear from you!