SVC_CHAT_PENDING_UWOS
This table is used to track realtime work (of type Chat) that has been accepted by an agent but cannot be routed (due to the corresponding Chat service session's CLIENT_ID not being available yet, for example).
Details
-
Schema: FUSION
-
Object owner: FUSION
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SVC_CHAT_PENDING_UWOS_PK |
PENDING_UWO_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PENDING_UWO_ID | NUMBER | 18 | Yes | Auto-generated number and primary key for this table. | |
| CHAT_SESSION_ID | NUMBER | 18 | Yes | Foreign key that references SVC_CHAT_SESSIONS (CHAT_SESSION_ID), the Chat service session of the agent that accepted the chat. | |
| ENGAGEMENT_ID | NUMBER | 18 | Yes | Id of the pending chat (as generated by the Chat service). | |
| WORK_ID | NUMBER | 18 | Yes | Foreign key that references SVC_WORK_OBJECTS (WORK_ID), the Omni work object corresponding to the chat. | |
| STATUS_CD | VARCHAR2 | 30 | Yes | Lookup code that indicates the status code of the chat pending work, such as PENDING, ACCEPTED, CANCELLED, EXPIRED. | |
| DELETED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the chat pending work is logically deleted (Y or N). | |
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| SVC_CHAT_PENDING_UWOS | svc_chat_sessions | CHAT_SESSION_ID |
| SVC_CHAT_PENDING_UWOS | svc_work_objects | WORK_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SVC_CHAT_PENDING_UWOS_F1 | Non Unique | Default | CHAT_SESSION_ID |
| SVC_CHAT_PENDING_UWOS_F2 | Non Unique | Default | WORK_ID |
| SVC_CHAT_PENDING_UWOS_PK | Unique | Default | PENDING_UWO_ID |
| SVC_CHAT_PENDING_UWOS_U1 | Unique | Default | ENGAGEMENT_ID |