SVC_AI_ENGAGEMENT_METRICS
This table stores the AI agent-related events, focusing on agent engagements and associated object details. This table will serve as a foundation for feedback collection.
Details
-
Schema: FUSION
-
Object owner: SVC
-
Object type: TABLE
-
Tablespace: DEFAULT
Primary Key
| Name | Columns |
|---|---|
|
SVC_AI_ENGAGEMENT_METRICS_PK |
ENGAGEMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENGAGEMENT_ID | NUMBER | 18 | Yes | Auto-generated number and primary key for this table. | |
| ENGAGEMENT_NUMBER | VARCHAR2 | 30 | Yes | Public unique identifier for the AI agent engagement. | |
| 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_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated 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. | |
| AGENT_TEAM_CODE | VARCHAR2 | 200 | Yes | Agent team code from FAI_WORKFLOW_B.WORKFLOW_CODE. | |
| AGENT_TEAM_VERSION | NUMBER | 9 | Yes | Agent team version from FAI_WORKFLOW_B.WORKFLOW_VERSION. | |
| AGENT_CODE | VARCHAR2 | 200 | Agent code of the Gen AI agent from HR_GEN_AI_AGENTS_B.AGENT_CODE. | ||
| AGENT_VERSION | NUMBER | 4 | Agent version of the Gen AI agent from HR_GEN_AI_AGENTS_B.VERSION. | ||
| SERVICE_WORKFLOW_ID | NUMBER | 18 | Foreign key that references SVC_AP_ACTION_PLANS.ACTION_PLAN_ID, the workflow ID if the agent is generated through workflow. | ||
| OBJECT_REFERENCE_NUMBER | VARCHAR2 | 64 | Public unique identifier of the object that this engagement was created for. | ||
| OBJECT_TYPE_CD | VARCHAR2 | 30 | Lookup code that indicates the object type of OBJECT_REFERENCE_NUMBER, such as Service Request, Chat, Work Order, Email, etc. | ||
| JOB_EXECUTION_NUMBER | VARCHAR2 | 200 | Yes | Job execution number from FAI_WORKFLOW_EXECUTIONS.EXECUTION_GROUP_NUMBER that corresponds to Agent Run to track FAI platform. | |
| HUMAN_IN_LOOP_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate whether a human was expected to review/act (vs. silent/fully automated AI invocation). | |
| RECOMMENDATION_DISPLAYED_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate whether the AI Agent's output or recommendation was displayed to the human (agent or end-user). | |
| USER_DECISION_CD | VARCHAR2 | 30 | Lookup code that indicates Accepted, Rejected, Modified, Reviewed, Not Applicable. | ||
| CONFIDENCE_SCORE_CD | VARCHAR2 | 30 | Lookup code that indicates the confidence score, if programmatic comparison tools were used, to be denormalized to accommodate different score types. | ||
| CONFIDENCE_SCORE | NUMBER | 4 | Score value related to the confidence score type selected on CONFIDENCE_SCORE_CD. | ||
| USER_FEEDBACK_RATING | NUMBER | 4 | Optional feedback rating from the user (1-5). | ||
| USER_FEEDBACK_COMMENT | VARCHAR2 | 1000 | Free-form text field to capture any comments from user. | ||
| USER_FEEDBACK_CD | VARCHAR2 | 30 | Lookup code that stores the feedback from the human user, such as Accurate, Helpful, Needs Improvement, Not Relevant, Incorrect. | ||
| OUTCOME_TYPE_CD | VARCHAR2 | 30 | Lookup code that identifies the type of outcome generated by the AI agent. Some of the possible values are "SR Message", "Action Plan Action", "SR Severity Update", "SR Category Update" and so on. | ||
| OUTCOME_OBJECT_ID | NUMBER | 18 | The unique identifier of the object that was created as an outcome by the AI agent. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SVC_AI_ENGAGEMENT_METRICS_N1 | Non Unique | DEFAULT | OBJECT_REFERENCE_NUMBER, AGENT_TEAM_CODE, AGENT_TEAM_VERSION |
| SVC_AI_ENGAGEMENT_METRICS_N2 | Non Unique | DEFAULT | CREATION_DATE, AGENT_TEAM_CODE, AGENT_TEAM_VERSION |
| SVC_AI_ENGAGEMENT_METRICS_N3 | Non Unique | DEFAULT | CREATION_DATE, USER_DECISION_CD |
| SVC_AI_ENGAGEMENT_METRICS_N4 | Non Unique | DEFAULT | CREATION_DATE, CONFIDENCE_SCORE_CD |
| SVC_AI_ENGAGEMENT_METRICS_N5 | Non Unique | DEFAULT | CREATION_DATE, HUMAN_IN_LOOP_FLAG |
| SVC_AI_ENGAGEMENT_METRICS_N6 | Non Unique | DEFAULT | CREATION_DATE, RECOMMENDATION_DISPLAYED_FLAG |
| SVC_AI_ENGAGEMENT_METRICS_N7 | Non Unique | DEFAULT | JOB_EXECUTION_NUMBER |
| SVC_AI_ENGAGEMENT_METRICS_PK | Unique | DEFAULT | ENGAGEMENT_ID |
| SVC_AI_ENGAGEMENT_METRICS_U1 | Unique | DEFAULT | ENGAGEMENT_NUMBER |