ZCA_AI_OUTCOME_DOC
This table stores outcomes generated by agentic workflows.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZCA_AI_OUTCOME_DOC_PK |
OUTCOME_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OUTCOME_ID | NUMBER | 18 | Yes | The unique identifier of the AI outcome. | |
| OUTCOME_TYPE | VARCHAR2 | 64 | The classification of the AI outcome. | ||
| OUTCOME_SUBTYPE | VARCHAR2 | 128 | The subtype that further classifies the AI outcome within the broader outcome type. | ||
| CATEGORY | VARCHAR2 | 64 | The category assigned to the AI outcome. | ||
| PRIMARY_OBJECT_TYPE | VARCHAR2 | 64 | The type of the primary business object associated with the AI outcome. | ||
| PRIMARY_OBJECT_KEY | NUMBER | 18 | The key of the primary business object associated with the AI outcome. | ||
| PRIMARY_OBJECT_ALTKEY | VARCHAR2 | 30 | The alternate key of the primary business object associated with the AI outcome. | ||
| STATUS | VARCHAR2 | 24 | The status of the AI outcome indicating its current state for display and downstream processing. | ||
| URGENCY | VARCHAR2 | 64 | The urgency level of the AI outcome used for prioritization and triage. | ||
| GENERATED_TS | TIMESTAMP | The timestamp when the AI outcome was generated. | |||
| GENERATED_BY | VARCHAR2 | 256 | The identifier of the agent or user that generated the AI outcome. | ||
| AGENT_JOB_ID | VARCHAR2 | 128 | The agent job identifier for the AI outcome generation. | ||
| EXPIRES_TS | TIMESTAMP | The timestamp when the AI outcome expires. | |||
| EFFECTIVE_DATE | TIMESTAMP | The timestamp when the AI outcome becomes effective. | |||
| PAYLOAD | CLOB | The payload representing the AI outcome and supporting metadata. | |||
| 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. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| zca_ai_outcome_ref | zca_ai_outcome_doc | OUTCOME_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZCA_AI_OUTCOME_DOC_PK | Unique | Default | OUTCOME_ID |