DOO_FEATURE_USAGE_METRICS
This table stores the information about Order Management feature usage , incident pattern and other order processing KPIs.
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 | Primary Key for the table. Uniquely identifies each row in the table. | |
| USAGE_METRIC_TYPE | VARCHAR2 | 255 | Yes | USAGE_METRIC_TYPE hold each event point in life cycle of an order . FIXED Values : USAGE , METRIC , INCIDENT | |
| USAGE_METRIC_NAME | VARCHAR2 | 255 | Yes | USAGE_METRIC_NAME Holds the each event point for which we gathered the data . 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 | PREVIOUS_USAGE_VALUE, can be from : Y/N , Or Any other value | ||
| CURRENT_USAGE_VALUE | VARCHAR2 | 255 | CURRENT_USAGE_VALUE, can be from : Y/N , Or Any other value | ||
| USAGE_METRIC_DETAILS | CLOB | USAGE_METRIC_DETAILS, includes all the metadata related to USAGE_METRIC_DETAILS in form of json | |||
| USAGE_METRIC_OWING_MODULE | VARCHAR2 | 255 | Yes | USAGE_METRIC_OWING_MODULE Holds Fixed Value , CAPTURE/SUBMIT/ORCHESTRATION/FULFILLMENT_TASK/SHIPSET/SPLIT/EXTENSION/ACTION/REVISION | |
| USAGE_METRIC_APP_ATTRIBUTE1 | VARCHAR2 | 255 | This is the Custom columns to store additional data point. | ||
| USAGE_METRIC_APP_ATTRIBUTE2 | VARCHAR2 | 255 | This is the Custom columns to store additional data point. | ||
| USAGE_METRIC_APP_ATTRIBUTE3 | VARCHAR2 | 255 | This is the Custom columns to store additional data point. | ||
| USAGE_METRIC_APP_ATTRIBUTE4 | VARCHAR2 | 255 | This is the Custom columns to store additional data point. | ||
| USAGE_METRIC_APP_ATTRIBUTE5 | VARCHAR2 | 255 | This is the Custom columns to store additional data point. | ||
| USAGE_METRIC_APP_ATTRIBUTE6 | VARCHAR2 | 255 | This is the Custom columns to store additional data point. | ||
| USAGE_METRIC_APP_ATTRIBUTE7 | VARCHAR2 | 255 | This is the Custom columns to store additional data point. | ||
| USAGE_METRIC_APP_ATTRIBUTE8 | VARCHAR2 | 255 | This is the Custom columns to store additional data point. | ||
| USAGE_METRIC_APP_ATTRIBUTE9 | VARCHAR2 | 255 | This is the Custom columns to store additional data point. | ||
| USAGE_METRIC_APP_ATTRIBUTE10 | VARCHAR2 | 255 | This is the Custom columns to store additional data point. | ||
| 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 |