ACD_METRICS
Contains calculated metrics values for each concept solution alternative.
Details
-
Schema: FUSION
-
Object owner: ACD
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ACD_METRICS_PK |
METRICS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| METRICS_ID | NUMBER | 18 | Yes | Unique metrics ID. Each structure line item has several metrics records with its own ID. | |
| 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. | |
| CONCEPT_STRUCTURE_ID | NUMBER | 18 | Reference to structure line item | ||
| ALTERNATIVE_INDEX | NUMBER | 18 | This is the alternative index [1..15] that a given concept structure line item can point to from the acd_concept_structure table. | ||
| COST | NUMBER | This is the Calculated cost of this Concept Structure line item alternate solution. | |||
| WEIGHT | NUMBER | This is the Calculated Weight value of this Concept Structure line item alternate solution. | |||
| POWER_CONSUMPTION | NUMBER | This is the Calculated Power Consumption value of this Concept Structure line item alternate solution. | |||
| COST_INCOMPLETE | VARCHAR2 | 1 | 'y' if cost value for this node is incomplete because of missong some data in itself or its sub-nodes. Otherwise 'n' | ||
| WEIGHT_INCOMPLETE | VARCHAR2 | 1 | 'y' if weight value for this node is incomplete because of missong some data in itself or its sub-nodes. Otherwise 'n' | ||
| POWER_INCOMPLETE | VARCHAR2 | 1 | 'y' if power consumption value for this node is incomplete because of missong some data in itself or its sub-nodes. Otherwise 'n' | ||
| COST_VARIANCE | NUMBER | This is the Calculated cost variance value of this Concept Structure line item alternate solution. | |||
| WEIGHT_VARIANCE | NUMBER | This is the Calculated weight variance value of this Concept Structure line item alternate solution. | |||
| POWER_CONSUMPTION_VARIANCE | NUMBER | This is the Calculated power consumption variance value of this Concept Structure line item alternate solution. | |||
| COMPLIANCE | VARCHAR2 | 30 | This is the Calculated Compliance value of this Concept Structure line item alternate solution. | ||
| SCORE | NUMBER | This is the calculated score value, which is a part of metrics rollup value of this Concept Structure line item alternate solution. | |||
| 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. | ||
| M_EX_ATTRIBUTE_NUMBER001 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER002 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER003 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER004 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER005 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER006 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER007 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER008 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER009 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER010 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER011 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER012 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER013 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER014 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER015 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER016 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER017 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER018 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER019 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER020 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER021 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER022 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER023 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER024 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER025 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER026 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER027 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER028 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER029 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER030 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER031 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER032 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER033 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER034 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER035 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER036 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER037 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER038 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER039 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER040 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER041 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER042 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER043 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER044 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER045 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER046 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER047 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER048 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER049 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER050 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| M_EX_ATTRIBUTE_NUMBER051 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ACD_METRICS | acd_concept_structure | CONCEPT_STRUCTURE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ACD_METRICS_N1 | Non Unique | Default | CONCEPT_STRUCTURE_ID |
| ACD_METRICS_U1 | Unique | Default | METRICS_ID |
| ACD_METRICS_U2 | Unique | Default | ALTERNATIVE_INDEX, CONCEPT_STRUCTURE_ID |