DOO_FEATURE_USAGE_METRICS
This table stores the information about Order Management feature usage , incidents and values of key performance indicators
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
DOO_FEATURE_USAGE_METRICS_PK |
USAGE_METRIC_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| USAGE_METRIC_ID | NUMBER | 18 | Yes | Value that uniquely identifies the row in table | |
| USAGE_METRIC_TYPE | VARCHAR2 | 255 | Yes | Indicates the event point type of an order. Possible values are USAGE , METRIC , INCIDENT | |
| USAGE_METRIC_NAME | VARCHAR2 | 255 | Yes | Name of the event point. Possible values are PRETRANSFORM_RULES_USAGE,POSTTRANSFORM_RULES_USAGE,PRODUCT_TRANSFORMATION_RULES_USAGE,SUBMIT_FAILURE , GTM_PRESUBMIT, APPROVAL_PRESUBMIT , CREDIT_CHECK_PRESUBMIT , EXTENSION_USAGE , FULFILLMENT_TASK_USAGE { TaskType Name } , SPLIT , SHIPSET_BREAK , REMNANT. | |
| PREVIOUS_USAGE_VALUE | VARCHAR2 | 255 | Attribute indicating the previous usage whether Y or N. | ||
| CURRENT_USAGE_VALUE | VARCHAR2 | 255 | Attribute indicating the current usage whether Y or N. | ||
| USAGE_METRIC_DETAILS | CLOB | Includes metadata generated in form of json format. | |||
| USAGE_METRIC_OWING_MODULE | VARCHAR2 | 255 | Yes | Name of the metric owning module. Possible values are CAPTURE/SUBMIT/ORCHESTRATION/FULFILLMENT_TASK/SHIPSET/SPLIT/EXTENSION/ACTION/REVISION | |
| USAGE_METRIC_APP_ATTRIBUTE1 | VARCHAR2 | 255 | Generic placeholder column for storing additional information or data points. There are 10 generic columns called USAGE_METRIC_APP_ATTRIBUTE1 to USAGE_METRIC_APP_ATTRIBUTE10 defined. | ||
| USAGE_METRIC_APP_ATTRIBUTE2 | VARCHAR2 | 255 | Generic placeholder column for storing additional information or data points. | ||
| USAGE_METRIC_APP_ATTRIBUTE3 | VARCHAR2 | 255 | Generic placeholder column for storing additional information or data points. | ||
| USAGE_METRIC_APP_ATTRIBUTE4 | VARCHAR2 | 255 | Generic placeholder column for storing additional information or data points. | ||
| USAGE_METRIC_APP_ATTRIBUTE5 | VARCHAR2 | 255 | Generic placeholder column for storing additional information or data points. | ||
| USAGE_METRIC_APP_ATTRIBUTE6 | VARCHAR2 | 255 | Generic placeholder column for storing additional information or data points. | ||
| USAGE_METRIC_APP_ATTRIBUTE7 | VARCHAR2 | 255 | Generic placeholder column for storing additional information or data points. | ||
| USAGE_METRIC_APP_ATTRIBUTE8 | VARCHAR2 | 255 | Generic placeholder column for storing additional information or data points. | ||
| USAGE_METRIC_APP_ATTRIBUTE9 | VARCHAR2 | 255 | Generic placeholder column for storing additional information or data points. | ||
| USAGE_METRIC_APP_ATTRIBUTE10 | VARCHAR2 | 255 | Generic placeholder column for storing additional information or data points. | ||
| 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 |
|---|---|---|---|
| DOO_FEATURE_USAGE_METRICS_U1 | Unique | Default | USAGE_METRIC_ID |