OSS_AI_OUTCOME

Details

Schema: FUSION
Object owner: OSS
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
OSS_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	100			The alternate key of the primary business object associated with the AI outcome.
TARGET_PERSONA	VARCHAR2	64			The target persona 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.
EVALUATION_PERIOD	VARCHAR2	7			OSS evaluation window in YYYY-MM format for the raw signals, family facts, and decision packet that produced the outcome.
SIGNAL_FAMILY_CODE	VARCHAR2	30			OSS signal family represented by the generated outcome, aligned to ORA_OSS_SIGNAL_FAMILY.
DECISION_PACKET_ID	NUMBER		18		OSS decision packet identifier that produced or refreshed the outcome.
CURRENCY_CODE	VARCHAR2	15			Currency for commercial amount fields
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.
EFFECTIVE_END_DATE	TIMESTAMP				Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
EFFECTIVE_START_DATE	TIMESTAMP				Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
RESOLUTION_MODE	VARCHAR2	20			The resolution mode used to validate the primary business object reference, such as LEGACY or BO.
RESOLVER_BO_CODE	VARCHAR2	1000			The full Business Object code used by BO-based resolution for the primary business object reference.

Indexes

Index	Uniqueness	Tablespace	Columns
OSS_AI_OUTCOME_DOC_PK	Unique	Default	OUTCOME_ID
OSS_AI_OUTCOME_DOC_N1	Non Unique	Default	OUTCOME_TYPE, OUTCOME_SUBTYPE, PRIMARY_OBJECT_TYPE, PRIMARY_OBJECT_ALTKEY, CATEGORY, STATUS
OSS_AI_OUTCOME_DOC_N2	Non Unique	Default	DECISION_PACKET_ID, EVALUATION_PERIOD
OSS_AI_OUTCOME_DOC_N3	Non Unique	Default	SIGNAL_FAMILY_CODE, EVALUATION_PERIOD, STATUS