ZCC_TB_INTERACTION_STATUS
This table stores toolbar interaction region ui state.
Details
-
Schema: FUSION
-
Object owner: ZCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZCC_TB_INTERACTION_STATUS_PK |
TB_INTERACTION_STATUS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TB_INTERACTION_STATUS_ID | NUMBER | 18 | Yes | Primary Key | |
| AGENT_PARTY_ID | NUMBER | 18 | Yes | PartyId for the loggedin agent. | |
| AGENT_NAME | VARCHAR2 | 100 | Yes | AGENT_NAME | |
| SLOT_NUMBER | NUMBER | 1 | Yes | UI Slot number for the current Interaction (needed for multi-interaction support) | |
| IS_ACTIVE | VARCHAR2 | 1 | Determines if this slot is currently active (in focus). Y or N default null means N) | ||
| SESSION_ID | VARCHAR2 | 32 | Fnd Session Id for Agent. | ||
| CURRENT_STATE | VARCHAR2 | 20 | Current Interaction state (Delivered/Established etc). | ||
| INTERACTION_ID | NUMBER | 18 | Current Interaction Id. | ||
| INTERACTION_TYPE | VARCHAR2 | 20 | Interaction Type for current interaction. Received by toolbar on Delivered Event. Eg. Inbound Call/Outbound Call etc. Set in toolbar as part of Delivered/Established event from connector. | ||
| DEVICE_ID | VARCHAR2 | 20 | Unique identifier for device. Can be an ID or Name. Set in toolbar as part of Delivered/Established event from connector. | ||
| MEDIA_ITEM_ID | NUMBER | 18 | Unique identifier for each media item. for eg. CallId in Inbound call scenario. Set in toolbar as part of Delivered/Established event from connector. | ||
| MEDIA_ITEM_ID_1 | NUMBER | 18 | Unique identifier for 2nd call associated with Interaction (if present) | ||
| MEDIA_TYPE | VARCHAR2 | 20 | Media Type for Current Interaction. Set in toolbar as part of Delivered/Established Event from connector. | ||
| MEDIA_DIRECTION | VARCHAR2 | 20 | Direction for media item. Set in toolbar as part of Delivered/Established event from connector. | ||
| RECORD_PARTY_ID | NUMBER | 18 | Party Id for Interaction record. | ||
| RECORD_ORG_ID | NUMBER | 18 | Organization Id for Interaction record. | ||
| RECORD_RELATIONSHIP_ID | NUMBER | 18 | Relationship Id for Interaction record. | ||
| DISPLAY_ATTRIBUTE_VALUE | VARCHAR2 | 1024 | The string representing the interaction record displayed on the toolbar. This is based on ANI for inbound call. | ||
| INTERACTION_START_TIME_CLIENT | TIMESTAMP | Time on client desktop when interaction was started. Can be used to set timer correctly if page is refreshed. | |||
| CURR_STATE_START_TIME_CLIENT | TIMESTAMP | Time n agent desktop when current state was started. Can be used to set timer correctly when page is refreshed. | |||
| ACCEPT_VISIBLE_FLAG | VARCHAR2 | 1 | Flag indicating if Accept Toolbar button is visible. | ||
| IGNORE_VISIBLE_FLAG | VARCHAR2 | 1 | Flag indicating if Ignore Toolbar button is visible. | ||
| ON_HOLD_VISIBLE_FLAG | VARCHAR2 | 1 | Flag indicating if On Hold Toolbar button is visible. | ||
| OFF_HOLD_VISIBLE_FLAG | VARCHAR2 | 1 | OFF_HOLD_VISIBLE_FLAG | ||
| TRANSFER_VISIBLE_FLAG | VARCHAR2 | 1 | Flag indicating if Transfer Toolbar button is visible. | ||
| CONF_VISIBLE_FLAG | VARCHAR2 | 1 | Flag indicating if Conference Toolbar button is visible. | ||
| WARM_TRANSFER_VISIBLE_FLAG | VARCHAR2 | 1 | Flag indicating if Warm Transfer Toolbar button is visible. | ||
| RELEASE_VISIBLE_FLAG | VARCHAR2 | 1 | Flag indicating if Release Toolbar button is visible. | ||
| END_VISIBLE_FLAG | VARCHAR2 | 1 | Flag indicating if End Interaction Toolbar button is visible. | ||
| COMPLETE_VISIBLE_FLAG | VARCHAR2 | 1 | Flag indicating if Complete Toolbar button is visible. | ||
| CANCEL_VISIBLE_FLAG | VARCHAR2 | 1 | Flag indicating if Cancel Toolbar button is visible. | ||
| TIMER_VISIBLE_FLAG | VARCHAR2 | 1 | Flag indicating if Timer on toolbar is visible for the current interaction state. | ||
| STYLE_PANEL_VISIBLE_FLAG | VARCHAR2 | 1 | Flag indicating if the Style Panel (displaying interaction controls and display string) is visible. | ||
| STYLE_PANEL_INLINE_STYLE | VARCHAR2 | 128 | Inline style for displaying style panel. | ||
| OTHER_PARTY_PHONE_NUMBER | VARCHAR2 | 40 | The phone number of the person with whom the agent talked. (The phone number from which the person called the agent, or the phone number the agent dialed) | ||
| SWITCH_CALL_ID | VARCHAR2 | 128 | The handle which uniquely identifies the call in the CTI system. It will be used by customers and vendor to tie an interaction in fusion back to the record in the telephony system. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZCC_TB_INTERACTION_STATUS_U1 | Unique | Default | TB_INTERACTION_STATUS_ID |