DOO_RESOLUTION_OUTCOME_STORE
Stores learned preference and automation behavior. It is not an audit table and is intended for compact learning statistics rather than full order/action payloads.
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
DOO_RES_OUTCOME_STORE_PK |
RES_OUTCOME_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RES_OUTCOME_ID | NUMBER | 18 | Yes | Unique surrogate identifier for each learned resolution outcome record. | |
| OUTCOME_KEY | VARCHAR2 | 500 | Yes | Business-level unique key identifying the reference object, persona, signal, and exception pattern. | |
| REF_OBJECT_TYPE_CODE | VARCHAR2 | 30 | Yes | Type of business object used as the learning reference, such as account, customer, item, order, or customer item. | |
| REF_OBJECT_ID1 | NUMBER | 18 | Primary identifier of the business reference object associated with this learned outcome. | ||
| REF_OBJECT_ID2 | NUMBER | 18 | Secondary identifier of the business reference object when the outcome requires a composite reference. | ||
| PERSONA_CODE | VARCHAR2 | 30 | Yes | Persona for whom the learned outcome and automation preference apply. | |
| SIGNAL_CODE | VARCHAR2 | 30 | Yes | Code identifying the signal pattern used to learn or evaluate the resolution outcome. | |
| AUTOMATION_MODE_CODE | VARCHAR2 | 30 | Yes | Automation mode allowed for this outcome, such as human review, auto execute with FYI, or full auto execute. | |
| USER_OPT_IN_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the user has opted in to automation for this persona and signal pattern. | |
| PRESENTED_COUNT | NUMBER | 18 | Number of times this signal and action pattern was presented to users or automation logic. | ||
| ACTION_TAKEN_COUNT | NUMBER | 18 | Number of times a resolution action was selected for this learned signal pattern. | ||
| DOMINANT_ACTION_CODE | VARCHAR2 | 30 | Action code most frequently selected for this persona, signal, and reference object pattern. | ||
| DOMINANT_ACTION_RATE | NUMBER | Ratio of the dominant action count to the total number of selected actions. | |||
| SUCCESS_COUNT | NUMBER | 18 | Number of signal interactions that completed successfully for this learned outcome. | ||
| FAILED_COUNT | NUMBER | 18 | Number of signal interactions that failed during execution for this learned outcome. | ||
| OUTCOME_STATS_JSON | CLOB | Optional compact JSON containing per-action statistics and decision explanation for runtime LLM use. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| DOO_RES_OUTCOME_STORE_N1 | Non Unique | Default | REF_OBJECT_TYPE_CODE, REF_OBJECT_ID1, PERSONA_CODE, SIGNAL_CODE |
| DOO_RES_OUTCOME_STORE_N2 | Non Unique | Default | PERSONA_CODE, SIGNAL_CODE |
| DOO_RES_OUTCOME_STORE_N3 | Non Unique | Default | DOMINANT_ACTION_CODE, AUTOMATION_MODE_CODE |
| DOO_RES_OUTCOME_STORE_U1 | Unique | Default | RES_OUTCOME_ID |