ZCA_OBJ_ENGMT_INSIGHT
This table contains list of object engagement insights.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZCA_OBJ_ENGMT_INSIGHT_PK |
OBJ_ENGMT_INSIGHT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OBJ_ENGMT_INSIGHT_ID | NUMBER | 18 | Yes | Unique identifier (Primary Key) of the Object Engagement Insights object. | |
| OBJ_ENGMT_INSIGHT_NUMBER | VARCHAR2 | 30 | Yes | Public unique identifier (Alternate Key) of the Object Engagement Insights object. | |
| SOURCE_OBJECT_ID | NUMBER | 18 | Yes | Unique identifier of the source object (such as Opportunity, Account, or Lead) for which the engagement insight record is generated. | |
| SOURCE_OBJECT_CODE | VARCHAR2 | 30 | Yes | Code representing the type of source object (e.g., Opportunity, Account, Lead) for which the engagement insight is recorded. | |
| PROGRESSION_SUMMARY | CLOB | Gen AI summary of all engagements for the current source object. | |||
| LAST_PROCESSED_TIME | TIMESTAMP | Contains the date and time when the Gen AI evaluation of the progression summary last happened on this engagement insight. | |||
| SALES_PLAY_CODE | VARCHAR2 | 255 | Default Sales Play associated with this engagement insight. | ||
| SALES_MOTION_CODE | VARCHAR2 | 255 | Default Sales Motion associated with this engagement insight. | ||
| ADDITIONAL_INSIGHT_DATA | CLOB | Used to store any additional data for the opportunity insight. | |||
| PRIORITY_REASON | CLOB | Gen AI evaluation of reason why this opportunity is shows up on the user's prioritized list of opportunities. | |||
| PRIORITY_CATEGORY | VARCHAR2 | 30 | Category of the priority reason. Values can be ON_TRACK, NEEDS_ATTENTION, ACTION_REQUIRED etc. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of 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. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZCA_OBJ_ENGMT_INSIGHT_PK | Unique | Default | OBJ_ENGMT_INSIGHT_ID |
| ZCA_OBJ_ENGMT_INSIGHT_U1 | Unique | Default | OBJ_ENGMT_INSIGHT_NUMBER |
| ZCA_OBJ_ENGMT_INSIGHT_U2 | Unique | Default | SOURCE_OBJECT_ID, SOURCE_OBJECT_CODE |