| attempt_id |
varchar(120) |
|
false |
|
|
Attempt key: conversation id plus the Attempt sequence within the
Conversation (1 unless a scheduled callback came due on the same
Conversation) |
| conversation_id |
varchar(50) |
|
false |
|
|
Conversation GUID |
| contact_id |
varchar(255) |
|
true |
|
|
Outbound contact id within the contact list |
| contact_name |
varchar(255) |
|
true |
|
|
The contact list column named name, as currently stored in
odcontactlistdata; NULL when the list has no such column or the contact
is no longer in the list |
| campaign_id |
varchar(50) |
|
true |
|
|
Outbound campaign GUID |
| campaign_name |
varchar(200) |
|
true |
|
|
Campaign name (voice or messaging campaign) |
| contact_list_id |
varchar(50) |
|
true |
|
|
Outbound contact list GUID |
| contact_list_name |
varchar(200) |
|
true |
|
|
Contact list name |
| attempt_start_ts |
timestamp(3) without time zone |
|
true |
|
|
First segment start of the Attempt (UTC): the Conversation start, or
when a scheduled callback came due |
| attempt_end_ts |
timestamp(3) without time zone |
|
true |
|
|
Last segment end of the Attempt (UTC), scheduled-callback waiting
excluded; NULL while a segment is open |
| attempt_date |
date |
|
true |
|
|
UTC date of attempt_start_ts |
| agent_id |
varchar(50) |
|
true |
|
|
First agent Session (by start) of the Attempt, skipping one that was
only alerted and never took it; NULL when no agent took it |
| agent_name |
varchar(200) |
|
true |
|
|
Name of that agent |
| manager_id |
varchar(50) |
|
true |
|
|
Manager GUID of that agent |
| manager_name |
varchar(200) |
|
true |
|
|
Manager name of that agent |
| team_id |
varchar(50) |
|
true |
|
|
Work team GUID of that agent |
| team_name |
varchar(200) |
|
true |
|
|
Work team name of that agent |
| queue_id |
varchar(50) |
|
true |
|
|
Queue of the dial, the queue the campaign dialled into |
| queue_name |
varchar(255) |
|
true |
|
|
Name of that queue |
| media_type |
varchar(50) |
|
true |
|
|
Media type of the dial (voice for a call) |
| direction |
varchar(50) |
|
true |
|
|
Direction of the dial |
| wrap_up_code |
varchar(255) |
|
true |
|
|
Agent wrap-up code GUID: the latest wrap-up on the dial media, else
on the preview callback |
| wrap_up_name |
varchar(255) |
|
true |
|
|
Agent wrap-up code name |
| connect_status |
varchar(20) |
|
true |
|
|
Right Party Contact (reached and the wrap-up is flagged RPC),
Connected (reached), Not Connected |
| contact_reached |
boolean |
|
true |
|
|
The dial was answered: Genesys nOutboundConnected, or an interact
segment of the dial when the dialer gave no disposition. Voicemail that
picks up counts as answered |
| right_party_contact |
boolean |
|
true |
|
|
Right Party Contact flag of the agent wrap-up code in the outbound
wrap-up code mapping; without a wrap-up, false when nobody answered and
NULL otherwise |
| answering_machine |
boolean |
|
true |
|
|
Call analysis classified the answer as a machine; NULL without a
dialer disposition (preview campaigns have none) |
| no_answer |
boolean |
|
true |
|
|
Not answered: call analysis result, else SIP 408/480/487, Q.850
16/18/19/31/102, or the agent hung up on the ringing; NULL when nothing
is known |
| busy |
boolean |
|
true |
|
|
Busy: call analysis result, else SIP 486/600 or Q.850 17; NULL when
nothing is known |
| failed |
boolean |
|
true |
|
|
Failed before a connection: uncallable or SIT result, else any other
SIP/Q.850 failure code, edge error or error disconnect of an unanswered
dial; NULL when nothing is known |
| callback_required |
boolean |
|
true |
|
|
A callback was scheduled for the contact during this Attempt |
| callback_scheduled_ts |
timestamp(3) without time zone |
|
true |
|
|
Scheduled callback time (UTC) |
| disconnect_type |
varchar(50) |
|
true |
|
|
Disconnect type of the dial that describes the Attempt (the answered
one, else the last placed) |
| disconnect_reason |
text |
|
true |
|
|
Genesys error code, SIP response codes and Q.850 cause codes of that
dial |
| dial_count |
integer |
|
true |
|
|
Calls placed to the contact within the Attempt (platform retries and
second numbers included); Genesys nOutboundAttempted counts these |
| queue_time_seconds |
integer |
|
true |
|
|
Genesys tAcd of the Attempt: time the interaction waited in queue
before an agent answered |
| dial_time_seconds |
integer |
|
true |
|
|
Contacting and dialing (ringing) time of the dials placed in the
Attempt |
| duration_seconds |
integer |
|
true |
|
|
attempt_end_ts minus attempt_start_ts |
| talk_time_seconds |
integer |
|
true |
|
|
Genesys tTalkComplete of the agent Sessions on the dial media: time
talking to the contact |
| hold_time_seconds |
integer |
|
true |
|
|
Genesys tHeldComplete of the agent Sessions on the dial media |
| wrap_up_duration_seconds |
integer |
|
true |
|
|
Genesys tAcw of the agent Sessions; NULL when Genesys recorded no
after-call work |
| handle_time_seconds |
integer |
|
true |
|
|
Genesys tHandle summed over the agent Sessions of the Attempt: the
complete agent time, preview and post-call work included |
| source_system |
varchar(50) |
|
true |
|
|
GenesysCloud |
| load_ts |
timestamp(3) without time zone |
|
true |
|
|
When the row was last built (UTC) |
| conversationstartdate |
timestamp without time zone |
|
false |
|
|
Conversation Start Date (UTC); partition key and rebuild window |