public.outboundattemptdata

public.outboundattemptdata

Description

One row per outbound campaign dial attempt, 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: conversationid plus the called party session id
conversation_id varchar(50) false Conversation GUID
contact_id varchar(255) true Outbound contact id within the contact 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 called party session (UTC)
attempt_end_ts timestamp(3) without time zone true Last segment end of the called party session (UTC); NULL while the session is open. Not the conversation end: a scheduled callback keeps the Conversation open for days
attempt_date date true UTC date of attempt_start_ts
agent_id varchar(50) true First agent Session (by start) attributed to the Attempt, skipping one that was only alerted and never took the call; 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 called party Session, the queue the campaign dialled into
queue_name varchar(255) true Name of that queue
media_type varchar(50) true Media type of the called party session
direction varchar(50) true Direction of the called party session
outcome_code varchar(255) true The dialer system wrap-up code (ININ-OUTBOUND-*); NULL for an agent-placed callback, which the dialer does not classify
outcome_description varchar(255) true The Call Analysis Disposition (disposition.classification.*)
wrap_up_code varchar(255) true Agent wrap-up code GUID
wrap_up_name varchar(255) true Agent wrap-up code name
connect_status varchar(20) true Connected (Genesys nOutboundConnected), Failed (see failed), Not Connected; NULL without a call analysis result
contact_reached boolean true Connected as Genesys counts it (nOutboundConnected)
right_party_contact boolean true Right Party Contact flag of the agent wrap-up code in the outbound wrap-up code mapping; without an agent wrap-up, false when nobody answered (machine, no answer, busy, failed) and NULL otherwise
answering_machine boolean true Call analysis classified the answer as a machine; NULL without a call analysis result
no_answer boolean true Call analysis result: no answer; NULL without a call analysis result
busy boolean true Call analysis result: busy; NULL without a call analysis result
failed boolean true Failed before a successful connection: uncallable result, special information tone, or disconnected before the called party interacted; NULL without a call analysis result
callback_required boolean true A callback Session of the called party followed this Attempt
callback_scheduled_ts timestamp(3) without time zone true Scheduled callback time (UTC)
disconnect_type varchar(50) true Disconnect type of the called party session
disconnect_reason text true Genesys error code, else the SIP response codes, else the Q.850 codes of the called party session
duration_seconds integer true attempt_end_ts minus attempt_start_ts
talk_time_seconds integer true Genesys tTalkComplete of the agent Session; NULL until it completes
hold_time_seconds integer true Genesys tHeldComplete of the agent Session; NULL until it completes
wrap_up_duration_seconds integer true Genesys tAcw of the agent Session; NULL until it completes
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)