public.outboundattemptdata

public.outboundattemptdata

Description

One row per outbound campaign Attempt (a Conversation in which a call was placed to the contact), rebuilt per UTC day by the Interaction job from vwOutboundAttemptDataBuild. Query vwOutboundAttemptData.

Columns

Name Type Default Nullable Children Parents Comment
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

Constraints

Name Type Definition
outboundattemptdata_pkey PRIMARY KEY PRIMARY KEY (attempt_id, conversationstartdate)

Indexes

Name Definition
outboundattemptdata_pkey CREATE UNIQUE INDEX outboundattemptdata_pkey ON ONLY public.outboundattemptdata USING btree (attempt_id, conversationstartdate)
outboundattemptdata_conversationstartdate_idx CREATE INDEX outboundattemptdata_conversationstartdate_idx ON ONLY public.outboundattemptdata USING btree (conversationstartdate)
outboundattemptdata_conversation_id_idx CREATE INDEX outboundattemptdata_conversation_id_idx ON ONLY public.outboundattemptdata USING btree (conversation_id)
outboundattemptdata_contact_idx CREATE INDEX outboundattemptdata_contact_idx ON ONLY public.outboundattemptdata USING btree (contact_list_id, contact_id, attempt_start_ts)
outboundattemptdata_campaign_idx CREATE INDEX outboundattemptdata_campaign_idx ON ONLY public.outboundattemptdata USING btree (campaign_id, attempt_date)