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 |