Transfer Exception Events
Contains the relationship between an interaction and the transfer exception. EE_TransferEvents_viw contains Interaction ID key, site ID of the Interaction where the transfer exception is captured, UTC exception event timestamp when it is captured with offset to Server local time, in milliseconds, source queue name for captured exception, source user name for captured exception, target queue name for captured exception, target user name for captured exception, time in queue, and the transfer type.
Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
---|---|---|---|---|---|---|
InteractionIDKey | char (18) | False | No | Interaction ID Key |
17.1.0.324 | Added for transfer exception events. |
SiteID | smallint | False | No | Site ID of the Interaction where the exception is captured |
17.1.0.324 | Added for transfer exception events. |
EventDateTimeUTC | datetime | True | No | Event Date/Time (UTC) when the exception was captured |
17.1.0.324 | Added for transfer exception events. |
EventDTOffset | int | False | No | The GMT timestamp when the action happens |
17.1.0.324 | Added for transfer exception events. |
SourceQueueName | nvarchar (250) | False | No | Source queue name for captured exception. '-' if source queue name is not available. |
17.1.0.324 | Added for transfer exception events. |
SourceUserName | nvarchar (250) | False | Yes | Transferring CIC User name Id. '-' if source user name is not available. |
17.1.0.324 | Added for transfer exception events. |
TargetQueueName | nvarchar (250) | False | No | Target queue name for captured exception. '-' if target queue name is not available. |
17.1.0.324 | Added for transfer exception events. |
TargetUserName | nvarchar (250) | False | Yes | Target CIC User name. '-' if target user name is not available at the time of the transfer event (e.g. blind transfer to workgroup). |
17.1.0.324 | Added for transfer exception events. |
TimeInSrcQueue | bigint | True | No | Duration from queue entry to queue transfer event in milliseconds |
17.1.0.324 | Added for transfer exception events. |
TransferType | varchar (20) | True | No | Target queue type. |
17.1.0.324 | Added for transfer exception events. |
Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
---|---|---|---|---|---|---|
InteractionIDKey | char (18) | False | No | Interaction ID Key |
17.1.0.324 | Added for transfer exception events. |
SiteID | number | False | No | Site ID of the Interaction where the exception is captured |
17.1.0.324 | Added for transfer exception events. |
EventDateTimeUTC | timestamp | False | No | Event Date/Time (UTC) when the exception was captured |
17.1.0.324 | Added for transfer exception events. |
EventDTOffset | number | False | No | The GMT timestamp when the action happens |
17.1.0.324 | Added for transfer exception events. |
SourceQueueName | nvarchar2 (250) | True | No | Source queue name for captured exception. '-' if source queue name is not available. |
17.1.0.324 | Added for transfer exception events. |
SourceUserName | nvarchar2 (250) | True | Yes | Transferring CIC User name Id. '-' if source user name is not available. |
17.1.0.324 | Added for transfer exception events. |
TargetQueueName | nvarchar2 (250) | True | No | Target queue name for captured exception. '-' if target queue name is not available. |
17.1.0.324 | Added for transfer exception events. |
TargetUserName | nvarchar2 (250) | True | Yes | Target CIC User name. '-' if target user name is not available at the time of the transfer event (e.g. blind transfer to workgroup). |
17.1.0.324 | Added for transfer exception events. |
TimeInSrcQueue | number | True | No | Duration from queue entry to queue transfer event in milliseconds |
17.1.0.324 | Added for transfer exception events. |
TransferType | varchar2 (4000) | True | No | Target queue type. |
17.1.0.324 | Added for transfer exception events. |