ACE_METRIC_GOAL
This table stores the selected metrics for a particular business object. The current focus of the implementation is for Portfolio Business object. For each of the metric selected for a business object one row will be inserted in this table which identifies the selected metrics. There will be many to many relationship between business object and metric configuration. This table acts as a map table to store the many to many relationship between the entities.
Details
-
Schema: FUSION
-
Object owner: ACE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ACE_METRIC_GOAL_PK |
METRIC_GOAL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| METRIC_GOAL_ID | NUMBER | 18 | Yes | Metric configuration id. Primary key | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| BUSINESS_OBJECT_ID | NUMBER | 18 | Yes | Stores the Unique Id (Primary Key) of the business object to which the metric is associated. Hence will be a foreign key to the business object base table. | |
| BUSINESS_OBJECT_TYPE | VARCHAR2 | 30 | Yes | Stores the type of business object to which the metric is being associated to. This column will be used to identify to which business object base table to be used. The possible business object types and their identifiers are mentioned below: Code: PORTFOLIO Meaning: Portfolio Code: DESIGN Meaning: Design | |
| METRIC_TYPE | VARCHAR2 | 30 | Yes | Type of selected metric. This information is also available in the metric configuration. The supported types are defined in the Lookup type with the name ACE_METRIC_TYPES. The possible values codes and translatable names as follows, Code: PORTFOLIO Value: Portfolio Metric Code: PRODUCT.Value: Product Metric Code: CONCEPT_DESIGN.Value: Design Metric | |
| METRIC_CONFIG_ID | NUMBER | 18 | Yes | Stores the unique id (primary key) of the selected metrics. Hence will be a foreign key to the metric configuration table. This information will be used to hide/display the metrics for a given portfolio. | |
| GOAL_MIN_VALUE | NUMBER | Minimum goal value for the selected metric | |||
| GOAL_MAX_VALUE | NUMBER | Maximum goal value for the selected metric | |||
| 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 |
|---|---|---|---|
| ACE_METRIC_GOAL_N1 | Non Unique | Default | BUSINESS_OBJECT_ID, BUSINESS_OBJECT_TYPE |
| ACE_METRIC_GOAL_U1 | Unique | Default | METRIC_GOAL_ID |
| ACE_METRIC_GOAL_U2 | Unique | Default | BUSINESS_OBJECT_ID, METRIC_CONFIG_ID |