HWR_PRFL_CTL_SRC_METRIC

The profile control source metric table stores the metric info.

Details

  • Schema: FUSION

  • Object owner: HWR

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

HWR_PRFL_CTL_SRC_METRIC_PK

PRFL_ID, CONTROL_KEY, SOURCE_TYPE_ID, METRIC_DATE

Columns

Name Datatype Length Precision Not-null Comments Status
PRFL_ID VARCHAR2 500 Yes The profile ID for this metric.
TYPE_OF_RECORD NUMBER 18 Yes Type indicating the type of the post-control record
CONTROL_KEY VARCHAR2 64 Yes The control type key for this metric.
SOURCE_TYPE_ID NUMBER 18 Yes The id of source type for this metric.
SCORE_VALUE NUMBER The score value for score metric. Obsolete
POST_COUNT NUMBER The number of post counted for compliance summary metric.
ISSUE_COUNT NUMBER The number of issue counted for compliance summary metric.
GLOBAL_PERCENTILE NUMBER The global percentile for score metric.
LOCAL_PERCENTILE NUMBER The local percentile for score metric.
METRIC_DATE TIMESTAMP Yes The date this metric was recorded.
METRIC_ATTRIBUTE_1 VARCHAR2 80 This column is to contain Metric Attribute 1.
METRIC_ATTRIBUTE_2 VARCHAR2 80 This column is to contain Metric Attribute 2.
METRIC_ATTRIBUTE_3 VARCHAR2 80 This column is to contain Metric Attribute 3.
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.

Indexes

Index Uniqueness Tablespace Columns
HWR_PRFL_CTL_SRC_METRIC_N1 Non Unique FUSION_TS_TX_DATA METRIC_DATE
HWR_PRFL_CTL_SRC_METRIC_N2 Non Unique FUSION_TS_TX_DATA TYPE_OF_RECORD, CONTROL_KEY
HWR_PRFL_CTL_SRC_METRIC_N3 Non Unique FUSION_TS_TX_DATA PRFL_ID, SOURCE_TYPE_ID
HWR_PRFL_CTL_SRC_METRIC_U1 Unique FUSION_TS_TX_DATA PRFL_ID, CONTROL_KEY, SOURCE_TYPE_ID, METRIC_DATE