FACT_AGENT_INBOUND_CONSULTATIONS
Definition
Consultation calls produced by agents while having ACD inbound calls on hold, including transfers and conferences on a historical basis per call.
Main data source: t_acd_inbound_history
Field description
| Field name | Type | Description |
|---|---|---|
| RecoveryKey | varchar(40) | Unique identity of child call |
| ChildType | varchar(10) | Type of call (consult, transfer or conference) |
| ParentRecoveryKey | varchar(40) | Unique identity of parent call |
| RouterCallKeyDay | int | Together with RouterCallKey the unique identification of a contact |
| RouterCallKey | int | Together with RouterCallKeyDay the unique identification of a contact |
| MediaID | int | ID of medium for the contact |
| Sequence | int | Number of the sequence for the call segment |
| ConsultNumber | int | Phone number that was dialed for a consultation |
| ConsultCallTypeID | int | ID of call type that was reached by the consultation call |
| ConsultAgentID | int | ID of agent that was reached by the consultation call |
| ConsultlegAnswered | int | 1 if the consultation call has been answered |
| ConsultlegUnanswered | int | 1 if the consultation call has not been answered |
| ConsultlegDuration | int | Total duration of the consultation call in seconds |
| EndDateTime | datetime | Date and end time of the consultation call |